nerdexam
Oracle

1Z0-931 · Question #39

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…

The correct answer is C. Data Sync can load a combination of data source, such as .csv, .xlsx and Oracle relational files. https://docs.oracle.com/en/cloud/paas/bi-cloud/bilpd/data-sync.html

Loading and Transforming Data

Question

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?

Options

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

How the community answered

(35 responses)
  • A
    14% (5)
  • B
    6% (2)
  • C
    71% (25)
  • D
    9% (3)

Explanation

https://docs.oracle.com/en/cloud/paas/bi-cloud/bilpd/data-sync.html

Topics

#Oracle Data Sync#CSV loading#multi-source ETL#data formats

Community Discussion

No community discussion yet for this question.

Full 1Z0-931 Practice