Oracle Exam 1Z0-997 Topic 9 Question 1 Discussion

Actual exam question for Oracle's 1Z0-997 exam

Question #: 1
Topic #: 9

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 CPU Cores and 70 TB of storage. The architect is planning to setup autoscaling to respond to dynamic changes in the workload.

Which of the following needs to be considered while configuring auto scaling? Choose two

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

Show Suggested Answer

Suggested Answer: A, B

Explanation

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.

by Ruthann at May 07, 2022, 03:49 PM

Limited Time Offer

25%

Off

Get Premium 1Z0-997 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!