LeetQuiz Logo
Privacy Policy•contact@leetquiz.com
© 2025 LeetQuiz All rights reserved.
Microsoft Azure Data Engineer Associate - DP-203

Microsoft Azure Data Engineer Associate - DP-203

Get started today

Ultimate access to all questions.


Comments

Loading comments...

You have an Azure subscription containing an Azure Synapse Analytics dedicated SQL pool named Pool1. You are evaluating whether to enable result set caching for Pool1.

The following queries are executed:

Query 1:

SELECT COUNT(*) FROM dbo.FactInternetSales

Query 2:

SELECT COUNT(*) FROM dbo.FactInternetSales
OPTION (LABEL = 'MyQuery')

Query 3:

SELECT COUNT(*) FROM dbo.FactInternetSales
WHERE OrderDateKey = '20210101'

Query 4:

SELECT COUNT(*) FROM dbo.FactInternetSales WITH (NOLOCK)

Query 5:

SELECT COUNT(*) FROM dbo.FactInternetSales
WHERE CustomerKey = 12345

Which query results will be cached when result set caching is enabled?

Exam-Like
Quiz related visual




Powered ByGPT-5