File Formats interview questions

63 real File Formats questions from the Big Data bank, as asked in Indian campus drives and tech interviews. Every question has a verified answer and an AI-tutor explanation on placd — free to start.

1. What is Row group?

Junior
  1. A.a Parquet column encoding that replaces repeated values with small dictionary indexes, shrinking storage and speeding equality filters
  2. B.the contiguous storage of one column's data for a single Parquet row group, the unit of column pruning
  3. C.the Avro mechanism that lets readers and writers use different schema versions through writer and reader schema resolution
  4. D.the horizontal partition of rows in a Parquet file within which each column is stored together as a chunk
Reveal the answer + AI explanation — free account

2. Which term means: "the horizontal partition of rows in a Parquet file within which each column is stored together as a chunk"?

Junior
  1. A.Row group
  2. B.Parquet page index
  3. C.Predicate pushdown via min-max
  4. D.ORC predicate pushdown
Reveal the answer + AI explanation — free account

3. Which statement is correct?

Junior
  1. A.Row group — the Avro mechanism that lets readers and writers use different schema versions through writer and reader schema resolution
  2. B.Row group — a probabilistic index in Parquet and ORC that quickly rules out row groups not containing a sought value with no false negatives
  3. C.Row group — the horizontal partition of rows in a Parquet file within which each column is stored together as a chunk
  4. D.Row group — a columnar encoding that replaces repeated values with small integer codes referencing a per-chunk dictionary
Reveal the answer + AI explanation — free account

4. What is Stripe?

Junior
  1. A.the equivalent of a row group in ORC, a self-contained set of rows holding column data plus its indexes
  2. B.a Parquet column encoding that replaces repeated values with small dictionary indexes, shrinking storage and speeding equality filters
  3. C.an Avro annotation layering semantic meaning (such as decimal, date, or timestamp-millis) on top of a primitive physical type
  4. D.a compression technique that stores a repeated value once together with the count of its consecutive occurrences
Reveal the answer + AI explanation — free account

6. Which statement is correct?

Junior
  1. A.Stripe — the equivalent of a row group in ORC, a self-contained set of rows holding column data plus its indexes
  2. B.Stripe — a file format that can be divided at block boundaries so multiple tasks read one file in parallel, as Parquet and ORC allow
  3. C.Stripe — the contiguous storage of one column's data for a single Parquet row group, the unit of column pruning
  4. D.Stripe — an Avro annotation layering semantic meaning (such as decimal, date, or timestamp-millis) on top of a primitive physical type
Reveal the answer + AI explanation — free account

7. What is Column chunk?

Junior
  1. A.Protocol Buffers, a compact binary serialization format using numbered fields and a schema, common for Kafka messages and service APIs
  2. B.a probabilistic index in Parquet and ORC that quickly rules out row groups not containing a sought value with no false negatives
  3. C.the contiguous storage of one column's data for a single Parquet row group, the unit of column pruning
  4. D.the smallest unit of encoding and compression within a Parquet column chunk, also carrying its own statistics
Reveal the answer + AI explanation — free account

9. Which statement is correct?

Junior
  1. A.Column chunk — the contiguous storage of one column's data for a single Parquet row group, the unit of column pruning
  2. B.Column chunk — the in-memory columnar format enabling zero-copy data exchange between engines and languages without serialization overhead
  3. C.Column chunk — a file format that can be divided at block boundaries so multiple tasks read one file in parallel, as Parquet and ORC allow
  4. D.Column chunk — the equivalent of a row group in ORC, a self-contained set of rows holding column data plus its indexes
Reveal the answer + AI explanation — free account

10. What is Dictionary encoding?

Mid
  1. A.the ORC reader capability of skipping stripes and row groups using built-in min/max indexes and bloom filters when a filter is supplied
  2. B.the contiguous storage of one column's data for a single Parquet row group, the unit of column pruning
  3. C.a columnar encoding that replaces repeated values with small integer codes referencing a per-chunk dictionary
  4. D.a modern compression codec offering high ratios at fast decompression speeds, increasingly the default over Snappy and Gzip in columnar formats
Reveal the answer + AI explanation — free account

11. Which term means: "a columnar encoding that replaces repeated values with small integer codes referencing a per-chunk dictionary"?

Mid
  1. A.Schema evolution in Avro
  2. B.Page
  3. C.Dictionary encoding
  4. D.Run-length encoding
Reveal the answer + AI explanation — free account

12. Which statement is correct?

Mid
  1. A.Dictionary encoding — Protocol Buffers, a compact binary serialization format using numbered fields and a schema, common for Kafka messages and service APIs
  2. B.Dictionary encoding — the ORC reader capability of skipping stripes and row groups using built-in min/max indexes and bloom filters when a filter is supplied
  3. C.Dictionary encoding — the contiguous storage of one column's data for a single Parquet row group, the unit of column pruning
  4. D.Dictionary encoding — a columnar encoding that replaces repeated values with small integer codes referencing a per-chunk dictionary
Reveal the answer + AI explanation — free account

13. What is Run-length encoding?

Mid
  1. A.Protocol Buffers, a compact binary serialization format using numbered fields and a schema, common for Kafka messages and service APIs
  2. B.the in-memory columnar format enabling zero-copy data exchange between engines and languages without serialization overhead
  3. C.a Parquet column encoding that replaces repeated values with small dictionary indexes, shrinking storage and speeding equality filters
  4. D.a compression technique that stores a repeated value once together with the count of its consecutive occurrences
Reveal the answer + AI explanation — free account

14. Which term means: "a compression technique that stores a repeated value once together with the count of its consecutive occurrences"?

Mid
  1. A.Protobuf
  2. B.Run-length encoding
  3. C.ZSTD
  4. D.Columnar vs row-oriented storage
Reveal the answer + AI explanation — free account

15. Which statement is correct?

Mid
  1. A.Run-length encoding — the ORC reader capability of skipping stripes and row groups using built-in min/max indexes and bloom filters when a filter is supplied
  2. B.Run-length encoding — a compression technique that stores a repeated value once together with the count of its consecutive occurrences
  3. C.Run-length encoding — Protocol Buffers, a compact binary serialization format using numbered fields and a schema, common for Kafka messages and service APIs
  4. D.Run-length encoding — the tradeoff where columnar formats like Parquet excel at analytical scans while row formats like Avro suit record-at-a-time writes
Reveal the answer + AI explanation — free account

16. What is Bloom filter?

Mid
  1. A.the smallest unit of encoding and compression within a Parquet column chunk, also carrying its own statistics
  2. B.a columnar encoding that replaces repeated values with small integer codes referencing a per-chunk dictionary
  3. C.a probabilistic index in Parquet and ORC that quickly rules out row groups not containing a sought value with no false negatives
  4. D.a modern compression codec offering high ratios at fast decompression speeds, increasingly the default over Snappy and Gzip in columnar formats
Reveal the answer + AI explanation — free account

17. Which term means: "a probabilistic index in Parquet and ORC that quickly rules out row groups not containing a sought value with no false negatives"?

Mid
  1. A.ZSTD
  2. B.Row group
  3. C.Bloom filter
  4. D.Parquet dictionary encoding
Reveal the answer + AI explanation — free account

18. Which statement is correct?

Mid
  1. A.Bloom filter — the horizontal partition of rows in a Parquet file within which each column is stored together as a chunk
  2. B.Bloom filter — using the per-chunk minimum and maximum statistics in Parquet or ORC footers to skip chunks that cannot match a filter
  3. C.Bloom filter — the ORC reader capability of skipping stripes and row groups using built-in min/max indexes and bloom filters when a filter is supplied
  4. D.Bloom filter — a probabilistic index in Parquet and ORC that quickly rules out row groups not containing a sought value with no false negatives
Reveal the answer + AI explanation — free account

19. What is Predicate pushdown via min-max?

Mid
  1. A.the horizontal Parquet partition holding column chunks for a block of rows, the unit at which statistics and parallel reads operate
  2. B.using the per-chunk minimum and maximum statistics in Parquet or ORC footers to skip chunks that cannot match a filter
  3. C.a columnar encoding that replaces repeated values with small integer codes referencing a per-chunk dictionary
  4. D.the Avro mechanism that lets readers and writers use different schema versions through writer and reader schema resolution
Reveal the answer + AI explanation — free account

20. Which term means: "using the per-chunk minimum and maximum statistics in Parquet or ORC footers to skip chunks that cannot match a filter"?

Mid
  1. A.ORC predicate pushdown
  2. B.Protobuf
  3. C.ZSTD
  4. D.Predicate pushdown via min-max
Reveal the answer + AI explanation — free account

21. Which statement is correct?

Mid
  1. A.Predicate pushdown via min-max — the horizontal Parquet partition holding column chunks for a block of rows, the unit at which statistics and parallel reads operate
  2. B.Predicate pushdown via min-max — a file format that can be divided at block boundaries so multiple tasks read one file in parallel, as Parquet and ORC allow
  3. C.Predicate pushdown via min-max — using the per-chunk minimum and maximum statistics in Parquet or ORC footers to skip chunks that cannot match a filter
  4. D.Predicate pushdown via min-max — a columnar encoding that replaces repeated values with small integer codes referencing a per-chunk dictionary
Reveal the answer + AI explanation — free account

22. What is Page?

Mid
  1. A.the horizontal partition of rows in a Parquet file within which each column is stored together as a chunk
  2. B.the Arrow RPC framework that streams columnar record batches over the network at high throughput without row-by-row serialization
  3. C.the smallest unit of encoding and compression within a Parquet column chunk, also carrying its own statistics
  4. D.an Avro annotation layering semantic meaning (such as decimal, date, or timestamp-millis) on top of a primitive physical type
Reveal the answer + AI explanation — free account

23. Which term means: "the smallest unit of encoding and compression within a Parquet column chunk, also carrying its own statistics"?

Mid
  1. A.Schema evolution in Avro
  2. B.Page
  3. C.ORC predicate pushdown
  4. D.Predicate pushdown via min-max
Reveal the answer + AI explanation — free account

24. Which statement is correct?

Mid
  1. A.Page — the horizontal Parquet partition holding column chunks for a block of rows, the unit at which statistics and parallel reads operate
  2. B.Page — a columnar encoding that replaces repeated values with small integer codes referencing a per-chunk dictionary
  3. C.Page — the in-memory columnar format enabling zero-copy data exchange between engines and languages without serialization overhead
  4. D.Page — the smallest unit of encoding and compression within a Parquet column chunk, also carrying its own statistics
Reveal the answer + AI explanation — free account

25. What is Footer metadata?

Senior
  1. A.a file format that can be divided at block boundaries so multiple tasks read one file in parallel, as Parquet and ORC allow
  2. B.the smallest unit of encoding and compression within a Parquet column chunk, also carrying its own statistics
  3. C.an Avro annotation layering semantic meaning (such as decimal, date, or timestamp-millis) on top of a primitive physical type
  4. D.the trailing section of a Parquet or ORC file holding the schema, row-group offsets, and statistics needed to read it
Reveal the answer + AI explanation — free account

26. Which term means: "the trailing section of a Parquet or ORC file holding the schema, row-group offsets, and statistics needed to read it"?

Senior
  1. A.Avro logical type
  2. B.Stripe
  3. C.Parquet dictionary encoding
  4. D.Footer metadata
Reveal the answer + AI explanation — free account

27. Which statement is correct?

Senior
  1. A.Footer metadata — Protocol Buffers, a compact binary serialization format using numbered fields and a schema, common for Kafka messages and service APIs
  2. B.Footer metadata — the ORC reader capability of skipping stripes and row groups using built-in min/max indexes and bloom filters when a filter is supplied
  3. C.Footer metadata — the trailing section of a Parquet or ORC file holding the schema, row-group offsets, and statistics needed to read it
  4. D.Footer metadata — the in-memory columnar format enabling zero-copy data exchange between engines and languages without serialization overhead
Reveal the answer + AI explanation — free account

28. What is Schema evolution in Avro?

Senior
  1. A.the Avro mechanism that lets readers and writers use different schema versions through writer and reader schema resolution
  2. B.the trailing section of a Parquet or ORC file holding the schema, row-group offsets, and statistics needed to read it
  3. C.a compression technique that stores a repeated value once together with the count of its consecutive occurrences
  4. D.a Parquet column encoding that replaces repeated values with small dictionary indexes, shrinking storage and speeding equality filters
Reveal the answer + AI explanation — free account

29. Which term means: "the Avro mechanism that lets readers and writers use different schema versions through writer and reader schema resolution"?

Senior
  1. A.Parquet dictionary encoding
  2. B.Bloom filter
  3. C.row group
  4. D.Schema evolution in Avro
Reveal the answer + AI explanation — free account

30. Which statement is correct?

Senior
  1. A.Schema evolution in Avro — the smallest unit of encoding and compression within a Parquet column chunk, also carrying its own statistics
  2. B.Schema evolution in Avro — the Avro mechanism that lets readers and writers use different schema versions through writer and reader schema resolution
  3. C.Schema evolution in Avro — the trailing section of a Parquet or ORC file holding the schema, row-group offsets, and statistics needed to read it
  4. D.Schema evolution in Avro — the in-memory columnar format enabling zero-copy data exchange between engines and languages without serialization overhead
Reveal the answer + AI explanation — free account

Showing 30 of 63 File Formats questions — the full set, with answers, explanations and an AI tutor on every question, is inside.

Free to start

Answers, AI explanations, and a scored voice mock interview

Sign up free to check your answers with explanations, ask the AI tutor anything on any question, and take one full AI mock interview — scored like a real panel.

Practice File Formats free