Oracle Cloud Infrastructure 2019 Architect Associate — Question 21

In which way can a SQL Developer help you test your data loading scenario to Autonomous Database (ADB)?

Answer options

• A. In the TEST phase of the wizard, a subset of accepted records is displayed based on your definition.
• B. In the TEST phase of the wizard a list is generated containing the records that would be rejected during import.
• C. In the Column Definition Phase, the system cross-references with the file-contents and shows the conflicts with the definition.
• D. In the TEST phase, a temporary table will be populated with the records before inserting them in the destination table.

Correct answer: C

Explanation

The correct answer is C because it accurately describes how the system identifies and displays conflicts between the file contents and column definitions. Options A and B refer to record acceptance and rejection, which are not the primary focus during the Column Definition Phase. Option D incorrectly states that records are populated into a temporary table, which is not the main purpose of that phase.