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

Questions 6–10

1. 6foundation · easy

   Where does Hive store the actual table data by default?

   • AIn the metastore database
   • BIn HDFS
   • CIn the local file system of the client
   • DIn a relational database
   Reveal Solution Discussion Select an answer first
2. 7application · medium

   A Hive query is submitted. The HiveQL engine parses the query, generates a logical plan, and then converts it into a physical plan. Which component of the Hive architecture is responsible for executing the physical plan on the cluster?

   • ANameNode
   • BHiveQL engine
   • CExecution engine
   • DMetastore
   Reveal Solution Discussion Select an answer first
4. 8foundation · easy

   Which type of Hive table is most appropriate when the underlying data files are managed by an external process and should not be deleted when the table is dropped?

   • AExternal table
   • BIndexed table
   • CTemporary table
   • DManaged table
   Reveal Solution Discussion Select an answer first
5. 9application · medium

   A Hive table stores employee records. Each record has a name, a salary, and a list of project IDs. The team wants to query the second project ID for each employee. Which Hive data type should be used for the project IDs column?

   • ASTRUCT<project1 INT, project2 INT>
   • BARRAY<INT>
   • CMAP<STRING, INT>
   • DSTRING
   Reveal Solution Discussion Select an answer first
6. 10foundation · easy

   Which of the following is a key difference between Hive and a traditional relational database?

   • ARelational databases store data in HDFS.
   • BHive enforces schema constraints like primary keys and foreign keys.
   • CHive typically has higher latency for queries compared to relational databases.
   • DHive supports ACID transactions by default for all tables.
   Reveal Solution Discussion Select an answer first