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…
The correct answer is B. \Department\DataSource\YYYY\MM\DataFile_YYYYMMDD.parquet. Department top level in the hierarchy to simplify security management. Month (MM) at the leaf/bottom level to support fast data retrieval for data from the current month.
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
How the community answered
(29 responses)- A10% (3)
- B83% (24)
- C3% (1)
- D3% (1)
Explanation
Department top level in the hierarchy to simplify security management. Month (MM) at the leaf/bottom level to support fast data retrieval for data from the current month.
Topics
Community Discussion
No community discussion yet for this question.