Azure Data Monitoring and Optimization Flashcards

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

Answer: Azure Monitor

Azure Monitor collects, analyzes, and acts on telemetry from Azure resources, providing metrics, logs, alerts, and dashboards in a single platform.

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

Answer: To capture query execution plans and runtime statistics for performance troubleshooting

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

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

Answer: Automatic Tuning

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

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

Answer: Replicated distribution

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

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

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

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.

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

Answer: HTTP 429 (Request Rate Too Large) error rate

HTTP 429 errors in Cosmos DB indicate that requests are exceeding provisioned RU/s, causing the service to throttle and retry operations.