Interview question based on skill :
Take as many assements as you can to improve your validate your skill rating
Total Questions: 20
1. ___________ is a simple xUnit framework that enables you to easily test your Pig scripts.
Correct Answer is : PigXUnit
2. Which of the following will compile the Pigunit ?
Correct Answer is : $pig_trunk ant pigunit-jar
3. PigUnit runs in Pig’s _______ mode by default.
Correct Answer is : local
4. Avro-backed tables can simply be created by using _________ in a DDL statement.
Correct Answer is : “STORED AS AVRO”
5. Point out the correct statement :
Correct Answer is : Avro Bytes type should be defined in Hive as lists of tiny ints
6. Types that may be null must be defined as a ______ of that type and Null within Avro.
Correct Answer is : Union
7. The files that are written by the _______ job are valid Avro files.
Correct Answer is : Hive
8. Point out the wrong statement :
Correct Answer is : The AvroSerde cannot serialize any Hive table to Avro files
9. Use ________ and embed the schema in the create statement.
Correct Answer is : schema.literal
10. _______ is interpolated into the quotes to correctly handle spaces within the schema.
Correct Answer is : $SCHEMA
11. To force Hive to be more verbose, it can be started with :
Correct Answer is : *hive –hiveconf hive.root.logger=INFO,console*
12. ________ was designed to overcome limitations of the other Hive file formats.
Correct Answer is : ORC
13. An ORC file contains groups of row data called :
Correct Answer is : stripes
14. Serialization of string columns uses a ________ to form unique column values.
Correct Answer is : Dictionary
15. Point out the correct statement :
Correct Answer is : Streams are compressed using a codec, which is specified as a table property for all streams in that table
16. _______ is a lossless data compression library that favors speed over compression ratio.
Correct Answer is : LOZ
17. Which of the following will prefix the query string with parameters:
Correct Answer is : SET hive.exec.compress.output=false
18. Point out the wrong statement :
Correct Answer is : DECIMAL introduced in Hive 0.11.0 with a precision of 38 digits
19. Integral literals are assumed to be _________ by default.
Correct Answer is : INT
20. Hive uses _____-style escaping within the strings.
Correct Answer is : C
