Pre-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: 4

Questions 31

You are writing a set of SQL queries that administrators will use to troubleshoot an Azu re SQL database.

You need to embed documents and query results into a SQL notebook.

What should you use?

Options:
A.

Microsoft SQL Server Management Studio (SSMS)

B.

Azure Data Studio

C.

Azure CLI

D.

Azure PowerShell

Microsoft DP-900 Premium Access
Questions 32

Match The Types of data stores to The appropriate scenarios.

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

NOTE: Each correct match is worth one point

DP-900 Question 32

Options:
Questions 33

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?

Options:
A.

queue

B.

blob

C.

file

D.

table

Questions 34

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

Options:
A.

a control flow

B.

a trigger

C.

a paramet er

D.

an activity

Questions 35

Your company is designing a data store tor internet-connected temperature sensors. The collected data will be used to analyze temperature trends. Which type of data store should you use?

Options:
A.

relational

B.

columnar

C.

graph

D.

time series

Questions 36

Select the answer that correctly completes the sentence.

DP-900 Question 36

Options:
Questions 37

You have a table named Sales that contains the following data.

DP-900 Question 37

You need to query the table to return the average sales amount day. The output must produce the following results.

DP-900 Question 37

How should you complete the query? To answer, drag the appropriate values to the correct targets. Each value may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.

NOTE: Each correct selection is worth one point.

DP-900 Question 37

Options:
Questions 38

To complete the sente nce, select the appropriate option in the answer area.

DP-900 Question 38

Options:
Questions 39

Select the answer that correctly completes the sentence.

DP-900 Question 39

Options:
Questions 40

Select the answer that correctly completes the sentence.

DP-900 Question 40

Options: