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

Exam question from Amazon's AWS Certified Database - Specialty

Question #: 161
Topic #: 1

[All AWS Certified Database - Specialty Questions]

A company that analyzes the stock market has two offices: one in the us-east-1 Region and another in the eu-west-2 Region. The company wants to implement an AWS database solution that can provide fast and accurate updates.
The office in eu-west-2 has dashboards with complex analytical queries to display the data. The company will use these dashboards to make buying decisions, so the dashboards must have access to the application data in less than 1 second.
Which solution meets these requirements and provides the MOST up-to-date dashboard?

A. Deploy an Amazon RDS DB instance in us-east-1 with a read replica instance in eu-west-2. Create an Amazon ElastiCache cluster in eu-west-2 to cache data from the read replica to generate the dashboards.
B. Use an Amazon DynamoDB global table in us-east-1 with replication into eu-west-2. Use multi-active replication to ensure that updates are quickly propagated to eu-west-2.
C. Use an Amazon Aurora global database. Deploy the primary DB cluster in us-east-1. Deploy the secondary DB cluster in eu-west-2. Configure the dashboard application to read from the secondary cluster.
D. Deploy an Amazon RDS for MySQL DB instance in us-east-1 with a read replica instance in eu-west-2. Configure the dashboard application to read from the read replica.

Show Suggested Answer

Suggested Answer: C 🗳️

by johnconnor at Nov. 18, 2021, 2:02 a.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

2025flakyt

Highly Voted 3 years, 6 months ago

C is correct Amazon Aurora global databases span multiple AWS Regions, enabling low latency global reads and providing fast recovery from the rare outage that might affect an entire AWS Region. An Aurora global database has a primary DB cluster in one Region, and up to five secondary DB clusters in different Regions. https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/aurora-global-database.html

upvoted 6 times

...

guau

Most Recent 2 years, 4 months ago

Selected Answer: C

Answer is C: Advanced analytics = RDS Fastest = Aurora Global tables

upvoted 3 times

...

lollyj

2 years, 6 months ago

Selected Answer: C

logical choice

upvoted 1 times

...

khun

2 years, 6 months ago

Aurora global DB it is. Letter C.

upvoted 1 times

...

novice_expert

3 years, 1 month ago

Selected Answer: C

advanced analytical queries => RDS < 1 sec => Aurora Global Use an Amazon Aurora global database. Deploy the primary DB cluster in us-east-1. Deploy the secondary DB cluster in eu-west-2. Configure the dashboard application to read from the secondary cluster.

upvoted 1 times

...

Shinytopology

3 years, 5 months ago

Answer is C. Amazon Aurora Global Database is designed for globally distributed applications, allowing a single Amazon Aurora database to span multiple AWS regions. Global Database uses storage-based replication with typical latency of less than 1 second, using dedicated infrastructure that leaves your database fully available to serve application workloads. https://aws.amazon.com/rds/aurora/global-database/

upvoted 1 times

Shinytopology

3 years, 5 months ago

A is wrong. Read Replica can only be deployed in the same region. ElasticCache only cache data for app, but not ensure replication speed between primary node and replica. B. Multi-active replication data in all Regions is eventually consistent. This means replica data in other region may not be up to date. C is correct. Use an Amazon Aurora global database for replication cross region under 1 second. D. Same as A

upvoted 4 times

rlnd2000

3 years ago

Great explanation, I asked myself why not B and you are right, "eventually consistent" Thanks. Now is clear.

upvoted 1 times

Mintwater

2 years, 2 months ago

Agree. I thought, why not choose B?

upvoted 1 times

ArturoZapatero

1 year, 7 months ago

Complex analytical queries as well

upvoted 1 times

...

Mintwater

2 years, 2 months ago

Since Nov 16, 2022. AWS support across region replicas. I understand that we didn't choose A because of the performance, and RTO could not reach the requirement. https://aws.amazon.com/about-aws/whats-new/2022/11/amazon-rds-sql-server-cross-region-read-replica/#:~:text=Amazon%20Relational%20Database%20Service%20(Amazon,a%20new%20standalone%20production%20database.

upvoted 1 times

...

jove

3 years, 6 months ago

Selected Answer: C

Aurora global db is the right option

upvoted 2 times

...

Sp230

3 years, 7 months ago

C - i will go with aurora global database as replication needs to be less than a second

upvoted 2 times

...

johnconnor

3 years, 7 months ago

Does anyone have some insight on why this choice? I am not totally sold on it

upvoted 1 times

grekh001

3 years, 6 months ago

"advanced analytical queries" rules out DynamoDB. To decide between Aurora Global Database and RDS with Read Replcia in another Region see this FAQ https://aws.amazon.com/rds/aurora/faqs/#High_Availability_and_Replication "Physical replication, called Amazon Aurora Global Database, uses dedicated infrastructure that leaves your databases entirely available to serve your application, and can replicate up to five secondary regions with typical latency of under a second." RDS cross-Region replication lag can be several seconds to several minutes depending on workload on the source. https://aws.amazon.com/blogs/database/best-practices-for-amazon-rds-for-postgresql-cross-region-read-replicas/

upvoted 5 times

...