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 49

Question 480

A QuickSight dashboard compares two branch cost reports, one in local currency and one in USD, without conversion. Which technical dependency most directly explains this behavior?

  1. Failure evidence is lost with ephemeral compute nodes.
  2. The changed table layout or join pattern increases data movement.
  3. Visualization dimensions and units are inconsistent between sources.
  4. The workflow has no buffering or explicit throughput regulation at the ingress boundary.

Explanation

Correct Answer

C:

Visualization dimensions and units are inconsistent between sources. The corresponding fix is to normalize currencies using approved rates and label dates, units and calculation rules.

Incorrect Answers

A:

This diagnosis addresses another AWS case: An EMR job intermittently fails due to capacity interruptions but its logs are stored only on the terminated instance. The dependency here is different.

B:

This diagnosis addresses another AWS case: A Redshift reporting job suddenly spends time redistributing a large fact table after a schema change. The dependency here is different.

D:

This diagnosis addresses another AWS case: An orchestrated data processing task receives tens of thousands of S3 events, causing Lambda reserved concurrency exhaustion. The dependency here is different.

Question 481

Two Athena workgroups query identically named tables but one references a different data catalog and gets old records. Which engineering change best addresses the underlying issue?

  1. Choose an appropriately modeled DynamoDB or other eligible low-latency store with measured capacity.
  2. Qualify or configure the intended catalog/database and verify metadata references.
  3. Measure query plans and evaluate AUTO or an appropriate event-time sort design.
  4. Use a supported ETL/write path to update the authoritative source, then refresh catalog metadata.

Explanation

Correct Answer

B:

Qualify or configure the intended catalog/database and verify metadata references. It directly addresses the case cause (Query context includes the catalog and database, not just table name.) and should be verified by: Both controlled queries return the expected published dataset version.

Incorrect Answers

A:

That change addresses an online session store uses S3 object listing as a low-latency millisecond key lookup service and response times are erratic; it would not repair this incident.

C:

That change addresses a fact table in Redshift filters mostly on event date but load order does not correlate with the filter, driving wide block scans; it would not repair this incident.

D:

That change addresses a Redshift query joins external and local datasets but expects Spectrum to automatically overwrite remote S3 data during UPDATE; it would not repair this incident.

Question 482

A pipeline uses long-lived IAM user access keys embedded in a Glue script instead of an execution role. Select TWO complementary measures that correctly repair and validate this failure.

  1. Use an AWS Glue service role and approved short-lived credentials instead of hard-coded keys.
  2. The job operates without embedded secrets and permissions stay narrowly scoped.
  3. Copy a production access key into every developer notebook.
  4. After a test run, temporary sensitive artifacts are removed or retained only under policy.
  5. Grant scoped Lake Formation SELECT and required catalog permissions to the authorized principal.

Explanation

Correct Answers

A:

Use an AWS Glue service role and approved short-lived credentials instead of hard-coded keys. The underlying cause is: Static credentials create unnecessary exposure and rotation burden.

B:

The job operates without embedded secrets and permissions stay narrowly scoped. This is the observable result required before accepting the correction.

Incorrect Answers

C:

Copy a production access key into every developer notebook. That shortcut conflicts with the stated requirement.

D:

This would validate a different case: A lake-to-warehouse pipeline removes raw PII from visible tables but keeps an untracked temporary S3 staging prefix indefinitely. It does not verify the outcome required here.

E:

That corrective action is for a different case: A Lake Formation-enabled S3 table is visible in Glue Data Catalog, but Athena SELECT is denied to the analyst role. It does not resolve this incident.

Question 483

A team applies a reviewed fix for this situation: A Glue processing library has no pinned dependency versions and a release pulls a new incompatible parser. Which observed outcome would most convincingly validate the fix?

  1. A multi-status order contributes exactly one order to the verified report.
  2. Multiple tasks use the available cluster and total runtime improves.
  3. A rebuild reproduces the tested parser and expected input transformation.
  4. Critical orders stay within latency SLA during a backfill rehearsal.

Explanation

Correct Answer

C:

A rebuild reproduces the tested parser and expected input transformation. This verifies the result of pin and test dependency versions within the supported Glue runtime and publish a locked artifact.

Incorrect Answers

A:

This would verify another situation: A nightly aggregation counts an order once per status-change event rather than once per order ID. It does not validate the current case.

B:

This would verify another situation: A data transformation uses one Spark partition for a terabyte input and only one executor stays busy. It does not validate the current case.

D:

This would verify another situation: A large historical data export shares the same small API rate limit as near-real-time orders and delays critical events. It does not validate the current case.

Question 484

After resolving the following incident, which ongoing safeguard most directly prevents recurrence? A Spark aggregation produces incorrect category totals because one hot key is dropped after a task retry and the target doesn't reconcile.

  1. Review partition and frame definitions for each analytic window.
  2. Review service log-retention settings when compliance requirements change.
  3. Track cardinality and group-level drift in quality dashboards.
  4. Add join-cardinality and cost regression checks.

Explanation

Correct Answer

C:

Track cardinality and group-level drift in quality dashboards. This safeguards against a recurring cause: Pipeline retry handling and final quality checks do not preserve all expected groups.

Incorrect Answers

A:

That safeguard addresses another case: A Redshift window query uses SUM without the intended PARTITION BY and produces one cumulative total over all tenants. It is not the control for this recurring failure.

B:

That safeguard addresses another case: A Lambda processor logs errors but its CloudWatch Logs retention is shorter than the postmortem evidence requirement. It is not the control for this recurring failure.

D:

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.

Question 485

After resolving the following incident, which ongoing safeguard most directly prevents recurrence? An Athena Spark notebook reads only a handful of development files yet a manager interprets its average as an entire production trend.

  1. Document sampling design and population coverage in analysis artifacts.
  2. Define alarm thresholds using service objectives and error budgets.
  3. Test workflow reachability and trigger states after DAG edits.
  4. Alert on sustained age relative to data freshness and retention.

Explanation

Correct Answer

A:

Document sampling design and population coverage in analysis artifacts. This safeguards against a recurring cause: The sample does not represent the target population and interval.

Incorrect Answers

B:

That safeguard addresses another case: A monitoring rule sees one Athena query failure and pages the full team despite a known transient backend retry. It is not the control for this recurring failure.

C:

That safeguard addresses another case: An engineer adds a new processing step to an AWS Glue workflow but never connects its trigger to the existing dependency chain. It is not the control for this recurring failure.

D:

That safeguard addresses another case: A Kinesis consumer reports healthy CPU yet its IteratorAge grows for hours during normal traffic. It is not the control for this recurring failure.

Question 486

A Firehose transformation Lambda returns malformed record status envelopes and some messages enter an error prefix. Which engineering change best addresses the underlying issue?

  1. Configure appropriate reserved/provisioned concurrency and buffer events to match sustainable throughput.
  2. Normalize arrays with stable parent identifiers and aggregate only at the intended business grain.
  3. Apply a defined typed schema, normalize units, and retain raw payloads for replay.
  4. Return correctly structured transformed records and audit failure routing.

Explanation

Correct Answer

D:

Return correctly structured transformed records and audit failure routing. It directly addresses the case cause (The transformation response does not comply with the expected record IDs, data encoding, and result status.) and should be verified by: Controlled valid, malformed, and retry inputs end at their intended S3 destinations.

Incorrect Answers

A:

That change addresses a Lambda ETL function exhausts concurrency during a flash sale, causing fresh events to be throttled; it would not repair this incident.

B:

That change addresses a Glue job reading nested JSON flattens arrays incorrectly and duplicates parent order totals; it would not repair this incident.

C:

That change addresses a clickstream pipeline converts all nested attributes to strings before storage, making numeric analytics unreliable; it would not repair this incident.

Question 487

A pipeline calls an AWS SDK to invoke Glue but drops the request token on network timeout and starts duplicate ETL runs. Which technical dependency most directly explains this behavior?

  1. The data quality contract omits numeric precision and tolerance.
  2. The caller lacks a durable run identity and reconciliation on uncertain acknowledgement.
  3. Stream producer health is separate from the consumer's authorization and processing.
  4. Object existence alone does not prove the current scheduled partition is fresh.

Explanation

Correct Answer

B:

The caller lacks a durable run identity and reconciliation on uncertain acknowledgement. The corresponding fix is to persist business run IDs and query existing job state before retrying execution creation.

Incorrect Answers

A:

This diagnosis addresses another AWS case: An upstream system changes a decimal field from two to four digits of precision and rounding introduces revenue drift. The dependency here is different.

C:

This diagnosis addresses another AWS case: A Kinesis stream is receiving writes but downstream analytics remain empty after the consumer IAM role lost read permission. The dependency here is different.

D:

This diagnosis addresses another AWS case: A daily S3 data lake output is present but the last successful ETL timestamp is two days old. The dependency here is different.

Question 488

A Lambda ETL function exhausts concurrency during a flash sale, causing fresh events to be throttled. Select TWO complementary measures that correctly repair and validate this failure.

  1. Injected cancelled and failed jobs exit with correctly classified outcomes.
  2. Set function timeout to maximum to eliminate concurrent invocation throttling.
  3. Configure appropriate reserved/provisioned concurrency and buffer events to match sustainable throughput.
  4. A load rehearsal stays within accepted throttle and freshness targets.
  5. Use supported batching, buffering, compaction, or columnar write paths appropriate to latency.

Explanation

Correct Answers

C:

Configure appropriate reserved/provisioned concurrency and buffer events to match sustainable throughput. The underlying cause is: Invocation concurrency is not budgeted against account capacity and downstream rate limits.

D:

A load rehearsal stays within accepted throttle and freshness targets. This is the observable result required before accepting the correction.

Incorrect Answers

A:

This would validate a different case: A workflow branches on a job-status string but overlooks the Cancelled terminal state, leaving executions stuck. It does not verify the outcome required here.

B:

Set function timeout to maximum to eliminate concurrent invocation throttling. That shortcut conflicts with the stated requirement.

E:

That corrective action is for a different case: A Lambda process writes individual small S3 JSON files for millions of events and downstream scans slow dramatically. It does not resolve this incident.

Question 489

After resolving the following incident, which ongoing safeguard most directly prevents recurrence? A Redshift view exposes unmasked customer SSNs to a general BI role despite a requirement for partial disclosure.

  1. Add direct-versus-view access checks for sensitive attributes.
  2. Map required change evidence to the appropriate audit services.
  3. Keep lineage-based deletion runbooks and retention-exception records.
  4. Include negative column-access tests in governed dataset onboarding.

Explanation

Correct Answer

A:

Add direct-versus-view access checks for sensitive attributes. This safeguards against a recurring cause: The published data access layer does not implement required masking or view restrictions.

Incorrect Answers

B:

That safeguard addresses another case: An AWS Config rule flags altered S3 encryption settings but the team uses CloudTrail alone as its continuous current-state configuration inventory. It is not the control for this recurring failure.

C:

That safeguard addresses another case: A personal-data deletion request removes a row from an Athena external table view but leaves original S3 objects and downstream extracts. It is not the control for this recurring failure.

D:

That safeguard addresses another case: A Lake Formation table exposes a private salary column through a broad Athena SELECT grant when an analyst needs only aggregated headcount. It is not the control for this recurring failure.

Question 490

A team applies a reviewed fix for this situation: An EMR workflow submits five jobs simultaneously but two require the first job's generated HDFS staging output. Which observed outcome would most convincingly validate the fix?

  1. The dashboard marks stale partitions before consumers treat them as current.
  2. Long-running tasks improve without changing aggregate results.
  3. Malformed fixture values fail quality checks without discarding unrelated valid records.
  4. Consumers start only after the upstream staging output is committed.

Explanation

Correct Answer

D:

Consumers start only after the upstream staging output is committed. This verifies the result of express ordered execution or an appropriate DAG with artifact-ready checks.

Incorrect Answers

A:

This would verify another situation: A daily S3 data lake output is present but the last successful ETL timestamp is two days old. It does not validate the current case.

B:

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.

C:

This would verify another situation: A Glue data quality rule checks only that an email column is nonnull but accepts invalid malformed addresses. It does not validate the current case.

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.