Data Engineering on Microsoft Azure — Question 57

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?

Answer options

• A. Parquet
• B. ORC
• C. JSON
• D. HIVE

Correct answer: A

Explanation

The correct format for tables in DB1 to ensure they are available as external tables in the serverless SQL pool is Parquet, as it is optimized for performance and is compatible with Azure Synapse. While ORC, JSON, and HIVE are valid formats, they do not provide the same level of integration with serverless SQL pools in Azure Synapse Analytics as Parquet does.