1Z0-997-25 Question 73
Select 2You have deployed a single-instance Oracle Database on the VM.Standard.E3 shape in OCI for a mission-critical online transaction processing (OLTP) workload. As transaction volumes grow, users are complaining about performance slowdowns, and management is concerned about business continuity in the event of a region-wide outage. Which two solutions should you implement to address these requirements? (Choose two.)
- A
Configure Oracle Data Guard to replicate the database to a standby database in a different OCI region.
- B
Convert the database to an Autonomous Database (Shared) in the same region for performance improvements.
- C
Implement a lifecycle policy on your Object Storage bucket to automatically move archived redo logs to Archive Storage.
- D
Resize your database environment to a larger compute shape or migrate to Exadata Cloud Service.
Show answer and explanation
Correct answers: A, D
Explanation
To address both the performance and business continuity requirements, you should combine a robust DR solution (Oracle Data Guard to a different region) with a larger or more sophisticated database shape (e.g., Exadata Cloud Service) to handle peak workloads. For more details, consult Oracle� documentation on Configuring Oracle Data Guard in OCI and Scaling Options for Oracle Databases in Exadata Cloud Service.
- A. Correct.
Option 1 is correct. Data Guard provides a managed standby database in a different region, offering robust disaster recovery. If the primary region experiences an outage, you can fail over to the standby, minimizing downtime and data loss. This aligns with best practices for business continuity in OCI.
- B. Incorrect.
Option 2 is incorrect. While converting to an Autonomous Database might ease management and potentially improve performance in some cases, it does not automatically provide cross-region disaster recovery. You would still need to configure Autonomous Data Guard or another cross-region strategy to meet the RPO and RTO requirements.
- C. Incorrect.
Option 3 is incorrect. Moving archived redo logs to Archive Storage can lower storage costs for older backups, but it does not address immediate performance bottlenecks nor provide a complete disaster recovery solution in another region.
- D. Correct.
Option 4 is correct. Resizing your environment to a larger compute shape or migrating to Exadata Cloud Service can help handle the increased workload, ensuring better performance under high transaction volumes. Exadata Cloud Service also offers advanced features for scalability and high availability.