Question 1

When would you use the COUNT(DISTINCT column_name) function in Apache Hive?

Options :

A : To count all non-NULL values in a column

B : To sum up the values in a column

C : To count the total number of rows

D : To count the number of unique values in a column

Answer: D

Question 2

How can you save query results into a CSV file in HDFS using Hive?

Options :

A : Use CREATE TABLE AS SELECT with CSV format

B : Use INSERT OVERWRITE DIRECTORY with a CSV format.

C : Use LOAD DATA INPATH and convert to CSV

D : Use EXPORT to HDFS

Answer: B

Question 3

What is the purpose of the GROUP BY clause when used with aggregate functions in Apache Hive?

Options :

A : To combine rows into a single row

B : To filter rows based on aggregate values

C : To perform aggregation on each group

D : To sort the result set

Answer: C

Question 4

How does Cloudera ensure high availability for virtual warehouses?

Options :

A : By replicating virtual warehouse instances across nodes

B : By periodically backing up data

C : By using a single-node setup

D : By limiting access to the virtual warehouse

Answer: A

Question 5

In Cloudera, which type of table would you use if you want Hive to only manage metadata without affecting the actual data storage?

Options :

A : Temporary table

B : Partitioned table

C : External table

D : Managed table

Answer: C

Free CDP-4001 Mock Exam – Practice Online Confidently