Perform data ingestion.
21 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
21 total · page 1 of 2AWS Glue Studio PII Obfuscation for S3 Data Lake
AWS Glue Studio provides a native Detect PII transform that can both identify and obfuscate personally identifiable information with minimal operation
AWS Data Exchange for Third-Party Datasets
This question tests the correct selection of AWS services for integrating third-party data with minimal operational overhead. The correct solution lev
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
AWS DataSync for On-Premises to S3 Transfer
AWS DataSync is the optimal service for securely and efficiently transferring large volumes of data from on-premises storage to Amazon S3 with automat
Which Kinesis Option Delivers IoT Sensor Data to S3 with Least Latency?
This DEA-C01 question asks which AWS streaming path writes 100 KB IoT sensor batches to Amazon S3 with the least latency. The answer is Kinesis Data S
S3 Select vs Athena for Parquet Column Query
This question evaluates the optimal AWS service for querying a single column from Apache Parquet files in S3 with minimal overhead. The correct soluti
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
Which AWS service cost-effectively orchestrates Glue crawler and ETL to S3?
AWS Glue workflows are the most cost-effective way to orchestrate a Glue crawler over Microsoft SQL Server and the downstream ETL job that writes to A
Low-Latency IoT Data Ingestion with Kinesis and DynamoDB
This question evaluates the selection of AWS services for real-time sensor data ingestion and low-latency querying. The correct solution leverages Ama
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
How to Ingest CSV into S3 for Cost-Effective Athena Queries?
Converting a 15-column CSV source into Apache Parquet with an AWS Glue ETL job lets Athena scan only the queried columns, making it the most cost-effe
How do you stream CloudWatch Logs cross-account to Kinesis Data Streams?
Delivering CloudWatch Logs from a production account to a security account with Kinesis Data Streams requires the destination stream in the security a
Amazon Redshift COPY Command for Optimal Throughput
To achieve the greatest possible throughput when loading data into Amazon Redshift, a single COPY command is the required solution. This page explains
Which AWS solution detects changing schemas and loads data to S3 with least overhead?
This DEA-C01 scenario requires detecting undefined or changing schemas across SAP HANA, SQL Server, MongoDB, Kafka, and DynamoDB while loading transfo
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
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
How Can You Confirm PostgreSQL Is Causing DMS CDC Latency?
This question tests how to isolate change data capture latency in an AWS DMS ongoing replication task from PostgreSQL to Amazon Redshift. The page est
How to Fix Kinesis WriteThroughputExceeded from Facility ID Hot Shards?
Amazon Kinesis Data Streams hot shards and WriteThroughputExceeded exceptions occur when facility ID concentrates traffic; this page confirms that swi
Ingesting Oracle to S3 Parquet with Least Effort
Determines the optimal AWS service for migrating on-premises Oracle data to Amazon S3 in Parquet format with minimal configuration effort.