A) Configure storage Auto Scaling on the RDS for Oracle instance. = Makes sense. With RDS Storage Auto Scaling, you simply set your desired maximum storage limit, and Auto Scaling takes care of the rest. B) Migrate the database to Amazon Aurora to use Auto Scaling storage. = Scenario specifies application's data layer uses Oracle-specific PL/SQL functions. This rules out migration to Aurora. C) Configure an alarm on the RDS for Oracle instance for low free storage space. = You could do this but what does it fix? Nothing. The CW notification isn't going to trigger anything. D) Configure the Auto Scaling group to use the average CPU as the scaling metric. = Makes sense. The CPU utilization is the precursor to the storage outage. When the ec2 instances are overloaded, the RDS instance storage hits its limits, too.

B mean db migration and only oracle specfic commands are allowed C is just notification not High avalibilty Now the toss up is between D and E since D is measuring CPU % and E is measuring memory and the question states "This is causing the EC2 instances to become overloaded and the RDS instance to run out of storage" i will err on the side of option E

To ensure the system can automatically scale for the increased traffic, you can take the following steps: A. Configure storage Auto Scaling on the RDS for Oracle instance. By enabling storage Auto Scaling on the RDS instance, you ensure that additional storage is provisioned automatically when the existing storage reaches capacity. This helps prevent the RDS instance from running out of storage due to increased traffic and data growth. C. Configure an alarm on the RDS for Oracle instance for low free storage space. Setting up an alarm for low free storage space on the RDS instance allows you to receive notifications when the storage capacity is approaching its limits. This proactive monitoring helps you take necessary actions, such as adding more storage or scaling resources, before it affects the application's performance.

B is not possible because the application "uses Oracle-specific PL/SQL functions" C does not meet the "automatically scale" requirement E would require an agent on the hosts which we might not have, plus CPU is a better indicator than memory

A. Configure storage Auto Scaling on the RDS for Oracle instance. This option allows the RDS instance to automatically scale its storage based on the actual storage usage, ensuring that you don't run out of storage. D. Configure the Auto Scaling group to use the average CPU as the scaling metric. By using CPU utilization as a scaling metric, the Auto Scaling group can dynamically adjust the number of EC2 instances based on the application's demand. This helps in handling increased traffic and preventing overload on existing instances.

Configure storage Auto Scaling on the RDS for Oracle instance and Configure the Auto Scaling group to use the average CPU as the scaling metric to accommodate the increased traffic automatically.

Option B (Migrate the database to Amazon Aurora) may be a good long-term solution, but it involves database migration, which can be complex and time-consuming. For immediate scalability and to address the storage issue, configuring storage Auto Scaling on the existing RDS instance is a more immediate and straightforward solution. Option C (Configure an alarm on the RDS for Oracle instance for low free storage space) is useful for monitoring, but it doesn't proactively address the storage issue by automatically expanding storage as needed. Option E (Configure the Auto Scaling group to use the average free memory as the scaling metric) is less common as a scaling metric for EC2 instances compared to CPU utilization. While memory can be an important factor for application performance, CPU utilization is typically a more commonly used metric for scaling decisions. It also doesn't directly address the RDS storage issue.

A. By enabling storage Auto Scaling on the RDS for Oracle instance, it will automatically add more storage when the existing storage is running out, ensuring the application's data layer can handle the increased data storage requirements. D. By configuring the Auto Scaling group to use the average CPU utilization as the scaling metric, it can automatically add more EC2 instances to the Auto Scaling group when the CPU utilization exceeds a certain threshold. This will help handle the increased traffic and workload on the EC2 instances in the multi-tier application.

A. By enabling storage Auto Scaling on the RDS for Oracle instance, it will automatically add more storage when the existing storage is running out, ensuring the application's data layer can handle the increased data storage requirements. D. By configuring the Auto Scaling group to use the average CPU utilization as the scaling metric, it can automatically add more EC2 instances to the Auto Scaling group when the CPU utilization exceeds a certain threshold. This will help handle the increased traffic and workload on the EC2 instances in the multi-tier application.

These options will allow the system to scale both the compute tier (EC2 instances) and the data tier (RDS storage) automatically as traffic increases: A. Storage Auto Scaling will allow the RDS for Oracle instance to automatically increase its allocated storage when free storage space gets low. This ensures the database does not run out of capacity and can continue serving data to the application. D. Configuring the EC2 Auto Scaling group to scale based on average CPU utilization will allow it to launch additional instances automatically as traffic causes higher CPU levels across the instances. This scales the compute tier to handle increased demand.

Auto scaling storage RDS will ease storage issues and migrating Oracle Pl/Sql to Aurora is cumbersome. Also Aurora has auto storage scaling by default. https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_PIOPS.StorageTypes.html#USER_PIOPS.Autoscaling

My answer is B & D... B. Migrate the database to Amazon Aurora to use Auto Scaling Storage. --- Aurora storage is also self-healing. Data blocks and disks are continuously scanned for errors and repaired automatically. D. Configurate the Auto Scaling group to sue the average CPU as the scaling metric. -- Good choice. I believe either A & C or B & D options will work.

a and d

A and D.

a and d

A and D

https://www.examtopics.com/discussions/amazon/view/46534-exam-aws-certified-solutions-architect-associate-saa-c02/