Answer-first summary for fast verification
Answer: File1.csv and File4.csv only
## Explanation When creating an external table in Azure Synapse Analytics serverless SQL pool with `LOCATION='/topfolder/'`, the behavior differs from dedicated SQL pools and Hadoop external tables. ### Key Technical Details: 1. **Native External Tables in Serverless SQL Pools**: Unlike Hadoop external tables or dedicated SQL pool external tables, native external tables in serverless SQL pools do **not** automatically traverse subfolders unless explicitly specified. 2. **Recursive Folder Traversal**: To enable recursive traversal of subfolders, you must append `/**` to the location path. Without this wildcard pattern, the external table will only access files located directly in the specified folder. 3. **File Access Behavior**: - With `LOCATION='/topfolder/'`: Only files directly in `/topfolder/` are accessible - With `LOCATION='/topfolder/**'`: All files in `/topfolder/` and its subfolders are accessible ### Analysis of the Scenario: Based on the folder structure shown in the exhibit: - **File1.csv** and **File4.csv** are located directly in `/topfolder/` - **File2.csv** is located in `/topfolder/folder1/` (subfolder) - **File3.csv** is located in `/topfolder/folder2/` (subfolder) Since the external table was created with `LOCATION='/topfolder/'` (without the `/**` wildcard), only files directly in the `/topfolder/` directory will be returned when querying the table. ### Why Other Options Are Incorrect: - **Option A (File2.csv and File3.csv only)**: Incorrect because these files are in subfolders and won't be accessed without the recursive wildcard. - **Option C (All four files)**: Incorrect because this would require `LOCATION='/topfolder/**'` to enable recursive subfolder traversal. - **Option D (File1.csv only)**: Incorrect because it misses File4.csv, which is also directly in the `/topfolder/` directory. This behavior is by design in serverless SQL pools to provide more granular control over file access and avoid unintended data exposure from nested folder structures.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
You have an Azure Data Lake Storage Gen2 account containing files and folders for an Azure Synapse workspace, as illustrated in the provided exhibit.
You create an external table named ExtTable with the LOCATION set to '/topfolder/'.
When you query ExtTable using an Azure Synapse Analytics serverless SQL pool, which files are returned?
A
File2.csv and File3.csv only
B
File1.csv and File4.csv only
C
File1.csv, File2.csv, File3.csv, and File4.csv
D
File1.csv only
No comments yet.