You have an Azure subscription that contains an Azure Synapse Analytics dedicated SQL pool named Pool1. You have the queries shown in the following table. You are evaluating whether to enable result…

The correct answer is C. Query1 and Query2 only. https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/performance- tuning-result-set-caching#whats-not-cached

Submitted by manish99· Mar 30, 2026Secure, monitor, and optimize data storage and data processing

Question

You have an Azure subscription that contains an Azure Synapse Analytics dedicated SQL pool named Pool1. You have the queries shown in the following table. You are evaluating whether to enable result set caching for Pool1. Which query results will be cached if result set caching is enabled?

Exhibit

Options

AQuery1 only
BQuery2 only
CQuery1 and Query2 only
DQuery1 and Query3 only
EQuery1, Query2, and Query3 only

How the community answered

(55 responses)

A
11% (6)
B
5% (3)
C
78% (43)
D
4% (2)
E
2% (1)

Explanation

https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/performance- tuning-result-set-caching#whats-not-cached

Topics

#result set caching#dedicated SQL pool#cache eligibility#query evaluation

Community Discussion

No community discussion yet for this question.

Full DP-203 Practice