
Ultimate access to all questions.
You are designing a folder structure for files in an Azure Data Lake Storage Gen2 account. The account has a single container holding three years of data.
You need to recommend a folder structure that meets these requirements:
Enables partition elimination for queries using Azure Synapse Analytics serverless SQL pools
Optimizes data retrieval speed for the current month's data
Simplifies data security management by department
Which folder structure should you recommend?
A
\Department\DataSource\YYYY\MM\DataFile_YYYYMMDD.parquet
B
\DataSource\Department\YYYYMM\DataFile_YYYYMMDD.parquet
C
\DD\MM\YYYY\Department\DataSource\DataFile_DDMMYY.parquet
D
\YYYY\MM\DD\Department\DataSource\DataFile_YYYYMMDD.parquet