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?
In Azure Synapse Analytics, result set caching is enabled for queries that are deterministic and do not use user-defined functions, row-level security, or have large result sets. According to the information given: 1. Query1 uses deterministic runtime expressions and has a result set size of 25 MB, which qualifies it for caching. 2. Query2 uses deterministic built-in functions and has a result set size of 1 GB, which qualifies it for caching. 3. Query3 uses user-defined functions (UDFs), which disqualifies it from caching even though its result set size is 50 MB. 4. Query4 uses row-level security (RLS) and has a result set size of 15 GB, which disqualifies it from caching both because it uses RLS and because the result set is larger than 10 GB. Therefore, only Query1 and Query2 will be cached if result set caching is enabled, making option C the correct choice.
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)
Correct. https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/performance-tuning-result-set-caching#whats-not-cached
Correct, queries that don't depend on the User
must be deterministic