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 - What option can be used to import the entire database from a relational system using sqoop?

A - --import-all-db

B - --import-all-tables

C - --import-all

D - --import

Answer : C

Explanation

The --import-all-tables is used to import all the tables from the database. The tables structure as well as data is imported one by one through this command.

Q 3 - The argument in a saved sqoop job can be altered at run time by using the option

A - --alter

B - --newval

C - --exec

D - --changeparam

Answer : C

Explanation

For a saved job named 'job1' the --table parameter can be altered at run time by using the command below.

sqoop job --exec job1 -- --table-newtable.

Q 4 - While inserting data into Relational system from Hadoop using sqoop, the various table constraints present in the relational table must be

A - Disabled temporarily

B - Dropped and re created

C - Renamed

D - Not violated

Answer : D

Explanation

We must verify that the data being exported does not violate the constraints error.

Answer : A

Explanation

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

Answer : C

Explanation

A comma separate dlist of column names which together identify a unique record can be used in the –update-key parameter.

Answer : D

Explanation

As sqoop will call the stored procedure using parallel jobs, so heavy laod is induced in the database.

Q 8 - To overwrite data present in hive table while importing data using sqoop, the sqoop parameter is

A - --sqoop-overwrite

B - --hive-overwrite

C - --hive-delete-all

D - --sqoop-delete-all

Answer : B

Explanation

The --hive-overwrite parameter truncates the hive table before loading the data.

Q 9 - To import data to HBase using sqoop the parameter(s) required is/are

A - --hbase-table

B - --hbase-columns

C - --hbase-table and --column-family

D - --habse-table and --hbase-column-family

Answer : C

Explanation

sqoop needs to mention both the hbase table name and column family to do the import.

Answer : B

Explanation

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

sqoop_questions_answers.htm
Advertisements