You manage an enterprise data warehouse in Azure Synapse Analytics. Users report slow performance when they run commonly used queries. Users do not report performance changes for infrequently used que

Question

Options

• ADWU percentage
• BCache hit percentage
• CData Warehouse Units (DWU) used
• DData IO percentage

• A
  2% (1)
• B
  84% (38)
• C
  4% (2)
• D
  9% (4)

Explanation

Cache hit percentage is correct because the symptom - slow performance only on commonly used queries, not infrequent ones - points directly to the adaptive cache. Commonly used queries should be served from cached data in the SSD-based layer; a low cache hit percentage means those queries are repeatedly reading from slower storage instead of cache, explaining the degraded performance pattern.

DWU percentage (A) and DWU used (C) measure overall compute utilization. They would show stress across all query types, not selectively on common ones - the symptom pattern doesn't fit a compute bottleneck. Data IO percentage (D) measures raw I/O throughput, which again would affect queries broadly and doesn't explain why frequency of use correlates with slowness.

Memory tip: Think "frequently used = should be cached." If common queries are slow but rare ones aren't, the cache is the suspect - so monitor cache hit %. If everything were slow, you'd look at DWU or IO.

No community discussion yet for this question.