DP-203 Question #317: Real Exam Question with Answer & Explanation

Question

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 container1 container contains a folder named folder1. You need to query the top 100 rows of all the CSV files in folder1. How should you complete the query? To answer, drag the appropriate values to the correct targets. Each value may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content. NOTE: Each correct selection is worth one point. Answer:

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.

No community discussion yet for this question.