Docsity
Docsity

Prepare for your exams
Prepare for your exams

Study with the several resources on Docsity


Earn points to download
Earn points to download

Earn points by helping other students or get them with a premium plan


Guidelines and tips
Guidelines and tips

DP-900 Exam Preparation: Past Questions and Answers, Exams of Computer Science

A collection of past questions and answers related to the dp-900 exam, covering topics such as data warehousing, analytics, and database concepts. It offers a valuable resource for individuals preparing for the dp-900 certification exam, helping them assess their understanding and identify areas for further study.

Typology: Exams

2024/2025

Available from 01/23/2025

Shantelle
Shantelle 🇺🇸

5

(2)

3K documents

1 / 148

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
DP-900 With 252 Past Questions
Correctly Solved
A tumbling window can run a job using data for a specific period of
time, and not before or after that.
SQL Database supports two purchasing models. What are they?
Pay per hour and pay per month
ACUs and CPUs
DTUs and vCore
Standard and Premium -
DTUs and vCore
SQL Database supports both DTU-based and vCore-based pricing
models. DTU stands for Database Transaction Unit and is a relative
measure of performance. The vCore model lets you select CPU and
storage separately from each other.
Which Power BI tool helps build paginated reports?
pf3
pf4
pf5
pf8
pf9
pfa
pfd
pfe
pff
pf12
pf13
pf14
pf15
pf16
pf17
pf18
pf19
pf1a
pf1b
pf1c
pf1d
pf1e
pf1f
pf20
pf21
pf22
pf23
pf24
pf25
pf26
pf27
pf28
pf29
pf2a
pf2b
pf2c
pf2d
pf2e
pf2f
pf30
pf31
pf32
pf33
pf34
pf35
pf36
pf37
pf38
pf39
pf3a
pf3b
pf3c
pf3d
pf3e
pf3f
pf40
pf41
pf42
pf43
pf44
pf45
pf46
pf47
pf48
pf49
pf4a
pf4b
pf4c
pf4d
pf4e
pf4f
pf50
pf51
pf52
pf53
pf54
pf55
pf56
pf57
pf58
pf59
pf5a
pf5b
pf5c
pf5d
pf5e
pf5f
pf60
pf61
pf62
pf63
pf64

Partial preview of the text

Download DP-900 Exam Preparation: Past Questions and Answers and more Exams Computer Science in PDF only on Docsity!

DP-900 With 252 Past Questions

Correctly Solved

A tumbling window can run a job using data for a specific period of time, and not before or after that. SQL Database supports two purchasing models. What are they?

Pay per hour and pay per month

ACUs and CPUs

DTUs and vCore

Standard and Premium - ✔ ✔ DTUs and vCore SQL Database supports both DTU-based and vCore-based pricing models. DTU stands for Database Transaction Unit and is a relative measure of performance. The vCore model lets you select CPU and storage separately from each other. Which Power BI tool helps build paginated reports?

Power BI Server

Power BI Desktop

Power BI Report Builder

Power BI Apps - ✔ ✔ Power BI Report Builder Power BI Report Builder is the tool that allows you to build paginated reports. Which of the following are examples of unstructured data?

Log files

CSV files

SQL Server tables

An external Oracle DB

Blob storage - ✔ ✔ Log files

SQL DW are databases that are specifically designed for reporting. In fact, it does not support updates to data rows once written to the DB. It supports massive amounts of data. The DW has the ability to scale to multiple servers if a complex query is run against it needing a lot of computing power. Which famous company invented the database known as "Cassandra"?

Google

Amazon

Facebook

Microsoft - ✔ ✔ Facebook Descriptive Analytics tells you

  1. What is most likely to occur in the future
  2. What occured in the past
  3. Which actions you can perform to affect outcomes
  4. Why something happened in the past - ✔ ✔ 2. What occured in the past Normalisation involves eliminating relationships between database tables

True/False - ✔ ✔ False Normalising a database reduces data redundancy True/False - ✔ ✔ True Normalisation improves data integrity True/False - ✔ ✔ True An ETL process requires:

  1. A matching schema in the data source and the data target
  2. A target data store powerful enough to transform data
  3. data that is fully processed before being loaded to the target data store
  4. that the data target be a relational database - ✔ ✔ 4. that the data target be a relational database In batch processing:
  5. data is always inserted one row at a time
  6. data is processed in real-time
  7. latency is expected
  8. processing car only execute serially - ✔ ✔ 3. latency is expected Match the types of analytics that can be used to answer the business questions.

Why did sales increase last month?

Predictive analytics help answer questions about what will happen in the future Match the types of analytics that can be used to answer the business questions.

Which people are mentioned in a company's business documents?

  1. Cognitive
  2. Diagnostic
  3. Descriptive
  4. Predictive
  5. Prescriptive - ✔ ✔ 1. Cognitive

Cognitive analytics attempt to draw inferences from existing data and patterns... Transcribing audio files is an example of:

  1. Cognitive
  2. Diagnostic
  3. Descriptive
  4. Predictive
  1. Prescriptive - ✔ ✔ 1. Cognitive You have the following JSON document. Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the JSON document.

"customer": { "first name" : "Ben", "last name" : "Smith", "address": { "line 1" : "161 Azure Ln", "line 2" : "Palo Alto", "ZIP code" : "54762" },

"social media": [ { "service" : "twitter", "handle" : "@bensmith", }, {

You have the following JSON document. Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the JSON document.

"customer": { "first name" : "Ben", "last name" : "Smith", "address": { "line 1" : "161 Azure Ln", "line 2" : "Palo Alto", "ZIP code" : "54762" },

"social media": [ { "service" : "twitter", "handle" : "@bensmith", }, { "service" : "linkedin",

"handle" : "bensmith", } ],

"phone numbers": [ { "type" : "mobile", "number" : "555-555-555", } ] }

Address is:

  1. a nested array
  2. a nested object
  3. a root object - ✔ ✔ 2. a nested object You have the following JSON document. Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the JSON document.

],

"phone numbers": [ { "type" : "mobile", "number" : "555-555-555", } ] }

Social Media is:

  1. a nested array
  2. a nested object
  3. a root object - ✔ ✔ 1. a nested array You are reviewing the data model shown in the following exhibit:

Customer -> Sales Key: CustomerID Foreign Keys: None

Product -> Sales Key: ProductID Foreign Keys: None

SalesPerson -> Sales Key: SalesPersonID Foreign Keys: None

Warehouse -> Sales Key: WarehouseID Foreign Keys: None

Sales: Key: SalesID Foreign Keys: CustomerID, ProductID, SalesPersonID, WarheouseID

The data model is

  1. transactional model
  2. star schema

Key: SalesID Foreign Keys: CustomerID, ProductID, SalesPersonID, WarheouseID

Customer is ......table

  1. fact
  2. dimension
  3. bridge - ✔ ✔ 2. dimension The massively parallel processing (MPP) engine of Azure Synapse Analytics:
  4. distributes processing across compute notes
  5. distributes processing across control nodes
  6. redirects client connections across compute notes
  7. redirects client connections across control nodes - ✔ ✔ 1. distributes processing across compute notes
  8. A clustered index
  9. A Filetable
  10. A Foreign Key
  11. A stored procedure

...is an object associated with a table that sorts and stores the data rows in the table based on their key values - ✔ ✔ 1. A clustered index A relational database must be used when....

  1. a dynamic schema is required
  2. data will be stored as key/value pairs
  3. storing large images and videos
  4. strong consistency guarantees are required - ✔ ✔ 4. strong consistency guarantees are required Relational data uses ......to enforce relationships between different tables
  5. collections
  6. columns
  7. keys
  8. partitions - ✔ ✔ 3. keys .....is a virtual table that contains content defined by a query
  9. A heap
  10. A stored procedure
  11. A view
  12. An index - ✔ ✔ 3. A view

Product3. 176

Which statement should you use in a SQL query to change the inventory quantity of Product1 to 270?

A. INSERT B. MERGE C. UPDATE D. CREATE - ✔ ✔ C. UPDATE Your company needs to implement a relational database in Azure. The solution must minimize ongoing maintenance. Which Azure service should you use?

A. Azure HDInsight B. Azure SQL Database C. Azure Cosmos DB D. SQL Server on Azure virtual machines - ✔ ✔ B. Azure SQL Database You are writing a set of SQL queries that administrators will use to troubleshoot an Azure SQL database.

You need to embed documents and query results into a SQL notebook.What should you use?

A. Microsoft SQL Server Management Studio (SSMS) B. Azure Data Studio C. Azure CLI D. Azure PowerShell - ✔ ✔ B. Azure Data Studio A database object that holds data

  1. Index
  2. View
  3. Table - ✔ ✔ 3. Table A database object whose content is defined by a query
  4. Index
  5. View
  6. Table - ✔ ✔ 2. View A database object that helps improve the speed of data retrieval
  7. Index
  8. View
  9. Table - ✔ ✔ 1. Index Which command-line tool can you use to query Azure SQL databases?