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 4 of 4Least-Effort Near Real-Time MySQL to Redshift Integration
This question tests how to move frequently changing on-premises MySQL data into Amazon Redshift in near real time with the least development effort. A
How to enforce custom data quality validation rules in AWS Glue ETL?
AWS Glue Data Quality rulesets let you codify custom validation checks for ETL datasets, so order data is tested for accuracy and consistency before i
Optimize Athena Query Performance on ALB Logs
This question addresses optimizing Amazon Athena queries for increasing data volumes by leveraging AWS Glue crawlers to automate schema detection and
Troubleshooting Amazon Athena Queries for Partitioned S3 Data
This page explains how to troubleshoot empty query results in Amazon Athena by verifying S3 paths and repairing table metadata partitions.
Masking and Securing PII in AWS Data Pipelines
This question addresses how to automatically mask Personally Identifiable Information (PII) in S3 using AWS Glue DataBrew while securing access via IA
Cost-Effective Serverless Data Processing for Small Files
This question evaluates the selection of a serverless, cost-effective data processing architecture using AWS Glue and Athena for small, frequent S3 up
Optimize Redshift Spectrum Query Performance with Columnar Format and Partitioning
This question addresses optimizing Amazon Redshift Spectrum queries by leveraging columnar file formats and partitioning to reduce I/O overhead. It es
Diagnosing MWAA Workflow Failures with Apache Airflow Logs
Learn which Amazon MWAA log type is essential for diagnosing workflow failures: Task logs provide the specific error details needed to troubleshoot in
Optimizing AWS Glue for Millions of Small Files
This question addresses the performance bottleneck caused by processing millions of small JSON files in AWS Glue, where file overhead dominates execut
AWS Lake Formation FindMatches for Record Matching
This question addresses using AWS Lake Formation's built-in ML transform to identify matching records without unique identifiers in an ETL pipeline. T
Optimize EMR Costs for CPU-Bound Spark Jobs
This question addresses cost optimization for Amazon EMR clusters running Apache Spark by identifying the appropriate EC2 instance family based on res
Low-Latency Time Series Visualization with OpenSearch
This question evaluates the optimal AWS service for visualizing near real-time time series data with minimal latency. It establishes that Amazon OpenS
Cost-Effective S3 Access from VPC-Enabled Lambda
This question addresses resolving connectivity timeouts for a VPC-enabled AWS Lambda function accessing Amazon S3. It establishes that a VPC Gateway E
How to Speed Up Redshift COPY from an S3 Data Lake?
Amazon Redshift loads data fastest from Amazon S3 when a single COPY command reads all files through a manifest instead of issuing one COPY command pe