DP-900 Exam Dumps - Microsoft Certified: Azure Data Fundamentals Questions and Answers

You have an on-premises Microsoft SQL Server database.

You need to migrate the database to the cloud. The solution must meet the following requirements:

• Minimize maintenance effort.

• Support the Database Mail and Service Broker features.

What should you include in the solution?

What should you include in the solution?

Match the job roles to the appropriate tasks.

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

NOTE: Each correct match is worth one point.

Select the answer that correctly completes the sentence.

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?

Select the answer that correctly completes the sentence.

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

You need to query a table named Products in an Azure SQL database.

Which three requirements must be met to query the table from the internet? Each correct answer presents part of the solution. (Choose three.)

NOTE: Each correct selection is worth one point.

What is the primary purpose of a data warehouse?

For each of the following statements, select Yes if the statement is true. Otherwise, select No.

NOTE: Each correct selection is worth one point.

Select the answer that correctly completes the sentence.