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 - The data type mapping between the database column and sqoop column can be overridden by using the parameter

A - --override-column-type

B - --map-column-type

C - --override-column-java

D - --map-column-java

Answer : D

Explanation

As sqoop uses the Java Data types internally, the mapping of the data types has to be done with Java Data Types.

Q 3 - While using a free-form query to import data, Sqoop finds that two columns from the joined tables have the same name. In this case the job

A - will fail

B - will run ignoring the column from each table

C - will prompt the user to rename one of the columns

D - automatically create an alias for one of the columns as succeed the job.

Answer : A

Explanation

The job will fail as the mapreduce job creates java classes for each of the column names and two java classes cannot have the same name in the same mapreduce job.

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

The parameter

Dsqoop.export.statements.per.transaction decides how many rows will be inserted for transaction.

Answer : A

Explanation

only the columns other than in the –update-key parameter will be appear in the SET clause.

Q 7 - The parameter used to override NULL values to be inserted into relational targets is

A - -override-null

B - –input-null-string

C - -substitute-null

D - --replace-null

Answer : B

Explanation

the parameter –input-null-string is used to override the NULL values when exporting to relational tables.

Answer : B

Explanation

The data is first staged into a temporary location as a HDFS file and then loaded into the hive table.

Answer : C

Explanation

the parameter --hive-drop-import-delims removes the mentioned characters.

Q 10 - The tool that populates a Hive metastore with a definition for a table based on a database table previously imported to HDFS is

A - create-hive-table

B - import-hive-metastore

C - create-hive-metastore

D - update-hive-metastore

Answer : B

Explanation

Define in Hive a table named emps with a definition based on a database table named employees −

$ sqoop create-hive-table --connect jdbc:mysql://db.example.com/corp \
   --table employees --hive-table emps
sqoop_questions_answers.htm
Advertisements