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 - By default the records from databases imported to HDFS by sqoop are
The default record separator is comm.
Q 2 - What option can be used to import the entire database from a relational system using sqoop?
The --import-all-tables is used to import all the tables from the database. The tables structure as well as data is imported one by one through this command.
Q 3 - The argument in a saved sqoop job can be altered at run time by using the option
For a saved job named 'job1' the --table parameter can be altered at run time by using the command below.
sqoop job --exec job1 -- --table-newtable.
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 - What does the parameter “ Dsqoop.export.records.per.statemet=10” do in a sqoop export command?
The sqoop command submits the values form 10 records in each insert statement with this parameter.
Q 6 - The –update-key parameter can take
A comma separate dlist of column names which together identify a unique record can be used in the –update-key parameter.
Q 7 - The disadvantage of using a stored procedure to laod data is
As sqoop will call the stored procedure using parallel jobs, so heavy laod is induced in the database.
Q 8 - To overwrite data present in hive table while importing data using sqoop, the sqoop parameter is
The --hive-overwrite parameter truncates the hive table before loading the data.
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 - What is achieved by the command – sqoop job –exec myjob
This is the command to execute a sqoop job already saved in the metastore.