Sqoop Online Quiz


Advertisements

Following quiz provides Multiple Choice Questions (MCQs) related to Sqoop. You will have to read all the given answers and click over the correct answer. If you are not sure about the answer then you can check the answer using Show Answer button. You can use Next Quiz button to check new set of questions in the quiz.

Questions and Answers

Q 1 - While SequenceFile stores each record as key-value pair, the avro system stored records as

A - Simple text

B - chained lists

C - Linked lists

D - schema and data

Answer : D

Explanation

Sqoop generates the schema automatically when reading the data and stores the schema details along with the data in each Avro file generated.

Answer : B

Explanation

Sqoop does not have any inbuilt code to carry out file compression. It relies on Hadoop's compression settings.

Answer : A

Explanation

The WHERE $CONDITION is used to split the result of the SQL query into multiple chunks.

Answer : A

Explanation

the default behavior is to insert one row at a time while it can be configured for bulk load.

Answer : D

Explanation

All the listed options are disadvantages while using the –staging-table option.

Answer : C

Explanation

A comma separate dlist of column names which together identify a unique record can be used in the –update-key parameter.

Answer : D

Explanation

we can use the –column parameter and specify the required column in the required order.

Q 8 - When a column value has a different data type in the HDFS system than expected in the relational table to which data will be exported −

A - Sqoop skips the rows

B - Sqoop fails the job

C - Sqoop loads the remaining rows by halting and asking whether to continue the load

D - Sqoop automatically changes the data type to a compatible data type and loads the data.

Answer : B

Explanation

The job fails and sqoop gives a log showing the reason of failure.

Q 9 - The data type of the column used for partition name while importing data using sqoop ino hive can be

A - only string

B - string or numeric

C - only date

D - string without special characters

Answer : A

Explanation

Sqoop can only take strings as partition column names while loading data to hive.

Answer : A

Explanation

The ValidationThreshold - Determines if the error margin between the source and target are acceptable: Absolute, Percentage Tolerant, etc. Default implementation is AbsoluteValidationThreshold which ensures the row counts from source and targets are the same.

sqoop_questions_answers.htm
Advertisements