Sqoop Interview Questions

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

The correct answer is JDBC Driver

Q: The data type mapping between the database column and sqoop column can be overridden by using the parameter

The correct answer is --map-column-java

Q: The free-form query import feature in sqoop allows to import data from

The correct answer is a relation source using a sql query

Q: Data Transfer using sqoop can be

The correct answer is both imported and exported from Hadoop system

Q: Using the higher value for the parameter sqoop.export.statements.per.transaction will

The correct answer is May decrease the performance for some of the tables

Take as many assements as you can to improve your validate your skill rating

Total Questions: 5

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

Correct Answer is : JDBC Driver

2. The data type mapping between the database column and sqoop column can be overridden by using the parameter

A. --override-column-type

B. --map-column-type

C. --override-column-java

D. --map-column-java

Correct Answer is : --map-column-java

3. The free-form query import feature in sqoop allows to import data from

A. non relations sources

B. a relational source without using a connector

C. a relation source using a sql query

D. a relational source using custom java classes

Correct Answer is : a relation source using a sql query

4. Data Transfer using sqoop can be

A. only imported into the Hadoop system

B. both imported and exported from Hadoop system

C. transformed during import

D. transformed during the export

Correct Answer is : both imported and exported from Hadoop system

5. Using the higher value for the parameter sqoop.export.statements.per.transaction will

A. Always increase the export performance

B. May or may not increase the export performance

C. May decrease the performance for some of the tables

D. Cause frequent commits to the database

Correct Answer is : May decrease the performance for some of the tables

Sqoop interview questions