Summer Sale Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 70track

Free Microsoft DP-900 Practice Exam with Questions & Answers | Set: 6

Questions 51

Select the answer that correctly completes the sentence.

DP-900 Question 51

Options:
Microsoft DP-900 Premium Access
Questions 52

Which service is optimized for loT scenarios that involve streaming time series data?

Options:
A.

SQL Server on Azure Virtual Machines

B.

Azure SQL Managed Instance

C.

Azure SQL Database

D.

Azure SQL Edge

Questions 53

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

Options:
A.

XML

B.

KQL

C.

YAML

D.

SQL

Questions 54

Your company recently reported sales from the third quarter.

You have the chart shown in the following exhibit.

DP-900 Question 54

Which type of analysis is shown for the fourth quarter?

Options:
A.

predictive

B.

prescription

C.

descriptive

D.

diagnostic

Questions 55

To complete the sentence, select the appropriate option in the answer area.

DP-900 Question 55

Options:
Questions 56

You have an Azure SQL database that contains tables for customers and orders. You need to create a query that will return the orders placed by each customer.

Which two Transact-SQL statements should you include in the query? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

Options:
A.

JOIN

B.

ORDERBY

C.

INDEX

D.

SELECT

E.

EXISTS

Questions 57

In a fully denormalized database, how is data read and written for a single entity?

Options:
A.

Data is read from a single table and written to a single table.

B.

Data is read from multiple tables and written to a single table.

C.

Data is read from a single table and written to multiple tables.

D.

Data is read from multiple tables and written to multiple tables.

Questions 58

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

Options:
A.

soft delete

B.

archive storage

C.

the change feed

D.

a lifecycle management policy

Questions 59

Match the Azure services to the appropriate requirements.

To answer, drag the appropriate service from the column on the left to its requirement on the right. Each service may be used once, more than once, or not at all.

NOTE: Each correct match is worth one point.

DP-900 Question 59

Options:
Questions 60

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

Options:
A.

a control flow

B.

a trigger

C.

a parameter

D.

an activity