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 13 discussion

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

Question #: 13
Topic #: 1

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

A company is migrating a three-tier application to AWS. The application requires a MySQL database. In the past, the application users reported poor application performance when creating new entries. These performance issues were caused by users generating different real-time reports from the application during working hours.
Which solution will improve the performance of the application when it is moved to AWS?

A. Import the data into an Amazon DynamoDB table with provisioned capacity. Refactor the application to use DynamoDB for reports.
B. Create the database on a compute optimized Amazon EC2 instance. Ensure compute resources exceed the on-premises database.
C. Create an Amazon Aurora MySQL Multi-AZ DB cluster with multiple read replicas. Configure the application to use the reader endpoint for reports.
D. Create an Amazon Aurora MySQL Multi-AZ DB cluster. Configure the application to use the backup instance of the cluster as an endpoint for the reports.

Show Suggested Answer

Suggested Answer: C 🗳️
Amazon RDS Read Replicas Now Support Multi-AZ Deployments
Starting today, Amazon RDS Read Replicas for MySQL and MariaDB now support Multi-AZ deployments. Combining Read Replicas with Multi-AZ enables you to build a resilient disaster recovery strategy and simplify your database engine upgrade process.
Amazon RDS Read Replicas enable you to create one or more read-only copies of your database instance within the same AWS Region or in a different AWS
Region. Updates made to the source database are then asynchronously copied to your Read Replicas. In addition to providing scalability for read-heavy workloads, Read Replicas can be promoted to become a standalone database instance when needed.
Amazon RDS Multi-AZ deployments provide enhanced availability for database instances within a single AWS Region. With Multi-AZ, your data is synchronously replicated to a standby in a different Availability Zone (AZ). In the event of an infrastructure failure, Amazon RDS performs an automatic failover to the standby, minimizing disruption to your applications.
You can now use Read Replicas with Multi-AZ as part of a disaster recovery (DR) strategy for your production databases. A well-designed and tested DR plan is critical for maintaining business continuity after a disaster. A Read Replica in a different region than the source database can be used as a standby database and promoted to become the new production database in case of a regional disruption.
You can also combine Read Replicas with Multi-AZ for your database engine upgrade process. You can create a Read Replica of your production database instance and upgrade it to a new database engine version. When the upgrade is complete, you can stop applications, promote the Read Replica to a standalone database instance, and switch over your applications. Since the database instance is already a Multi-AZ deployment, no additional steps are needed.
Overview of Amazon RDS Read Replicas
Deploying one or more read replicas for a given source DB instance might make sense in a variety of scenarios, including the following:
Scaling beyond the compute or I/O capacity of a single DB instance for read-heavy database workloads. You can direct this excess read traffic to one or more read replicas.
Serving read traffic while the source DB instance is unavailable. In some cases, your source DB instance might not be able to take I/O requests, for example due to I/O suspension for backups or scheduled maintenance. In these cases, you can direct read traffic to your read replicas. For this use case, keep in mind that the data on the read replica might be "stale" because the source DB instance is unavailable.
Business reporting or data warehousing scenarios where you might want business reporting queries to run against a read replica, rather than your primary, production DB instance.
Implementing disaster recovery. You can promote a read replica to a standalone instance as a disaster recovery solution if the source DB instance fails.
Reference:
https://aws.amazon.com/about-aws/whats-new/2018/01/amazon-rds-read-replicas-now-support-multi-az-deployments/ https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_ReadRepl.html

by malefin280 at June 1, 2020, 4:18 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 C

upvoted 62 times

greypig

3 years, 8 months ago

c is ok

upvoted 6 times

...

aguy9

3 years, 8 months ago

Yes C is correct

upvoted 4 times

...

dsegura980

Highly Voted 3 years, 9 months ago

Answer is C. Who verify the answers?!

upvoted 27 times

...

Fletch89

Most Recent 9 months, 2 weeks ago

If the problem is "creating" repors, I don't understand how can (read improvement) will help. Any ideas?

upvoted 1 times

...

48cd959

1 year, 3 months ago

Selected Answer: C

Answer - C, Clue - users were having issue in getting (reading) reports in working hours. Issue could be solved by having multiple Aurora read replicas.

upvoted 1 times

...

bikshu

2 years, 10 months ago

will go with C

upvoted 1 times

...

leebug

3 years, 2 months ago

Why not D? When deploying in Multi-AZ DB Cluster, two readable standby DB instances are created without any further configuration.

upvoted 1 times

botmania

2 years, 11 months ago

standby DB instances is for fault-tolerant cases. The question asks for optimisation.

upvoted 2 times

...

Rupak10

2 years, 4 months ago

We cannot do anything in the standby instance. That is for disaster recovery. The thing you are thinking is that is a clone of the aurora database where we can make changes apart from the Primay database .

upvoted 1 times

...

ArmenG

3 years, 2 months ago

C is ok

upvoted 1 times

...

zik87

3 years, 3 months ago

D is wrong because cluster endpoint provides failover support. Answer is C

upvoted 2 times

...

joe2211

3 years, 6 months ago

Selected Answer: C

vote C

upvoted 1 times

...

Siraf

3 years, 7 months ago

Answer is C: https://aws.amazon.com/about-aws/whats-new/2016/09/reader-end-point-for-amazon-aurora/

upvoted 2 times

...

Vibes

3 years, 7 months ago

C is fine

upvoted 2 times

...

woke

3 years, 7 months ago

C is Correct

upvoted 2 times

...

Cabrera

3 years, 7 months ago

C is correct

upvoted 2 times

...

Murlidhar

3 years, 8 months ago

Cluster Endpoint – The Cluster Endpoint connect your application to the current primary DB instance for that DB cluster. Your application can both read and write to this instance. Reader Endpoint – The Reader Endpoint load-balances connections across the pool of available Read Replicas. Offload read queries here, reducing load on your primary DB instance. Instance Endpoints – An Instance Endpoint connects to a specific instance in the cluster. Clients can have fine-grained control over query allocation, rather than having Amazon Aurora handle connection distribution. Hence I choose C

upvoted 14 times

...

Abdullah777

3 years, 8 months ago

I think C is correct. D incorrect as it mentioned "the backup instance of the cluster" the backup is deferent of the replica . replica can be called as reader or standby instance.

upvoted 2 times

...

vineeth1996

3 years, 8 months ago

C is correct

upvoted 1 times

...

KK_uniq

3 years, 8 months ago

C for sure

upvoted 1 times

...

Load full discussion...