exam questions

Exam AWS Certified Database - Specialty All Questions

View all questions & answers for the AWS Certified Database - Specialty exam

Exam AWS Certified Database - Specialty topic 1 question 28 discussion

Exam question from Amazon's AWS Certified Database - Specialty
Question #: 28
Topic #: 1
[All AWS Certified Database - Specialty Questions]

A company with branch offices in Portland, New York, and Singapore has a three-tier web application that leverages a shared database. The database runs on
Amazon RDS for MySQL and is hosted in the us-west-2 Region. The application has a distributed front end deployed in the us-west-2, ap-southheast-1, and us- east-2 Regions.
This front end is used as a dashboard for Sales Managers in each branch office to see current sales statistics. There are complaints that the dashboard performs more slowly in the Singapore location than it does in Portland or New York. A solution is needed to provide consistent performance for all users in each location.
Which set of actions will meet these requirements?

  • A. Take a snapshot of the instance in the us-west-2 Region. Create a new instance from the snapshot in the ap-southeast-1 Region. Reconfigure the ap- southeast-1 front-end dashboard to access this instance.
  • B. Create an RDS read replica in the ap-southeast-1 Region from the primary RDS DB instance in the us-west-2 Region. Reconfigure the ap-southeast-1 front- end dashboard to access this instance.
  • C. Create a new RDS instance in the ap-southeast-1 Region. Use AWS DMS and change data capture (CDC) to update the new instance in the ap-southeast-1 Region. Reconfigure the ap-southeast-1 front-end dashboard to access this instance.
  • D. Create an RDS read replica in the us-west-2 Region where the primary instance resides. Create a read replica in the ap-southeast-1 Region from the read replica located on the us-west-2 Region. Reconfigure the ap-southeast-1 front-end dashboard to access this instance.
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️

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
BillyMadison
Highly Voted 3 years, 8 months ago
Leaning to B. https://aws.amazon.com/rds/features/read-replicas/ "Amazon RDS Read Replicas provide enhanced performance and durability for RDS database (DB) instances. They make it easy to elastically scale out beyond the capacity constraints of a single DB instance for read-heavy database workloads. You can create one or more replicas of a given source DB Instance and serve high-volume application read traffic from multiple copies of your data, thereby increasing aggregate read throughput. "
upvoted 20 times
khchan123
3 years ago
Agree it's B.
upvoted 1 times
...
...
[Removed]
Highly Voted 3 years, 8 months ago
If they go with A, how do they keep the databases in sync? B for me
upvoted 6 times
...
NishithShah
Most Recent 1 year, 6 months ago
Selected Answer: B
B is correct.
upvoted 1 times
...
Sathish_dbs
1 year, 8 months ago
apparently I need to now geography as well that Singapore is AP region
upvoted 1 times
jitesh_k
1 year, 6 months ago
They assume as much.
upvoted 1 times
...
...
Germaneli
1 year, 9 months ago
Selected Answer: B
From the plausible options, A - this would make it a non-shared database, destroying the architecture. B - iff the dashboard is only for reading then the read replica in SGP might do.
upvoted 1 times
...
ken_test1234
2 years, 2 months ago
Selected Answer: B
Because the read replica is designed for this purpose
upvoted 1 times
...
im_not_robot
2 years, 4 months ago
Selected Answer: B
A is incorrect in no data synchronization between 2 databases B is correct since the read replica is same region with the frontend C is incorrect because extra cost of DMS instance. Although it is feasible option. D is incorrect because of extra cost of new replica on primary region and replication lag.
upvoted 3 times
...
examineme
2 years, 6 months ago
Selected Answer: B
B is the answer
upvoted 1 times
...
sachin
2 years, 11 months ago
You can create read replication from a already existing replica, but the replication lag will be high. So D is operationally possible but replication lag will be high. So correct answer is B.
upvoted 1 times
...
ryuhei
2 years, 11 months ago
Selected Answer: B
Answer:B
upvoted 1 times
...
novice_expert
3 years, 1 month ago
Selected Answer: B
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_ReadRepl.XRgn.html You can create replicas through Region same way as in same region Create an RDS read replica in the ap-southeast-1 Region from the primary RDS DB instance in the us-west-2 Region. Reconfigure the ap-southeast-1 front- end dashboard to access this instance.
upvoted 1 times
...
AriraAWS
3 years, 4 months ago
Selected Answer: B
B is the right answer!!
upvoted 2 times
...
ChauPhan
3 years, 7 months ago
B is correct. You can create replicas through Region https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_ReadRepl.XRgn.html
upvoted 1 times
...
Dip11
3 years, 7 months ago
I will go with B
upvoted 1 times
...
LMax
3 years, 7 months ago
Would go with B
upvoted 2 times
...
myutran
3 years, 7 months ago
Ans: B
upvoted 1 times
...
Bassel
3 years, 7 months ago
Not sure why you all excluded C. It is definitely a good solution to keep two databases in sync using DMS with CDC.
upvoted 3 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 ...