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?
These are the two binary file formats supported by Sqoop.
Q 2 - What does the --last-value parameter in sqoop incremental import signify?
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 clause 'WHERE $CONDITIONS' in the sql query specified to import data, serves the purpose of
The WHERE $CONDITION is used to split the result of the SQL query into multiple chunks.
Q 4 - Sqoop’s default behavior while inserting rows into relational tables is
the default behavior is to insert one row at a time while it can be configured for bulk load.
Q 5 - Using the –staging-table parameter while loading data to relational tables the creation of staging table is done
The user has to ensure that the staging tab e is created and accessible by sqoop.
Q 6 - A table contains 4 columns (C1,C2,C3,C4). With –update-key C2,C4, the sqoop generated query will be like
only the columns other than in the –update-key parameter will be appear in the SET clause.
Q 7 - How do we decide the order of columns in which data is loaded to the target table?
we can use the –column parameter and specify the required column in the required order.
Q 8 - To ensure that the columns created in hive by sqoop have the correct data types the parameter used by sqoop is
The correct column mapping is handled by the parameter --map-column-hive.
Q 9 - To import data to HBase using sqoop the parameter(s) required is/are
sqoop needs to mention both the hbase table name and column family to do the import.
Q 10 - The parameters in sqoop command can be passed in to Oozie by using which tags?
The <args> tag can contain the parameters of a sqoop command when scheduling with Oozie.