Q.1
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”
Q.2
Point out the correct statement.
  • a) Avro Fixed type should be defined in Hive as lists of tiny ints
  • b) Avro Bytes type should be defined in Hive as lists of tiny ints
  • c) Avro Enum type should be defined in Hive as strings
  • d) All of the mentioned
Q.3
Types that may be null must be defined as a ______ of that type and Null within Avro.
  • a) Union
  • b) Intersection
  • c) Set
  • d) All of the mentioned
Q.4
The files that are written by the _______ job are valid Avro files.
  • a) Avro
  • b) Map Reduce
  • c) Hive
  • d) All of the mentioned
Q.5
Point out the wrong statement.
  • a) To create an Avro-backed table, specify the serde as org.apache.hadoop.hive.serde2.avro.AvroSerDe
  • b) Avro-backed tables can be created in Hive using AvroSerDe
  • c) The AvroSerde cannot serialize any Hive table to Avro files
  • d) None of the mentioned
Q.6
Use ________ and embed the schema in the create statement.
  • a) schema.literal
  • b) schema.lit
  • c) row.literal
  • d) all of the mentioned
Q.7
_______ is interpolated into the quotes to correctly handle spaces within the schema.
  • a) $SCHEMA
  • b) $ROW
  • c) $SCHEMASPACES
  • d) $NAMESPACES
Q.8
To force Hive to be more verbose, it can be started with ___________
  • a) *hive –hiveconf hive.root.logger=INFO,console*
  • b) *hive –hiveconf hive.subroot.logger=INFO,console*
  • c) *hive –hiveconf hive.root.logger=INFOVALUE,console*
  • d) All of the mentioned
Q.9
________ was designed to overcome limitations of the other Hive file formats.
  • a) ORC
  • b) OPC
  • c) ODC
  • d) None of the mentioned
Q.10
An ORC file contains groups of row data called __________
  • a) postscript
  • b) stripes
  • c) script
  • d) none of the mentioned
0 h : 0 m : 1 s