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 Monitor collects, analyzes, and acts on telemetry from Azure resources, providing metrics, logs, alerts, and dashboards in a single platform.

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

Query Store persists query execution plans, runtime statistics, and wait statistics over time, enabling analysis of query performance regressions.

Question 3

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

Accepted Answer

Automatic Tuning

Answer

Automatic Tuning in Azure SQL Database monitors workloads and can automatically create missing indexes, drop unused indexes, and correct plan regressions.

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

Replicated tables store a full copy on every compute node, eliminating data movement when joining small dimension tables with large fact tables.

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

Result-set caching stores the output of a query and serves the same result for subsequent identical queries, dramatically reducing latency for repeated BI queries.

DP-200 - Microsoft Azure Data Solutions Practice Test

DP-200 - Microsoft Azure Data Solutions Practice Test

DP-200 Azure Data Monitoring and Optimization