Oracle Cloud Infrastructure 2019 Architect Associate — Question 23

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?

Answer options

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

Correct answer: A

Explanation

The correct answer is A because a Kubernetes Cluster provides the high availability required for the application. Option B suggests using ADW, but it does not address the high availability requirement. Option C proposes a separate data warehouse, which adds complexity and maintenance. Option D mentions ATP, but it does not meet the high availability needs as effectively as a Kubernetes Cluster.