
Ultimate access to all questions.
You are designing the folder structure for an Azure Data Lake Storage Gen2 account with the following usage patterns:
Users will query data using Azure Synapse Analytics serverless SQL pools and Azure Synapse Analytics serverless Apache Spark pools.
Most queries will include a filter on the current year or current week.
Data will be secured by its data source.
You need to recommend a folder structure that meets these requirements:
Supports the specified usage patterns
Simplifies the management of folder security
Minimizes query execution times
Which folder structure should you recommend?
A
\DataSource\SubjectArea\YYYY\WW\FileData_YYYY_MM_DD.parquet
B
\DataSource\SubjectArea\YYYY-WW\FileData_YYYY_MM_DD.parquet
C
DataSource\SubjectArea\WW\YYYY\FileData_YYYY_MM_DD.parquet
D
\YYYY\WW\DataSource\SubjectArea\FileData_YYYY_MM_DD.parquet
E
WW\YYYY\SubjectArea\DataSource\FileData_YYYY_MM_DD.parquet