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 27

Question 260

A Redshift star schema mixes order-line and order-header facts in the same table and reports double-count revenue. Which technical dependency most directly explains this behavior?

  1. The modeled fact grain is inconsistent across record types.
  2. Business catalog stewardship and access context have drifted from the source asset.
  3. The two metastore environments are not synchronized.
  4. Inconsistent metadata taxonomies prevent reliable automated governance.

Explanation

Correct Answer

A:

The modeled fact grain is inconsistent across record types. The corresponding fix is to separate or explicitly model fact grain and join to dimensions at compatible levels.

Incorrect Answers

B:

This diagnosis addresses another AWS case: A SageMaker Catalog project references a dataset whose owner changed but permissions and business definitions still point to the former team. The dependency here is different.

C:

This diagnosis addresses another AWS case: A Hive metastore-based EMR Spark job writes a new partition but Athena never sees it through Glue Data Catalog. The dependency here is different.

D:

This diagnosis addresses another AWS case: A data catalog stores PII labels only as free-text comments, so new tables bypass a tagging-based access process. The dependency here is different.

Question 261

After resolving the following incident, which ongoing safeguard most directly prevents recurrence? An S3 export writes regulated data to an unencrypted partner endpoint despite source-at-rest SSE-KMS protection.

  1. Review residency control coverage across data services after architecture changes.
  2. Use policy-simulator and negative-access tests during access changes.
  3. Test transport security separately from storage encryption.
  4. Review role ownership and permissions after organizational changes.

Explanation

Correct Answer

C:

Test transport security separately from storage encryption. This safeguards against a recurring cause: At-rest encryption does not secure data transmission on an external path.

Incorrect Answers

A:

That safeguard addresses another case: A project migrates its authoritative EU records to another AWS Region and management assumes an S3 bucket policy alone enforces future residency. It is not the control for this recurring failure.

B:

That safeguard addresses another case: An S3 lake access point exists but a cross-account principal still receives AccessDenied when its IAM and bucket policies are not aligned. It is not the control for this recurring failure.

D:

That safeguard addresses another case: A data engineering service uses one unrestricted role for production ETL, development notebooks and reporting. It is not the control for this recurring failure.

Question 262

Two Kinesis consumers must independently recover after a deployment, but one team reuses the other's checkpoint store. Which technical dependency most directly explains this behavior?

  1. Skewed join/group keys concentrate disproportionate workload in one task.
  2. Consumer applications share state intended to represent separate progress positions.
  3. Test coverage fails to represent the actual deployed interface.
  4. An unbounded driver collect breaks distributed processing assumptions.

Explanation

Correct Answer

B:

Consumer applications share state intended to represent separate progress positions. The corresponding fix is to separate durable per-application checkpoints and verify replay position semantics.

Incorrect Answers

A:

This diagnosis addresses another AWS case: An EMR Spark job sends all rows for a popular customer to one reducer and fails despite plenty of idle cores. The dependency here is different.

C:

This diagnosis addresses another AWS case: A code deployment changes an ETL function's parameter name but unit tests exercise only the old pipeline entry point. The dependency here is different.

D:

This diagnosis addresses another AWS case: A distributed Spark process collects a large dataset to the driver and crashes from memory exhaustion. The dependency here is different.

Question 263

Two developers independently edit Glue Data Catalog schema types during release, and a job fails after the last writer wins. Which engineering change best addresses the underlying issue?

  1. Restore a compatible snapshot/checkpoint pair and reconcile changes before resuming writes.
  2. Add correct scoped KMS decrypt permissions and key-policy authorization for the loading role.
  3. Use reviewed schema contracts and serialized catalog publication through CI.
  4. Validate retention requirements and apply supported retention/lock controls before approving lifecycle changes.

Explanation

Correct Answer

C:

Use reviewed schema contracts and serialized catalog publication through CI. It directly addresses the case cause (Concurrent metadata changes lack a controlled version/change process.) and should be verified by: A conflicting schema change is rejected before the production job runs.

Incorrect Answers

A:

That change addresses a cross-region disaster recovery table is restored from an old snapshot, and CDC replication starts from an incompatible new checkpoint; it would not repair this incident.

B:

That change addresses a Redshift COPY command reads encrypted S3 files but the IAM role lacks decryption permission for the customer KMS key; it would not repair this incident.

D:

That change addresses an S3 data product has an approved seven-year retention requirement, but an engineer adds a 30-day expiration lifecycle rule; it would not repair this incident.

Question 264

An SQS-backed processor overwhelms a downstream database after scaling consumers without any concurrency cap. Which engineering change best addresses the underlying issue?

  1. Inspect key distribution and apply skew-aware partitioning, salting, or alternate aggregation strategy.
  2. Set supported concurrency/batch controls and scale throughput using measured sink limits.
  3. Normalize arrays with stable parent identifiers and aggregate only at the intended business grain.
  4. Use nullable-aware extraction and document sensible default or reject handling per field.

Explanation

Correct Answer

B:

Set supported concurrency/batch controls and scale throughput using measured sink limits. It directly addresses the case cause (Queue-consumer concurrency exceeds the sink's sustainable write capacity.) and should be verified by: Backlog declines within SLA without excessive database connection or write failures.

Incorrect Answers

A:

That change addresses an EMR Spark job sends all rows for a popular customer to one reducer and fails despite plenty of idle cores; it would not repair this incident.

C:

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

D:

That change addresses an API payload includes optional addresses but a transformation fails when a nullable nested object is absent; it would not repair this incident.

Question 265

An EMR workflow submits five jobs simultaneously but two require the first job's generated HDFS staging output. Which technical dependency most directly explains this behavior?

  1. Workflow execution order lacks explicit job dependencies.
  2. The data quality contract omits numeric precision and tolerance.
  3. Operational log retention is not aligned with audit or incident policy.
  4. Changed query logic multiplies intermediate data and compute cost.

Explanation

Correct Answer

A:

Workflow execution order lacks explicit job dependencies. The corresponding fix is to express ordered execution or an appropriate DAG with artifact-ready checks.

Incorrect Answers

B:

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 Lambda processor logs errors but its CloudWatch Logs retention is shorter than the postmortem evidence requirement. The dependency here is different.

D:

This diagnosis addresses another AWS case: A Glue job begins consuming twice its normal DPU budget after a transformation adds a repeated cross join. The dependency here is different.

Question 266

A batch import uses a Lambda in a private subnet that cannot reach S3 because no NAT or S3 endpoint path is configured. Which engineering change best addresses the underlying issue?

  1. Publish versioned manifest metadata containing output location, partition, checksum, and schema identity.
  2. Inspect DAG import errors and validate packaging dependencies before deployment.
  3. Inspect key distribution and apply skew-aware partitioning, salting, or alternate aggregation strategy.
  4. Configure a supported S3 VPC endpoint or justified outbound path with required IAM and endpoint policies.

Explanation

Correct Answer

D:

Configure a supported S3 VPC endpoint or justified outbound path with required IAM and endpoint policies. It directly addresses the case cause (VPC routing and endpoint access do not support the intended AWS service call.) and should be verified by: The Lambda retrieves the intended object without an unrestricted internet route.

Incorrect Answers

A:

That change addresses an ETL task finishes but its success event omits the S3 prefix and schema version needed downstream; it would not repair this incident.

B:

That change addresses an MWAA DAG was deployed but its Python import fails, so no scheduled run appears; it would not repair this incident.

C:

That change addresses an EMR Spark job sends all rows for a popular customer to one reducer and fails despite plenty of idle cores; it would not repair this incident.

Question 267

A tokenization pipeline uses a deterministic unkeyed hash on low-entropy postal identifiers and calls them irreversibly anonymous. Select TWO complementary measures that correctly repair and validate this failure.

  1. Narrow bucket and access-point resource ARNs and test effective explicit deny boundaries.
  2. A sample output meets organizational reidentification risk requirements.
  3. Apply an approved privacy design with keyed tokenization or stronger controls and threat modeling.
  4. The report job reads its approved prefix but payroll reads fail.
  5. Publish hashes alongside the complete lookup dictionary.

Explanation

Correct Answers

B:

A sample output meets organizational reidentification risk requirements. This is the observable result required before accepting the correction.

C:

Apply an approved privacy design with keyed tokenization or stronger controls and threat modeling. The underlying cause is: Low-entropy fields remain vulnerable to dictionary reversal despite hashing.

Incorrect Answers

A:

That corrective action is for a different case: A data access policy permits all S3 prefixes under `reports/*`, unintentionally including payroll records stored beneath that path. It does not resolve this incident.

D:

This would validate a different case: A data access policy permits all S3 prefixes under `reports/*`, unintentionally including payroll records stored beneath that path. It does not verify the outcome required here.

E:

Publish hashes alongside the complete lookup dictionary. That shortcut conflicts with the stated requirement.

Question 268

A partner uploads a CSV over SFTP to Transfer Family but a load starts before the file finishes writing. Select THREE complementary measures that correctly repair and validate, and prevent recurrence of this failure.

  1. Require delivery manifests and replay-safe keys for partner batches.
  2. Use supported Map maximum concurrency and explicit backoff to respect provider quotas.
  3. Consume a supported completion event or atomic finalized object naming before ingestion.
  4. The loader processes the complete expected byte count and checksum only once.
  5. Only permitted attributes enter the model request and classification remains usable.
  6. Interpret an object's first visibility as proof the transfer is complete.

Explanation

Correct Answers

A:

Require delivery manifests and replay-safe keys for partner batches. This protects against the following risk: The consuming workflow lacks a reliable transfer-completion boundary.

C:

Consume a supported completion event or atomic finalized object naming before ingestion. The underlying cause is: The consuming workflow lacks a reliable transfer-completion boundary.

D:

The loader processes the complete expected byte count and checksum only once. This is the observable result required before accepting the correction.

Incorrect Answers

B:

That corrective action is for a different case: A pipeline launches thousands of concurrent Step Functions Map tasks and saturates a small partner API. It does not resolve this incident.

E:

This would validate a different case: An ETL pipeline calls a Bedrock model on full records containing account secrets merely to extract public product categories. It does not verify the outcome required here.

F:

Interpret an object's first visibility as proof the transfer is complete. That shortcut conflicts with the stated requirement.

Question 269

A team applies a reviewed fix for this situation: A personal-data deletion request removes a row from an Athena external table view but leaves original S3 objects and downstream extracts. Which observed outcome would most convincingly validate the fix?

  1. A controlled test subject is absent from eligible data products after verified deletion.
  2. The job writes only its registered approved table location.
  3. The analyst queries permitted columns while sensitive excluded fields remain inaccessible.
  4. An authorized consumer principal can resolve and read the shared table.

Explanation

Correct Answer

A:

A controlled test subject is absent from eligible data products after verified deletion. This verifies the result of locate affected source and derivative assets via lineage and apply approved deletion/retention policy.

Incorrect Answers

B:

This would verify another situation: An AWS Glue job writes to a governed S3 target but lacks the Lake Formation data-location access permission required for its workflow. It does not validate the current case.

C:

This would verify another situation: A Lake Formation-enabled S3 table is visible in Glue Data Catalog, but Athena SELECT is denied to the analyst role. It does not validate the current case.

D:

This would verify another situation: A cross-account Lake Formation share is granted but the consumer account has not accepted its RAM invitation where required. It does not validate the current case.

Question 270

After resolving the following incident, which ongoing safeguard most directly prevents recurrence? An MWAA DAG was deployed but its Python import fails, so no scheduled run appears.

  1. Require DAG import and syntax checks in CI.
  2. Review retention and recovery objectives whenever downstream processing latency changes.
  3. Record expected grain for every output fact table.
  4. Measure freshness and refresh overhead before materialization.

Explanation

Correct Answer

A:

Require DAG import and syntax checks in CI. This safeguards against a recurring cause: The scheduler cannot parse the DAG file and therefore cannot schedule its tasks.

Incorrect Answers

B:

That safeguard addresses another case: A fraud detector needs to reread yesterday's Kinesis records but the stream uses its short default retention window. It is not the control for this recurring failure.

C:

That safeguard addresses another case: A nightly aggregation counts an order once per status-change event rather than once per order ID. It is not the control for this recurring failure.

D:

That safeguard addresses another case: A Redshift transformation materializes a complex subquery repeatedly in one reporting workflow and exceeds its compute budget. It is not the control for this recurring failure.

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.