Exit demo DP-200 Implementing an Azure Data Solution PDF format · free preview

Microsoft DP-200 - Questions & Answers

Free preview · every answer includes a full explanation

Product page: https://prepkeys.com/dp-200.html

Question 1
Single choice

You need to ensure that phone-based poling data can be analyzed in the PollingData database.

How should you configure Azure Data Factory?

A.

Use a tumbling schedule trigger

B.

Use an event-based trigger

C.

Use a schedule trigger

D.

Use manual execution

Question 2
Hotspot

HOTSPOT

You need to ensure polling data security requirements are met.

Which security technologies should you use? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Question 3
Hotspot

HOTSPOT

You need to ensure phone-based polling data upload reliability requirements are met. How should you configure monitoring? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Question 4
Hotspot

HOTSPOT

You need to ensure that Azure Data Factory pipelines can be deployed. How should you configure authentication and authorization for deployments? To answer, select the appropriate options in the answer choices.

NOTE: Each correct selection is worth one point.

Question 5
Drag & drop

DRAG DROP

You need to provision the polling data storage account.

How should you configure the storage account? To answer, drag the appropriate Configuration Value to the correct Setting. Each Configuration 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.

Question 6
Drag & drop

DRAG DROP

You need to ensure that phone-based polling data can be analyzed in the PollingData database.

Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

Question 7
Single choice

On which data store should you configure TDE to meet the technical requirements?

A.

Cosmos DB

B.

Azure Synapse Analytics

C.

Azure SQL Database

Question 8
Single choice

What should you include in the Data Factory pipeline for Race Central?

A.

a copy activity that uses a stored procedure as a source

B.

a copy activity that contains schema mappings

C.

a delete activity that has logging enabled

D.

a filter activity that has a condition

Question 9
Multiple choice

Which two metrics should you use to identify the appropriate RU/s for the telemetry data? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

A.

Number of requests

B.

Number of requests exceeded capacity

C.

End to end observed read latency at the 99th percentile

D.

Session consistency

E.

Data + Index storage consumed

F.

Avg Throughput/s

Question 10
Single choice

What should you implement to optimize SQL Database for Race Central to meet the technical requirements?

A.

the sp_update_stats stored procedure

B.

automatic tuning

C.

Query Store

D.

the dbcc checkdb command

Showing 10 of 249 questions · Unlock the full set