1Z0-997-25 Question 82
Single answerYour finance department plans to adopt a new database on Oracle Cloud Infrastructure to handle high-volume daily transaction processing and occasional complex analytical queries. They want a fully managed solution with minimal administrative overhead, automated patching, elastic scaling, and integrated machine learning capabilities. Which Oracle Cloud Infrastructure database service would best address these requirements?
- A
Autonomous Transaction Processing (ATP)
- B
Autonomous Data Warehouse (ADW)
- C
Base Database on a VM DB System
- D
Base Database on Exadata Cloud Service
Show answer and explanation
Correct answer: A
Explanation
Autonomous Transaction Processing (ATP) is designed for mixed workloads that include both transaction processing and some analytical capabilities. It offloads routine database maintenance tasks like patching and tuning, offers on-demand scaling, and includes built-in machine learning for better workload optimization. This makes ATP the best fit for the department� goal of a low-maintenance, high-performance, and scalable environment. Refer to Oracle Cloud Infrastructure documentation on Autonomous Database for deployment best practices and details on converged workloads.
- A. Correct.
Correct. Autonomous Transaction Processing (ATP) provides a fully managed environment with automated patching, automatic scaling, built-in machine learning features, and support for both transactional and some analytical workloads. It requires minimal administrative overhead, fitting the department� need for a hands-free operational model.
- B. Incorrect.
Incorrect. Autonomous Data Warehouse (ADW) is optimized for analytics rather than high-volume transactional workloads. While it� also fully managed, it� primarily designed for data warehousing activities, not frequent transactional operations.
- C. Incorrect.
Incorrect. A Base Database on a VM DB System allows more control over administrative tasks but does not offer the same level of automation, integrated scale-up/scale-down, or built-in machine learning features as ATP. It also requires more hands-on management for tasks like patching and tuning.
- D. Incorrect.
Incorrect. Running a Base Database on Exadata Cloud Service provides high performance and scalability but still demands more DBA expertise for patching and administrative tasks compared to an autonomous service. It is more suitable when there are stringent performance or customization requirements that surpass what ATP can deliver, and the organization is prepared to manage the additional configuration overhead.