Accessing Hadoop Data Using Hive cognitive class Exam Answer:-

Related Articles

Data Analysis with Python Cognitive Class Exam Answers:-

January 25, 2022

Data Science Tools Cognitive Class Exam Answers:-

January 25, 2022

Node-RED: basics to bots Cognitive Class Exam Answers:-

January 24, 2022

Course Name :- Accessing Hadoop Data Using Hive

Module 1:- Introduction to Hive

Question 1: Which company first developed Hive?

• Starbucks
• Facebook
• HP
• Yahoo

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

• True
• False

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

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

Module 2: Hive DDL

Question 1: 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 2: MAPS are a Hive complex data type. True or false?

• True
• False

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

• True
• False

Module 3:  Hive DDL

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

• True
• False

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

• QUERYPLAN
• SHOWME
• HOW
• EXPLAIN

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

• True
• False

Module 3: Hive Operators and Function

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

• triplemultiple
• floor
• upper
• round

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

• True
• False

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

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