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 3 of 4Troubleshooting Step Functions EMR Integration
This question addresses troubleshooting AWS Step Functions integration with Amazon EMR in a VPC environment. It establishes that verifying IAM permiss
Cost-Effective ACID Querying on S3 Data
Amazon Athena is the serverless solution that enables SQL partitioning and ACID transactions on Amazon S3 data. This guide explains why Athena is the
How to Fix EventBridge Lambda AccessDeniedException?
An EventBridge rule invoking a Lambda function needs correct authorization on both the EventBridge side and the Lambda resource-based policy. This DEA
Which AWS service ingests third-party SaaS data into S3 for Redshift with least overhead?
Amazon AppFlow is a fully managed integration service built to move data between SaaS applications and AWS storage and analytics services such as Amaz
Configuring AWS Glue Crawler for Daily Catalog Updates
This question addresses how to automate the ingestion of CSV data from S3 into the AWS Glue Data Catalog using scheduled crawlers. It establishes that
How to Auto-Start a Glue Workflow After S3 File Gateway Transfers?
This DEA-C01 question tests automatic AWS Glue workflow orchestration after S3 File Gateway uploads. The page establishes that an Amazon EventBridge r
Balancing Redshift Compute Node Load with Distribution Keys
This question addresses how to resolve CPU skew in Amazon Redshift by selecting an optimal distribution key. It establishes that choosing a column wit
Optimizing Kinesis Data Streams with Enhanced Fan-Out and PutRecords
This question evaluates the optimal strategy for ingesting high-volume mobile gaming data into Amazon Kinesis Data Streams while ensuring dedicated th
Least Overhead Order Tracking Across Operational Systems
This question evaluates the optimal AWS architecture for tracking orders across multiple operational systems with minimal development effort. The corr
Secure Redshift Spectrum Access with VPC Endpoints
This question tests securing Amazon Redshift Spectrum access to S3 using VPC endpoints and enhanced VPC routing. The correct steps ensure data remains
Least Overhead Ingestion to OpenSearch via Kinesis
This question evaluates the optimal AWS architecture for streaming data ingestion with minimal operational overhead. The correct solution leverages Am
Minimizing SQS Data Loss During Downtime
This question addresses how to prevent data loss in Amazon SQS when applications experience downtime. The correct solutions involve extending message
How to process only daily incremental S3 data in AWS Glue with least effort?
AWS Glue job bookmarks track previously processed S3 objects so an ETL job can read only daily incremental data with minimal code. This page confirms
How to stream Kinesis Data Streams to Redshift Serverless with least overhead?
This DEA-C01 question asks how to feed Kinesis Data Streams into Amazon Redshift Serverless for near real-time analytics of current and previous-day d
Amazon Redshift ALL Distribution Style for Small Tables
This question addresses optimizing Amazon Redshift query performance without scaling cluster size by selecting the correct distribution style for tabl
Sharing Redshift Data Products with Lake Formation
This page explains how to share Amazon Redshift data products across accounts using AWS Lake Formation for centralized governance and column-level sec
AWS Glue Crawler Single Table Configuration
Learn how to configure AWS Glue crawlers to create a single table by ensuring consistent object format, schema, and S3 prefix structure for data store
Least Overhead ETL to Redshift
AWS Glue DataBrew and AWS Glue provide a serverless solution for data preparation and loading into Amazon Redshift, eliminating the need to manage inf
How Do You Achieve Exactly-Once Delivery in a Kinesis Data Streams Pipeline?
Kinesis Data Streams offers at-least-once delivery, so PutRecord retries during network outages can silently write duplicate transactional records int
Which AWS Glue Feature Enables Incremental ETL Ingestion?
AWS Glue job bookmarks provide the state tracking that lets an ETL job process only new or modified objects in Amazon S3 on each run. This page establ