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 - 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 - 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 - What is the disadvantage of storing password in the metastore as compared to storing in a password file?

A - it is easily accessible

B - it may get deleted accidentally

C - It cannot be updated

D - it is unencrypted

Answer : D

Explanation

The password file can be encrypted and prevented from reading by proper permissions. But metastore is unencrypted and cannot be prevented from reading.

Q 4 - While importing data into Hadoop using sqoop the SQL SELCT clause is used. Similarly while exporting data form Hadoop the SQL clause used is

A - APPEND

B - MERGE

C - UPDTAE

D - INSERT

Answer : D

Explanation

The INSERT statements are generated by sqoop to insert data into the relational tables.

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.

Answer : A

Explanation

The –update-key parameter cannot export new rows which do not have a matching key in the already exported table.

Q 7 - For Text based columns the parameter used for substituting null values is

A - -input-null-string

B - -input-null-non-string

C - -input-null-text

D - -input-null-varchar

Answer : A

Explanation

The –input- null-string is used to substitute null values for text based columns.

Answer : B

Explanation

as both sqoop and hive are part of hadoop ecosystem, sqoop is able to create the meta data in hive.

Answer : B

Explanation

This parameter can be used with both hive and text files.

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

A - --Validate

B - --Rowcount

C - -row(count)

D - -allrows

Answer : A

Explanation

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


sqoop_questions_answers.htm

Advertisements
E-Books Store