Q: 5
A company stores a large dataset for an online advertising business in an Amazon RDS for MySQL DB
instance. The company wants to run business reporting queries on the data without affecting write
operations to the DB instance.
Which solution will meet these requirements?
Options
Discussion
Option A had something like this in a mock and read replicas are the usual AWS way to separate reporting reads from production writes.
A . Read replicas are meant for offloading read-heavy stuff like reporting so the primary keeps handling writes smoothly. Scaling up (C) just makes everything share one bigger box, doesn't separate reads from writes. Anyone see it different?
C/D? But pretty sure it's A that actually solves isolation for reporting, not just more power. Agree?
A
Yeah, A is right here. Using read replicas lets you run reporting queries without impacting the main RDS write workload.
C or A? I think it's supposed to be A with read replicas for reporting but not totally sure since horizontal scaling can be confusing with RDS. Anyone else see something like this?
A in my experience, especially from similar exam questions. Read replicas are the way AWS recommends for offloading reporting without touching write performance. Could be wrong but pretty sure that's what they're testing.
A tbh, that's what the official guide mentions for isolating reporting queries. Practice exams hit this a lot too.
C. scaling up the DB instance feels like it would let both writes and reporting work better at once, right?
Y AWS makes this so convoluted sometimes, but it's A for sure.
Be respectful. No spam.
