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 - Which of the following is used by sqoop to establish a connection with enterprise data warehouses?

A - RDBMS driver

B - JDBC Driver

C - IDBC Driver

D - SQL Driver

Answer : B

Explanation

The JDBC driver is a java program which has been traditionally providing data base connectivity to a variety of databases.

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.

Q 3 - while specifying the connect string in the sqoop import command, for a Hadoop cluster, if we specify localhost in place of a server address(hostname or IP address) in the URI, then

A - The import job will connect to local databases

B - Each node may connect to different databases

C - the import job may succeed

D - All of the above

Answer : D

Explanation

Specifying localhost does not invalidate the command as some local database may be running and the node will be able to connect. So each node will connect to different database if they are available.

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

Q 6 - Can sqoop use the TRUNCATE option in database while clearing data from a table?

A - Yes

B - No

C - Depends on the database

D - Depends on the Hadoop configuration

Answer : C

Explanation

If available through the database driver, sqoop can clear the data quickly using TRUNCATE option.

Q 7 - The parameter which can be used in place of --table parameter to insert data into table is

A - –call

B - –insert-into

C - –populate

D - –load-into

Answer : A

Explanation

The –call parameter will call a database stored procedure which in turn can insert data into table.

Q 8 - The parameter used in sqoop to import data directly into hive is

A - -import-direct

B - -import-hive

C - –hive-import

D - -hive-sqoop

Answer : C

Explanation

The parameter used is –hive-import which will directly place the data in hie without needing any connectors as in case of relational systems.

Answer : A

Explanation

both partition-key and partition value are passed in to load data into hive partitioned table.

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