Oracle Cloud Infrastructure 2020 Architect Professional — Question 35

You are advising the database administrator responsible for managing non-production environment for Oracle Autonomous Database running on Oracle Cloud
Infrastructure. You need to help the database administrator ensure that the non-production environments have a copy of the current data from the production environment in a manner that is most time-efficient.
Which method should you recommend? (Choose the best answer.)

Answer options

• A. Take a full database backup of the production Autonomous database and create the non-production database from it.
• B. Create a metadata clone of the production Autonomous Database and create the non-production database from it.
• C. Create a full clone of the production Autonomous Database and create the non-production database from it.
• D. Take a Data Pump export of the production Autonomous database and import into the non-production database.

Correct answer: C

Explanation

Option C is the correct choice because creating a full clone of the production Autonomous Database ensures that the non-production environment has an exact and current copy of the data, which is time-efficient. Options A and D involve additional steps that may take more time, while option B only copies metadata and does not include the actual data.