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?
- A. JSON
- B. CSV
- C. Parquet Correct
- D. ORC
Explanation
Azure Synapse automatically shares managed and external Spark tables stored in Parquet with the serverless SQL pool, where they appear as external tables with the same name. Tables in JSON or ORC format are not synchronized automatically, so you would have to create the external tables yourself. Current Microsoft documentation also lists CSV and Delta as shared formats, so a CSV table would be synchronized today as well, but Parquet is the best choice here: it is fully supported in serverless SQL pool and it is the format Microsoft's own examples of this behaviour use.
