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

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

Exam AWS Certified Solutions Architect - Associate SAA-C02 topic 1 question 21 discussion

Exam question from Amazon's AWS Certified Solutions Architect - Associate SAA-C02

Question #: 21
Topic #: 1

[All AWS Certified Solutions Architect - Associate SAA-C02 Questions]

A company's web application uses an Amazon RDS PostgreSQL DB instance to store its application data. During the financial closing period at the start of every month, Accountants run large queries that impact the database's performance due to high usage. The company wants to minimize the impact that the reporting activity has on the web application.
What should a solutions architect do to reduce the impact on the database with the LEAST amount of effort?

A. Create a read replica and direct reporting traffic to the replica.
B. Create a Multi-AZ database and direct reporting traffic to the standby.
C. Create a cross-Region read replica and direct reporting traffic to the replica.
D. Create an Amazon Redshift database and direct reporting traffic to the Amazon Redshift database.

Show Suggested Answer

Suggested Answer: A 🗳️

by Kossa at June 2, 2020, 11:17 p.m.

Disclaimers:

- ExamTopics website is not related to, affiliated with, endorsed or authorized by Amazon.
- Trademarks, certification & product names are used for reference only and belong to Amazon.

Comments

Submit Cancel

Kossa

Highly Voted 3 years, 9 months ago

Ans is A

upvoted 64 times

aguy9

3 years, 8 months ago

Yes answer is A

upvoted 4 times

...

nemisis95

Highly Voted 3 years, 9 months ago

A https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_ReadRepl.html Amazon RDS uses the MariaDB, MySQL, Oracle, PostgreSQL, and Microsoft SQL Server DB engines' built-in replication functionality to create a special type of DB instance called a read replica from a source DB instance. Updates made to the source DB instance are asynchronously copied to the read replica. You can reduce the load on your source DB instance by routing read queries from your applications to the read replica.

upvoted 22 times

...

48cd959

Most Recent 1 year, 3 months ago

Selected Answer: A

Answer -A Clue - Only performance is desired, fault tolerance is not asked. So A should be correct. Standby RDS DB can't be used for querying the data, so adding read replicas are the only answer.

upvoted 1 times

...

apchandana

2 years, 3 months ago

one should say why C is not correct. 1. minimum effort as multi region replica is complex. 2.it does not talk about HA. so Multi-AZ or multi-region is out

upvoted 1 times

...

BATSIE

2 years, 4 months ago

ANSWER A, A solutions architect can reduce the impact of the reporting activity on the database with the least amount of effort by using Amazon RDS read replicas. This will allow the company to offload read-intensive activity from the primary RDS instance to one or more read replicas. The read replicas can be used to run the large queries during the financial closing period, freeing up the primary instance to support the web application's write-intensive activity.

upvoted 1 times

...

Sachin032

2 years, 5 months ago

Selected Answer: A

As such no requirement for cross region access, then A is perfect

upvoted 1 times

...

queen101

2 years, 11 months ago

AAAAAAAAAAAAAA

upvoted 1 times

...

3 years, 7 months ago

Option "A" is best for this scenario. Explanation: An RDS read replica instance is an asynchronous read-only replica of a primary ("master") database instance located upstream. It can be used by your application for any query that does not require changing data, relieving the master of the load.

upvoted 1 times

...