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 - What are the two binary file formats supported by sqoop?
Answer : A
Explanation
These are the two binary file formats supported by Sqoop.
Q 2 - The compression mechanism used by sqoop is
Answer : B
Explanation
Sqoop does not have any inbuilt code to carry out file compression. It relies on Hadoop's compression settings.
Q 3 - The argument in a saved sqoop job can be altered at run time by using the option
Answer : C
Explanation
For a saved job named 'job1' the --table parameter can be altered at run time by using the command below.
sqoop job --exec job1 -- --table-newtable.
Q 4 - Sqoops default behavior while inserting rows into relational tables is
B - multiple rows depending on the memory availability
C - It depends on the database driver being used
D - Executes random number of insert statements depending on the CPU availability
Answer : A
Explanation
the default behavior is to insert one row at a time while it can be configured for bulk load.
Q 5 - The staging-table parameter is used for
A - Storing some sample data from Hadoop before loading the real table
B - Storing all the required data from Hadoop before loading it to real table
D - Storing the metadata structure of tables to which data is being exported
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 - 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
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 disadvantage of using a stored procedure to laod data is
B - Parallel loads in the database table
C - The store procedure cannot load multiple tables at a time
Answer : D
Explanation
As sqoop will call the stored procedure using parallel jobs, so heavy laod is induced in the database.
Q 8 - For a column of data type numeric, the parameter used for substituting null values is
Answer : B
Explanation
The input- null-non-string is used to substitute null values for text based columns.
Q 9 - To import data to HBase using sqoop the parameter(s) required is/are
Answer : C
Explanation
sqoop needs to mention both the hbase table name and column family to do the import.
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
Answer : B
Explanation
This is the command to execute a sqoop job already saved in the metastore.