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

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?

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

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?

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

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?

Select the answer that correctly completes the sentence.

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

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

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.

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

Select the answer that correctly completes the sentence.

Select the answer that correctly completes the sentence.