Microsoft
DP-203 · Question #396
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 s
Sign in or unlock DP-203 to reveal the answer and full explanation for question #396. The question stem and answer options stay visible for context.
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
Unlock DP-203 to see the answer
You've previewed enough free DP-203 questions. Unlock DP-203 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#result set caching#dedicated SQL pool#cache eligibility#query evaluation