Ultimate access to all questions.
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?