1Z0-1067-25 Question 60
Select 2Your organization runs a high-traffic e-commerce application on Oracle Cloud Infrastructure using a 3-tier architecture: a public load balancer, several compute instances for the web and application tier, and a single Oracle Database System for all transactional data. During peak load, users report significant slowdowns at the checkout stage, and analysis reveals the database is the primary bottleneck. Which two strategies should you implement to improve database performance?
- A
- Switch the database to a larger compute shape with more OCPUs and memory.
- B
- Migrate the database storage to ephemeral local NVMe devices for higher IOPS.
- C
- Upgrade the block volume performance tier from Balanced to Higher Performance.
- D
- Implement an Active Data Guard read replica for write-intensive workloads.
Show answer and explanation
Correct answers: A, C
Explanation
Optimizing performance on Oracle Cloud Infrastructure typically involves scaling compute resources and choosing the appropriate block volume performance tier when the database is a bottleneck. Refer to Oracle Cloud Infrastructure best practices documentation for additional guidance on selecting shapes, tuning block volumes, and planning high-availability solutions.
- A. Correct.
Option 1: Correct � Increasing the database shape (more OCPUs, RAM) can handle higher concurrency and throughput, reducing performance bottlenecks under heavy loads. Oracle Cloud Infrastructure supports resizing the DB system to a shape that provides additional resources as a standard performance enhancement practice.
- B. Incorrect.
Option 2: Incorrect � Ephemeral local NVMe devices can provide higher IOPS, but they are not recommended for primary database storage due to lack of built-in persistence and durability. These disks are locally attached and do not offer the same reliability as block volumes, posing a higher risk in the event of hardware failure.
- C. Correct.
Option 3: Correct � By upgrading from Balanced to Higher Performance (or an equivalent high-performance tier) for block volumes, you increase throughput and IOPS capacity. This directly addresses storage I/O bottlenecks that often occur under peak transaction loads.
- D. Incorrect.
Option 4: Incorrect � While Active Data Guard read replicas can offload read workloads, they are not a recommended solution for write-intensive OLTP bottlenecks. Active Data Guard is primarily for read scaling and high availability rather than alleviating heavy write traffic under peak loads.