Exam DP-203 topic 4 question 63 discussion

Actual exam question from Microsoft's DP-203

Question #: 63
Topic #: 4

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?

A. Query1 only
B. Query2 only
C. Query1 and Query2 only
D. Query1 and Query3 only
E. Query1, Query2, and Query3 only

Show Suggested Answer

Suggested Answer: C 🗳️

by jongert at Jan. 5, 2024, 5:49 p.m.

Comments

Submit Cancel

Tapaskaro

Highly Voted 1 year, 6 months ago

correct What's not cached Once result set caching is turned ON for a database, results are cached for all queries until the cache is full, except for these queries: Queries with built-in functions or runtime expressions that are non-deterministic even when there’s no change in base tables’ data or query. For example, DateTime.Now(), GetDate(). Queries using user defined functions Queries using tables with row level security Queries returning data with row size larger than 64KB Queries returning large data in size (>10GB)

upvoted 12 times

...

jongert

Highly Voted 1 year, 6 months ago

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

upvoted 7 times

...

f7c717f

Most Recent 7 months, 2 weeks ago

Selected Answer: C

Answer is "C" as below Examples shows Examples of Eligible and Ineligible Queries Eligible Queries: Queries using deterministic runtime expressions. Queries using deterministic built-in functions. Ineligible Queries: Queries using user-defined functions (UDFs). Queries using row-level security (RLS). Queries using non-deterministic functions (e.g., GETDATE(), NEWID()).

upvoted 1 times

...

evangelist

12 months ago

Selected Answer: B

must be deterministic

upvoted 1 times

...

Alongi

1 year, 4 months ago

Selected Answer: C

Correct, queries that don't depend on the User

upvoted 2 times

...