Amazon AWS Certified Data Engineer - Associate DEA-C01 Exam Dumps, Practice Test Questions

100% Latest & Updated Amazon AWS Certified Data Engineer - Associate DEA-C01 Practice Test Questions, Exam Dumps & Verified Answers!
30 Days Free Updates, Instant Download!

Amazon AWS Certified Data Engineer - Associate DEA-C01 Premium Bundle
$79.97
$59.98

AWS Certified Data Engineer - Associate DEA-C01 Premium Bundle

  • Premium File: 366 Questions & Answers. Last update: Nov 2, 2026
  • Training Course: 273 Video Lectures
  • Study Guide: 809 Pages
  • Latest Questions
  • 100% Accurate Answers
  • Fast Exam Updates

AWS Certified Data Engineer - Associate DEA-C01 Premium Bundle

Amazon AWS Certified Data Engineer - Associate DEA-C01 Premium Bundle
  • Premium File: 366 Questions & Answers. Last update: Nov 2, 2026
  • Training Course: 273 Video Lectures
  • Study Guide: 809 Pages
  • Latest Questions
  • 100% Accurate Answers
  • Fast Exam Updates
$79.97
$59.98

Amazon AWS Certified Data Engineer - Associate DEA-C01 Practice Test 30

Question 290

A Glue workflow reruns yesterday's partition after a partially failed daily job but overwrites already-approved historical results. Which engineering change best addresses the underlying issue?

  1. Create a supported Firehose dynamic-partitioning delivery stream with well-chosen keys and S3 prefixes.
  2. Use an appropriate hashed lookup structure while preserving deterministic output behavior.
  3. Use supported partial batch failure handling and idempotent sink writes with a failure destination.
  4. Write to a versioned staging output and promote only a complete validated partition.

Explanation

Correct Answer

D:

Write to a versioned staging output and promote only a complete validated partition. It directly addresses the case cause (Retry logic does not isolate staging and atomic commit boundaries.) and should be verified by: A forced mid-run failure leaves the previous published partition available.

Incorrect Answers

A:

That change addresses a Firehose stream delivering transactions to S3 mixes every customer into the same prefix, making Athena queries scan all tenants; it would not repair this incident.

B:

That change addresses a large ETL data structure uses a list for repeated membership checks and CPU use grows unexpectedly; it would not repair this incident.

C:

That change addresses a Lambda Kinesis event-source mapping repeatedly delivers the same batch after one malformed record fails; it would not repair this incident.

Question 291

An Athena query of yesterday's S3 partition returns zero rows because its table metadata lacks that partition. Which engineering change best addresses the underlying issue?

  1. Add supported partition projection or update Glue partitions in the ingestion workflow.
  2. Offload reporting to an appropriately refreshed warehouse, replica or approved analytical system.
  3. Separate hot operational state from archival S3 objects using a measured suitable database/cache.
  4. Redesign keys using appropriately distributed entity/shard identifiers while preserving retrieval needs.

Explanation

Correct Answer

A:

Add supported partition projection or update Glue partitions in the ingestion workflow. It directly addresses the case cause (The catalog partition listing is not synchronized with newly written S3 prefixes.) and should be verified by: Yesterday's test row becomes queryable without a broad table recreation.

Incorrect Answers

B:

That change addresses an operational RDS database has a complex read-only report consuming most CPU at peak checkout time; it would not repair this incident.

C:

That change addresses a customer expects fast key-value reads over frequently accessed session state yet stores every session in a multi-megabyte compressed S3 archive; it would not repair this incident.

D:

That change addresses a DynamoDB table uses the same partition key for all new daily events, producing throttled writes during each morning burst; it would not repair this incident.

Question 292

A team applies a reviewed fix for this situation: Two Kinesis consumers must independently recover after a deployment, but one team reuses the other's checkpoint store. Which observed outcome would most convincingly validate the fix?

  1. A replayed historical event receives its original applicable classification.
  2. A forced retry leaves one intended row per business event.
  3. One consumer restarts without altering the other consumer's offset.
  4. A fixture with two nested lines produces correct line and order totals.

Explanation

Correct Answer

C:

One consumer restarts without altering the other consumer's offset. This verifies the result of separate durable per-application checkpoints and verify replay position semantics.

Incorrect Answers

A:

This would verify another situation: A Glue transform joins events to reference data refreshed weekly, but old events are silently reclassified on every rerun. It does not validate the current case.

B:

This would verify another situation: A Glue streaming job writes duplicate target rows when a microbatch is retried after a worker restart. It does not validate the current case.

D:

This would verify another situation: A Glue job reading nested JSON flattens arrays incorrectly and duplicates parent order totals. It does not validate the current case.

Question 293

After resolving the following incident, which ongoing safeguard most directly prevents recurrence? A data privacy analyst needs to identify PII in unknown S3 datasets but assumes object names reveal sensitive content.

  1. Run privacy checks on log fields and permissions.
  2. Include encrypted-fixture reads and key rotation scenarios in ETL QA.
  3. Recheck sensitive-data classifications after source schema changes.
  4. Test retention and deletion restrictions during compliance reviews.

Explanation

Correct Answer

C:

Recheck sensitive-data classifications after source schema changes. This safeguards against a recurring cause: Object naming is not a reliable classifier of data content.

Incorrect Answers

A:

That safeguard addresses another case: A central CloudWatch Logs group for Glue jobs retains all raw customer payloads in debug messages across many teams. It is not the control for this recurring failure.

B:

That safeguard addresses another case: A Glue job reads an S3 object encrypted with a customer-managed KMS key and fails even though it has `s3:GetObject`. It is not the control for this recurring failure.

D:

That safeguard addresses another case: An organization exports audit logs to S3 without lifecycle retention review and required records expire before annual audit. It is not the control for this recurring failure.

Question 294

After resolving the following incident, which ongoing safeguard most directly prevents recurrence? A lake stores customer location coordinates as one unparsed text field while downstream joins require numeric latitude and longitude.

  1. Capture Athena bytes-scanned baselines for frequent queries.
  2. Track metadata version and compatible migration steps per release.
  3. Test range, nullability and precision for geospatial attributes.
  4. Treat catalog identities and permissions as persistent infrastructure.

Explanation

Correct Answer

C:

Test range, nullability and precision for geospatial attributes. This safeguards against a recurring cause: Schema representation prevents typed spatial validation and query optimization.

Incorrect Answers

A:

That safeguard addresses another case: An Athena query reads huge raw JSON partitions for a narrow timestamp filter and scans far more bytes than expected. It is not the control for this recurring failure.

B:

That safeguard addresses another case: Two developers independently edit Glue Data Catalog schema types during release, and a job fails after the last writer wins. It is not the control for this recurring failure.

D:

That safeguard addresses another case: An ETL job drops a Glue Data Catalog table and recreates it daily, deleting important tags and permissions. It is not the control for this recurring failure.

Question 295

After resolving the following incident, which ongoing safeguard most directly prevents recurrence? An Athena query uses SELECT * on a wide Parquet table, although the report needs two measures and a date.

  1. Test on-call subscriptions and runbooks during pipeline release.
  2. Monitor end-to-end flow, not producer success alone.
  3. Monitor bytes scanned per report and require column selection in review.
  4. Record recipe revision and project ownership in pipeline manifests.

Explanation

Correct Answer

C:

Monitor bytes scanned per report and require column selection in review. This safeguards against a recurring cause: The query unnecessarily reads columns beyond its actual projection.

Incorrect Answers

A:

That safeguard addresses another case: A Glue job has failed for three mornings but no CloudWatch alarm exists, so dashboards show stale data. It is not the control for this recurring failure.

B:

That safeguard addresses another case: A Kinesis stream is receiving writes but downstream analytics remain empty after the consumer IAM role lost read permission. It is not the control for this recurring failure.

D:

That safeguard addresses another case: A Glue DataBrew recipe was changed interactively but the production pipeline still applies a previous published recipe version. It is not the control for this recurring failure.

Question 296

A pipeline calls an AWS SDK to invoke Glue but drops the request token on network timeout and starts duplicate ETL runs. Select THREE complementary measures that correctly repair and validate, and prevent recurrence of this failure.

  1. Examine iterator age, shard utilization, downstream latency and consumer parallelism.
  2. Persist business run IDs and query existing job state before retrying execution creation.
  3. Treat any SDK timeout as proof a new job never started.
  4. A forced timeout leads to one accepted logical batch and auditable retries.
  5. A forced retry produces totals matching an independent known fixture.
  6. Test idempotency and unknown-success network failure scenarios.

Explanation

Correct Answers

B:

Persist business run IDs and query existing job state before retrying execution creation. The underlying cause is: The caller lacks a durable run identity and reconciliation on uncertain acknowledgement.

D:

A forced timeout leads to one accepted logical batch and auditable retries. This is the observable result required before accepting the correction.

F:

Test idempotency and unknown-success network failure scenarios. This protects against the following risk: The caller lacks a durable run identity and reconciliation on uncertain acknowledgement.

Incorrect Answers

A:

That corrective action is for a different case: A Kinesis consumer reports healthy CPU yet its IteratorAge grows for hours during normal traffic. It does not resolve this incident.

C:

Treat any SDK timeout as proof a new job never started. That shortcut conflicts with the stated requirement.

E:

This would validate a different case: A Spark aggregation produces incorrect category totals because one hot key is dropped after a task retry and the target doesn't reconcile. It does not verify the outcome required here.

Question 297

A data lake copies SSE-KMS objects across AWS accounts but the destination principal cannot decrypt the replica. Select THREE complementary measures that correctly repair and validate, and prevent recurrence of this failure.

  1. Test encrypted cross-account replication with intended and forbidden principals.
  2. Apply supported column-level permissions or a governed aggregate view and deny raw salary access.
  3. The authorized destination role reads replicas and unapproved accounts remain denied.
  4. Make the customer-managed key publicly decryptable.
  5. Configure supported KMS key policy, IAM and replication encryption settings for the intended accounts.
  6. A controlled decrypt action can be attributed to the intended assumed role.

Explanation

Correct Answers

A:

Test encrypted cross-account replication with intended and forbidden principals. This protects against the following risk: Cross-account cryptographic key and replica policies do not match the consumer identities.

C:

The authorized destination role reads replicas and unapproved accounts remain denied. This is the observable result required before accepting the correction.

E:

Configure supported KMS key policy, IAM and replication encryption settings for the intended accounts. The underlying cause is: Cross-account cryptographic key and replica policies do not match the consumer identities.

Incorrect Answers

B:

That corrective action is for a different case: A Lake Formation table exposes a private salary column through a broad Athena SELECT grant when an analyst needs only aggregated headcount. It does not resolve this incident.

D:

Make the customer-managed key publicly decryptable. That shortcut conflicts with the stated requirement.

F:

This would validate a different case: An ETL role invokes KMS Decrypt repeatedly, but the pipeline's incident review examines only application logs without recording AWS API actor identity. It does not verify the outcome required here.

Question 298

A team applies a reviewed fix for this situation: A nightly lake job publishes versioned S3 snapshots but deletes all old snapshots before the replacement is fully validated. Which observed outcome would most convincingly validate the fix?

  1. An injected failed publish leaves the last approved snapshot accessible.
  2. Planning overhead falls while required rollback snapshots remain available.
  3. A test order maps to exactly the customer attributes valid at transaction time.
  4. A test with a banner row keeps numeric fields correctly typed and records the reject.

Explanation

Correct Answer

A:

An injected failed publish leaves the last approved snapshot accessible. This verifies the result of use staged validation and controlled retention/cleanup of replaced snapshots.

Incorrect Answers

B:

This would verify another situation: An Iceberg table's snapshot history grows as frequent small commits accumulate and query planning becomes slow. It does not validate the current case.

C:

This would verify another situation: A warehouse fact table is joined to customer history using only customer ID, multiplying matches across changing customer versions. It does not validate the current case.

D:

This would verify another situation: A crawler changes a decimal sales column to string after encountering a nonnumeric banner row in one export. It does not validate the current case.

Question 299

After resolving the following incident, which ongoing safeguard most directly prevents recurrence? A data lake in an EU Region replicates raw customer records to an unapproved Region for convenience.

  1. Maintain and test account/Region audit coverage inventories.
  2. Test transport security separately from storage encryption.
  3. Add direct-versus-view access checks for sensitive attributes.
  4. Enforce residency rules in IaC/policy checks and governance reviews.

Explanation

Correct Answer

D:

Enforce residency rules in IaC/policy checks and governance reviews. This safeguards against a recurring cause: Replication destination conflicts with the required data sovereignty boundary.

Incorrect Answers

A:

That safeguard addresses another case: A CloudTrail Lake query lists IAM role changes but its event filter omits the Regions holding the relevant data pipelines. It is not the control for this recurring failure.

B:

That safeguard addresses another case: An S3 export writes regulated data to an unencrypted partner endpoint despite source-at-rest SSE-KMS protection. It is not the control for this recurring failure.

C:

That safeguard addresses another case: A Redshift view exposes unmasked customer SSNs to a general BI role despite a requirement for partial disclosure. It is not the control for this recurring failure.

Question 300

An S3 data-access investigation searches CloudTrail for object reads but only management events were enabled. Which engineering change best addresses the underlying issue?

  1. Configure the intended Lambda execution role with scoped API permissions.
  2. Assign supported domain/project membership and dataset entitlements through reviewed workflows.
  3. Grant scoped Lake Formation SELECT and required catalog permissions to the authorized principal.
  4. Enable reviewed CloudTrail data events for the required S3 buckets or prefixes.

Explanation

Correct Answer

D:

Enable reviewed CloudTrail data events for the required S3 buckets or prefixes. It directly addresses the case cause (Object-level S3 reads require appropriate data-event collection scope.) and should be verified by: A controlled object read produces a traceable data event with expected context.

Incorrect Answers

A:

That change addresses a Lambda data extractor assumes an EC2 instance profile is available when running as a Lambda function; it would not repair this incident.

B:

That change addresses an admin provisions a SageMaker Unified Studio project but the intended team cannot open governed domain assets despite being added to a general account group; it would not repair this incident.

C:

That change addresses a Lake Formation-enabled S3 table is visible in Glue Data Catalog, but Athena SELECT is denied to the analyst role; it would not repair this incident.

AWS Certified Data Engineer - Associate DEA-C01 Practice Tests

UP

SPECIAL OFFER: GET 10% OFF

This is ONE TIME OFFER

ExamSnap Discount Offer
Enter Your Email Address to Receive Your 10% Off Discount Code

A confirmation link will be sent to this email address to verify your login. *We value your privacy. We will not rent or sell your email address.

Download Free Demo of VCE Exam Simulator

Experience Avanset VCE Exam Simulator for yourself.

Simply submit your e-mail address below to get started with our interactive software demo of your free trial.

Free Demo Limits: In the demo version you will be able to access only first 5 questions from exam.