DP-300: Administering Microsoft Azure SQL Solutions

By Microsoft · Question Mode

QuestionQ20

Monitor, configure, and optimize database resources

You manage an enterprise data warehouse in Azure Synapse Analytics.

Users report slow performance when running commonly used queries. They do not report performance changes for infrequently used queries.

You need to monitor resource utilization to identify the source of the performance issues.

Which metric should you monitor?

Explanation

Cache hit percentage measures how effectively workloads use the dedicated SQL pool cache. A low value indicates more physical reads because frequently accessed working data is not being served from cache, which can slow commonly used queries while infrequently used queries show no corresponding change. Microsoft identifies Cache hit percentage as a key metric for troubleshooting cache-related query performance.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!