Data Formats Parquet ORC Quiz

5 questions Pass: 70% +25 pts (50 with Pro)

Quiz covering Data Ingestion

What you'll be asked

  1. Which of the following best describes the primary structural advantage of both Parquet and ORC compared to CSV files?
  2. You are designing a data lake architecture for a Hadoop-based ecosystem where Hive is the primary query engine. Which format is generally considered the 'native' choice for Hive to achieve the best performance?
  3. Which of the following scenarios best justifies choosing Apache Parquet over ORC?
  4. Both Parquet and ORC utilize 'predicate pushdown'. What does this feature accomplish during data ingestion?
  5. When configuring a Spark job to write a Parquet file, you notice the resulting output consists of thousands of tiny files. What is the most significant technical drawback of this 'small file problem' in columnar formats?

Answers and explanations come after you submit.