A bank plans to use an Amazon RDS for MySQL DB instance. The database should support read-intensive traffic with very few repeated queries. Which solution meets these requirements?
A.
Create an Amazon ElastiCache cluster. Use a write-through strategy to populate the cache.
B.
Create an Amazon ElastiCache cluster. Use a lazy loading strategy to populate the cache.
C.
Change the DB instance to Multi-AZ with a standby instance in another AWS Region.
D.
Create a read replica of the DB instance. Use the read replica to distribute the read traffic.
very bad wording used in this question ; because of "with extremely few repeated queries" which basically means "with a lot of different queries" Elasticache won't help
Sorry I take it back completely. Im an idiot. "Very few repeated read queries" as in most queries are unique. Elasticache wont help here. I will change my option to (D)
Correct Answer is (B) Another question right here in ExamTopics
For its application database tier, a corporation uses Amazon RDS MySQL instances, and for its web tier, Apache Tomcat servers. Repeated read requests make up the majority of database queries from web apps.
Which AWS service would benefit from the addition of an in-memory store for repeated read queries?
A. Amazon RDS Multi-AZ
B. Amazon SQS
C. Amazon ElastiCache <<< (Official Answer)
D. Amazon RDS read replica
what does this even mean? "...with extremely few repeated queries." -> English grammar is aborrant in these questions and they're artificially creating phrases they think makese sense!!
But if they are TRYING to ask prevent the repeated queries from hitting the database- then Elasticache with lazy loading will do the trick the first query will take a hit to the database but the repeated queries will be returned from the cache
Feels like (B)
B
Elasticache is the best solution to "handle high-volume read requests with extremely few repeated queries."
Note that it is extremely few repeated queries. As per this link, https://docs.aws.amazon.com/AmazonElastiCache/latest/mem-ug/Strategies.html, the lazy loading strategy fits this requirement
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.
sj143
Highly Voted 3 years, 3 months agokhun
Most Recent 2 years, 4 months agonovice_expert
3 years agokret
3 years, 1 month agoRotterDam
3 years, 2 months agoRotterDam
3 years, 2 months agoRotterDam
3 years, 2 months agoMintwater
2 years agoawsmonster
3 years, 3 months agooopsy
3 years, 3 months agoSMAZ
3 years, 4 months agojove
3 years, 4 months agojove
3 years, 4 months ago