Monday , August 15 2022
Home / cognitive class / Accessing Hadoop Data Using Hive cognitive class Exam Answer:-

Accessing Hadoop Data Using Hive cognitive class Exam Answer:-

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

About Machine Learning

Check Also

Python for Data Science Cognitive Class Exam Answers:-

Course Name:- Python for Data Science Module 1. Python Basics Question 1. What is the …

Leave a Reply

Your email address will not be published.