Explanation:
In Azure Synapse Analytics serverless SQL pools, the OPENROWSET function is used to read data directly from files in data storage without creating external tables. The key characteristics of this operation are:
Why Option A (in a file in a data lake) is correct:
OPENROWSET function with the BULK parameter reads data directly from the specified file location in Azure Data Lake StorageWhy other options are incorrect:
The fundamental principle is that serverless SQL pools provide on-demand query capabilities over data stored in external locations like Azure Data Lake Storage, Azure Blob Storage, or other supported data sources, without requiring data movement or local storage of results.
Ultimate access to all questions.
You have an Azure subscription that contains an Azure Synapse Analytics serverless SQL pool.
You execute the following query.
SELECT TOP 100 *
FROM OPENROWSET(
BULK 'https://datalake.blob.core.windows.net/container/folder/*.parquet',
FORMAT = 'PARQUET'
) AS [result]
SELECT TOP 100 *
FROM OPENROWSET(
BULK 'https://datalake.blob.core.windows.net/container/folder/*.parquet',
FORMAT = 'PARQUET'
) AS [result]
Where are the rows returned by the query stored?
A
in a file in a data lake
B
in a relational database
C
in a global temporary table
D
in a session temporary table
No comments yet.