Administering Relational Databases on Microsoft Azure — Question 16

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. JSON
• B. CSV
• C. Parquet
• D. ORC

Correct answer: C

Explanation

The correct answer is C, Parquet, as it is the format that allows for efficient querying and compatibility with serverless SQL pools in Azure Synapse Analytics. The other formats, while useful for various data storage scenarios, do not provide the same level of integration for external table availability in this context.