Question 58

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 pools. • 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\DataSource\SubjectArea\YYYY\WW\FileData_YYYY_MM_DD.parquet
• B\DataSource\SubjectArea\YYYY-WW\FileData_YYYY_MM_DD.parquet
• CDataSource\SubjectArea\WW\YYYY\FileData_YYYY_MM_DD.parquet
• D\YYYY\WW\DataSource\SubjectArea\FileData_YYYY_MM_DD.parquet
• EWW\YYYY\SubjectArea\DataSource\FileData_YYYY_MM_DD.parquet