Oracle Cloud Infrastructure 2023 Architect Associate — Question 12

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 nonpeak hours. The architecture team is debating whether such reports should be run on the online transaction processing (OLTP) database or in a separate data mart. The DBA Manager does not want to add anymore admin responsibility to the team and 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?

Answer options

• A. It is best to build a separate data warehouse, and move the OLTP data on a nightly basis.
• B. Use Autonomous Transaction Processing (ATP) with "tpurgent" and "high" TNS services to separate connection types.
• C. Use Autonomous Data Warehouse (ADW) because operational reporting is a higher priority this scenario.
• D. The application should be deployed on a Kubernetes Cluster because it needs to be highly available.

Correct answer: B

Explanation

Option B is correct because Autonomous Transaction Processing (ATP) can handle both transaction processing and operational reporting efficiently, especially with the specified TNS services for performance. Option A is incorrect as moving OLTP data to a separate warehouse may increase maintenance and complexity. Option C, while suggesting ADW, does not address the need for low maintenance in the same way that ATP does. Option D is irrelevant to the database service requirement and focuses instead on application deployment.