Accessing Hadoop Data Using Hive Quiz Answers – Cognitive Class

Get Accessing Hadoop Data Using Hive Quiz Answers

Writing MapReduce programs to analyze your Big Data can get complex. Hive can help make querying your data much easier. Apache Hive, first created at Facebook, is a data warehouse system for Hadoop that facilitates easy data summarization, ad-hoc queries, and the analysis of large datasets stored in Hadoop compatible file systems. Hive provides a mechanism to project structure onto this data and query the data using a SQL-like language called HiveQL. This course will get you started so that you can use Hive for Data Warehousing tasks on your Big Data projects.

Enroll on Cognitive Class

Module 1 – Introduction To Hive

Question: Which company first developed Hive?

  • Starbucks
  • Facebook
  • HP
  • Yahoo

Question: Hive is a Data Warehouse system built on top of Hadoop. True or false?

  • True
  • False

Question: Which of the following is NOT a valid Hive Metastore config?

  • Server Metastore
  • Local Metastore
  • Remote Metastore
  • Embedded Metastore

Module 2 – Hive DDL

Question: Which of the following commands will list the databases in the Hive system?

  • DISPLAY ALL DB;
  • SHOW ME THE DATABASES;
  • DISPLAY DB;
  • SHOW DATABASES;

Question: MAPS are a Hive complex data type. True or false?

  • True
  • False

Question: An index can be created on a Hive table. True or false?

  • True
  • False

Module 3 – Hive DML

Question: LOAD DATA LOCAL means that the data should be loaded from HDFS. True or false?

  • True
  • False

Question: Which of the following commands is used to generate a Hive query plan?

  • QUERYPLAN
  • SHOWME
  • HOW
  • EXPLAIN

Question: Data can be exported out of Hive. True or false?

  • True
  • False

Module 4 – Hive Operators and Functions

Question: Which of the following is NOT a built-in Hive function?

  • triplemultiple
  • floor
  • upper
  • round

Question: Users can create their own custom user defined functions. True or false?

  • True
  • False

Question: Which of the following is NOT a valid Hive relational operator?

  • A ATE B
  • A IS NOT NULL
  • A LIKE B
  • A IS NULL

Final Exam

Question: What is the primary purpose of Hive in the Hadoop architecture?

  • To provide logging support for Hadoop jobs
  • To support the execution of workflows consisting of a collection of actions
  • To support SQL-like queries of data stored in Hadoop in place of writing MapReduce applications
  • To move data into HDFS

Question: Hive is SQL-92 compliant and supports row-level inserts, updates, and deletes. True or false?

  • True
  • False

Question: In a production setting, you should configure the Hive metastore as:

  • Remote
  • Local
  • Embedded
  • None of the above

Question: The Hive Command Line Interface (CLI) allows you to

  • retrieve query explain plans
  • view and manipulate table metadata
  • perform queries, DML, and DDL
  • All of the above

Question: When using the Hive CLI, which option allows you to execute HiveQL that’s saved in a text file?

  • hive -d
  • hive -S
  • hive -e
  • hive -f

Question: Which statement is true of “Managed” tables in Hive?

  • Dropping a table deletes the table’s metadata, NOT the actual data
  • You can easily share your data with other Hadoop tools
  • Table data is stored in a directory outside of Hive
  • None of the Above

Question: Hive Data Types include:

  • Maps
  • Arrays
  • Structs
  • A subset of RDBMS primitive types
  • All of the above

Question: The PARTITION BY clause in Hive can be used to improve performance by storing all the data associated with a specified column’s value in the same folder. True or false?

  • True
  • False

Question: The LOAD DATA LOCAL command in Hive is used to move a datafile in HDFS into a Hive table structure. True or false?

  • True
  • False

Question: The INSERT OVERWRITE LOCAL DIRECTORY command in Hive is used to

  • copy data into an externally managed table
  • load data into a Hive Table
  • append rows to an existing Hive Table
  • export data from Hive to the local file system

Question: Hive supports which type of join?

  • Left Semi-Join
  • Inner Join
  • Full Outer Join
  • Equi-Join
  • All of the above

Question: With Hive, you can write your own user defined functions in Java and invoke them using HiveQL. True or false?

  • True
  • False

Question: Which of the following is a valid Hive operator for complex data types?

  • S.x where S is a struct and x is the name of the field you wish to retrieve
  • M[k] where M is a map and k is a key value
  • A[n] where A is an array and n is an int
  • All of the above
Conclusion:

We hope you know the correct answers to Accessing Hadoop Data Using Hive If Why Quiz helped you to find out the correct answers then make sure to bookmark our site for more Course Quiz Answers.

If the options are not the same then make sure to let us know by leaving it in the comments below.

Course Review:

In our experience, we suggest you enroll in this and gain some new skills from Professionals completely free and we assure you will be worth it.

This course is available on Cognitive Class for free, if you are stuck anywhere between quiz or graded assessment quiz, just visit Queslers to get all Quiz Answers and Coding Solutions.

More Courses Quiz Answers >>

Building Cloud Native and Multicloud Applications Quiz Answers

Accelerating Deep Learning with GPUs Quiz Answers

Leave a Reply

Your email address will not be published.