Which folder structure should you recommend?

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?
A . YYYYYWWDataSourceSubjectAreaFileData_YYYY_MM_D
B . parquet
C . DataSourceSubjectAreaWWYYYYFileData_YYYY_MM_D
D . parquet
E . DataSourceSubjectAreaYYYYWWFileData_YYYY_MM_D
F . parquet
G . DataSourceSubjectAreaYYYY-WWFileData_YYYY_MM_D
H . parquet
. WWYYYYSubjectAreaDataSourceFileData_YYYY_MM_D
. parquet

View Answer

Answer: D