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 - What does the num-mappers parameter serves?
A - force sqoop to use only one map task
B - set the number of map tasks sqoop can use
C - store the data imported by each map tasks in a separate file
Answer : B
Explanation
The default number of map task ssqoop uses is 4.
This can be altered using num-mappers parameter.
Q 3 - While using a free-form query to import data, Sqoop finds that two columns from the joined tables have the same name. In this case the job
B - will run ignoring the column from each table
C - will prompt the user to rename one of the columns
D - automatically create an alias for one of the columns as succeed the job.
Answer : A
Explanation
The job will fail as the mapreduce job creates java classes for each of the column names and two java classes cannot have the same name in the same mapreduce job.
Q 4 - While importing data into Hadoop using sqoop the SQL SELCT clause is used. Similarly while exporting data form Hadoop the SQL clause used is
Answer : D
Explanation
The INSERT statements are generated by sqoop to insert data into the relational tables.
Q 5 - What does the parameter Dsqoop.export.records.per.statemet=10 do in a sqoop export command?
A - Exports 10 records in each insert statement
B - Export 10 insert statements every time the command runs
Answer : A
Explanation
The sqoop command submits the values form 10 records in each insert statement with this parameter.
Q 6 - Can sqoop use the TRUNCATE option in database while clearing data from a table?
Answer : C
Explanation
If available through the database driver, sqoop can clear the data quickly using TRUNCATE option.
Q 7 - The parameter used to override NULL values to be inserted into relational targets is
Answer : B
Explanation
the parameter input-null-string is used to override the NULL values when exporting to relational tables.
Q 8 - During import to hive using sqoop the data is
A - directly loaded to existing hive table
B - first moved into a hive directory as a hdfs file
Answer : B
Explanation
The data is first staged into a temporary location as a HDFS file and then loaded into the hive table.
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 - After importing a table into HBAse you find that the number of rows inserted is fewer than in the source. The possible reason is −
A - Sqoop is yet to have mature code for HBase
B - Sqoop version and Hbase version conflict
C - Hbase does not allow rows will all NULL values to be inserted
D - Hbase has very limited capabilities to handle numeric data types so some rows got rejected.
Answer : C
Explanation
As Hbase does not allow the rows with all NULL values, those rows were skipped during import and caused fewer row counts.