DP-203 Certification Practice Question #279

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?

Accepted Answer

Result set caching in a dedicated SQL pool applies to eligible deterministic queries and excludes specific ineligible categories such as non-deterministic functions and user-defined functions. The community comments cite exactly that rule set, and the suggested answer agrees that Query1 and Query2 qualify while Query3 does not. So only Query1 and Query2 are cached.

More DP-203 practice questions