ExamPark
Course menuCLF-C02

Exams / CLF-C02 / Databases and migration / Question 1

CLF-C02 practice question: Databases and migration (1 of 2)

Cloud Technology and Services A free question from our original CLF-C02 practice exam. Try it, then open the answer to see why each option is right or wrong.

Last verified against current AWS documentation ·How we write our questions

An online shop's product pages read the same product data from an Amazon RDS database thousands of times a minute.

The product data changes only a few times a day. The company wants the repeated reads answered from memory, to respond faster and reduce load on the database.

Which change should it make?

Choose one answer.

  1. A. Add Amazon ElastiCache in front of the database, caching frequent query results
  2. B. Add an RDS read replica and send all product reads to it
  3. C. Move the product data to Amazon Redshift, a data warehouse for faster queries
  4. D. Use AWS Database Migration Service to copy the product data into another database engine
Show the answer and explanation

Answer: A

  • A. Right: Correct. ElastiCache is a distributed in-memory data store used as a cache. Caching frequent query results answers repeated reads from memory and reduces database load, and rarely changing data stays cached well. Learn more: Caching database query results (opens in a new tab)
  • B. Wrong: A read replica spreads reads across a second database copy, which helps load. But each read is still answered from database storage rather than from memory, so it misses the in-memory goal.
  • C. Wrong: Redshift is built for large analytical queries over structured data. It is not an in-memory cache for fast, repeated product reads.
  • D. Wrong: DMS moves data between databases during a migration or replication. It does not keep frequently read data in memory to speed up responses.

Explanation

ElastiCache is an in-memory data store used as a cache. Placing it in front of RDS answers repeated product reads from memory, which is faster and lightens the load on the database. A read replica still reads from database storage, while Redshift and DMS do other jobs.

Study

Keep practicing

Answer questions with a score at the end, or practice just this topic with the explanation after each one. No sign-up needed.

Take the free CLF-C02 practice examPractice Databases and migrationAll Databases and migration questions

Want more on Databases and migration? The 5 full-length practice sets have 10 more Databases and migration questions, 325 in all, none of them in the free exam. One payment of $14.99, no subscription. See the practice sets