Courseiva
Cloud Technology and ServicesmediumMultiple ChoiceObjective-mapped

CLF-C02 Cloud Technology and Services Practice Question

A company is developing a mobile application that requires a database to store user session data and preferences. The data is accessed very frequently with low-latency requirements, and the access patterns are unpredictable – the application experiences sudden spikes in read and write traffic. The company wants a fully managed database service that automatically scales to handle the workload, requires no patching or server administration, and charges based on the throughput consumed rather than on provisioned capacity. Which AWS service meets these requirements?

⚠ Common exam trap

A common mix-up: candidates confuse 'fully managed' with 'serverless' and pick Amazon RDS for MySQL because it is also fully managed, but they overlook the specific requirement for throughput-based pricing and automatic scaling for unpredictable spikes, which only DynamoDB's on-demand mode provides.

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 on-demand capacity mode, which automatically scales to handle unpredictable traffic spikes and charges based on the actual reads and writes consumed, not on pre-provisioned throughput. This eliminates the need for patching, server administration, or capacity planning, matching all the stated requirements exactly.

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

    Amazon RDS for MySQL requires you to provision a fixed amount of read/write capacity in advance and does not automatically scale throughput based on demand, so it cannot handle unpredictable traffic spikes without manual intervention. It is tempting because RDS is a fully managed relational database that handles patching and server administration, making it a correct choice when you need a traditional SQL database with predictable, steady-state workloads and are willing to pay for provisioned capacity rather than consumed throughput.

    When this WOULD be correct

    A company needs a fully managed relational database for a traditional web application with predictable traffic, requiring complex joins and transactions, and is willing to manage scaling and pay for provisioned capacity.

  • Amazon DynamoDB

    Why this is correct

    Amazon DynamoDB is a fully managed NoSQL database that provides single-digit millisecond performance at any scale. It supports on-demand capacity mode, which automatically scales to accommodate traffic spikes and charges per request, eliminating the need for provisioning. It is ideal for session storage, gaming, and real-time applications.

  • Amazon Redshift

    Why it's wrong here

    Amazon Redshift is a petabyte-scale data warehouse used for analytical queries on large datasets. It is not optimized for low-latency, high-frequency point lookups or writes, and requires cluster management. It does not fit the use case of a session database.

    When this WOULD be correct

    A company needs to run complex analytical queries on petabytes of structured data, such as sales reports or business intelligence dashboards, and requires a fully managed, columnar storage data warehouse that integrates with existing BI tools.

  • Amazon EBS

    Why it's wrong here

    Amazon EBS provides block-level storage volumes for use with Amazon EC2 instances. It is not a database service and does not offer query capabilities, automatic scaling, or throughput-based pricing. It simply provides raw storage that must be managed by the operating system.

    When this WOULD be correct

    A question asking for a persistent, high-performance block storage solution for an EC2 instance running a custom database or application that requires low-latency access and manual scaling control, with no need for automatic scaling or throughput-based pricing.

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

Amazon DynamoDB is a fully managed NoSQL database that provides single-digit millisecond performance at any scale. It supports on-demand capacity mode, which automatically scales to accommodate traffic spikes and charges per request, eliminating the need for provisioning. It is ideal for session storage, gaming, and real-time applications.

Amazon RDS for MySQLWrong answer — click to see why

Why this is wrong here

Amazon RDS for MySQL requires provisioning capacity and does not automatically scale for unpredictable spikes; it also involves patching and server administration, and charges based on provisioned capacity, not throughput consumed.

★ When this WOULD be the correct answer

A company needs a fully managed relational database for a traditional web application with predictable traffic, requiring complex joins and transactions, and is willing to manage scaling and pay for provisioned capacity.

Why candidates choose this

Candidates may associate MySQL with mobile app backends and overlook the specific requirements for automatic scaling, no administration, and throughput-based pricing that DynamoDB offers.

Amazon RedshiftWrong answer — click to see why

Why this is wrong here

Amazon Redshift is a data warehousing service optimized for analytical queries on large datasets, not for low-latency, high-frequency read/write operations on user session data. It requires provisioning capacity and does not charge based on throughput consumed.

★ When this WOULD be the correct answer

A company needs to run complex analytical queries on petabytes of structured data, such as sales reports or business intelligence dashboards, and requires a fully managed, columnar storage data warehouse that integrates with existing BI tools.

Why candidates choose this

Candidates may confuse Redshift's managed nature and scalability with DynamoDB's, or think that any database on AWS can handle unpredictable spikes, overlooking the specific throughput-based pricing and low-latency requirements.

Amazon EBSWrong answer — click to see why

Why this is wrong here

Amazon EBS is a block-level storage volume for EC2 instances, not a fully managed database service. It does not automatically scale, requires server administration, and charges based on provisioned capacity, not throughput.

★ When this WOULD be the correct answer

A question asking for a persistent, high-performance block storage solution for an EC2 instance running a custom database or application that requires low-latency access and manual scaling control, with no need for automatic scaling or throughput-based pricing.

Why candidates choose this

Candidates may confuse EBS with a database service because it can host database files, or they might think its low-latency block storage meets the performance requirements without considering the need for a fully managed database.

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?”

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 →

How Courseiva writes practice questions · Editorial policy

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.