100% Latest & Updated Amazon AWS Certified Data Engineer - Associate DEA-C01 Practice Test Questions, Exam Dumps & Verified Answers!
30 Days Free Updates, Instant Download!
Question 450
After resolving the following incident, which ongoing safeguard most directly prevents recurrence? A cross-account Lake Formation share is granted but the consumer account has not accepted its RAM invitation where required.
- Add direct-versus-view access checks for sensitive attributes.
- Maintain and test account/Region audit coverage inventories.
- Review residency control coverage across data services after architecture changes.
- Add cross-account acceptance and resource-link tests to onboarding.
Explanation
Correct Answer
D:Add cross-account acceptance and resource-link tests to onboarding. This safeguards against a recurring cause: Cross-account resource sharing has a recipient-side acceptance and grant step.
Incorrect Answers
A: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.
B: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.
C: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.
Question 451
A team applies a reviewed fix for this situation: A production Glue workflow receives the same completed-file notification twice and creates two warehouse loads. Which observed outcome would most convincingly validate the fix?
- Object counts decrease while all events remain available and fresh enough.
- Duplicate notifications create one committed warehouse batch and auditable duplicate attempts.
- The published job serializes work to executors and produces correct output.
- Price and duration fields support correct arithmetic on known test rows.
Explanation
Correct Answer
B:Duplicate notifications create one committed warehouse batch and auditable duplicate attempts. This verifies the result of use a stable manifest identifier with transactional state before launching or committing loads.
Incorrect Answers
A:This would verify another situation: A Lambda process writes individual small S3 JSON files for millions of events and downstream scans slow dramatically. It does not validate the current case.
C:This would verify another situation: A team changes an analytics library but releases a job without checking distributed task serialization compatibility. It does not validate the current case.
D:This would verify another situation: A clickstream pipeline converts all nested attributes to strings before storage, making numeric analytics unreliable. It does not validate the current case.
Question 452
A Lambda data extractor assumes an EC2 instance profile is available when running as a Lambda function. Which engineering change best addresses the underlying issue?
- Confirm CloudTrail delivery, then repair Athena catalog partitions or approved projection.
- Configure the intended Lambda execution role with scoped API permissions.
- Apply approved tokenization, masking, or projection before data exits the trusted boundary.
- Complete supported AWS RAM share acceptance and consumer-side permission delegation.
Explanation
Correct Answer
B:Configure the intended Lambda execution role with scoped API permissions. It directly addresses the case cause (The runtime identity is supplied by the Lambda execution role, not a host instance profile.) and should be verified by: A controlled invocation succeeds only for authorized source actions.
Incorrect Answers
A:That change addresses an Athena query for CloudTrail logs shows a missing day because the log data lake partitions were never registered; it would not repair this incident.
C:That change addresses a DynamoDB-backed application needs to redact sensitive values before exporting analytics but relies only on table encryption; it would not repair this incident.
D:That change addresses a cross-account Lake Formation share is granted but the consumer account has not accepted its RAM invitation where required; it would not repair this incident.
Question 453
A Step Functions run is marked succeeded although a downstream notification publish fails and no incident ticket is opened. Which technical dependency most directly explains this behavior?
- The workflow's sensor condition does not match the actual upstream terminal status.
- Visualization dimensions and units are inconsistent between sources.
- SQL window scope does not match the required per-tenant aggregation.
- The workflow's success criteria omit an operationally required delivery dependency.
Explanation
Correct Answer
D:The workflow's success criteria omit an operationally required delivery dependency. The corresponding fix is to model the notification as a checked task with failure handling or durable outbox.
Incorrect Answers
A:This diagnosis addresses another AWS case: An MWAA scheduled data DAG waits forever for an upstream batch because the external task reports completion through a different status name. The dependency here is different.
B:This diagnosis addresses another AWS case: A QuickSight dashboard compares two branch cost reports, one in local currency and one in USD, without conversion. The dependency here is different.
C:This diagnosis addresses another AWS case: A Redshift window query uses SUM without the intended PARTITION BY and produces one cumulative total over all tenants. The dependency here is different.
Question 454
A team applies a reviewed fix for this situation: A Redshift COPY import fails on a changed date format in one batch even though prior files loaded. Which observed outcome would most convincingly validate the fix?
- Valid dates load accurately and malformed rows are recorded for repair.
- Cross-region events land in the correct expected hourly event-time partitions.
- Producer reconnects and publishes through broker failover without hard-coded single-host dependency.
- Driver memory remains stable while full dataset results are produced.
Explanation
Correct Answer
A:Valid dates load accurately and malformed rows are recorded for repair. This verifies the result of validate upstream schema and use appropriate supported COPY date parsing or a staging correction.
Incorrect Answers
B:This would verify another situation: A data ingestion service accepts API JSON but passes inconsistent event time zones to downstream partitions. It does not validate the current case.
C:This would verify another situation: An MSK producer succeeds only intermittently after brokers change because its connection string contains one retired broker address. It does not validate the current case.
D:This would verify another situation: A distributed Spark process collects a large dataset to the driver and crashes from memory exhaustion. It does not validate the current case.
Question 455
After resolving the following incident, which ongoing safeguard most directly prevents recurrence? A workflow branches on a job-status string but overlooks the Cancelled terminal state, leaving executions stuck.
- Version and validate the event envelope contract at ingestion.
- Apply schema and timestamp quality tests at ingress.
- Define a producer completion contract and deduplicate notifications.
- Check service response enums when revising orchestration logic.
Explanation
Correct Answer
D:Check service response enums when revising orchestration logic. This safeguards against a recurring cause: The state machine lacks complete terminal-status handling.
Incorrect Answers
A:That safeguard addresses another case: A mobile event producer uses timestamp as the only deduplication key and collapses unrelated events recorded in one millisecond. It is not the control for this recurring failure.
B:That safeguard addresses another case: A data ingestion service accepts API JSON but passes inconsistent event time zones to downstream partitions. It is not the control for this recurring failure.
C:That safeguard addresses another case: An S3 event notification triggers Glue for every file of a large export, producing hundreds of competing jobs. It is not the control for this recurring failure.
Question 456
A Lambda process writes individual small S3 JSON files for millions of events and downstream scans slow dramatically. Which technical dependency most directly explains this behavior?
- Linear repeated lookups are inefficient for a high-cardinality membership workload.
- Airflow task failure handling does not match known transient dependency behavior.
- Consumer applications share state intended to represent separate progress positions.
- Excessive small objects create metadata and planning overhead.
Explanation
Correct Answer
D:Excessive small objects create metadata and planning overhead. The corresponding fix is to use supported batching, buffering, compaction, or columnar write paths appropriate to latency.
Incorrect Answers
A:This diagnosis addresses another AWS case: A large ETL data structure uses a list for repeated membership checks and CPU use grows unexpectedly. The dependency here is different.
B:This diagnosis addresses another AWS case: An AWS MWAA DAG has no task-level retries or SLA alerts, and a brief Glue API throttle causes a missed daily close. The dependency here is different.
C:This diagnosis addresses another AWS case: Two Kinesis consumers must independently recover after a deployment, but one team reuses the other's checkpoint store. The dependency here is different.
Question 457
A cross-region disaster recovery table is restored from an old snapshot, and CDC replication starts from an incompatible new checkpoint. Which engineering change best addresses the underlying issue?
- Join using correct surrogate keys or as-of effective dates for SCD history.
- Restrict crawler targets, table prefixes and schema-change behavior to approved locations.
- Choose an appropriately modeled DynamoDB or other eligible low-latency store with measured capacity.
- Restore a compatible snapshot/checkpoint pair and reconcile changes before resuming writes.
Explanation
Correct Answer
D:Restore a compatible snapshot/checkpoint pair and reconcile changes before resuming writes. It directly addresses the case cause (Recovery snapshot and change-stream offsets do not represent a consistent recovery point.) and should be verified by: The recovered dataset has no unaccounted change gap or duplicate commits.
Incorrect Answers
A:That change addresses a warehouse fact table is joined to customer history using only customer ID, multiplying matches across changing customer versions; it would not repair this incident.
B:That change addresses a Glue crawler crawls the entire lake for every hourly feed and adds unexpected tables from temporary staging prefixes; it would not repair this incident.
C: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.
Question 458
A daily sensor batch is duplicated after retry, causing every aggregate event count to double. Select THREE complementary measures that correctly repair and validate, and prevent recurrence of this failure.
- Deduplicate on timestamp alone and discard simultaneous legitimate events.
- Deduplicate on a documented source event key and verify idempotent load state.
- Add duplicate-key checks and replay tests to ingestion quality gates.
- A simulated missed load triggers a delivered alert before the data SLA expires.
- A repeated batch does not change the accepted distinct event count.
- Keep identifiers typed as strings and apply field-specific whitespace rules only.
Explanation
Correct Answers
B:Deduplicate on a documented source event key and verify idempotent load state. The underlying cause is: The pipeline lacks stable event-level uniqueness validation.
C:Add duplicate-key checks and replay tests to ingestion quality gates. This protects against the following risk: The pipeline lacks stable event-level uniqueness validation.
E:A repeated batch does not change the accepted distinct event count. This is the observable result required before accepting the correction.
Incorrect Answers
A:Deduplicate on timestamp alone and discard simultaneous legitimate events. That shortcut conflicts with the stated requirement.
D:This would validate a different case: A Glue job has failed for three mornings but no CloudWatch alarm exists, so dashboards show stale data. It does not verify the outcome required here.
F:That corrective action is for a different case: An analyst creates a Glue DataBrew visual cleaning step that trims all leading zeros from product IDs, breaking lookups. It does not resolve this incident.
Question 459
A team applies a reviewed fix for this situation: A Glue job reading nested JSON flattens arrays incorrectly and duplicates parent order totals. Which observed outcome would most convincingly validate the fix?
- Controlled valid, malformed, and retry inputs end at their intended S3 destinations.
- The published job serializes work to executors and produces correct output.
- A fixture with two nested lines produces correct line and order totals.
- A tenant query scans only the relevant partitions and records appear under expected prefixes.
Explanation
Correct Answer
C:A fixture with two nested lines produces correct line and order totals. This verifies the result of normalize arrays with stable parent identifiers and aggregate only at the intended business grain.
Incorrect Answers
A:This would verify another situation: A Firehose transformation Lambda returns malformed record status envelopes and some messages enter an error prefix. It does not validate the current case.
B:This would verify another situation: A team changes an analytics library but releases a job without checking distributed task serialization compatibility. It does not validate the current case.
D:This would verify another situation: A Firehose stream delivering transactions to S3 mixes every customer into the same prefix, making Athena queries scan all tenants. It does not validate the current case.
Question 460
A data transformation uses one Spark partition for a terabyte input and only one executor stays busy. Select TWO complementary measures that correctly repair and validate this failure.
- Repartition data with appropriate cardinality and avoid bottlenecking single-stage operations.
- Add workers without changing the single-partition stage.
- Use supported Map maximum concurrency and explicit backoff to respect provider quotas.
- A rebuild reproduces the tested parser and expected input transformation.
- Multiple tasks use the available cluster and total runtime improves.
Explanation
Correct Answers
A:Repartition data with appropriate cardinality and avoid bottlenecking single-stage operations. The underlying cause is: The processing layout prevents distributed parallelism.
E:Multiple tasks use the available cluster and total runtime improves. This is the observable result required before accepting the correction.
Incorrect Answers
B:Add workers without changing the single-partition stage. That shortcut conflicts with the stated requirement.
C: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.
D:This would validate a different case: A Glue processing library has no pinned dependency versions and a release pulls a new incompatible parser. It does not verify the outcome required here.
AWS Certified Data Engineer - Associate DEA-C01 Practice Tests