1Z0-997-25 Question 78
Select 2Your company manages a high-volume e-commerce platform that must support a mix of transactional requests (OLTP) and regular data analytics. You want to minimize operational overhead, anticipate large spikes in user traffic, and expect sizable data growth over time. Which two approaches are valid solutions for implementing a database architecture on Oracle Cloud Infrastructure to meet these needs?
- A
Create a single Base Database on a Virtual Machine (VM) DB System to handle both OLTP and analytics workloads
- B
Deploy an Autonomous Transaction Processing (ATP) instance with integrated analytics features to handle both transactional and analytical queries
- C
Deploy separate Autonomous Transaction Processing (ATP) and Autonomous Data Warehouse (ADW) instances to segregate OLTP from analytics
- D
Use an Exadata Base Database for both OLTP and analytics to reduce operational overhead
Show answer and explanation
Correct answers: B, C
Explanation
In Oracle Cloud Infrastructure, Autonomous Databases (ATP and ADW) provide automatic scaling, patching, and optimization, reducing administrative overhead. For OLTP workloads with occasional analytics and reporting needs, ATP alone can be sufficient (Option 2). However, if analytics are very intensive or data volumes are large, separating the two into ATP and ADW (Option 3) often yields better performance and resource isolation. Refer to Oracle� documentation on Autonomous Database configurations for details on best practices for mixed workloads and data warehousing deployments.
- A. Incorrect.
Option 1: This is generally not recommended for high-volume OLTP mixed with analytics if you want minimal operational overhead and the ability to auto-scale. A single Base Database on a VM DB System requires more manual administration and may not scale as easily as autonomous services.
- B. Correct.
Option 2 (Correct): Autonomous Transaction Processing supports both transactional workloads and analytical queries through features like Oracle Database In-Memory, making it a valid choice for consolidated workloads with minimal manual maintenance. It also scales automatically based on demand.
- C. Correct.
Option 3 (Correct): Separating OLTP and analytics into ATP (for transaction processing) and ADW (for data warehousing and analytics) is a common best practice for high-performance scenarios. This approach allows each database to scale independently and optimize its configuration for the specific workload type.
- D. Incorrect.
Option 4: Exadata cloud services are powerful, but they do not provide the same level of autonomous operational overhead reduction as ATP or ADW. While Exadata can handle both OLTP and analytics very effectively, more manual management is generally required compared to autonomous services.