DP-900 · Question #249
Which file format has defined names and data types for each column and uses compressed columnar storage?
The correct answer is C. Apache Parquet. Apache Parquet is a columnar binary file format that enforces a defined schema with named columns and data types, and uses efficient columnar compression algorithms.
Question
Options
- AHTML
- BCSV
- CApache Parquet
- DJSON
How the community answered
(28 responses)- A4% (1)
- B4% (1)
- C93% (26)
Why each option
Apache Parquet is a columnar binary file format that enforces a defined schema with named columns and data types, and uses efficient columnar compression algorithms.
HTML is a markup language for web pages and has no concept of defined columns, data types, or columnar compression.
CSV is a plain-text row-based format with no enforced schema, no defined data types, and no compression.
Apache Parquet is an open-source columnar storage format designed for analytics workloads. It stores data column-by-column rather than row-by-row, which allows for highly efficient compression and encoding because values within the same column tend to be similar. Parquet files include schema metadata that defines the name and data type of each column, making it self-describing and suitable for big data processing frameworks like Apache Spark and Azure Synapse Analytics.
JSON is a text-based hierarchical format that supports nested structures but is row-oriented, does not enforce column data types, and does not use columnar compression.
Concept tested: Apache Parquet columnar file format schema and compression
Source: https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/query-parquet-files
Topics
Community Discussion
No community discussion yet for this question.