Question 167

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?

• 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