Sqoop Online Quiz

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 - What are the two binary file formats supported by sqoop?

A - Avro & SequenceFile

B - Rcfile and SequenceFile

C - ORC file and RC file

D - Avro and RC file

Answer : A

Explanation

These are the two binary file formats supported by Sqoop.

Q 2 - Sqoop supports

A - full import of tables

B - partial import of data from tables

C - Both full and partial data import

D - Import both the table and its partitions

Answer : C

Explanation

You can do both full and partial data import from tables but not a subset of columns from a table.

Q 3 - The free-form query import feature in sqoop allows to import data from

A - non relations sources

B - a relational source without using a connector

C - a relation source using a sql query

D - a relational source using custom java classes

Answer : C

Explanation

With the The free form query we can write a sql query involving a join between 2 tables and mention it with --query parameter while importing. It is used in place of the --table parameter.

Q 4 - In a table import the name of the mapreduce job

A - Is named after the table name

B - Can be customized

C - Can be passed as a query parameter

D - Is a random name decided by the system.

Answer : A

Explanation

The name of the job is based on the name of the table which is being imported.

Q 5 - What does the parameter “ Dsqoop.export.records.per.statemet=10” do in a sqoop export command?

A - Exports 10 records in each insert statement

B - Export 10 insert statements every time the command runs

C - Export only the first 10 record to the table

D - Run 10 data export commands in parallel

Answer : A

Explanation

The sqoop command submits the values form 10 records in each insert statement with this parameter.

Q 6 - Sqoop can automatically clear the staging table before loading by using the parameter

A - –clear-table

B - –clear-staging-table

C - --truncate-staging-table

D - -delete-from-staging-table

Answer : B

Explanation

the –clear-staging-table automatically cleans data form the staging table.

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.

Q 8 - The temporary location to which sqoop moves the data before loading into hive is specified by the parameter

A - --target-dir

B - --source-dir

D - --sqoop-dir

Answer : A

Explanation

The --target-dir parameter mentions the directory used for temporary staging the data before loading into the hive table.

Q 9 - The parameter --hive-drop-import-delims does which of the following?

A - replaces the hive delimiters with sqoop delimiters

B - drops the rows which do not have the \n,\t,\01 delimiters

C - removes all the \n,\t and \01 characters

D - drops the columns which do not have the \n,\t,\01 delimiters

Answer : C

Explanation

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

Q 10 - The comparison of row counts between the source system and the target database while loading the data using sqoop is done using the parameter

C - -row(count)

Answer : A

Explanation

The –validate parameter is used to show the result of row comparison between source and target.

sqoop_questions_answers.htm

Advertisements