- 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 - To run sqoop from multiple nodes, it has to be installed in
A - Any one of the in the local filesystem.
B - each of the node where it is supposed to run
Answer : A
Explanation
On installing in one node it, automatically gets replicated to other nodes in the cluster.
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
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 --options-file parameter is used to
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 - Sqoop’s 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 - When using –update-mode allowinsert parameter with oracle database the feature of oracle used by sqoop is
Answer : B
Explanation
The Merger statement of oracle is used to achieve update else insert condition.
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 - While importing data to hive using sqoop, if data already exists in hive table then the default behaviour is
A - The incoming data is appended to hive table
B - the incoming data replaces data in hive table
C - The data only gets updated using the primary key of the hive table
Answer : A
Explanation
The default behavior is to append data into existing hive table.
Q 9 - If the hbase table to which sqoop is importing data does not exist then
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 - The sqoop export/import jobs canbe stored and used again and again by using
Answer : D
Explanation
Running a sqoop job by using sqoop-job statement saves the job into metastore which can be retrived later and used again and again
Example −
$ sqoop-job --create jobname -- import --connect jdbc:mysql://example.com/db \ --table mytable
To Continue Learning Please Login