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 - To prevent the password from being mentioned in the sqoop import clause we can use the additional parameters

A - -p

B - --password-file

C - both of these

D - cannot be prevented

Answer : C

Explanation

The -P option asks for password from standard input without echoing and --password-file option reads the password value stored in some other file.

Q 2 - For some databases sqoop can to faster data transefr by using the parameter

A - --bulkload

B - --fastload

C - --dump

D - --direct

Answer : D

Explanation

The direct mode delegates the data transferring capabilities to the native untilities provided by the database.

Answer : A

Explanation

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

Q 4 - While importing data into Hadoop using sqoop the SQL SELCT clause is used. Similarly while exporting data form Hadoop the SQL clause used is

A - APPEND

B - MERGE

C - UPDTAE

D - INSERT

Answer : D

Explanation

The INSERT statements are generated by sqoop to insert data into the relational tables.

Answer : A

Explanation

sqoop runs another mapreduce job to load the final table after the staging load completes successfully.

Answer : D

Explanation

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

Answer : A

Explanation

The default behavior is to append data into existing hive table.

Answer : B

Explanation

This parameter can be used with both hive and text files.

Answer : A

Explanation

The property sqoop.hbase.add.row.key instructs Sqoop to insert the row key column twice, once as a row identifier and then again in the data itself. Even if all other columns contain NULL, at least the column used for the row key won’t be null, which will allow the insertion of the row into HBase.


sqoop_questions_answers.htm

Advertisements