Which ONE of the following statements regarding Sqoop is TRUE?

Which ONE of the following statements regarding Sqoop is TRUE?
A . By default, data is compressed with Sqoop
B . Sqoop can only read committed transactions from a source database, not uncommitted ones
C . When performing parallel imports, Sqoop always uses the primary key column in a table as the splitting column
D . When performing parallel imports, each degree of parallelism corresponds to a concurrent database connection

View Answer

Answer: B

Explanation:

Explanation: By default, Sqoop uses the read committed transaction isolation in the mappers to import data. This may not be the ideal in all ETL workflows and it may desired to reduce the isolation guarantees. The –relaxed­isolation option can be used to instruct Sqoop to use read uncommitted isolation level.

Reference: https://sqoop.apache.org/docs/1.4.6/SqoopUserGuide.html