1Z0-997-25 Question 83
Single answerYour organization is launching a new e-commerce platform on Oracle Cloud Infrastructure (OCI). The platform must handle unpredictable spikes in transactional workloads during peak shopping periods and also support advanced analytics against the same operational data in near-real time. Management wants to minimize administrative overhead, relying on automated patching and scaling. Which OCI database solution best meets these requirements?
- A
Provision an Autonomous Transaction Processing (ATP) database on Shared Infrastructure
- B
Provision an Autonomous Data Warehouse (ADW) database on Dedicated Infrastructure
- C
Deploy an Oracle Base Database on a Virtual Machine (VM) DB system
- D
Implement an Oracle Base Database on an Exadata Cloud Service using manual partitioning and indexing
Show answer and explanation
Correct answer: A
Explanation
For unpredictable, high-concurrency transactional workloads that also need real-time analytical queries with minimal administration, Autonomous Transaction Processing (ATP) on Shared Infrastructure is typically the best choice. It automatically handles patching, scaling, and tuning, allowing teams to focus on development instead of database maintenance. Refer to the Oracle documentation on Autonomous Database (docs.oracle.com/en-us/iaas/Content/Database/Concepts/adboverview.htm) for additional details on workload-optimized Autonomous Transaction Processing capabilities.
- A. Correct.
Correct. Autonomous Transaction Processing (ATP) on Shared Infrastructure offers automatic scaling, patching, and built-in analytics features for real-time reporting. It is designed for OLTP workloads with the ability to perform analytics on the same data, meeting the requirement for minimal administration and advanced analytics. It also handles bursty workloads effectively.
- B. Incorrect.
Incorrect. Autonomous Data Warehouse (ADW) on Dedicated Infrastructure focuses primarily on analytical and batch workloads. While it provides automated management, ADW is optimized for complex queries and less suited for high-concurrency, transactional processing compared to ATP. It could handle analytics, but not the mixed OLTP analytics most efficiently.
- C. Incorrect.
Incorrect. An Oracle Base Database VM DB system provides OS-level access and manual control over patching, backups, and scaling, which increases administrative overhead. It is a valid solution for certain custom configurations, but it does not deliver the automated features or effortless scaling required in this scenario.
- D. Incorrect.
Incorrect. An Oracle Base Database on Exadata Cloud Service is a powerful option, but it typically requires more manual administration, from deployment to partitioning and indexing, which contradicts the organization's goal to minimize overhead. While it can handle large-scale workloads, it is not as automated for patching and scaling as Autonomous Database solutions.