nerdexam
Microsoft

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.

Submitted by lucia.co· Mar 30, 2026Describe core data concepts

Question

Which file format has defined names and data types for each column and uses compressed columnar storage?

Options

  • AHTML
  • BCSV
  • CApache Parquet
  • DJSON

How the community answered

(28 responses)
  • A
    4% (1)
  • B
    4% (1)
  • C
    93% (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.

AHTML

HTML is a markup language for web pages and has no concept of defined columns, data types, or columnar compression.

BCSV

CSV is a plain-text row-based format with no enforced schema, no defined data types, and no compression.

CApache ParquetCorrect

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.

DJSON

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

#Apache Parquet#columnar storage#file formats#data compression

Community Discussion

No community discussion yet for this question.

Full DP-900 Practice