exam questions

Exam AWS Certified SysOps Administrator - Associate All Questions

View all questions & answers for the AWS Certified SysOps Administrator - Associate exam

Exam AWS Certified SysOps Administrator - Associate topic 1 question 472 discussion

A company is using an Amazon CloudWatch alarm to monitor the FreeLocalStorage metric for an Amazon Aurora PostgreSQL production database. The alarm goes into ALARM state and indicates that the database is running low on temporary storage. A SysOps administrator discovers that a weekly report is using most of the temporary storage that is currently allocated.

What should the SysOps administrator do to solve this problem?

  • A. Turn on Aurora PostgreSQL query plan management.
  • B. Modify the configuration of the DB cluster to turn on storage auto scaling.
  • C. Add an Aurora read replica to the DB cluster. Modify the report to use the new read replica.
  • D. Modify the DB instance class for each DB instance in the DB cluster to increase the instance size.
Show Suggested Answer Hide Answer
Suggested Answer: C 🗳️

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
dev_stape
2 weeks, 6 days ago
Selected Answer: B
B cause addresses storage issue. not C because a read replica does not have more local storage and results in the same issue.
upvoted 1 times
...
examaws
1 month ago
Selected Answer: B
This option directly addresses the low temporary storage issue by allowing the database to scale its storage automatically as required, ensuring that the database can handle the demands of the weekly report without running out of temporary storage.
upvoted 1 times
...
Grodgar
1 month, 2 weeks ago
Selected Answer: C
predicted, only "read" for report - C
upvoted 1 times
...
numark
1 month, 4 weeks ago
Selected Answer: B
Amazon Aurora supports storage auto-scaling. By enabling this feature, the SysOps administrator can ensure that the Aurora PostgreSQL production database automatically scales its storage, reducing the risk of running out of free local storage. This is particularly useful in cases where it's difficult to predict storage requirements in advance, such as fluctuating workloads.Adding an Aurora read replica would offload read traffic from the primary database and could potentially alleviate performance issues. However, since the question indicates that temporary storage space is the problem, and not necessarily the performance of read operations, this might not resolve the issue of running out of storage. Moreover, if the report generation involves a significant amount of data writing, a read replica will not help because write operations cannot be offloaded to read replicas.
upvoted 1 times
Grodgar
1 month, 2 weeks ago
you wrong. Correct is C. 1) This is a "report" - so only READ, no writing. 2) Auto-scaling is used for "unpredicted" cases, but we have predicted - "weekly".
upvoted 1 times
dev_stape
2 weeks, 6 days ago
If the pants are tight buying a new pair of the same size would not solve an issue...
upvoted 1 times
...
...
...
igor12ghsj577
2 months, 1 week ago
Selected Answer: B
I would say B.
upvoted 1 times
...
Aamee
3 months, 1 week ago
Selected Answer: C
C makes most sense compared to all others..
upvoted 1 times
...
kutesa1407
3 months, 3 weeks ago
Selected Answer: C
For A sec id like to think adding a read replica, would solve this.
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