Courseiva

DEA-C01 Data Ingestion and Transformation Practice Question

A company uses AWS Lambda to process messages from an Amazon SQS queue. The messages contain JSON payloads that need to be transformed and written to an Amazon DynamoDB table. Recently, the Lambda function has been timing out and messages are being sent to the dead-letter queue (DLQ). What is the BEST way to troubleshoot and resolve this issue?

⚠ Common exam trap

The trap here is that candidates often focus on SQS queue configuration (visibility timeout, queue type) rather than addressing the actual performance bottleneck in the Lambda function or downstream DynamoDB service.

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

✓

Increase the Lambda function timeout and monitor DynamoDB write capacity to ensure it is not throttling.

The Lambda function is timing out, which suggests the function's execution duration is exceeding its configured timeout. Increasing the timeout gives the function more time to process messages. Additionally, if DynamoDB write capacity is insufficient, throttling can cause retries that further delay processing, so monitoring and possibly increasing write capacity units addresses the root cause of timeouts.

Answer analysis

Option-by-option breakdown

For each option: why learners choose it and why it is or isn't the right answer here.

  • ✗

    Use a standard SQS queue instead of a DLQ to reprocess failed messages automatically.

    Why it's wrong here

    A standard queue is not a diagnostic tool; it merely redelivers the same failing payloads, so timeouts persist and the underlying cause stays hidden. It appeals because standard queues do retry automatically, which suits transient failures, but here the Lambda function itself is timing out, so retries cannot resolve it.

  • ✓

    Increase the Lambda function timeout and monitor DynamoDB write capacity to ensure it is not throttling.

    Why this is correct

    Timeouts and DLQ routing usually stem from the function exceeding its configured duration or downstream throttling. Raising the timeout addresses slow execution, while monitoring DynamoDB write capacity reveals throttling that silently extends processing time, letting you right-size capacity or batch writes.

  • ✗

    Switch the SQS queue to a FIFO queue to ensure exactly-once processing.

    Why it's wrong here

    FIFO ordering and deduplication address sequencing and duplicate delivery, not execution duration, so the Lambda function still times out. It is tempting because FIFO queues guarantee exactly-once processing, which suits order-sensitive workloads, but the stem's symptom is timeout-induced DLQ delivery, unrelated to message ordering.

  • ✗

    Increase the visibility timeout of the SQS queue to 30 minutes.

    Why it's wrong here

    Raising visibility timeout only extends how long a message stays invisible after receipt; it does not stop the Lambda function from exceeding its own timeout, so failures continue. It is tempting because visibility timeout must exceed function duration, which is correct when functions finish successfully but slowly, not when they time out.

Visual reference

Client Recursive Resolver Root DNS (13 root servers) TLD DNS (.com, .org, …) Authoritative example.com query IP addr answer

Quick reference

Cloud Service Model Comparison

ModelYou ManageProvider ManagesExamples
IaaSOS, runtime, apps, dataHardware, hypervisor, networkingEC2, Azure VMs, GCP Compute Engine
PaaSApps and dataOS, runtime, middleware, hardwareElastic Beanstalk, Azure App Service
SaaSData and settings onlyEverything elseMicrosoft 365, Salesforce, Workday
FaaS / ServerlessFunction code onlyInfra, scaling, runtimeLambda, Azure Functions, Cloud Run
CaaSContainers and appsKubernetes, OS, hardwareEKS, AKS, GKE

About these practice questions

One of 1,321 original DEA-C01 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 →

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.