1Z0-997-25 Question 74
Single answerYou are deploying a mission-critical Oracle Database in OCI that processes large transaction volumes. The requirements include direct access to the underlying operating system for advanced performance tuning, full control over when patches are applied to both the database and the OS, and robust disaster recovery using Data Guard. Which OCI deployment choice best meets these requirements?
- A
Autonomous Database on Shared Exadata Infrastructure
- B
Exadata Cloud Service
- C
Virtual Machine DB System with Data Guard
- D
Bare Metal DB System with Data Guard
Show answer and explanation
Correct answer: D
Explanation
For critical workloads requiring dedicated system resources, full OS-level access, manual patch management, and Data Guard-based DR, a Bare Metal DB System with Data Guard is the most suitable option. Autonomous Database (shared or dedicated) does not allow OS-level access or fully manual patching. Although Exadata Cloud Service provides OS-level access, it is often geared toward very large or specialized deployments. Oracle� documentation on DB Systems and Data Guard (available at https://docs.oracle.com/en-us/iaas/Content/Database/Concepts/overview.htm) discusses these deployment models and DR strategies in detail.
- A. Incorrect.
Option 1: Autonomous Database on Shared Exadata Infrastructure. This does not provide operating system access because Oracle fully manages the environment. Also, database patching is automatic, so it does not allow the manual patch scheduling you require.
- B. Incorrect.
Option 2: Exadata Cloud Service. While this provides OS-level access and high performance, it often targets larger scale or more complex deployments than needed. The question specifically mentions minimal overhead, so this may be more capacity than necessary for your use case.
- C. Incorrect.
Option 3: Virtual Machine DB System with Data Guard. This offers OS-level access and Data Guard integration, but large-scale performance tuning can be more flexible on a dedicated hardware environment. If you need highly resource-intensive performance tuning, a VM-based system might not be sufficient in certain high-load scenarios.
- D. Correct.
Option 4: Bare Metal DB System with Data Guard. Correct. This configuration grants direct OS-level access for advanced tuning, allows manual scheduling for both database and operating system patches, and integrates with Data Guard for disaster recovery. It also ensures dedicated hardware resources for high-volume workloads.