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 - Which of the following is used by sqoop to establish a connection with enterprise data warehouses?

A - RDBMS driver

B - JDBC Driver

C - IDBC Driver

D - SQL Driver

Answer : B

Explanation

The JDBC driver is a java program which has been traditionally providing data base connectivity to a variety of databases

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 : D

Explanation

The command line options (the name and value of the parameters) that do not change from time to time can be saved into a file and used again and again. This is called an options file

Q 4 - Which parameter in sqoop is used for bulk data export to relational tables?

A - –bulk

B - –batch

C - -load

D - -grouped data

Answer : B

Explanation

The –batch parameter uses the JDBC batch load capability to do bulk load.

Answer : A

Explanation

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

Q 6 - When using –update-mode allowinsert parameter with oracle database the feature of oracle used by sqoop is

A - UPSERT statement

B - MERGE statement

C - MULTITABLE INSERT statement

D - BULK LOAD statement

Answer : B

Explanation

The Merger statement of oracle is used to achieve update else insert condition.

Answer : A

Explanation

If there are columns whose value is mandatory and the HDFS file does not have it in the subset the load will fail.

Answer : D

Explanation

Sqoop supports loading into hive partitions using additional parameters in the sqoop command

Answer : B

Explanation

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

Answer : B

Explanation

This is the command to execute a sqoop job already saved in the metastore


sqoop_questions_answers.htm

Advertisements