Oracle Cloud Infrastructure 2019 Architect Associate — Question 40

As a database architect you are tasked with configuring a high concurrency, production OLTP application to connect to an Autonomous Transaction Processing database with a requirement to have some reporting queries run in parallel mode.
Which connection service is appropriate for such a workload?

Answer options

• A. HIGH
• B. TP
• C. MEDIUM
• D. TPURGENT

Correct answer: D

Explanation

The correct answer is D, TPURGENT, as it is designed for workloads that require immediate processing of transactions and allows reporting queries to run in parallel efficiently. The other options, such as HIGH, TP, and MEDIUM, do not specifically cater to the need for urgent transaction processing and parallel query execution in high concurrency environments.