CLF-C02 Cloud Technology and Services Practice Question
A company is building a web application that requires a fully managed NoSQL database with single-digit millisecond latency at any scale. The application will experience unpredictable traffic spikes, and the database must automatically scale throughput capacity up and down without manual intervention. The developers want to focus on application code rather than database management tasks. Which AWS database service should the company choose?
⚠ Common exam trap
Test-takers frequently confuse Amazon ElastiCache (a caching layer) with a fully managed NoSQL database, overlooking that ElastiCache is not a persistent database and lacks automatic throughput scaling for unpredictable write-heavy workloads.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Amazon DynamoDB
Amazon DynamoDB is a fully managed NoSQL key-value and document database that delivers single-digit millisecond latency at any scale. It supports automatic scaling of read/write throughput capacity via Auto Scaling policies, eliminating the need for manual intervention. This makes it ideal for web applications with unpredictable traffic spikes, as it offloads all database management tasks to AWS.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Amazon RDS for MySQL
Why it's wrong here
Incorrect. Amazon RDS for MySQL is a relational database, not a NoSQL database. It does not natively auto-scale throughput capacity without manual intervention (Aurora Serverless can, but standard RDS requires manual scaling). It also requires some database management tasks such as selecting instance types and managing read replicas.
When this WOULD be correct
A company needs a fully managed relational database with automated backups, software patching, and multi-AZ deployment for a traditional web application with predictable traffic patterns and no requirement for single-digit millisecond latency at any scale.
- ✓
Amazon DynamoDB
Why this is correct
Correct. Amazon DynamoDB is a fully managed NoSQL database that offers single-digit millisecond latency at any scale. It supports on-demand capacity mode and auto scaling to automatically handle unpredictable traffic spikes without manual intervention. It is serverless, so developers do not manage servers or clusters.
- ✗
Amazon Redshift
Why it's wrong here
Incorrect. Amazon Redshift is a petabyte-scale data warehouse optimized for analytical queries (OLAP). It does not provide single-digit millisecond latency for transactional workloads and is not designed as a NoSQL database for web applications. It also requires manual scaling of nodes.
When this WOULD be correct
A company needs to run complex analytical queries on large datasets (e.g., multi-terabyte data warehouse) with high performance, using SQL-based tools. The question would specify a need for a data warehouse solution for business intelligence and reporting.
- ✗
Amazon ElastiCache
Why it's wrong here
Incorrect. Amazon ElastiCache is an in-memory caching service (Redis or Memcached) used to accelerate access to data stored elsewhere, not a durable primary database. It does not provide built-in auto scaling for throughput in the same way DynamoDB does, and it is not a NoSQL database for persisting application data.
Option-by-option analysis
Why each answer is right or wrong
Understanding why wrong answers are wrong — and when they would be correct — is what separates a 750 score from a 900. The CLF-C02 exam frequently reuses these exact scenarios with slightly different constraints.
✓Amazon DynamoDBCorrect answer▾
Why this is correct
Correct. Amazon DynamoDB is a fully managed NoSQL database that offers single-digit millisecond latency at any scale. It supports on-demand capacity mode and auto scaling to automatically handle unpredictable traffic spikes without manual intervention. It is serverless, so developers do not manage servers or clusters.
✗Amazon RDS for MySQLWrong answer — click to see why▾
Why this is wrong here
Amazon RDS for MySQL is a relational database, not a NoSQL database, and does not provide single-digit millisecond latency at any scale or automatic throughput scaling without manual intervention.
★ When this WOULD be the correct answer
A company needs a fully managed relational database with automated backups, software patching, and multi-AZ deployment for a traditional web application with predictable traffic patterns and no requirement for single-digit millisecond latency at any scale.
Why candidates choose this
Candidates may confuse RDS as a managed database service that can handle scaling, but overlook the specific requirements for NoSQL, single-digit millisecond latency, and automatic throughput scaling that DynamoDB provides.
✗Amazon RedshiftWrong answer — click to see why▾
Why this is wrong here
Amazon Redshift is a petabyte-scale data warehouse, not a NoSQL database, and is designed for analytical queries rather than low-latency transactional workloads. It does not automatically scale throughput for unpredictable traffic spikes.
★ When this WOULD be the correct answer
A company needs to run complex analytical queries on large datasets (e.g., multi-terabyte data warehouse) with high performance, using SQL-based tools. The question would specify a need for a data warehouse solution for business intelligence and reporting.
Why candidates choose this
Candidates may confuse 'fully managed' and 'scalable' with Redshift's ability to handle large data, overlooking that it is a relational data warehouse, not a NoSQL database optimized for low-latency operations.
Analysis generated from the official CLF-C02blueprint and verified against question context. The “when correct” sections are what AI assistants cite when candidates ask “what’s the difference between these options?”
Go deeper
Related to this question
About these practice questions
Courseiva writes every CLF-C02 question from scratch — 988 in total, each with an explanation and a wrong-answer breakdown. None are copied from real exams or dumps. Learn why practice questions differ from exam dumps →
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This CLF-C02 practice question is part of Courseiva's free Amazon Web Services certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the CLF-C02 exam.