An OCI Architect is working on a solution consisting of analysis of data from clinical trials of a pharmaceutical company. The data is being stored in OCI Autonomous Data Warehouse (ADW) having 8…

Question

Options

• AEnabling auto scaling does not change the concurrency and parallelism settings
• BAuto scaling also scales IO throughput linearly along with CPU
• CThe database memory SGA and PGA will not get affected by the changes in the number of CPUs during auto scaling
• DThe maximum CPU cores that will be automatically allocated for this database is 16 CPUs

• A
  84% (41)
• C
  6% (3)
• D
  10% (5)

Explanation

Explanation/Reference: Auto scaling is enabled by default when you create an Autonomous Database instance or you can use Scale Up/Down on the Oracle Cloud Infrastructure console to enable or disable auto scaling. With auto scaling enabled the database can use up to three times more CPU and IO resources than specified by the number of OCPUs currently shown in the Scale Up/Down dialog. When auto scaling is enabled, if your workload requires additional CPU and IO resources the database automatically uses the resources without any manual intervention required. Enabling auto scaling does not change the concurrency and parallelism settings for the predefined services IO throughput depends on the number of CPUs you provision and scales linearly with the number of CPUs.

No community discussion yet for this question.