A Corporation is building a web application to allow its customers to schedule service requests online.
There is also a need to run operational reports at times during non-peak hours.
The architecture team is debating whether such reports should be run on the OLTP database or in a separate data mart.
The DBA Manager does not want to add anymore admin responsibility to the team and is looking for a database option that's low to zero maintenance, but meets their strict performance requirements as well.
Which Oracle Cloud Infrastructure database service is appropriate for this scenario? (Choose the best answer.)
Click on the arrows to vote for the correct answer
A. B. C. D.B.
The best option for the Corporation's web application and operational reporting requirements would be to use Oracle Autonomous Data Warehouse (ADW) database service.
Option A is not appropriate for the scenario since Kubernetes Cluster is a container orchestration platform and not a database service. Although Kubernetes can be used to deploy and manage databases, it requires significant administration and management skills, which goes against the requirement of the DBA Manager for a low to zero maintenance option.
Option B refers to Oracle Autonomous Transaction Processing (ATP) database service, which is designed for OLTP workloads with high availability, security, and performance. However, ATP is optimized for transactional workloads and may not perform optimally for analytical or reporting workloads. Moreover, separating connection types with TNS services may not be an ideal solution for operational reporting.
Option C suggests building a separate data warehouse and moving the OLTP data on a nightly basis. This approach can work but requires a lot of manual effort to build and maintain ETL processes. It also adds complexity to the architecture, increases the risk of data inconsistency, and may not meet the strict performance requirements.
Option D, ADW, is designed specifically for analytical and reporting workloads, making it an ideal solution for operational reporting in this scenario. It is also a fully managed service, meaning that Oracle handles all the administration and maintenance tasks, allowing the DBA team to focus on application development. ADW is also optimized for performance, scalability, and security, making it a good fit for the Corporation's requirements.
In summary, the best option for the Corporation's web application and operational reporting requirements would be to use Oracle Autonomous Data Warehouse (ADW) database service, as it is optimized for analytical and reporting workloads, low maintenance, and provides high performance, scalability, and security.