Oracle Cloud Infrastructure 2023 Architect Associate — Question 14

Which statement is true when the Autonomous Database has auto scaling enabled?

Answer options

• A. It scales the PGA and SGA size when needed for the workload.
• B. Database concurrency is scaled up when needed by the workload.
• C. It enables the database to use up to 3x OCPU/IO resources immediately when needed by the workload.
• D. It increases the number of sessions available to the database.

Correct answer: C

Explanation

The correct answer is C because enabling auto scaling allows the Autonomous Database to rapidly utilize additional OCPU and IO resources, up to three times, to accommodate workload demands. The other options, while related to database performance, do not accurately describe the specific behavior of auto scaling in this context.