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?

The correct answer is A. in a file in a data lake. Serverless SQL pools can query, import, and store data from Azure Blob Storage, Azure Data Lake Storage Gen1 and Gen2. Serverless does not support TYPE=Hadoop. https://learn.microsoft.com/en-us/sql/t-sql/statements/create-external-table-transact…

Submitted by joshua94· Mar 30, 2026Design and implement data storage

Question

Exhibit

Options

Ain a file in a data lake
Bin a relational database
Cin a global temporary table
Din a session temporary table

How the community answered

(23 responses)

A
78% (18)
B
4% (1)
C
13% (3)
D
4% (1)

Explanation

Serverless SQL pools can query, import, and store data from Azure Blob Storage, Azure Data Lake Storage Gen1 and Gen2. Serverless does not support TYPE=Hadoop. https://learn.microsoft.com/en-us/sql/t-sql/statements/create-external-table-transact- sql?view=azure-sqldw-latest&tabs=dedicated#overview-azure-synapse-analytics

Topics

#serverless SQL pool#CETAS#data lake storage#query output

Community Discussion

No community discussion yet for this question.

Full DP-203 Practice