Sqoop Online Quiz


Advertisements


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.

Questions and Answers

Answer : A

Explanation

On installing in one node it, automatically gets replicated to other nodes in the cluster.

Q 2 - For some databases sqoop can to faster data transefr by using the parameter

A - --bulkload

B - --fastload

C - --dump

D - --direct

Answer : D

Explanation

The direct mode delegates the data transferring capabilities to the native untilities provided by the database.

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

A - The import job will connect to local databases

B - Each node may connect to different databases

C - the import job may succeed

D - All of the above

Answer : D

Explanation

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 - The export and import of data between sqoop and relational system happens through which of the following programs?

A - Sqoop client program

B - Mapreduce job submitted by the sqoop command

C - Database stores procedure

D - Hdfs file management program

Answer : B

Explanation

The sqoop client only submits the command and oversees the completion or failure of the command. The Mapreduce job created will do the actual data transfer.

Answer : A

Explanation

The sqoop command submits the values form 10 records in each insert statement with this parameter.

Answer : C

Explanation

A comma separate dlist of column names which together identify a unique record can be used in the –update-key parameter.

Q 7 - To sync a HDFS file with some deleted rows with a previously exported table for the same table the option is to

A - Using staging table

B - Export the data again to a new database table and rename it

C - Use a ETL tool

D - Can not be done using sqoop

Answer : B

Explanation

you can drop the existing table and re-import the data from Hadoop. Then rename it to the dropped table.

Q 8 - When a column value has a different data type in the HDFS system than expected in the relational table to which data will be exported −

A - Sqoop skips the rows

B - Sqoop fails the job

C - Sqoop loads the remaining rows by halting and asking whether to continue the load

D - Sqoop automatically changes the data type to a compatible data type and loads the data.

Answer : B

Explanation

The job fails and sqoop gives a log showing the reason of failure.

Q 9 - The parameter that can create a hbase table using sqoop when importing data to hbase is

A - -hbase-create-table

B - -create-hbase-table

C - -create-hbase-table-columnlist

D - -create-hbase-table-rowkey

Answer : B

Explanation

If the–create-hbase-table is mentioned during the import then the Hbase table can get created using sqoop if it does not already exist.

Answer : A

Explanation

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.


sqoop_questions_answers.htm

Advertisements