Oracle Cloud Infrastructure 2023 Architect Associate — Question 30

As a database architect, you are tasked with configuring a high concurrency, production OLTP (online transaction processing) 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. TP
• B. MEDIUM
• C. HIGH
• D. TPURGENT

Correct answer: C

Explanation

The correct answer is C, as the HIGH connection service is designed to support high concurrency workloads, making it ideal for OLTP applications that also need to run reporting queries in parallel. Options A (TP), B (MEDIUM), and D (TPURGENT) do not provide the same level of concurrency support required for this scenario.