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

Exam question from Amazon's AWS Certified Database - Specialty

Question #: 145
Topic #: 1

[All AWS Certified Database - Specialty Questions]

A ride-hailing application uses an Amazon RDS for MySQL DB instance as persistent storage for bookings. This application is very popular and the company expects a tenfold increase in the user base in next few months. The application experiences more traffic during the morning and evening hours.
This application has two parts:
✑ An in-house booking component that accepts online bookings that directly correspond to simultaneous requests from users.
✑ A third-party customer relationship management (CRM) component used by customer care representatives. The CRM uses queries to access booking data.
A database specialist needs to design a cost-effective database solution to handle this workload.
Which solution meets these requirements?

A. Use Amazon ElastiCache for Redis to accept the bookings. Associate an AWS Lambda function to capture changes and push the booking data to the RDS for MySQL DB instance used by the CRM.
B. Use Amazon DynamoDB to accept the bookings. Enable DynamoDB Streams and associate an AWS Lambda function to capture changes and push the booking data to an Amazon SQS queue. This triggers another Lambda function that pulls data from Amazon SQS and writes it to the RDS for MySQL DB instance used by the CRM.
C. Use Amazon ElastiCache for Redis to accept the bookings. Associate an AWS Lambda function to capture changes and push the booking data to an Amazon Redshift database used by the CRM.
D. Use Amazon DynamoDB to accept the bookings. Enable DynamoDB Streams and associate an AWS Lambda function to capture changes and push the booking data to Amazon Athena, which is used by the CRM.

Show Suggested Answer

Suggested Answer: B 🗳️

by novak18 at April 2, 2021, 7:29 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

Aesthet

Highly Voted 3 years, 10 months ago

In A "AWS Lambda function to capture changes" capture changes to what? ElastiCache? The main use of ElastiCache is to cache frequently read data. Also "the company expects a tenfold increase in the user base" and "correspond to simultaneous requests from users" suggest DynamoDB imo. Since we already have MySQL RDS I prefer answer B

upvoted 11 times

learnazureportal

3 years, 10 months ago

Actually, It is D. based on the increasing the overall, we cannot go for B.

upvoted 4 times

ChauPhan

3 years, 10 months ago

Amazon Athena is an interactive query service that makes it easy to analyze data directly in Amazon Simple Storage Service (Amazon S3) using standard SQL. It is DB query service serverless for data stored on S3. It is itself not a DB storage

upvoted 4 times

cnmc

2 years, 2 months ago

Athena can read from DynamoDB... This kind of answers show that you guys are only studying for the cert without any actual experience. Setting up a whole new RDS clusters just so some CRM can read from it will cost your company thousands of dollars per month.

upvoted 1 times

JasonZhu

1 year, 10 months ago

Athena is more cost-effective than RDS. I prefer D.

upvoted 1 times

...

Load full discussion...

...

manan728

Highly Voted 3 years, 10 months ago

This question wasn't asked but in summary a lot of questions exactly from this 145 set questions were asked. I passed with a score of 794. Bunch of new questions on Aurora upgrades and maintenance windows, MS SQL server and Oracle migrations. All the best 👍

upvoted 7 times

user0001

3 years, 5 months ago

you are trying to mention score to give gradability to your answer, you only get pass or fail but not the score

upvoted 1 times

...

guru_ji

3 years, 9 months ago

I gave exam today. Only 60% questions came in actual exam from this 145 set.

upvoted 2 times

palanikumar_n

3 years, 9 months ago

Do you have the 145 questions.I could see only 112 question in the site

upvoted 1 times

...

aviathor

Most Recent 2 years, 2 months ago

Selected Answer: B

Although I do not understant why one should use one Lambda function to read from the DunamoDB stream, write to an SQS queue and then another Lambda to read from SQS and write to RDS... B is what makes most sense. But I would have considered using only one Lambda function and no SQS.

upvoted 1 times

...

manig

2 years, 3 months ago

I go with Answer D. For booking we need a persistent DB which is a dynamoDB but querying the data through Athena is more cost effective way.

upvoted 1 times

...

lollyj

2 years, 8 months ago

Selected Answer: B

Chose this option because this architecture definitely needs a SQS component being that it's a ride hailing application. Only makes sense

upvoted 1 times

...

novice_expert

3 years, 3 months ago

Selected Answer: B

no use of Elasticache + Redis ( A, C) Athena is not DB (D)

upvoted 1 times

...

Dantas

3 years, 5 months ago

Selected Answer: B

- Redis is an in-memory data store, therefore not suitable for bookings persistence. A and C are incorrect. - Athena is an interactive query service, not a database. D is incorrect.

upvoted 4 times

...

user0001

3 years, 5 months ago

B is the answer , we need the data in mysql

upvoted 1 times

...

tugboat

3 years, 5 months ago

Selected Answer: B

CRM needs data in MySQL

upvoted 2 times

...

user0001

3 years, 6 months ago

i go with B you need to save data to MySQL A is not persistence

upvoted 2 times

...

scottkerker

3 years, 8 months ago

ElastiCache, either MemcaheD or Redis, is used for data frequently read. And Amazon Athena is for querying data stored in Amazon S3. Considering all the features provided by the services, Option B is the best option.

upvoted 1 times

...