Hive DATA-SCIENCE-OPTIMIZE Practice Questions (Page 5)

Questions 21–25

1. 21foundation · easy

   What does bucketing in Hive do to the data within a table?

   • AIt compresses the data to reduce storage.
   • BIt creates a secondary index on the table.
   • CIt splits data into a fixed number of files based on a hash of a column.
   • DIt sorts the data by a column within each partition.
   Reveal Solution Discussion Select an answer first
2. 22foundation · easy

   Which component of Hive architecture stores metadata such as table schemas, partition information, and column types?

   • AMetastore
   • BExecution engine
   • CHDFS NameNode
   • DHiveQL engine
   Reveal Solution Discussion Select an answer first
4. 23foundation · easy

   What is the purpose of vectorization in Hive query optimization?

   • ATo process multiple rows at once instead of one row at a time.
   • BTo create indexes on frequently queried columns.
   • CTo compress data before storing it in HDFS.
   • DTo automatically tune the number of reducers.
   Reveal Solution Discussion Select an answer first
5. 24foundation · easy

   Which execution engine is known for providing better performance than classic MapReduce in Hive by creating a directed acyclic graph (DAG) of tasks?

   • APig
   • BFlink
   • CSpark
   • DTez
   Reveal Solution Discussion Select an answer first
6. 25application · medium

   A company currently runs a nightly batch job that processes terabytes of historical data. They are evaluating Hive versus a traditional relational database for this workload. Which characteristic of Hive makes it the better choice for this scenario?

   • AHive supports ACID transactions with full row-level updates.
   • BHive provides sub-second query latency for interactive queries.
   • CHive scales out across a cluster to process large data volumes in parallel.
   • DHive enforces a strict schema at write time like a traditional database.
   Reveal Solution Discussion Select an answer first