Courseiva
Data Ingestion and TransformationmediumMatchingObjective-mapped

DEA-C01 Data Ingestion and Transformation Practice Question

Match each AWS database service to its primary use case.

Drag a concept onto its matching description — or click a concept then click the description.

Concepts
Matches

Relational database with managed operations

NoSQL key-value and document database

In-memory caching for low latency

Graph database for connected data

Time-series data for IoT and analytics

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: Relational database for online transaction processing (OLTP) workloads.

Correct matches: RDS -> OLTP relational, DynamoDB -> NoSQL low-latency, Redshift -> data warehousing, ElastiCache -> in-memory caching. Common confusions include swapping RDS and DynamoDB use cases.

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: Relational database for online transaction processing (OLTP) workloads.

    Why this is correct

    Amazon RDS is a managed relational database service ideal for OLTP workloads such as e-commerce sites and CRM systems.

  • Amazon DynamoDB: NoSQL key-value and document database for low-latency, high-traffic applications.

    Why this is correct

    DynamoDB is a fully managed NoSQL database providing single-digit millisecond latency at any scale, suitable for gaming, ad tech, and IoT.

  • Amazon Redshift: Petabyte-scale data warehouse for running complex analytical queries.

    Why this is correct

    Redshift is a fast, petabyte-scale data warehouse that enables running complex analytic queries across large datasets.

  • Amazon ElastiCache: In-memory caching service for improving application performance.

    Why this is correct

    ElastiCache offers managed Redis or Memcached, used for caching, session management, and real-time analytics.

  • Amazon RDS: NoSQL key-value database for low-latency applications.

    Why it's wrong here

    Incorrect — Amazon RDS is a relational database, not NoSQL. This describes Amazon DynamoDB.

  • Amazon DynamoDB: Relational database for OLTP workloads.

    Why it's wrong here

    Incorrect — DynamoDB is a NoSQL database, not relational. This describes Amazon RDS.

About these practice questions

Courseiva writes every DEA-C01 question from scratch — 1,711 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 DEA-C01 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 DEA-C01 exam.