Oracle Cloud Infrastructure 2020 Architect Associate — Question 45

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.)

Answer options

• A. Since the application needs to be highly available, it should to be deployed on a Kubernetes Cluster.
• B. ATP. Using 'tpurgent' and 'high' TNS services to separate connection types.
• C. It is best to build a Separate data warehouse, and move the OLTP data on a nightly basis.
• D. ADW since operational reporting is a higher priority in this scenario.

Correct answer: B

Explanation

The correct answer is B, as ATP (Autonomous Transaction Processing) is designed to handle high-performance transactional workloads with minimal maintenance. Options A and C suggest alternatives that either do not align with the low-maintenance requirement or involve more complexity, while D focuses on ADW, which is better suited for data warehousing rather than the immediate transactional needs of the application.