1Z0-997-25 Question 81
Single answerYour organization currently maintains a set of on-premises Oracle Databases primarily supporting transactional workloads. Due to strict compliance and security requirements, you must retain full control over database patching, operating system access, and configurations. As part of your cloud migration strategy on Oracle Cloud Infrastructure (OCI), you are evaluating whether to use Autonomous Databases or Base Databases. Which solution best meets these requirements?
- A
Provision an Autonomous Transaction Processing database with auto-scaling.
- B
Deploy a Base Database system on Virtual Machine (VM) in OCI and manage patching yourself.
- C
Use an Autonomous Data Warehouse for both transactional and analytic workloads.
- D
Leverage a fully managed Autonomous Database with Oracle-managed patching.
Show answer and explanation
Correct answer: B
Explanation
When compliance or business requirements demand custom OS-level configurations and full control over patching, choosing a Base Database architecture on OCI is appropriate. An Autonomous Database abstracts patching and system management from you, making it unsuitable for scenarios requiring specific security or regulatory compliance controls. According to Oracle Cloud Infrastructure documentation on Database services (https://docs.oracle.com/en/solutions/index.html), Base Databases (VM or bare metal) offer the flexibility and administrative control to align with strict compliance and security needs, whereas Autonomous Databases are designed to reduce operational overhead by automatically handling patches, backups, and tuning.
- A. Incorrect.
Option 1 (Autonomous Transaction Processing) is incorrect because Autonomous Database automatically handles patching and you do not have OS-level access or control to meet strict compliance requirements requiring custom patching or specific OS configurations.
- B. Correct.
Option 2 (Deploy a Base Database system on Virtual Machine) is correct because Base Databases on VM systems in OCI allow you to manage database patches, configure the OS, and maintain full administrative control�fulfilling compliance requirements that require direct control over patching and operating system configurations.
- C. Incorrect.
Option 3 (Use an Autonomous Data Warehouse) is incorrect because ADW is optimized for analytic workloads rather than transactional workloads, and it also restricts direct patching and OS-level control. This does not align with your stated compliance needs.
- D. Incorrect.
Option 4 (Leverage a fully managed Autonomous Database with Oracle-managed patching) is incorrect because it contradicts the requirement to perform patches under your own schedule and control. Oracle handles patching for Autonomous Database, limiting your control over the process.