75.5k views
5 votes
Which two of the following can Sqoop import from a relational database? (select two)

A. Tables
B. Views
C. Indexes
D. Triggers

User Dstonek
by
8.1k points

1 Answer

5 votes

Final answer:

Sqoop can import Tables and Views from a relational database to a Hadoop ecosystem but cannot import Indexes or Triggers.

Step-by-step explanation:

When working with Sqoop import to transfer data from a relational database to a Hadoop ecosystem, Sqoop can handle importing specific types of database objects. The two types of objects that Sqoop can import from a relational database are A) Tables and B) Views. Sqoop is not designed to handle the importation of database structures such as C) Indexes or D) Triggers because these are part of the internal mechanism of a database to optimize queries and ensure data integrity, which do not contain the actual data but rather metadata and procedural code respectively.

User Goltsev Eugene
by
7.7k points