nerdexam
MicrosoftMicrosoft

DP-203 · Question #221

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

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

Submitted by jakub_pl· Mar 30, 2026

Question

You are implementing a batch dataset in the Parquet format. Data tiles will be produced by using Azure Data Factory and stored in Azure Data Lake Storage Gen2. The files will be consumed by an Azure Synapse Analytics serverless SQL pool. You need to minimize storage costs for the solution. What should you do?

Options

  • AStore all the data as strings in the Parquet tiles.
  • BUse OPENROWEST to query the Parquet files.
  • CCreate an external table mat contains a subset of columns from the Parquet files.
  • DUse Snappy compression for the files.

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.

Full DP-203 PracticeBrowse All DP-203 Questions