CLF-C02 Cloud Technology and Services Practice Question
Which AWS database service is best suited for storing and querying data with complex relationships using structured query language?
⚠ Common exam trap
Many exam-takers confuse Amazon DynamoDB's ability to store JSON documents with relational capabilities, but DynamoDB lacks SQL support and cannot efficiently handle complex multi-table joins or referential integrity constraints.
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 RDS
Amazon RDS is the correct choice because it provides managed relational database services (e.g., MySQL, PostgreSQL, Oracle, SQL Server) that use structured query language (SQL) and are designed to handle complex relationships through foreign keys, joins, and normalized schemas. This makes it ideal for applications requiring ACID transactions and complex queries across multiple tables.
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 DynamoDB
Why it's wrong here
Amazon DynamoDB is a fully managed NoSQL key-value and document database that delivers single-digit-millisecond performance at any scale, with a flexible schema and automatic horizontal partitioning. Although it offers a limited PartiQL query syntax, it lacks complex relational features such as multi-table joins, foreign keys, and built-in aggregation operations, and item-level transactions require careful setup. Consequently, DynamoDB is not appropriate for a workload that needs full SQL relational querying.
- ✓
Amazon RDS
Why this is correct
Amazon RDS is a fully managed service that supports multiple relational database engines, including MySQL, PostgreSQL, MariaDB, Oracle, and SQL Server. It provides traditional SQL capabilities such as schemas, joins, and transactions, ideal for structured data, plus automated backups, patching, and multi-AZ replication. For any workload requiring a relational database with standard SQL queries, RDS is the correct choice.
- ✗
Amazon ElastiCache
Why it's wrong here
Amazon ElastiCache is an in-memory data store offering Redis or Memcached, primarily used as a caching layer to accelerate read-heavy applications by serving frequently accessed data. It is not designed as a persistent relational database and does not support SQL joins, foreign keys, or transactional integrity; data resides in memory and is lost on failure unless replication is configured. Thus it cannot act as a primary relational database for structured queries.
- ✗
Amazon Neptune
Why it's wrong here
Amazon Neptune is a purpose-built graph database optimized for traversing highly interconnected data, such as social networks, fraud detection, or recommendation engines, using graph query languages like Gremlin and SPARQL. It does not provide a relational model or standard SQL semantics like tables and multi-table joins, so it is unsuitable for general-purpose relational data. Neptune excels at graph traversal but not at typical SQL-based transactional workloads.
Go deeper
Related to this question
About these practice questions
One of 988 original CLF-C02 practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. 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.