1. What is Hive managed table ? Junior A. an optional per-column probabilistic index in ORC files that lets Hive skip stripes which cannot contain a searched value B. a Hive engine mode that processes batches of rows in columnar form to improve CPU efficiency on ORC data C. a table where Hive owns the data, so DROP deletes the underlying files D. the Hive execution engine that runs queries as a directed acyclic graph of tasks, avoiding the multi-stage disk writes of classic MapReduce
2. Which term means: "a table where Hive owns the data, so DROP deletes the underlying files"? Junior A. schema-on-read B. Vectorized execution C. Hive managed table D. Cost-based optimizer
3. Which statement is correct? Junior A. Hive managed table — a Hive ACID operation that merges base and delta files into new base files, applying all updates and deletes B. Hive managed table — a table where Hive owns the data, so DROP deletes the underlying files C. Hive managed table — the Hive ACID layout where base files hold compacted data and delta files record subsequent inserts and deletes D. Hive managed table — the Hive optimizer (backed by Apache Calcite) that uses table and column statistics to reorder joins and choose efficient plans
4. What is Hive external table ? Junior A. a table where Hive owns only metadata, so DROP keeps the data B. a Hive join optimization that joins corresponding buckets of two bucketed tables in memory, avoiding a full shuffle C. the Hive service that stores table schemas, partitions, and storage locations in a relational database for query engines to consult D. the Hive background process that merges base and delta files of transactional tables, with minor compaction merging deltas and major compaction rewriting bases
5. Which term means: "a table where Hive owns only metadata, so DROP keeps the data"? Junior A. Dynamic partition insert B. Major compaction C. Vectorized execution D. Hive external table
6. Which statement is correct? Junior A. Hive external table — applying a schema at query time rather than at write time B. Hive external table — a Hive join optimization that joins corresponding buckets of two bucketed tables in memory, avoiding a full shuffle C. Hive external table — an optional per-column probabilistic index in ORC files that lets Hive skip stripes which cannot contain a searched value D. Hive external table — a table where Hive owns only metadata, so DROP keeps the data
7. What is Hive partitioning ? Mid A. the Hive background process that merges base and delta files of transactional tables, with minor compaction merging deltas and major compaction rewriting bases B. splitting data into directories by column value for partition pruning C. applying a schema at query time rather than at write time D. an optional per-column probabilistic index in ORC files that lets Hive skip stripes which cannot contain a searched value
8. Which term means: "splitting data into directories by column value for partition pruning"? Mid A. LLAP B. Hive partitioning C. Hive managed table D. Dynamic partition insert
9. Which statement is correct? Mid A. Hive partitioning — splitting data into directories by column value for partition pruning B. Hive partitioning — a Hive write mode that creates partitions automatically from column values in the data being inserted C. Hive partitioning — the Hive service that stores table schemas, partitions, and storage locations in a relational database for query engines to consult D. Hive partitioning — a Hive join optimization that joins corresponding buckets of two bucketed tables in memory, avoiding a full shuffle
10. What is Hive bucketing ? Mid A. the Hive query optimizer that uses table statistics through Apache Calcite to pick join orders and plans B. the Hive service that stores table schemas, partitions, and storage locations in a relational database for query engines to consult C. hashing a column into a fixed number of files within a partition D. a Hive ACID operation that merges base and delta files into new base files, applying all updates and deletes
11. Which term means: "hashing a column into a fixed number of files within a partition"? Mid A. Metastore B. Partition pruning C. ORC bloom filter D. Hive bucketing
12. Which statement is correct? Mid A. Hive bucketing — a table where Hive owns the data, so DROP deletes the underlying files B. Hive bucketing — hashing a column into a fixed number of files within a partition C. Hive bucketing — a Hive engine mode that processes batches of rows in columnar form to improve CPU efficiency on ORC data D. Hive bucketing — the Hive ACID layout where base files hold compacted data and delta files record subsequent inserts and deletes
13. What is schema-on-read ? Junior A. a Hive write mode that creates partitions automatically from column values in the data being inserted B. applying a schema at query time rather than at write time C. a Hive ACID operation that merges base and delta files into new base files, applying all updates and deletes D. the Hive optimization that reads only the partition directories matching a query's filter on partition columns
14. Which term means: "applying a schema at query time rather than at write time"? Junior A. ACID tables B. Hive bucketing C. schema-on-read D. ORC bloom filter
15. Which statement is correct? Junior A. schema-on-read — a Hive ACID operation that merges several delta files into a single delta file without rewriting base files B. schema-on-read — applying a schema at query time rather than at write time C. schema-on-read — the Hive feature processing batches of about 1024 rows per operation instead of one row at a time to cut CPU overhead D. schema-on-read — the Hive ACID layout where base files hold compacted data and delta files record subsequent inserts and deletes
16. What is Metastore ? Junior A. a Hive engine mode that processes batches of rows in columnar form to improve CPU efficiency on ORC data B. the Hive query optimizer that uses table statistics through Apache Calcite to pick join orders and plans C. a Hive join optimization that joins corresponding buckets of two bucketed tables in memory, avoiding a full shuffle D. the Hive service that stores table schemas, partitions, and storage locations in a relational database for query engines to consult
17. Which term means: "the Hive service that stores table schemas, partitions, and storage locations in a relational database for query engines to consult"? Junior A. Cost-based optimizer B. LLAP C. Hive bucketing D. Metastore
18. Which statement is correct? Junior A. Metastore — the Hive service that stores table schemas, partitions, and storage locations in a relational database for query engines to consult B. Metastore — a Hive join optimization that joins corresponding buckets of two bucketed tables in memory, avoiding a full shuffle C. Metastore — a Hive ACID operation that merges base and delta files into new base files, applying all updates and deletes D. Metastore — the Hive Live Long and Process service that keeps daemons and cached data resident in memory for low-latency interactive queries
19. What is ACID tables ? Junior A. the Hive Live Long and Process service that keeps daemons and cached data resident in memory for low-latency interactive queries B. applying a schema at query time rather than at write time C. Hive transactional tables, stored as ORC, that support row-level insert, update, and delete with snapshot isolation D. the Hive service that stores table schemas, partitions, and storage locations in a relational database for query engines to consult
20. Which term means: "Hive transactional tables, stored as ORC, that support row-level insert, update, and delete with snapshot isolation"? Junior A. vectorized query execution B. Partition pruning C. Minor compaction D. ACID tables
21. Which statement is correct? Junior A. ACID tables — a Hive ACID operation that merges several delta files into a single delta file without rewriting base files B. ACID tables — Hive transactional tables, stored as ORC, that support row-level insert, update, and delete with snapshot isolation C. ACID tables — the Hive feature processing batches of about 1024 rows per operation instead of one row at a time to cut CPU overhead D. ACID tables — a Hive ACID operation that merges base and delta files into new base files, applying all updates and deletes
22. What is LLAP ? Mid A. Hive transactional tables, stored as ORC, that support row-level insert, update, and delete with snapshot isolation B. the Hive Live Long and Process service that keeps daemons and cached data resident in memory for low-latency interactive queries C. a Hive write mode that creates partitions automatically from column values in the data being inserted D. the Hive execution engine that runs queries as a directed acyclic graph of tasks, avoiding the multi-stage disk writes of classic MapReduce
23. Which term means: "the Hive Live Long and Process service that keeps daemons and cached data resident in memory for low-latency interactive queries"? Mid A. Hive partitioning B. Major compaction C. ACID tables D. LLAP
24. Which statement is correct? Mid A. LLAP — hashing a column into a fixed number of files within a partition B. LLAP — splitting data into directories by column value for partition pruning C. LLAP — the Hive Live Long and Process service that keeps daemons and cached data resident in memory for low-latency interactive queries D. LLAP — a Hive engine mode that processes batches of rows in columnar form to improve CPU efficiency on ORC data
25. What is Delta and base files ? Mid A. the Hive ACID layout where base files hold compacted data and delta files record subsequent inserts and deletes B. a Hive write mode that creates partitions automatically from column values in the data being inserted C. splitting data into directories by column value for partition pruning D. the Hive execution engine that runs queries as a directed acyclic graph of tasks, avoiding the multi-stage disk writes of classic MapReduce
26. Which term means: "the Hive ACID layout where base files hold compacted data and delta files record subsequent inserts and deletes"? Mid A. ACID compaction B. bucketed map join C. Hive cost-based optimizer D. Delta and base files
27. Which statement is correct? Mid A. Delta and base files — the Hive background process that merges base and delta files of transactional tables, with minor compaction merging deltas and major compaction rewriting bases B. Delta and base files — the Hive optimization that reads only the partition directories matching a query's filter on partition columns C. Delta and base files — the Hive ACID layout where base files hold compacted data and delta files record subsequent inserts and deletes D. Delta and base files — Hive transactional tables, stored as ORC, that support row-level insert, update, and delete with snapshot isolation
28. What is Minor compaction ? Mid A. a Hive ACID operation that merges base and delta files into new base files, applying all updates and deletes B. a Hive ACID operation that merges several delta files into a single delta file without rewriting base files C. the Hive query optimizer that uses table statistics through Apache Calcite to pick join orders and plans D. applying a schema at query time rather than at write time
29. Which term means: "a Hive ACID operation that merges several delta files into a single delta file without rewriting base files"? Mid A. Dynamic partition insert B. Minor compaction C. Vectorized execution D. bucketed map join
30. Which statement is correct? Mid A. Minor compaction — the Hive ACID layout where base files hold compacted data and delta files record subsequent inserts and deletes B. Minor compaction — a Hive ACID operation that merges several delta files into a single delta file without rewriting base files C. Minor compaction — the Hive feature processing batches of about 1024 rows per operation instead of one row at a time to cut CPU overhead D. Minor compaction — splitting data into directories by column value for partition pruning Showing 30 of 63 Hive questions — the full set, with answers, explanations and an AI tutor on every question, is inside.