Microsoft
DP-203 · Question #207
You are designing a folder structure for the files in an Azure Data Lake Storage Gen2 account. The account has one container that contains three years of data. You need to recommend a folder structure
Sign in or unlock DP-203 to reveal the answer and full explanation for question #207. The question stem and answer options stay visible for context.
Submitted by anna_se· Mar 30, 2026Design and implement data storage
Question
You are designing a folder structure for the files in an Azure Data Lake Storage Gen2 account. The account has one container that contains three years of data. You need to recommend a folder structure that meets the following requirements:
- Supports partition elimination for queries by Azure Synapse Analytics
serverless SQL pools
- Supports fast data retrieval for data from the current month
- Simplifies data security management by department
Which folder structure should you recommend?
Options
- A\YYY\MM\DD\Department\DataSource\DataFile_YYYMMMDD.parquet
- B\Department\DataSource\YYYY\MM\DataFile_YYYYMMDD.parquet
- C\DD\MM\YYYY\Department\DataSource\DataFile_DDMMYY.parquet
- D\DataSource\Department\YYYYMM\DataFile_YYYYMMDD.parquet
Unlock DP-203 to see the answer
You've previewed enough free DP-203 questions. Unlock DP-203 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#ADLS Gen2 folder structure#partition elimination#department security#data retrieval