Oracle Cloud Infrastructure 2023 Architect Associate — Question 17

A customer wants to increase the throughput of their inserts. They have discovered that the bottleneck in the storage I/Os of their environment.
What should they do to remove this bottleneck?

Answer options

• A. Run the DBMS_CLOUD.INCREASE_THROUGHPUT procedure.
• B. Ask Support to migrate their setup to a node without noisy neighbors.
• C. Increase the number of OCPUs allocated to the database.
• D. Remove any non-JSON data from the database.

Correct answer: C

Explanation

Increasing the number of OCPUs allocated to the database allows for more parallel processing, which can significantly improve throughput for insert operations. The other options, while potentially helpful in specific scenarios, do not directly address the I/O bottleneck as effectively as increasing OCPU allocation.