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 1 of 4Redshift Streaming Ingestion with Materialized Views
This question evaluates the optimal architecture for near real-time analytics using Amazon Redshift and Kinesis Data Streams, focusing on minimizing o
AWS Glue PII Detection and Obfuscation
This question addresses the least operational effort solution for profiling and obfuscating Personally Identifiable Information (PII) in an Amazon S3
Cost-Effective Querying of Compressed Data for Audits
This question evaluates the most cost-effective solution for querying gzip-compressed transaction data stored in AWS, focusing on balancing storage co
How Can Lambda Connect Privately to an RDS Instance with Least Overhead?
Connecting an AWS Lambda function to a private Amazon RDS instance requires VPC placement plus a security-group rule that references the Lambda's own
Persisting EC2 Data Across Terminations with Default Settings
This page explains how to persist application data on Amazon EC2 when instances are terminated, specifically focusing on the default DeleteOnTerminati
Amazon EMR for Petabyte-Scale Migration with Legacy Frameworks
This question evaluates the selection of an AWS service for migrating complex, petabyte-scale ETL workloads involving Apache Pig, Oozie, Spark, HBase,
Kinesis Data Firehose CSV to Parquet Conversion
This question tests the native data transformation capabilities of Amazon Kinesis Data Firehose. The correct solution leverages built-in format conver
Lambda RDS Private Connectivity Least Overhead
Learn how to connect AWS Lambda functions to Amazon RDS privately with minimal operational overhead using shared security groups and subnet configurat
Low Latency Real-Time Sensor Dashboard with Kinesis and Timestream
This question evaluates the selection of AWS services for a real-time operational dashboard requiring the lowest possible latency from sensor data ing
How to Fix an AWS Glue S3 VPC Gateway Endpoint Error?
An AWS Glue job that reads from Amazon S3 over a VPC fails with an Amazon S3 VPC gateway endpoint error; the requirement is to restore connectivity by
Most Cost-Effective AWS Glue ETL for Small Daily CSV Files?
Choosing the cheapest AWS service to run a daily ETL job over sub-100 MB CSV files uploaded to Amazon S3 comes down to matching compute overhead to da
Solving Athena Query Planning Bottlenecks with Partition Indexing and Projection
This guide explains how to resolve Amazon Athena query planning bottlenecks caused by a high volume of S3 partitions using Glue partition indexing and
AWS Glue Job vs Crawler for SQL Server Migration
This question evaluates the operational efficiency of using AWS Glue Jobs versus Crawlers for migrating SQL Server data to Parquet format in S3. It es
Amazon Redshift Data API for Real-Time Queries
The Amazon Redshift Data API provides a serverless, HTTPS-based interface for executing SQL queries, eliminating the need to manage database drivers o
Redshift Data Sharing for Cross-Cluster Access
This question tests the use of Amazon Redshift Data Sharing to securely share live data between clusters without impacting producer performance. The c
Automating Amazon Redshift Materialized View Refresh
Learn how to automate Amazon Redshift materialized view refresh schedules with the least effort using built-in features or Query Editor v2.
AWS Glue Triggers and Connections for ETL Pipelines
This page explains how to minimize operational overhead in AWS Glue ETL pipelines by using native triggers for scheduling and connections for secure d
Enabling Apache Spark in Amazon Athena
To use Apache Spark instead of SQL for ETL tasks in Amazon Athena, you must create an Athena workgroup configured with the Spark engine. This configur
How to centrally share and update Python code across many Lambda functions?
Lambda layers let you package shared Python code once and attach it to many Lambda functions, so a single layer update replaces editing every function
Migrating Hive Metastore to Serverless AWS Glue Data Catalog
This question addresses migrating an on-premises Apache Hive metastore to a serverless, cost-effective AWS solution for data cataloging. It establishe