Azure Synapse Serverless SQL Pool Storage Location
You have an Azure subscription that contains an Azure Synapse Analytics serverless SQL pool. You execute the following query. Where will the rows returned by the query be stored? - 
Community Votes
100% of anonymous learners picked answer A. Votes are pick records left by other test-takers — they are not the verified answer.
Community Insight
The exam tests the distinction between dedicated and serverless SQL pools, with the common trap being confusion over temporary tables which are not supported in the same way as dedicated pools.
This question tests knowledge of Azure Synapse Analytics serverless SQL pool capabilities, specifically regarding external data storage. The community consensus confirms that serverless pools interact with Azure Data Lake Storage Gen2 for storing and querying data.
Candidates often choose C or D because they assume standard T-SQL behavior where results might be stored in temp tables; however, serverless pools do not support these traditional table types for persistent storage.
Community Discussion (9 comments)
Comments & Corrections
No comments yet — spotted an error or have a note? Share it below.
Expert Analysis
Why the Answer Is Correct
Serverless SQL pools in Azure Synapse Analytics are designed to query data directly from Azure Data Lake Storage (ADLS) Gen2 without needing to provision infrastructure. When you execute queries or create external tables, the data resides in the underlying data lake files (typically Parquet, CSV, etc.), making option A the correct choice.Why the Other Options Are Wrong
Options B, C, and D are incorrect because serverless SQL pools do not maintain a persistent relational database schema or support global/session temporary tables in the manner of dedicated SQL pools. They operate on a serverless basis, meaning there is no underlying SQL engine instance storing data in traditional database structures.Community Comment Notes
Comments [1] and [2] correctly cite Microsoft documentation confirming that serverless pools query and store data from ADLS. Comment [3] succinctly notes the absence of tables in serverless pools, reinforcing why options C and D are invalid.Official Reference
Exam Strategy
Memorize the architectural differences between Dedicated and Serverless SQL pools. Specifically, remember that Serverless does not support permanent tables or tempdb, relying entirely on external data sources like ADLS.