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

Q 2 - Sqoop supports

A - full import of tables

B - partial import of data from tables

C - Both full and partial data import

D - Import both the table and its partitions

Answer : C

Explanation

You can do both full and partial data import from tables but not a subset of columns from a table.

Q 3 - The --options-file parameter is used to

A - save the import log

B - specify the name of the data files to be created after import

C - store all the sqoop variables

D - store the parameters and their values in a file to be used by various sqoop commands.

Answer : D

Explanation

The command line options (the name and value of the parameters) that do not change from time to time can be saved into a file and used again and again. This is called an options file.

Q 4 - Data Transfer using sqoop can be

A - only imported into the Hadoop system

B - both imported and exported from Hadoop system

C - transformed during import

D - transformed during the export

Answer : B

Explanation

The data can be both imported and exported form Hadoop system using sqoop.

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 - The –update-key parameter can

A - Not insert new rows to the already exported table

B - Insert new rows to an already exported table

C - Insert new rows into the exported table only if it has a primary key

D - Delete rows form already exported 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 - The parameter used to override NULL values to be inserted into relational targets is

A - -override-null

B - –input-null-string

C - -substitute-null

D - --replace-null

Answer : B

Explanation

the parameter –input-null-string is used to override the NULL values when exporting to relational tables.

Q 8 - For a column of data type numeric, 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 : B

Explanation

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

Q 9 - If the hbase table to which sqoop is importing data does not exist then

A - sqoop creates it

B - sqoop job fails

C - sqoop waits for user input for hbase table details to proceed with import

D - sqoop imports the data to a temporary location under Hbase

Answer : B

Explanation

Unlike hive where sqoop creates the table if it does not exist, in HBase the job fails.

Q 10 - When inserting data using sqoop into Hbase table in one physical node, the different parallel tasks of sqoop import create a bottleneck. This can be solved by

A - Configuring sqoop not to run parallel tasks

B - Configuring gHBase to accept rows in parallel

C - Creating more regions in HBAse table

D - Cannot be solved

Answer : C

Explanation

By creating more regions, the Hbase table get split into many nodes in the HBAse cluster, which help load data faster from the sqoop parallel load tasks.

sqoop_questions_answers.htm