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

Answer : A

Explanation

On installing in one node it, automatically gets replicated to other nodes in the cluster.

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

with the --meta-connect parameter the metastore starts running as a service with the default port 16000.Now this metastore service becomes accessible throughout the cluster.

Answer : B

Explanation

The data can be both imported and exported form Hadoop system using sqoop.

Answer : B

Explanation

When you want to verify that indeed all the require data is successfully exported before loading the data to final table, use the parameter –staging-table.

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

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.

Q 10 - The sqoop export/import jobs canbe stored and used again and again by using

A - sqoop- jobname

B - sqoop-save-job

C - sqoop-all-jobs

D - sqoop-job

Answer : D

Explanation

Running a sqoop job by using sqoop-job statement saves the job into metastore which can be retrived later and used again and again

Example −

$ sqoop-job --create jobname -- import --connect jdbc:mysql://example.com/db \
   --table mytable

sqoop_questions_answers.htm

Advertisements