exam questions

Exam AWS Certified Solutions Architect - Associate SAA-C03 All Questions

View all questions & answers for the AWS Certified Solutions Architect - Associate SAA-C03 exam

Exam AWS Certified Solutions Architect - Associate SAA-C03 topic 1 question 276 discussion

A company has a multi-tier application deployed on several Amazon EC2 instances in an Auto Scaling group. An Amazon RDS for Oracle instance is the application’ s data layer that uses Oracle-specific PL/SQL functions. Traffic to the application has been steadily increasing. This is causing the EC2 instances to become overloaded and the RDS instance to run out of storage. The Auto Scaling group does not have any scaling metrics and defines the minimum healthy instance count only. The company predicts that traffic will continue to increase at a steady but unpredictable rate before leveling off.

What should a solutions architect do to ensure the system can automatically scale for the increased traffic? (Choose two.)

  • A. Configure storage Auto Scaling on the RDS for Oracle instance.
  • B. Migrate the database to Amazon Aurora to use Auto Scaling storage.
  • C. Configure an alarm on the RDS for Oracle instance for low free storage space.
  • D. Configure the Auto Scaling group to use the average CPU as the scaling metric.
  • E. Configure the Auto Scaling group to use the average free memory as the scaling metric.
Show Suggested Answer Hide Answer
Suggested Answer: AD 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
klayytech
Highly Voted 1 year, 8 months ago
Selected Answer: AD
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.
upvoted 28 times
MoshiurGCP
10 months ago
Nicely Explained.
upvoted 3 times
...
...
BombArat
Most Recent 5 months, 3 weeks ago
Selected Answer: AE
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
upvoted 1 times
...
Uzbekistan
9 months ago
Selected Answer: AC
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.
upvoted 3 times
...
pentium75
12 months ago
Selected Answer: AD
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
upvoted 2 times
...
meowruki
1 year ago
Selected Answer: AD
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.
upvoted 2 times
meowruki
1 year ago
Option B (Migrate the database to Amazon Aurora): While Amazon Aurora provides benefits such as auto-scaling storage and high performance, it involves migrating from Oracle to Aurora, which might require application changes and data migration efforts. Option C (Configure an alarm on the RDS for Oracle instance for low free storage space): While it's good to have an alarm for low storage space, configuring storage Auto Scaling (Option A) is a more proactive solution that automatically adjusts storage before reaching a critical point. Option E (Configure the Auto Scaling group to use the average free memory as the scaling metric): While monitoring memory is important for application performance, CPU utilization is often a more direct and responsive metric for auto-scaling in many scenarios.
upvoted 3 times
JA2018
1 month ago
STEM mentioned the application "uses Oracle-specific PL/SQL functions"
upvoted 1 times
...
...
...
TariqKipkemei
1 year, 2 months ago
Selected Answer: AD
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.
upvoted 2 times
...
vijaykamal
1 year, 2 months ago
Selected Answer: AD
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.
upvoted 2 times
JA2018
1 month ago
the application "uses Oracle-specific PL/SQL functions" Rules out Option B in my mind
upvoted 1 times
...
...
Guru4Cloud
1 year, 3 months ago
Selected Answer: AD
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.
upvoted 2 times
...
A1975
1 year, 4 months ago
Selected Answer: AD
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.
upvoted 2 times
...
kruasan
1 year, 7 months ago
Selected Answer: AD
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.
upvoted 3 times
...
kraken21
1 year, 8 months ago
Selected Answer: AD
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
upvoted 3 times
...
Nel8
1 year, 9 months ago
Selected Answer: BD
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.
upvoted 3 times
FourOfAKind
1 year, 9 months ago
In this question, you have Oracle DB, and Amazon Aurora is for MySQL/PostgreSQL. A and D are the correct choices.
upvoted 5 times
[Removed]
1 year, 9 months ago
You can migrate Oracle PL/SQL to Aurora: https://docs.aws.amazon.com/dms/latest/oracle-to-aurora-mysql-migration-playbook/chap-oracle-aurora-mysql.sql.html
upvoted 1 times
pentium75
12 months ago
But the application "uses Oracle-specific PL/SQL functions".
upvoted 2 times
...
[Removed]
1 year, 9 months ago
I still think A is the answer, because RDS for Oracle auto scaling once enabled it will automatically adjust the storage capacity.
upvoted 2 times
...
...
...
...
Ja13
1 year, 10 months ago
Selected Answer: AD
a and d
upvoted 4 times
...
KZM
1 year, 10 months ago
A and D.
upvoted 4 times
...
GwonLEE
1 year, 10 months ago
Selected Answer: AD
a and d
upvoted 4 times
...
LuckyAro
1 year, 10 months ago
Selected Answer: AD
A and D
upvoted 3 times
...
Joan111edu
1 year, 10 months ago
Selected Answer: AD
https://www.examtopics.com/discussions/amazon/view/46534-exam-aws-certified-solutions-architect-associate-saa-c02/
upvoted 2 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago