DP-203 · Question #11
You have files and folders in Azure Data Lake Storage Gen2 for an Azure Synapse workspace as shown in the following exhibit. You create an external table named ExtTable that has…
The correct answer is B. File1.csv and File4.csv only. In case of a serverless pool a wildcard should be added to the location. https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/develop-tables-external- tables?tabs=hadoop#arguments-create-external-table
Question
You have files and folders in Azure Data Lake Storage Gen2 for an Azure Synapse workspace as shown in the following exhibit. You create an external table named ExtTable that has LOCATION='/topfolder/'. When you query ExtTable by using an Azure Synapse Analytics serverless SQL pool, which files are returned?
Exhibit
Options
- AFile2.csv and File3.csv only
- BFile1.csv and File4.csv only
- CFile1.csv, File2.csv, File3.csv, and File4.csv
- DFile1.csv only
How the community answered
(30 responses)- A10% (3)
- B73% (22)
- C3% (1)
- D13% (4)
Explanation
In case of a serverless pool a wildcard should be added to the location. https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/develop-tables-external- tables?tabs=hadoop#arguments-create-external-table
Topics
Community Discussion
No community discussion yet for this question.