You have an Azure Synapse Analytics workspace named WS1 that contains an Apache Spark pool named Pool1. You plan to create a database named DB1 in Pool1. You need to ensure that when tables are…

The correct answer is C. Parquet. Serverless SQL pool can automatically synchronize metadata from Apache Spark. A serverless SQL pool database will be created for each database existing in serverless Apache Spark pools. For each Spark external table based on Parquet and located in Azure Storage, an external…

Submitted by jakub_pl· Mar 6, 2026Plan and implement data platform resources

Question

You have an Azure Synapse Analytics workspace named WS1 that contains an Apache Spark pool named Pool1. You plan to create a database named DB1 in Pool1. You need to ensure that when tables are created in DB1, the tables are available automatically as external tables to the built-in serverless SQL pool. Which format should you use for the tables in DB1?

Options

AJSON
BCSV
CParquet
DORC

How the community answered

(26 responses)

A
8% (2)
B
4% (1)
C
73% (19)
D
15% (4)

Explanation

Serverless SQL pool can automatically synchronize metadata from Apache Spark. A serverless SQL pool database will be created for each database existing in serverless Apache Spark pools. For each Spark external table based on Parquet and located in Azure Storage, an external table is created in a serverless SQL pool database. As such, you can shut down your Spark pools and still query Spark external tables from serverless SQL pool. https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/develop-storage-files-spark-tables

Topics

#Synapse Analytics#Apache Spark pool#serverless SQL pool#Parquet format

Community Discussion

No community discussion yet for this question.

Full DP-300 Practice