1Z0-997-25 Question 80
Single answerYour on-premises Oracle Database supports a mission-critical analytics workload. The data volume grows unpredictably, causing frequent spikes in concurrency. Your operations team wants to minimize manual tasks such as patching and performance tuning, while ensuring consistent performance during peak loads. Which deployment option in Oracle Cloud Infrastructure would best meet these requirements?
- A
Deploy a Virtual Machine-based Base Database system and manually manage patching and tuning for peak workloads.
- B
Migrate to an Autonomous Database (shared infrastructure) to leverage auto-scaling, automated patching, and automated performance tuning.
- C
Deploy a bare metal Base Database system for maximum control and manual scalability.
- D
Use Dedicated Autonomous Exadata Infrastructure but disable auto-scaling to reduce costs.
Show answer and explanation
Correct answer: B
Explanation
For dynamic analytics workloads with unpredictable spikes, Autonomous Database on OCI provides automated patching and tuning, as well as autoscaling to handle sudden increases in resource demands. This configuration reduces administrative overhead while maintaining performance. Refer to Oracle documentation for details on reviewing workload types (Transaction Processing or Data Warehouse) and migration strategies, such as Oracle Data Pump or Zero Downtime Migration, to move from on-premises databases seamlessly.
- A. Incorrect.
Option 1 is incorrect because it maintains manual administrative overhead and does not automatically handle concurrency spikes.
- B. Correct.
Option 2 is correct because Autonomous Database automates patching, updates, and performance tuning, while auto-scaling can manage unpredictable spikes in workload.
- C. Incorrect.
Option 3 is incorrect because bare metal Base Database systems require more manual oversight for scalability, patching, and tuning. This contradicts the goal of minimizing manual tasks.
- D. Incorrect.
Option 4 is incorrect because disabling auto-scaling may save cost but can lead to performance issues during unpredictable peaks, which conflicts with the requirement for consistent performance.