DP-203 · Question #203
You are designing the folder structure for an Azure Data Lake Storage Gen2 account. You identify the following usage patterns: - Users will query data by using Azure Synapse Analytics serverless SQL p
The correct answer is A. \DataSource\SubjectArea\YYYY\WW\FileData_YYYY_MM_DD.parquet. The recommended folder structure that best meets the requirements is option A. It separates data by data source, year and week. It allows for easy filtering of data by year or week, which aligns with the usage pattern where most queries include a filter on the current year or wee
Question
You are designing the folder structure for an Azure Data Lake Storage Gen2 account. You identify the following usage patterns:
- Users will query data by using Azure Synapse Analytics serverless SQL
pools and Azure Synapse Analytics serverless Apache Spark pods.
- Most queries will include a filter on the current year or week.
- Data will be secured by data source.
You need to recommend a folder structure that meets the following requirements:
- Supports the usage patterns
- Simplifies folder security
- Minimizes query times
Which folder structure should you recommend?
Options
- A\DataSource\SubjectArea\YYYY\WW\FileData_YYYY_MM_DD.parquet
- B\DataSource\SubjectArea\YYYY-WW\FileData_YYYY_MM_DD.parquet
- CDataSource\SubjectArea\WW\YYYY\FileData_YYYY_MM_DD.parquet
- D\YYYY\WW\DataSource\SubjectArea\FileData_YYYY_MM_DD.parquet
- EWW\YYYY\SubjectArea\DataSource\FileData_YYYY_MM_DD.parquet
How the community answered
(42 responses)- A79% (33)
- B12% (5)
- C5% (2)
- D2% (1)
- E2% (1)
Explanation
The recommended folder structure that best meets the requirements is option A. It separates data by data source, year and week. It allows for easy filtering of data by year or week, which aligns with the usage pattern where most queries include a filter on the current year or week.
Topics
Community Discussion
No community discussion yet for this question.