DP-203 · Question #232
You have an Azure subscription that contains an Azure Blob Storage account named storage1 and an Azure Synapse Analytics dedicated SQL pool named Pool1. You need to store data in storage1. The data wi
The correct answer is B. Parquet. Automatic creation of statistics is turned on for Parquet files. For CSV files, you need to create statistics manually until automatic creation of CSV files statistics is supported. https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/develop-tables-statistics
Question
You have an Azure subscription that contains an Azure Blob Storage account named storage1 and an Azure Synapse Analytics dedicated SQL pool named Pool1. You need to store data in storage1. The data will be read by Pool1. The solution must meet the following requirements:
- Enable Pool1 to skip columns and rows that are unnecessary in a
query.
- Automatically create column statistics.
- Minimize the size of files.
Which type of file should you use?
Options
- AJSON
- BParquet
- CAvro
- DCSV
How the community answered
(35 responses)- A9% (3)
- B83% (29)
- C6% (2)
- D3% (1)
Explanation
Automatic creation of statistics is turned on for Parquet files. For CSV files, you need to create statistics manually until automatic creation of CSV files statistics is supported. https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/develop-tables-statistics
Topics
Community Discussion
No community discussion yet for this question.