DP-203 · Question #159
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 D. 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 or CSV and located in Azure Storage, an…
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
- ACSV
- BORC
- CJSON
- DParquet
How the community answered
(20 responses)- A10% (2)
- B5% (1)
- C5% (1)
- D80% (16)
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 or CSV and located in Azure Storage, an external table is created in a serverless SQL pool database. https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/develop-storage-files-spark-tables
Topics
Community Discussion
No community discussion yet for this question.