DP-200 Azure Data Monitoring and Optimization

Question 1

Which Azure tool provides a unified monitoring experience for metrics, logs, and alerts across Azure data services?

Accepted Answer

Azure Monitor

Answer

Azure Service Health

Answer

Azure Advisor

Answer

Azure Cost Management

Question 2

In Azure SQL Database, what is the purpose of Query Store?

Accepted Answer

To capture query execution plans and runtime statistics for performance troubleshooting

Answer

To cache frequently executed query results

Answer

To store parameterized queries as stored procedures

Answer

To replicate queries to a secondary replica

Question 3

What Azure SQL Database feature automatically identifies performance recommendations such as missing indexes or plan regression?

Accepted Answer

Automatic Tuning

Answer

Query Store

Answer

Extended Events

Answer

Dynamic Management Views (DMVs)

Question 4

In Azure Synapse Analytics dedicated SQL pool, which distribution type should be used for small dimension tables to avoid data movement during joins?

Accepted Answer

Replicated distribution

Answer

Hash distribution

Answer

Round-robin distribution

Answer

Partitioned distribution

Question 5

What is the purpose of result-set caching in Azure Synapse Analytics dedicated SQL pool?

Accepted Answer

To return cached results for repeated identical queries without re-executing the computation

Answer

To store intermediate ETL results in ADLS

Answer

To compress query results before returning to the client

Answer

To distribute query load across nodes

Question 6

Which Azure Cosmos DB metric should you monitor to detect when your provisioned throughput is being throttled?

Accepted Answer

HTTP 429 (Request Rate Too Large) error rate

Answer

Total Request Units consumed

Answer

Average document size in bytes

Answer

Number of physical partitions