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 - Which of the following is used by sqoop to establish a connection with enterprise data warehouses?
The JDBC driver is a java program which has been traditionally providing data base connectivity to a variety of databases.
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 - while specifying the connect string in the sqoop import command, for a Hadoop cluster, if we specify localhost in place of a server address(hostname or IP address) in the URI, then
Specifying localhost does not invalidate the command as some local database may be running and the node will be able to connect. So each node will connect to different database if they are available.
Q 4 - While inserting data into Relational system from Hadoop using sqoop, the various table constraints present in the relational table must be
We must verify that the data being exported does not violate the constraints error.
Q 5 - The –staging-table parameter is used for
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 - Can sqoop use the TRUNCATE option in database while clearing data from a table?
If available through the database driver, sqoop can clear the data quickly using TRUNCATE option.
Q 7 - The parameter which can be used in place of --table parameter to insert data into table is
The –call parameter will call a database stored procedure which in turn can insert data into table.
Q 8 - The parameter used in sqoop to import data directly into hive is
The parameter used is –hive-import which will directly place the data in hie without needing any connectors as in case of relational systems.
Q 9 - The parameter(s) used to laod data using sqoop into the hive partitions is/are
both partition-key and partition value are passed in to load data into hive partitioned table.
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
The –validate parameter is used to show the result of row comparison between source and target.