Querying With Hive - Study Mode

Show All Answers

[#36] . . . . . . . . command fetches the contents of a row or a cell.

(A) select

(B) get

(C) put

(D) none of the mentioned

Correct Answer

(B) get

[#37] . . . . . . . . was designed to overcome limitations of the other Hive file formats.

(A) ORC

(B) OPC

(C) ODC

(D) None of the mentioned

Correct Answer

(A) ORC

[#38] Starting in Hive . . . . . . . . the Avro schema can be inferred from the Hive table schema.

(A) 0.14

(B) 0.12

(C) 0.13

(D) 0.11

Correct Answer

(A) 0.14

[#39] . . . . . . . . does re-write data and pack rows into columns for certain time-periods.

(A) OpenTS

(B) OpenTSDB

(C) OpenTSD

(D) OpenDB

Correct Answer

(B) OpenTSDB

[#40] Avro-backed tables can simply be created by using . . . . . . . . in a DDL statement.

(A) "STORED AS AVRO"

(B) "STORED AS HIVE"

(C) "STORED AS AVROHIVE"

(D) "STORED AS SERDE"

Correct Answer

(A) "STORED AS AVRO"