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 S

The correct answer is C. Create an external table mat contains a subset of columns from the Parquet files.. An external table points to data located in Hadoop, Azure Storage blob, or Azure Data Lake Storage. External tables are used to read data from files or write data to files in Azure Storage. With Synapse SQL, you can use external tables to read external data using dedicated SQL po

Submitted by jakub_pl· Mar 30, 2026Secure, monitor, and optimize data storage and data processing

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.

How the community answered

(44 responses)

A
7% (3)
B
2% (1)
C
77% (34)
D
14% (6)

Explanation

An external table points to data located in Hadoop, Azure Storage blob, or Azure Data Lake Storage. External tables are used to read data from files or write data to files in Azure Storage. With Synapse SQL, you can use external tables to read external data using dedicated SQL pool or serverless SQL pool. https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/develop-tables-external-tables

Topics

#Parquet format#storage cost optimization#external table#serverless SQL pool

Community Discussion

No community discussion yet for this question.

Full DP-203 Practice