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 29

Question 280

A team applies a reviewed fix for this situation: A Glue data quality rule checks only that an email column is nonnull but accepts invalid malformed addresses. Which observed outcome would most convincingly validate the fix?

  1. Execution plan and runtime return within accepted bounds with identical answers.
  2. A completed upstream fixture unblocks the DAG while failures follow the error path.
  3. Malformed fixture values fail quality checks without discarding unrelated valid records.
  4. Long-running tasks improve without changing aggregate results.

Explanation

Correct Answer

C:

Malformed fixture values fail quality checks without discarding unrelated valid records. This verifies the result of combine nullable, format, and authorized-value validation with appropriate error routing.

Incorrect Answers

A:

This would verify another situation: A Redshift reporting job suddenly spends time redistributing a large fact table after a schema change. It does not validate the current case.

B:

This would verify another situation: An MWAA scheduled data DAG waits forever for an upstream batch because the external task reports completion through a different status name. It does not validate the current case.

D:

This would verify another situation: An ETL task in Glue times out only when a small fraction of keys dominate the daily partition. It does not validate the current case.

Question 281

After resolving the following incident, which ongoing safeguard most directly prevents recurrence? An ETL task finishes but its success event omits the S3 prefix and schema version needed downstream.

  1. Version the ingestion schema and alert on incompatible type drift.
  2. Add grain and cardinality assertions after each flattening step.
  3. Prohibit unbounded collect operations in production ETL code reviews.
  4. Schema-check workflow handoffs and reject incomplete manifests.

Explanation

Correct Answer

D:

Schema-check workflow handoffs and reject incomplete manifests. This safeguards against a recurring cause: Workflow handoff lacks a complete machine-readable output contract.

Incorrect Answers

A:

That safeguard addresses another case: A Glue PySpark job fails when an upstream field changes from integer to string in some JSON documents. It is not the control for this recurring failure.

B:

That safeguard addresses another case: A Glue job reading nested JSON flattens arrays incorrectly and duplicates parent order totals. It is not the control for this recurring failure.

C:

That safeguard addresses another case: A distributed Spark process collects a large dataset to the driver and crashes from memory exhaustion. It is not the control for this recurring failure.

Question 282

A pipeline launches thousands of concurrent Step Functions Map tasks and saturates a small partner API. Which engineering change best addresses the underlying issue?

  1. Use supported Map maximum concurrency and explicit backoff to respect provider quotas.
  2. Right-size supported Lambda ephemeral storage or stream/process in bounded chunks.
  3. Check Glue connection subnet, ENIs, VPC routing, DNS, and the source's inbound rule.
  4. Refresh supported MSK bootstrap endpoints and validate client DNS, TLS, and network routes.

Explanation

Correct Answer

A:

Use supported Map maximum concurrency and explicit backoff to respect provider quotas. It directly addresses the case cause (Map concurrency is uncapped relative to external rate limits.) and should be verified by: Peak concurrent calls stay bounded and all tasks finish without escalating throttles.

Incorrect Answers

B:

That change addresses a Lambda ETL process writes temporary files larger than its configured /tmp capacity and receives storage errors; it would not repair this incident.

C:

That change addresses a Glue connection to a source RDS database times out, although the JDBC credentials are valid; it would not repair this incident.

D:

That change addresses an MSK producer succeeds only intermittently after brokers change because its connection string contains one retired broker address; it would not repair this incident.

Question 283

A Glue transform joins events to reference data refreshed weekly, but old events are silently reclassified on every rerun. Select THREE complementary measures that correctly repair and validate, and prevent recurrence of this failure.

  1. Commit source and deploy immutable versioned scripts through a controlled pipeline.
  2. Join by intended as-of validity and persist versioned reference mappings.
  3. The loader processes the complete expected byte count and checksum only once.
  4. Overwrite all historical labels with the newest mapping without review.
  5. Test point-in-time correctness with future reference updates.
  6. A replayed historical event receives its original applicable classification.

Explanation

Correct Answers

B:

Join by intended as-of validity and persist versioned reference mappings. The underlying cause is: Reference data lacks effective-date or historical snapshot semantics.

E:

Test point-in-time correctness with future reference updates. This protects against the following risk: Reference data lacks effective-date or historical snapshot semantics.

F:

A replayed historical event receives its original applicable classification. This is the observable result required before accepting the correction.

Incorrect Answers

A:

That corrective action is for a different case: A data engineering team manually changes Glue scripts on S3 without source control or a rollback identifier. It does not resolve this incident.

C:

This would validate a different case: A partner uploads a CSV over SFTP to Transfer Family but a load starts before the file finishes writing. It does not verify the outcome required here.

D:

Overwrite all historical labels with the newest mapping without review. That shortcut conflicts with the stated requirement.

Question 284

After resolving the following incident, which ongoing safeguard most directly prevents recurrence? An analyst creates a Glue DataBrew visual cleaning step that trims all leading zeros from product IDs, breaking lookups.

  1. Add join-cardinality and cost regression checks.
  2. Use key-format fixtures in data preparation recipes.
  3. Maintain release/version compatibility tests for third-party connectors.
  4. Compare query plans on major DDL/schema changes.

Explanation

Correct Answer

B:

Use key-format fixtures in data preparation recipes. This safeguards against a recurring cause: The transformation treats identifiers as numeric measures rather than text keys.

Incorrect Answers

A:

That safeguard addresses another case: A Glue job begins consuming twice its normal DPU budget after a transformation adds a repeated cross join. It is not the control for this recurring failure.

C:

That safeguard addresses another case: A data pipeline updates its Glue version but custom connector dependencies fail at initialization. It is not the control for this recurring failure.

D:

That safeguard addresses another case: A Redshift reporting job suddenly spends time redistributing a large fact table after a schema change. It is not the control for this recurring failure.

Question 285

An Athena query against a Lake Formation resource succeeds for the analyst, yet a separate Glue ETL role cannot read that same table. Which engineering change best addresses the underlying issue?

  1. Grant explicit least-privilege permissions to the Glue execution role and verify the data access path.
  2. Inventory staging artifacts and enforce approved secure cleanup/retention and access.
  3. Correlate CloudTrail and applicable KMS/service logs with job execution context.
  4. Publish ownership, purpose, classification and scoped project access before sharing.

Explanation

Correct Answer

A:

Grant explicit least-privilege permissions to the Glue execution role and verify the data access path. It directly addresses the case cause (Lake Formation grants and role identities are evaluated per workload principal.) and should be verified by: The approved Glue job reads its required table without inheriting analyst-admin rights.

Incorrect Answers

B:

That change addresses a lake-to-warehouse pipeline removes raw PII from visible tables but keeps an untracked temporary S3 staging prefix indefinitely; it would not repair this incident.

C:

That change addresses an ETL role invokes KMS Decrypt repeatedly, but the pipeline's incident review examines only application logs without recording AWS API actor identity; it would not repair this incident.

D:

That change addresses a SageMaker Catalog project shares a data product broadly across teams without recording owner and allowed purpose; it would not repair this incident.

Question 286

An S3 table is tagged `classification=restricted`, but its Lake Formation LF-Tag grant allows a broad organizational unit with no business need. Which technical dependency most directly explains this behavior?

  1. S3 object retrieval may also require KMS decrypt authorization for the encryption key.
  2. Cross-account cryptographic key and replica policies do not match the consumer identities.
  3. Data sharing lifecycle does not reflect approved contractual authorization.
  4. Attribute-based permissions have a policy scope broader than the approved audience.

Explanation

Correct Answer

D:

Attribute-based permissions have a policy scope broader than the approved audience. The corresponding fix is to narrow LF-Tag permissions to reviewed principals and classify data assets consistently.

Incorrect Answers

A:

This diagnosis addresses another AWS case: A Glue job reads an S3 object encrypted with a customer-managed KMS key and fails even though it has `s3:GetObject`. The dependency here is different.

B:

This diagnosis addresses another AWS case: A data lake copies SSE-KMS objects across AWS accounts but the destination principal cannot decrypt the replica. The dependency here is different.

C:

This diagnosis addresses another AWS case: A Redshift datashare grants partner analysts access to a customer data mart without a purpose or term limit. The dependency here is different.

Question 287

A partner API returns HTTP 429, and a Glue ETL job immediately retries in tight loops until access is suspended. Which engineering change best addresses the underlying issue?

  1. Configure validated subscriptions, policies and controlled test notifications.
  2. Apply bounded exponential backoff, jitter, and documented API quotas with durable checkpoints.
  3. Use deterministic batch output keys or conditional commits and reconcile existing results on retry.
  4. Persist scoped task-token correlation securely and use supported callback completion.

Explanation

Correct Answer

B:

Apply bounded exponential backoff, jitter, and documented API quotas with durable checkpoints. It directly addresses the case cause (Retry policy ignores rate limiting and server retry hints.) and should be verified by: A throttled test eventually completes without hammering the provider endpoint.

Incorrect Answers

A:

That change addresses a multi-account data pipeline sends operational alerts through an SNS topic that no engineer subscribes to; it would not repair this incident.

C:

That change addresses an orchestrator invokes a Lambda that writes to S3 then times out; the retry writes a second output under a new random key; it would not repair this incident.

D:

That change addresses a Step Functions Standard workflow waits for an external vendor callback but the task token is lost in logs; it would not repair this incident.

Question 288

A team applies a reviewed fix for this situation: A data engineering service uses one unrestricted role for production ETL, development notebooks and reporting. Which observed outcome would most convincingly validate the fix?

  1. Development cannot write production data while ETL still runs correctly.
  2. The approved role reads the encrypted object but cannot decrypt unrelated keys.
  3. The approved Glue job reads its required table without inheriting analyst-admin rights.
  4. The partner accesses only intended assets and access ends when approval expires.

Explanation

Correct Answer

A:

Development cannot write production data while ETL still runs correctly. This verifies the result of separate service roles and policies by environment, workload and required resources.

Incorrect Answers

B:

This would verify another situation: A Glue job reads an S3 object encrypted with a customer-managed KMS key and fails even though it has `s3:GetObject`. It does not validate the current case.

C:

This would verify another situation: An Athena query against a Lake Formation resource succeeds for the analyst, yet a separate Glue ETL role cannot read that same table. It does not validate the current case.

D:

This would verify another situation: A Redshift datashare grants partner analysts access to a customer data mart without a purpose or term limit. It does not validate the current case.

Question 289

A team applies a reviewed fix for this situation: A Glue connection to a source RDS database times out, although the JDBC credentials are valid. Which observed outcome would most convincingly validate the fix?

  1. A controlled JDBC connection from the Glue execution context succeeds.
  2. A mixed-currency fixture reproduces independently computed accepted totals.
  3. A failed release can restore the prior script and reproduce its output.
  4. An injected failure leaves no orphaned temporary cluster and preserves incident evidence.

Explanation

Correct Answer

A:

A controlled JDBC connection from the Glue execution context succeeds. This verifies the result of check Glue connection subnet, ENIs, VPC routing, DNS, and the source's inbound rule.

Incorrect Answers

B:

This would verify another situation: A batch ETL task combines USD and EUR amounts under the same column and computes invalid totals. It does not validate the current case.

C:

This would verify another situation: A data engineering team manually changes Glue scripts on S3 without source control or a rollback identifier. It does not validate the current case.

D:

This would verify another situation: A workflow that provisions a temporary staging cluster leaks resources after a later transform fails. It does not validate the current case.

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.

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.