• Simplifies data security management by department Which folder structure should you recommend?

You are designing a folder structure for the files m 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 pooh

• Supports fast data retrieval for data from the current month

• Simplifies data security management by department Which folder structure should you recommend?
A . YYYMMDDDepartmentDataSourceDataFile_YYYMMMDD.parquet
B. DepdftmentDataSourceYYYMMDataFile_YYYYMMDD.parquet
C. DDMMYYYYDepartmentDataSourceDataFile_DDMMYY.parquet
D. DataSourceDepartmentYYYYMMDataFile_YYYYMMDD.parquet

View Answer

Answer: B

Explanation:

Department top level in the hierarchy to simplify security management.

Month (MM) at the leaf/bottom level to support fast data retrieval for data from the current month.