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 option can bne used to import only some of the table from a database while using the --import-all-tables parameter?
You can mention the tables names along with the --exclude-table clause to skip a given number of tables while importing an entire database.
Q 3 - The parameter to give a custom name to the mapreduce job running a sqoop import command is −
The --mapreduce-job-name is used to give a user chosen job name to the sqoop command so that it can be easliy distinguished from other jobs in the jobtracker UI.
Q 4 - In a table import the name of the mapreduce job
The name of the job is based on the name of the table which is being imported.
Q 5 - What happens if the sqoop generated export query is not accepted by the database?
The export fails if the query is not accepted by the database.
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 - If the table to which data is being exported has more columns than the data present in the hdfs file then
The load can still be done by specifying the –column parameter to populate a subset of columns in the relational table.
Q 8 - During import to hive using sqoop the data is
The data is first staged into a temporary location as a HDFS file and then loaded into the hive table.
Q 9 - The purpose of --hive-delims-replacement parameter in sqoop is to
As the characters \n, \t, and \01 may interfere with the data giving incorrect result, these can be replaced with a suitable string using this parameter.
Q 10 - The property in sqoop that allows rows with all NULL values to be inserted into HBAse tables is −
The property sqoop.hbase.add.row.key instructs Sqoop to insert the row key column twice, once as a row identifier and then again in the data itself. Even if all other columns contain NULL, at least the column used for the row key won’t be null, which will allow the insertion of the row into HBase.