Sqoop Online Quiz

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.

Q 1 - Which of the following is used by sqoop to establish a connection with enterprise data warehouses?

Answer : B

Explanation

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

Q 2 - What does the --last-value parameter in sqoop incremental import signify?

A - What is the number of rows sucessfully imported in append type import

B - what is the date value to be used to select the rows for import in the last_update_date type import

C - Both of the above

D - The count of the number of rows that were succesful in the current import.

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 - The free-form query import feature in sqoop allows to import data from

A - non relations sources

B - a relational source without using a connector

C - a relation source using a sql query

D - a relational source using custom java classes

Answer : C

Explanation

With the The free form query we can write a sql query involving a join between 2 tables and mention it with --query parameter while importing. It is used in place of the --table parameter.

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.

Q 5 - The insert query used to insert exported data into tables is generate by

A - Sqoop command and processed as such

B - Sqoop command and modified suitably by JDBC drive

C - JDBC driver

D - Database specific driver

Answer : A

Explanation

The insert query is generated only by the sqoop command and processed as such without any further modification by any other driver.

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

Answer : A

Explanation

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

Q 8 - To ensure that the columns created in hive by sqoop have the correct data types the parameter used by sqoop is

A - --map-column-hive

B - --map-column

C - --column-hive

D - --map-table-hive

Answer : A

Explanation

The correct column mapping is handled by the parameter --map-column-hive.

Q 9 - The data type of the column used for partition name while importing data using sqoop ino hive can be

A - only string

B - string or numeric

C - only date

D - string without special characters

Answer : A

Explanation

Sqoop can only take strings as partition column names while loading data to hive.

Q 10 - What is achieved by the command – sqoop job –exec myjob

A - Sqoop job named myjob is saved to sqoop metastore

B - Sqoop job named myjob starts running

C - Sqoop job named myjob is scheduled

D - Sqoop job named myjob gets created

Answer : B

Explanation

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

sqoop_questions_answers.htm