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

Questions 26–30

1. 26application · medium

   A Hive table must store product information where each product can have multiple tags, and the tags are stored as a comma-separated string in the source file. The team wants to query individual tags later. Which column definition should they use?

   • Atags STRING
   • Btags STRUCT<tag1 STRING, tag2 STRING>
   • Ctags ARRAY<STRING>
   • Dtags MAP<STRING, STRING>
   Reveal Solution Discussion Select an answer first
2. 27foundation · easy

   In Hive architecture, which component is responsible for converting a HiveQL query into a directed acyclic graph (DAG) of tasks that can be executed by the underlying engine?

   • AHDFS DataNode
   • BMetastore
   • CExecution engine
   • DHiveQL engine
   Reveal Solution Discussion Select an answer first
4. 28foundation · easy

   Which HiveQL command is used to remove a table and its metadata from the metastore?

   • ADELETE TABLE table_name;
   • BDROP TABLE table_name;
   • CREMOVE TABLE table_name;
   • DTRUNCATE TABLE table_name;
   Reveal Solution Discussion Select an answer first
5. 29application · medium

   A company needs to run a one-time analysis over 10 TB of historical data. The analysis does not require low latency, and the data is already stored in HDFS. The team is deciding between using Hive and a traditional relational database. Which factor most strongly favors using Hive?

   • AHive provides real-time transaction processing for OLTP workloads.
   • BHive can scale horizontally across a cluster to process large data volumes.
   • CHive supports sub-second query responses for interactive dashboards.
   • DHive enforces strict schema at write time, ensuring data quality.
   Reveal Solution Discussion Select an answer first
6. 30foundation · easy

   Which of the following is a complex data type in Hive?

   • AINT
   • BDOUBLE
   • CSTRING
   • DARRAY
   Reveal Solution Discussion Select an answer first