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

Explanation

Sqoop uses the --last-value parameter in both the append mode and the last_update_date mode to import the incremental data form source.

Answer : A

Explanation

with the --meta-connect parameter the metastore starts running as a service with the default port 16000.Now this metastore service becomes accessible throughout the cluster.

Answer : A

Explanation

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

Answer : A

Explanation

The export fails if the query is not accepted by the database.

Q 6 - Can the upsert feature of sqoop delete some data form the exported table?

A - Yes

B - No

C - Depends on database

D - Yes With some additional sqoop parameters

Answer : A

Explanation

Sqoop will never delete data as part of upsert statement.

Q 7 - Load all or load nothing semantics is implemented by using the parameter

A - -loadd-all-nothing

B - -stage-load

C - -all-load

D - -staging-table

Answer : D

Explanation

The –staging-table parameter is used to load all the required data into a intermediate table before finally loading into the real table.

Answer : D

Explanation

Sqoop supports loading into hive partitions using additional parameters in the sqoop command.

Answer : C

Explanation

As the characters \n, \t, and \01 may interfere with the data giving incorrect result, these can be replaced with a suitable string using this parameter.

Answer : B

Explanation

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


sqoop_questions_answers.htm

Advertisements