Match each AWS database service to its description.
Drag a concept onto its matching description — or click a concept then click the description.
Managed relational database
NoSQL key-value and document database
Data warehousing
In-memory caching
MySQL/PostgreSQL-compatible relational database
Answer choices
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
Amazon RDS: Managed relational database service supporting multiple engines
Amazon RDS provides managed relational databases, DynamoDB offers NoSQL capabilities, Redshift is for data warehousing, and ElastiCache is for caching. Common confusions involve mixing up Redshift and ElastiCache due to their related but distinct use cases.
Answer analysis
For each option: why learners choose it and why it is or isn't the right answer here.
Amazon RDS: Managed relational database service supporting multiple engines
Why this is correct
Amazon RDS is a managed relational database service that automates routine operational tasks such as provisioning, patching, backup, and failover. It supports multiple relational database engines, including MySQL, PostgreSQL, MariaDB, Oracle, and Microsoft SQL Server. This makes it the appropriate choice for online transaction processing (OLTP) workloads requiring structured data and SQL queries, not for caching or data warehousing.
Amazon DynamoDB: Fully managed NoSQL key-value and document database
Why this is correct
Amazon DynamoDB is a fully managed NoSQL database service that supports both key-value and document data models. It is serverless and delivers consistent single-digit millisecond latency at any scale, automatically scaling capacity to match traffic. DynamoDB is ideal for high-velocity use cases such as gaming, IoT, web sessions, and shopping carts, but it does not natively support relational queries or joins.
Amazon Redshift: Fully managed in-memory caching service
Why it's wrong here
This description is incorrect because Amazon Redshift is not an in-memory caching service; it is a fully managed, petabyte-scale data warehouse optimized for running complex analytical queries. Redshift uses columnar storage and massively parallel processing (MPP) to scan and aggregate large datasets efficiently. The description actually applies to Amazon ElastiCache, which provides managed Redis or Memcached for caching and low-latency data access.
Amazon ElastiCache: Fully managed data warehousing service for analytics
Why it's wrong here
This description is incorrect because Amazon ElastiCache is not a data warehousing service; it is a fully managed in-memory caching service that deploys Redis or Memcached to accelerate read-heavy workloads by storing frequently accessed data in memory. Data warehousing requires a purpose-built service like Amazon Redshift, which uses columnar storage and parallel query execution for large-scale analytics. ElastiCache is meant to reduce database load and improve application latency, not to store and analyze historical data.
Go deeper
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 →
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.