Data Engineering on Microsoft Azure — Question 79

You have a Log Analytics workspace named la1 and an Azure Synapse Analytics dedicated SQL pool named Pool1. Pool1 sends logs to la1.

You need to identify whether a recently executed query on Pool1 used the result set cache.

What are two ways to achieve the goal? Each correct answer presents a complete solution.

NOTE: Each correct selection is worth one point.

Answer options

• A. Review the sys.dm_pdw_sql_requests dynamic management view in Pool1.
• B. Review the sys.dm_pdw_exec_requests dynamic management view in Pool1.
• C. Use the Monitor hub in Synapse Studio.
• D. Review the AzureDiagnostics table in la1.
• E. Review the sys.dm_pdw_request_steps dynamic management view in Pool1.

Correct answer: B, C

Explanation

Option B is correct as reviewing the sys.dm_pdw_exec_requests view provides information on currently executing requests, including cache usage. Option C is also correct because the Monitor hub in Synapse Studio allows users to review query performance, which includes details about caching. Options A, D, and E do not specifically provide the necessary information about result set cache usage for recently executed queries.