DP-203 Certification Practice Question #39

Question

You are performing exploratory analysis of the bus fare data in an Azure Data Lake Storage Gen2 account by using an Azure Synapse Analytics serverless SQL pool.
You execute the Transact-SQL query shown in the following exhibit.

What do the query results include?

Accepted Answer

In serverless SQL pool, the `BULK` path pattern uses wildcards to match files in storage. The `*.csv` suffix limits the read to CSV files, while the path prefix narrows the match to file names beginning with `tripdata_2020`. That makes D the best fit. The community notes a wording imperfection around whether subfolders could also be matched, but Microsoft?s wildcard behavior still supports D over the other choices because the key distinction is CSV-only plus a leading filename prefix.

More DP-203 practice questions