DP-203 · Question #317
Drag and Drop Question You have an Azure Synapse Analytics serverless SQL pool. You have an Azure Data Lake Storage account named adls1 that contains a public container named container1. The container
The correct answer is OPENROWSET; BULK; DATA_SOURCE. In Azure Synapse Analytics serverless SQL pool, the correct query structure uses OPENROWSET as the primary function to read files from external storage, followed by the BULK parameter to specify the file path or pattern (e.g., 'https://adls1.dfs.core.windows.net/container1/folder
Question
Exhibit
Answer Area
Drag items
Correct arrangement
- OPENROWSET
- BULK
- DATA_SOURCE
Explanation
In Azure Synapse Analytics serverless SQL pool, the correct query structure uses OPENROWSET as the primary function to read files from external storage, followed by the BULK parameter to specify the file path or pattern (e.g., 'https://adls1.dfs.core.windows.net/container1/folder1/*.csv'), and optionally DATA_SOURCE to reference a pre-defined external data source. OPENROWSET is the T-SQL function that enables querying files directly in Azure Data Lake Storage without needing to load data first, BULK defines the file location/wildcard path within that function, and DATA_SOURCE can reference a named credential/location. LOCATION is not a valid parameter within the OPENROWSET function syntax - it is used in CREATE EXTERNAL TABLE definitions instead.
Topics
Community Discussion
No community discussion yet for this question.