DP-203 · Question #207
DP-203 Question #207: Real Exam Question with Answer & Explanation
Sign in or unlock DP-203 to reveal the answer and full explanation for question #207. The question stem and answer options stay visible for context.
Question
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?
Options
- A\YYY\MM\DD\Department\DataSource\DataFile_YYYMMMDD.parquet
- B\Department\DataSource\YYYY\MM\DataFile_YYYYMMDD.parquet
- C\DD\MM\YYYY\Department\DataSource\DataFile_DDMMYY.parquet
- D\DataSource\Department\YYYYMM\DataFile_YYYYMMDD.parquet
Unlock DP-203 to see the answer
You've previewed enough free DP-203 questions. Unlock DP-203 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.