Oracle Cloud Infrastructure 2019 Architect Associate — Question 56

Your customer receives information in various formats like .csv files from their suppliers. The business user would like to collect all of this information and store it in a ATP environment. The Oracle adviser recommends to use Oracle Data Sync for this.
Which statement is true regarding Oracle Data Sync?

Answer options

• A. Data Sync can only load files into tables (insert-only), the customer has to write the additional code.
• B. Data Sync can not transform your data while loading it into the destination table.
• C. Data Sync can load a combination of data source, such as .csv, .xlsx and Oracle relational files.
• D. Data Sync can only load data from one source into one destination table.

Correct answer: C

Explanation

The correct answer is C because Oracle Data Sync supports loading data from multiple formats like .csv and .xlsx. Option A is incorrect as Data Sync does not limit itself to insert-only operations; it can handle updates as well. Option B is false because Data Sync does allow for some data transformations. Option D is incorrect as Data Sync can handle multiple sources and destinations.