nerdexam
MicrosoftMicrosoft

DP-203 · Question #170

DP-203 Question #170: Real Exam Question with Answer & Explanation

Sign in or unlock DP-203 to reveal the answer and full explanation for question #170. The question stem and answer options stay visible for context.

Submitted by anna_se· Mar 30, 2026Develop data processing

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?

Options

  • AOnly CSV files in the tripdata_2020 subfolder.
  • BAll files that have file names that beginning with "tripdata_2020".
  • CAll CSV files that have file names that contain "tripdata_2020".

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.

Topics

#Azure Synapse Analytics#Serverless SQL pool#OPENROWSET#Wildcard paths
Full DP-203 PracticeBrowse All DP-203 Questions