Question 1

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 2

Which function is used to cast a column to a different data type in Impala?

Options :

A : TRANSFORM

B : CHANGE

C : CAST

D : CONVERT

Answer: C

Question 3

How can you enforce data security policies at the file level in HDFS using Apache Ranger?

Options :

A : By configuring HDFS policies in Cloudera Manager

B : By configuring HDFS policies in HDFS Admin

C : By configuring HDFS policies in Atlas Admin

D : By configuring HDFS policies in Ranger Admin

Answer: D

Question 4

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 5

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