Microsoft DP-900 Exam Dumps

Microsoft DP-900 Sample Question Answers

Question # 1

A data engineer is responsible for which task?

A. Design and build analytical models. 
B. Design and implement data stores for analytical workloads. 
C. Explore data to identify trends. 
D. Implement policies, tools. and processes for backup and recovery plans. 

Show Answer

Question # 2

Which Azure SQL offering provides near-IOO percent compatibility with on-premises Microsoft SQL Server instances, while providing automated updates, backups, and maintenance tasks? 

A. Azure SQL Managed Instance 
B. SQL Server on Azure Virtual Machines
C. Azure SQL Edge 
D. Azure SQL Database

Show Answer

Question # 3

What should you use to automatically delete blobs from Azure Blob Storage?

A. soft delete 
B. archive storage
C. the change feed 
D. a lifecycle management policy 

Show Answer

Question # 4

What is required to provision Azure Data Lake Storage in an Azure Storage account? 

A. Versioning must be enabled. 
B. Hierarchical namespace must be enabled. 
C. Hierarchical namespace must be disabled. 
D. Versioning must be disabled.

Show Answer

Question # 5

You need to recommend a data store service that meets the following requirements:Native SQL API access Configurable indexesWhat should you recommend? 

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

Show Answer

Question # 6

What is a characteristic of non-relational data?

A. a well-defined schema
B. no indexes 
C. self-describing entities 
D. no unique key values 

Show Answer

Question # 7

What is the primary purpose of a data warehouse? 

A. to provide answers to complex queries that rely on data from multiple sources 
B. to provide transformation services between source and target data stores 
C. to provide read-only storage of relational and non-relational historical data 
D. to provide storage for transactional line-of-business (LOB) applications 

Show Answer

Question # 8

What is used to define a query in a stream processing jobs in Azure Stream Analytics?

A. XML 
B. KQL
C. YAML 
D. SQL 

Show Answer

Question # 9

Your company needs to design a database that illustrates the relationships between utilization levels of individual network devices across a local area network.Which type of data store should you use?  

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

Show Answer

Question # 10

Which T-SQL statement should be used to instruct a database management system to use an index instead of performing a full table scan? 

A. WHERE
B. SELECT 
C. JOIN 

Show Answer

Question # 11

You need to store data by using Azure Table storage.What should you create first?  

A. an Azure Cosmos DB instance 
B. a storage account
C. a blob container 
D. a table

Show Answer

Question # 12

You need to perform hybrid transactional and analytical processing (HTAP) queries against Azure Cosmos DB data sources by using Azure Synapse Analytics.What should you use?  

A. Synapse pipelines
B. a Synapse SQL pool
C. Synapse Link 
D. Synapse Studio 

Show Answer

Question # 13

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

A. INSERT 
B. DISABLE
C. ALTER 
D. DROP 

Show Answer

Question # 14

Which two activities can be performed entirely by using the Microsoft Power BI service? Each correct answer presents a complete solution. (Choose two.) NOTE: Each correct selection is worth one point.

A. report and dashboard creation 
B. report sharing and distribution 
C. data modeling
D. data acquisition and preparation 

Show Answer

Question # 15

Which storage solution supports access control lists (ACLs) at the file and folder level?

A. Azure Data Lake Storage 
B. Azure Cosmos DB 
C. Azure Queue storage 
D. Azure Blob storage 

Show Answer

Question # 16

Which property of a transactional workload guarantees that each transaction is treated as a single unit that either succeeds completely or fails completely? 

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

Show Answer

Question # 17

You have an application that runs on Windows and requires access to a mapped drive. Which Azure service should you use?

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

Show Answer

Question # 18

A bank has a system that manages financial transactions.When transferring money between accounts, the system must never retrieve a value for the source account that reflects the balance before the transfer and a value for the destination account that reflects the balance after the transfer.Of which ACID semantic is this an example? 

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

Show Answer

Question # 19

You need to store event log data that is semi-structured and received as the logs occur. What should you use? 

A. Azure Table storage 
B. Azure Queue storage 
C. Azure Files

Show Answer

Question # 20

Which component of Azure Data Factory enables you to define a sequence of activities including for each iterators? 

A. control flow
B. linked services 
C. datasets
D. the integration runtime 

Show Answer

Question # 21

What Is a benefit of hosting a database on Azure SQL managed instance as compared to an Azure SQL database? 

A. native support for cross-database queries and transactions
B. built-in high availability 
C. system-Initiated automatic backups 
D. support for encryption at rest

Show Answer

Question # 22

You need to create an Azure resource to store data in Azure Table storage.Which command should you run? 

A. az scorage share create 
B. az scorage account creace 
C. az cosmosdb creace 
D. az scorage concainer creace 

Show Answer

Question # 23

What is a characteristic of batch processing? 

A. The data ingested during batch processing must be processed as soon as the data is received. 
B. Large datasets must be split into batches of less than 1 GB before the data can be processed.
C. There is a noticeable time delay between ingesting data and obtaining the data processing results.
D. Batch processing can only process data that is structured. 

Show Answer

Question # 24

Which clause should you use in a select statement to combine rows in one table with rows in another table?  

A. JOIN
B. VALUES
C. set 
D. KEY 

Show Answer

Question # 25

Which type of Azure resource supports the serverless configuration of an Azure SQL database? 

A. Azure SQL Managed Instance
B. SQL Server on Azure Virtual Machines 
C. a single database in Azure SQL Database 
D. an Azure SQL Database elastic pool 

Show Answer

Question # 26

Which type of database is Azure Database for PostgreSQL?

A. Platform as a service (PaaS)
B. Infrastructure as a service (laaS)
C. Microsoft SQL Server 
D. on-premises 

Show Answer

Question # 27

You have a transactional application that stem data in an Azure SQL managed instance. When should you implement a read-only database replica? 

A. You need to generate reports without affecting the transactional workload.
B. You need to audit the transactional application. 
C. You need to implement high availability in the event of a regional outage 
D. You need to improve the recovery point objective (RPO).

Show Answer

Question # 28

What is a primary characteristic of a relational database? 

A. data is queried and manipulated by using a variant of the SQL language 
B. a flexible data structure 
C. a lack of dependencies between tables
D. a large amount of duplicate data

Show Answer

Question # 29

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