Microsoft
DP-203 · Question #311
You have an Azure subscription that contains the resources shown in the following table. You need to read the TSV files by using ad-hoc queries and the OPENROWSET function. The solution must assign a
Sign in or unlock DP-203 to reveal the answer and full explanation for question #311. The question stem and answer options stay visible for context.
Submitted by thandi_sa· Mar 30, 2026Develop data processing
Question
You have an Azure subscription that contains the resources shown in the following table. You need to read the TSV files by using ad-hoc queries and the OPENROWSET function. The solution must assign a name and override the inferred data type of each column. What should you include in the OPENROWSET function?
Exhibit
Options
- Athe WITH clause
- Bthe ROWSET_OPTIONS bulk option
- Cthe DATAFILETYPE bulk option
- Dthe DATA_SOURCE parameter
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
#OPENROWSET#WITH clause#serverless SQL pool#TSV