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 - To prevent the password from being mentioned in the sqoop import clause we can use the additional parameters

A - -p

B - --password-file

C - both of these

D - cannot be prevented

Answer : C

Explanation

The -P option asks for password from standard input without echoing and --password-file option reads the password value stored in some other file.

Answer : B

Explanation

The default number of map task ssqoop uses is 4.

This can be altered using num-mappers parameter.

Answer : A

Explanation

The WHERE $CONDITION is used to split the result of the SQL query into multiple chunks.

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 : D

Explanation

All the listed options are disadvantages while using the –staging-table option.

Answer : A

Explanation

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

Answer : D

Explanation

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

Answer : B

Explanation

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

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