Automate data processing by using AWS services.

74 practice questions under this official exam objective (DEA-C01), each with the answer key, an option-by-option explanation and instant feedback.

Questions under this objective

74 total · page 2 of 4
DEA-C01 S-grade

DynamoDB Scheduled Auto Scaling for Predictable Workloads

This question evaluates the cost-effective management of Amazon DynamoDB provisioned capacity using AWS Application Auto Scaling with scheduled polici

9 comments
DEA-C01 A-grade

Which Step Functions State Parallel Processes a Collection of Data Files?

AWS Step Functions uses the Map state to iterate over a collection of items such as S3 data files and run the same transformation steps on each one co

8 comments
DEA-C01 S-grade

Which AWS service most cost-effectively orchestrates an Amazon EMR ETL pipeline?

Amazon EMR ETL pipelines that pull from multiple sources need an orchestrator that can sequence EMR steps and other AWS services. AWS Step Functions i

8 comments
DEA-C01 S-grade

Least Operational Overhead for API Gateway Lambda

Determining the optimal compute solution for occasional Python scripts invoked by Amazon API Gateway with minimal management. AWS Lambda is the correc

8 comments
DEA-C01 S-grade

Real-Time Network Outage Detection with Kinesis and Flink

This page analyzes the optimal architecture for detecting sudden network usage drops with the least latency using Amazon Kinesis Data Analytics (Flink

8 comments
DEA-C01 S-grade

AWS DMS Replication Instance Region for Cross-Region Migration

This question addresses the placement of an AWS DMS replication instance when migrating data between different AWS accounts and regions, specifically

8 comments
DEA-C01 A-grade

How to Process Multi-Region EFS Data in One Region with Least Effort?

Amazon EFS replication can copy each Regional file system into the data science team's Region so Lambda functions mount local replicas and process the

7 comments
DEA-C01 A-grade

Which EMR Storage and Instance Choices Meet Cost and Reliability Needs?

This DEA-C01 question tests cost-optimized, reliable Amazon EMR design for long-running Apache Spark workloads. The page establishes that Amazon S3 fo

7 comments
DEA-C01 A-grade

Enabling Concurrency Scaling in Amazon Redshift WLM

This guide explains how to enable concurrency scaling for Amazon Redshift clusters by configuring the Workload Management (WLM) queue settings. It cla

7 comments
DEA-C01 A-grade

How to Trigger a Lambda CSV-to-Parquet Conversion on S3 Upload?

An S3 event notification with the s3:ObjectCreated:* event type plus a .csv suffix filter can invoke a Lambda function directly, which is the lowest-o

7 comments
DEA-C01 S-grade

Amazon Athena Query Result Reuse for Cost Optimization

This page explains how to optimize Amazon Athena costs using the built-in query result reuse feature, which caches results from identical queries exec

7 comments
DEA-C01 S-grade

Reducing RDS MySQL High CPU for Write-Heavy Workloads

This page explains how to reduce high CPU utilization on an Amazon RDS for MySQL instance with a write-heavy workload, establishing that A and D are t

7 comments
DEA-C01 S-grade

Cost-Effective CDC in S3 Data Lake

This question addresses the most cost-effective method for performing Change Data Capture (CDC) on a transactional data lake stored in Amazon S3, spec

7 comments
DEA-C01 S-grade

AWS Glue Data Catalog Incremental Updates with SQS

This question addresses configuring AWS Glue Data Catalog for incremental updates using S3 event notifications and SQS. The solution leverages event-d

7 comments
DEA-C01 S-grade

Invoking Lambda for Redshift Load Status via EventBridge

This question addresses integrating Amazon Redshift Data API with AWS Lambda and EventBridge to track table load statuses. It establishes that publish

7 comments
DEA-C01 S-grade

How Do You Schedule a Redshift Stored Procedure Daily Cost-Effectively?

Amazon Redshift query editor v2 supports scheduled queries, so a stored procedure can run daily without standing up extra compute. For a non-mission-c

7 comments
DEA-C01 A-grade

Most cost-effective AWS Glue execution class for daily non-urgent jobs?

AWS Glue FLEX execution class runs non-urgent daily Glue jobs on spare capacity at a lower price than STANDARD, making it the most cost-effective opti

6 comments
DEA-C01 A-grade

How to Dynamically Redact S3 PII for Multiple Applications?

Amazon S3 Object Lambda runs code on S3 GET requests so PII can be redacted per application without storing duplicate datasets. This page establishes

6 comments
DEA-C01 A-grade

Amazon Redshift Serverless for Infrequent Analytics

This question evaluates the use of Amazon Redshift Serverless to eliminate manual infrastructure management for intermittent workloads. The correct so

6 comments
DEA-C01 A-grade

How to Run 30-Minute Windowed Streaming Analytics with Least Overhead?

This DEA-C01 question asks which AWS service should power fault-tolerant real-time analytics with time-based aggregations over a 30-minute window whil

6 comments