Microsoft DP-900 Exam Dumps

Microsoft DP-900 Sample Question Answers

Question # 1

Which statement is an example of Data Manipulation Language (DML)? 

A. REVOKE 
B. DISABLE 
C. CREATE 
D. UPDATE 

Show Answer

Question # 2

Which three actions are used when performing diagnostic analytics? 

A. • Identify data anomalies • Collect anomaly-related data • Discover relationships and trends that explain anomalies. 
B. • Identify data anomalies • Predict when anomalies are likely to recur • Use analytical tools such as decision trees and regression. 
C. • Apply serf-learning loops to draw inferences from anomalies. • Predict when anomalies are likely to recur • Use analytical tools such as decision trees and regression. 
D. • Identify data anomalies • Use machine learning to find patterns in large datasets. • Discover relationships and trends that explain anomalies. 

Show Answer

Question # 3

You plan to deploy an app. The app requires a nonrelational data service that will provide latency guarantees of less than 10-ms for reads and writes. What should you include in the solution? 

A. Azure Cosmos 
B. Azure Table storage 
C. Azure Files 
D. Azure Blob storage 

Show Answer

Question # 4

You need to use Transact-SQL to query files in Azure Data Lake Storage from an Azure Synapse Analytics data warehouse. What should you use to query the files?

A. Azure Functions 
B. Microsoft SQL Server Integration Services (SSIS) 
C. PolyBase 
D. Azure Data Factory 

Show Answer

Question # 5

Which statement is an example of Data Definition Language (DDL)? 

A. SELECT 
B. JOIN 
C. MERGE 
D. CREATE 

Show Answer

Question # 6

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 

Show Answer

Question # 7

Your company is designing a database that will contain session data for a website. The data will include notifications, personalization attributes, and products that are added to a shopping cart. Which type of data store will provide the lowest latency to retrieve the data? 

A. key/value
B. graph 
C. columnar 
D. document 

Show Answer

Question # 8

You need to design and model a database by using a graphical tool that supports project oriented offline database development. What should you use? 

A. Microsoft SQL Server Data Tools (SSDT) 
B. Microsoft SQL Server Management Studio (SSMS) 
C. Azure Databricks 
D. Azure Data Studio 

Show Answer

Question # 9

Which Azure Data Factory component provides the compute environment for activities? 

A. a linked service 
B. an integration runtime 
C. a control flow 
D. a pipeline 

Show Answer

Question # 10

What are two characteristics of real-time data processing? Each correct answer present a complete solution. NOTE: Each correct selection is worth one point. 

A. Data is processed as it is created. 
B. Low latency is expected 
C. High latency acceptable 
D. Data is processed periodically 

Show Answer

Question # 11

You manage an application that stores data in a shared folder on a Windows server. You need to move the shared folder to Azure Storage. Which type of Azure Storage should you use? 

A. queue 
B. blob 
C. file 
D. table 

Show Answer

Question # 12

Your company needs to ensure that in Azure virtual machine can connect to Azure SQL databases without exposing the databases to the internet. What should you use? 

A. Azure DNS 
B. Azure Application Gateway 
C. Azure Private link 
D. Azure Traffic Manager 

Show Answer

Question # 13

Which setting can only be configured during the creation of an Azure Cosmos DB account? 

A. geo-redundancy 
B. multi-region writes 
C. production or non-reduction account type 
D. API 

Show Answer

Question # 14

Which two Azure services can be used to provision Apache Spark clusters? Each correct answer presents a complete solution. (Choose two.) NOTE: Each correct selection is worth one point.

 A. Azure Time Series Insights 
B. Azure HDInsight 
C. Azure Databricks 
D. Azure Log Analytics

Show Answer

Question # 15

Which Azure Data Factory component initiates the execution of a pipeline? 

A. a control flow 
B. a trigger 
C. a parameter 
D. an activity 

Show Answer

Question # 16

What are two uses of data visualization? Each correct answer present a complete solution. NOTE: Each correct selection is worth one point. 

A. Represent trends and patterns over time. 
B. Communicate the significance of data. 
C. implement machine learning to predict future values. 
D. Consistently implement business logic across reports 

Show Answer

Question # 17

You need to modify a view in a relational database by adding a new column. Which statement should you use? 

A. MERGE 
B. ALTER 
C. INSERT 
D. UPDATE 

Show Answer

Question # 18

Which type of database contains nodes and edges? 

A. graph 
B. columnar 
C. key/value 
D. time series 

Show Answer

Question # 19

Which three objects can be added to a Microsoft Power BI dashboard? Each correct answer presents a complete solution. (Choose three.) NOTE: Each correct selection is worth one point. 

A. a report page 
B. a Microsoft PowerPoint slide 
C. a visualization from a report 
D. a dataflow 
E. a text box 

Show Answer

Question # 20

What is a benefit of the Azure Cosmos DB Table API as compared to Azure Table storage? 

A. supports partitioning 
B. provides resiliency if art Azure region fads 
C. provides a higher storage capacity 
D. supports a multi-master model 

Show Answer

Question # 21

What ate three characteristics of an Online Transaction Processing (OLTP) workload? Each correct answer presents a complete solution NOTE: Each correct selection is worth one point. 

A. denormalized data 
B. schema defined in a database 
C. schema defined when reading unstructured data from a database 
D. normalized data 
E. light writes and heavy reads 
F. heavy writes and moderate reads 

Show Answer

Question # 22

You need to store data in Azure Blob storage for seven years to meet your company's compliance requirements. The retrieval time of the data is unimportant. The solution must minimize storage costs. Which storage tier should you use?

A. Archive 
B. Hot 
C. Cool 

Show Answer

Question # 23

Which database transaction property ensures that transactional changes to a database are preserved during unexpected operating system restarts? 

A. consistency 
B. durability 
C. isolation 
D. atomicity 

Show Answer

Question # 24

Which scenario is an example of a streaming workload? 

A. sending transactions that are older than a month to an archive 
B. sending transactions daily from point of sale (POS) devices 
C. sending telemetry data from edge devices 
D. sending cloud infrastructure metadata every 30 minutes 

Show Answer

Question # 25

You need to create an Azure Storage account. Data in the account must replica outside the Azure region automatically. Which two types of replica can you us for the storage account? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one pint. 

A. read-access geo-redundant storage (RA_GRS) 
B. zone-redundant storage (ZRS) 
C. geo-redundant storage (GRS) 
D. locally-redundant storage (LRS) 

Show Answer

Question # 26

You have an Azure SQL database that you access directly from the internet. You recently changed your external IP address. After changing the IP address, you can no longer access the database. You can connect to other resources in Azure What is a possible cause of the issue?

A. a database-level firewall 
B. role-based access control (RSAC) 
C. Dynamic Host Configuration Protocol (DHCP) 
D. Domain Name Service (DNS) 

Show Answer

Question # 27

At which level in Azure Cosmos DB can you configure multiple write regions and read regions? 

A. database 
B. partition 
C. collection 
D. account 

Show Answer

Question # 28

Which database transaction property ensures that individual transactions are executed only once and either succeed in their entirety or roll back? 

A. isolation 
B. durability 
C. atomicity 
D. consistency 

Show Answer

Question # 29

You need to gather real-time telemetry data from a mobile application. Which type of workload describes this scenario? 

A. Online Transaction Processing (OLTP) 
B. batch
C. massively parallel processing (MPP) 
D. streaming 

Show Answer

Question # 30

Which type of non-relational data store supports a flexible schema, stores data as JSON files, and stores the all the data for an entity in the same document? 

A. document 
B. columnar 
C. graph 
D. time series 

Show Answer

Question # 31

You have an Azure Cosmos DB account that uses the Core (SQL) API. Which two settings can you configure at the container level? Each correct answer presents a complete solution. (Choose two.) NOTE: Each correct selection is worth one point.

A. the throughput 
B. the read region 
C. the partition key 
D. the API 

Show Answer

Question # 32

A team of developers has computers Thai run Windows 10 and Ubuntu Desktop. The developers need to connect to and query an Azure SQL database from the computers. The developers require code assistance features such as intellSense. What should the developers use ? 

A. Azure Data Studio 
B. sq1cmd 
C. Microsoft SQL Server Management Studio (SSMS) 
D. Azure Data Explorer 

Show Answer