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

Q 1 - Which of the following is used by sqoop to establish a connection with enterprise data warehouses?

A - RDBMS driver

B - JDBC Driver

C - IDBC Driver

D - SQL Driver

Answer : B

Explanation

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?

A - --skip-tables

B - --without-tables

C - --forgo-tables

D - --exclude-tables

Answer : D

Explanation

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 −

A - --sqoop-job-name

B - --map-job-name

C - --mapreduce-job-name

D - --rename-job

Answer : C

Explanation

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.

Answer : A

Explanation

The name of the job is based on the name of the table which is being imported.

Answer : A

Explanation

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?

A - Yes

B - No

C - Depends on the database

D - Depends on the Hadoop configuration

Answer : C

Explanation

If available through the database driver, sqoop can clear the data quickly using TRUNCATE option.

Answer : B

Explanation

The load can still be done by specifying the –column parameter to populate a subset of columns in the relational table.

Answer : B

Explanation

The data is first staged into a temporary location as a HDFS file and then loaded into the hive table.

Answer : C

Explanation

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.

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

Useful Video Courses


Video

Advance Big Data Analytics using Hive & Sqoop

50 Lectures 4 hours

Navdeep Kaur

Advertisements