exam questions

Exam AWS Certified Solutions Architect - Professional All Questions

View all questions & answers for the AWS Certified Solutions Architect - Professional exam

Exam AWS Certified Solutions Architect - Professional topic 1 question 83 discussion

You are running a successful multitier web application on AWS and your marketing department has asked you to add a reporting tier to the application. The reporting tier will aggregate and publish status reports every 30 minutes from user-generated information that is being stored in your web application s database.
You are currently running a Multi-AZ RDS MySQL instance for the database tier. You also have implemented Elasticache as a database caching layer between the application tier and database tier.
Please select the answer that will allow you to successfully implement the reporting tier with as little impact as possible to your database.

  • A. Continually send transaction logs from your master database to an S3 bucket and generate the reports off the S3 bucket using S3 byte range requests.
  • B. Generate the reports by querying the synchronously replicated standby RDS MySQL instance maintained through Multi-AZ.
  • C. Launch a RDS Read Replica connected to your Multi AZ master database and generate reports by querying the Read Replica.
  • D. Generate the reports by querying the ElastiCache database caching tier.
Show Suggested Answer Hide Answer
Suggested Answer: C 🗳️

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
cinopi
Highly Voted 3 years, 7 months ago
C is correct because Cache won't represent full DB. Here, we need aggregation on whole DB which can be with Read Replica
upvoted 12 times
...
amministrazione
Most Recent 8 months, 3 weeks ago
C. Launch a RDS Read Replica connected to your Multi AZ master database and generate reports by querying the Read Replica.
upvoted 1 times
...
SkyZeroZx
1 year, 10 months ago
Selected Answer: C
C is correct this a classic example to use read replicas in RDS
upvoted 1 times
...
Mimek
3 years, 1 month ago
Selected Answer: C
C typical use case of RDS read-replicas
upvoted 2 times
...
AMKazi
3 years, 3 months ago
ans is c: https://aws.amazon.com/rds/features/multi-az/#:~:text=Several%20Amazon%20RDS%20engines%20allow,instances%20in%20a%20different%20AZ. B: is not possible. https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Concepts.MultiAZ.html A Multi-AZ DB instance deployment has one standby DB instance that provides failover support, but doesn't serve read traffic.
upvoted 1 times
...
cldy
3 years, 4 months ago
C is correct.
upvoted 1 times
...
mnsait
3 years, 5 months ago
C This is a typical use case for read-replica. It is an Architect Associate level question :)
upvoted 1 times
...
01037
3 years, 6 months ago
C is correct.
upvoted 1 times
...
cldy
3 years, 6 months ago
C. Remember cache is not the DB. For reporting you need a replica DB.
upvoted 1 times
...
encraze
3 years, 6 months ago
But if ElastiCache is using the write-through strategy and TTL is 30+ mins, then D is an option.
upvoted 1 times
...
fullaws
3 years, 6 months ago
C is correct
upvoted 1 times
...
learner4ever
3 years, 6 months ago
Why not B? The data is already available in standby RDS MySQL.
upvoted 1 times
cpal012
3 years, 6 months ago
That is not accessible to you. You can't query from that DB
upvoted 2 times
01037
3 years, 6 months ago
Agreed.
upvoted 1 times
...
...
Ni_yot
3 years, 4 months ago
The standby DB is always offline. So not accessible
upvoted 2 times
...
...
AWSChia
3 years, 6 months ago
C is the answer. One of the use cases of Read Replica is for business reporting and cached data wouldn't represent the entire reports.
upvoted 2 times
...
miracle
3 years, 6 months ago
Answer is C. Very simple.
upvoted 1 times
...
cloudinvader
3 years, 7 months ago
Yes its C, As Cache layer will keep most read content and report need to generate on the aggregation of latest changes in DB. So using ReadReplica we can create reports without impacting main RDS.
upvoted 3 times
...
Gorha
3 years, 7 months ago
C is correct!
upvoted 2 times
...
amog
3 years, 7 months ago
Answer is C
upvoted 2 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 ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago