Examice

Exam 1z0-931-23 All QuestionsBrowse all questions from this exam

Question 3

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?

It is best to build a separate data warehouse, and move the OLTP data on a nightly basis.

Use Autonomous Transaction Processing (ATP) with "tpurgent" and "high" TNS services to separate connection types.

Use Autonomous Data Warehouse (ADW) because operational reporting is a higher priority this scenario.

The application should be deployed on a Kubernetes Cluster because it needs to be highly available.

Correct Answer: B

The Autonomous Transaction Processing (ATP) service on Oracle Cloud Infrastructure is optimized for transactional workloads and supports running complex queries and reports. It offers automated maintenance and tuning, making it a low-to-zero maintenance option, while also providing high performance. The use of 'tpurgent' and 'high' TNS services allows the separation of different connection types, which helps in meeting both transactional and reporting needs efficiently. This makes ATP the most appropriate choice for an application that requires low administrative effort and high performance for both OLTP and reporting tasks.

Discussion

piipoOption: B

Correct