- Sqoop Tutorial
- Sqoop - Home
- Sqoop - Introduction
- Sqoop - Installation
- Sqoop - Import
- Sqoop - Import-All-Tables
- Sqoop - Export
- Sqoop - Sqoop Job
- Sqoop - Codegen
- Sqoop - Eval
- Sqoop - List Databases
- Sqoop - List Tables
- Sqoop Useful Resources
- Sqoop - Questions and Answers
- Sqoop - Quick Guide
- Sqoop - Useful Resources
- Sqoop - Discussion
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 - By default the records from databases imported to HDFS by sqoop are
Answer : D
Explanation
The default record separator is comm.
Q 2 - What option can be used to import the entire database from a relational system using sqoop?
Answer : C
Explanation
The --import-all-tables is used to import all the tables from the database. The tables structure as well as data is imported one by one through this command.
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 - Which parameter in sqoop is used for bulk data export to relational tables?
Answer : B
Explanation
The –batch parameter uses the JDBC batch load capability to do 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 - Load all or load nothing semantics is implemented by using the parameter
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.
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 - HIve shows more row count than imported by sqoop. What can be the reason?
A - the \n chara cter present int the data
B - Error with java classes used in sqoop
Answer : A
Explanation
The new line characters present in data will increase the number of rows.
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
Answer : A
Explanation
The –validate parameter is used to show the result of row comparison between source and target.
To Continue Learning Please Login