Microsoft Certified Azure Data Fundamentals · Free Practice Question Easy
Question 25
Which optimized file format stores data in a row-based format and utilizes JSON for storing headers?
-
A
CSV
-
B
Avro
-
C
ORC
-
D
Parquet
Reveal correct answer
Correct answer: B
Explanation
Avro is a row-based format, and it uses JSON to store headers.
ORC is not a row-based format, and it doesn't use JSON for storing headers. Instead, ORC is a columnar format optimized for read and write operations.
Parquet is not a row-based format, and it doesn't use JSON for storing headers. It is also a columnar format specialized in efficient storage and processing of nested data.
CSV (Comma-Separated Values) is not an optimized file format as discussed in the text. It lacks the features like columnar storage, indexing, and efficient compression found in Avro.
Discussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
