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 - By default the records from databases imported to HDFS by sqoop are

A - Tab separated

B - Concatenated columns

C - space separated

D - comma separated

Answer : D

Explanation

The default record separator is comm

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.

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.

Q 5 - Using the –staging-table parameter while loading data to relational tables the creation of staging table is done

A - Automatically b sqoop

B - Automatically by database

C - User has to ensure it is created

D - Automatically created by a Hadoop process beyond sqoop

Answer : C

Explanation

The user has to ensure that the staging tab e is created and accessible by sqoop.

Answer : A

Explanation

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

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.

Q 8 - The parameter used in sqoop to import data directly into hive is

A - -import-direct

B - -import-hive

C - –hive-import

D - -hive-sqoop

Answer : C

Explanation

The parameter used is –hive-import which will directly place the data in hie without needing any connectors as in case of relational systems

Answer : A

Explanation

The new line characters present in data will increase the number of rows.

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