DP-203 Certification Practice Question #196

Question

You have an Azure Data Lake Storage account that contains one CSV file per hour for January 1, 2020, through January 31, 2023. The files are partitioned by using the following folder structure.

You need to query the files by using an Azure Synapse Analytics serverless SQL pool. The solution must return the row count of each file created during the last three months of 2022.

How should you complete the query? To answer, select the appropriate options in the answer area.

Accepted Answer

In Synapse serverless SQL, `filepath(n)` is based on wildcard position, not simply folder depth. Because the year `2022` is fixed in the BULK path and the month is represented by the first wildcard in the target pattern, the correct selector for the month is `filepath(1)`. The path itself should be constrained to the last three months of 2022 so only October through December files are considered before grouping by file path to count rows.

More DP-203 practice questions