Ultimate access to all questions.
You are designing the folder structure for an Azure Data Lake Storage Gen2 container. Data will be queried using services like Azure Databricks and Azure Synapse Analytics serverless SQL pools. The data must be secured by subject area, and most queries will filter for the current year or current month. Which folder structure provides the best query performance and simplifies folder-level security?