ExamTopics Logo
Mail Us[email protected]
Menu
Amazon Discussions
exam questions

Exam AWS Certified Database - Specialty All Questions

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

Exam AWS Certified Database - Specialty topic 1 question 45 discussion

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

An ecommerce company has tasked a Database Specialist with creating a reporting dashboard that visualizes critical business metrics that will be pulled from the core production database running on Amazon Aurora. Data that is read by the dashboard should be available within 100 milliseconds of an update.
The Database Specialist needs to review the current configuration of the Aurora DB cluster and develop a cost-effective solution. The solution needs to accommodate the unpredictable read workload from the reporting dashboard without any impact on the write availability and performance of the DB cluster.
Which solution meets these requirements?

  • A. Turn on the serverless option in the DB cluster so it can automatically scale based on demand.
  • B. Provision a clone of the existing DB cluster for the new Application team.
  • C. Create a separate DB cluster for the new workload, refresh from the source DB cluster, and set up ongoing replication using AWS DMS change data capture (CDC).
  • D. Add an automatic scaling policy to the DB cluster to add Aurora Replicas to the cluster based on CPU consumption.
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️
by BillyMadison at July 21, 2020, 10:40 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

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
Submit Cancel
novice_expert
Highly Voted 2 years, 12 months ago
Selected Answer: D
https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/Aurora.Replication.html replica lag < 100 ms Option A would take time
upvoted 7 times
...
Pranava_GCP
Most Recent 1 year, 7 months ago
Selected Answer: D
D. Add an automatic scaling policy to the DB cluster to add Aurora Replicas to the cluster based on CPU consumption. https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/Aurora.Replication.html
upvoted 3 times
...
manig
1 year, 10 months ago
agree it's D...there is no 'serverless turn on ' option exist For example, take a scaling policy that uses the predefined average CPU utilization metric. Such a policy can keep CPU utilization at, or close to, a specified percentage of utilization, such as 40 percent.
upvoted 3 times
...
IBANGA007
2 years, 4 months ago
Selected Answer: C
C. Create a separate DB cluster for the new workload, refresh from the source DB cluster, and set up ongoing replication using AWS DMS change data capture (CDC).
upvoted 1 times
...
lollyj
2 years, 4 months ago
Selected Answer: D
Even though replication is asynchronous I believe it is within the 100 ms requirement. It is also cost effective with autoscaling.
upvoted 1 times
...
KaranGandhi30
2 years, 11 months ago
Selected Answer: D
Option A? How can you use serverless and scale in the same statement
upvoted 1 times
...
VPup
3 years, 2 months ago
Answer D https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/Aurora.Replication.html "As a result, all Aurora Replicas return the same data for query results with minimal replica lag. This lag is usually much less than 100 milliseconds after the primary instance has written an update. "
upvoted 3 times
...
Dip11
3 years, 5 months ago
Option D makes most sense.
upvoted 2 times
...
LMax
3 years, 5 months ago
Answer D
upvoted 4 times
...
myutran
3 years, 6 months ago
Ans: D
upvoted 3 times
...
Robbb
3 years, 6 months ago
A is a ridiculous answer. If you say A, don't bother taking the test.
upvoted 3 times
GeeBeeEl
3 years, 6 months ago
Oh, I love this your response...... Option A seems to make the most sense to me and I will take the test Here is a link to help with the correct response -- https://aws.amazon.com/rds/aurora/faqs/ Amazon Aurora Serverless is an on-demand, autoscaling configuration for the MySQL-compatible and PostgreSQL-compatible editions of Amazon Aurora. An Aurora Serverless DB cluster automatically starts up, shuts down, and scales capacity up or down based on your application's needs. Aurora Serverless provides a relatively simple, cost-effective option for infrequent, intermittent, or unpredictable workloads. The question is focused on unpredictable workloads
upvoted 4 times
RotterDam
3 years, 1 month ago
The answer is saying "Turn on Serverless option on the cluster". There's no such thing.
upvoted 1 times
...
[Removed]
3 years, 5 months ago
you can't turn on serverless option.you need to take a snapshot and restore it to Aurora Serverless. A is definitely wrong
upvoted 5 times
...
...
...
Robbb
3 years, 6 months ago
Also it says that the new workload is unpredictable, and yet should have no impact on the current operations. It takes time to adjust to unpredictable workloads, so D does not solve the stated problem.
upvoted 1 times
toppic26
3 years, 5 months ago
it says read workload, not write.
upvoted 1 times
...
...
Robbb
3 years, 6 months ago
B is the best choice. A cloned Cluster will use the existing DB cluster until those items are written over, so that will have the fastest, immediate response. The best solution, of course, is to dedicate a read replica to the team and use an instance endpoint. D does not directly address the issue.
upvoted 1 times
Dip11
3 years, 5 months ago
Clone is a one time copy, it does not continuously replicate which is a requirement here.
upvoted 3 times
...
...
Glendon
3 years, 6 months ago
Why can't B be an option? Create a clone of the Aurora cluster and use the clone for data read on the Dashboard?
upvoted 1 times
AM
3 years, 6 months ago
B is not an option since clone does not support read scaling of the same cluster. This question is on read scaling of Aurora cluster. Only achieved with Read replicas. Serverless as pointed out is not available as an option. Correct an D.
upvoted 1 times
...
...
Faz
3 years, 6 months ago
Ans is D. https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/Aurora.Integrating.AutoScaling.html#:~:text=The%20scaling%20policy%20defines%20the,CloudWatch%20metrics%20and%20target%20values.
upvoted 2 times
...
JobinAkaJoe
3 years, 6 months ago
D is the best choice
upvoted 2 times
...
kilkar
3 years, 6 months ago
Ashoks is right. There is no turn on option to Serverless, it needs migration
upvoted 3 times
...
Load full discussion...
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
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago