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 730
After resolving the following incident, which ongoing safeguard most directly prevents recurrence? A data team declares a successful cleanup because duplicate percentage fell, but the job also dropped valid unique rows.
- Test workflow reachability and trigger states after DAG edits.
- Schema-check measure types and null handling before analytics.
- Build SDK orchestration tests for all Athena terminal states.
- Require multidimensional quality gates before final publish.
Explanation
Correct Answer
D:Require multidimensional quality gates before final publish. This safeguards against a recurring cause: Single-metric quality scoring hides unintended data loss.
Incorrect Answers
A: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.
B:That safeguard addresses another case: An Athena SQL query sums decimal prices stored as strings and uses lexicographic ordering on text. It is not the control for this recurring failure.
C:That safeguard addresses another case: An Athena automated report tries to read query results immediately after StartQueryExecution returns a query ID. It is not the control for this recurring failure.
Question 731
An S3 data-access investigation searches CloudTrail for object reads but only management events were enabled. Select TWO complementary measures that correctly repair and validate this failure.
- The intended cross-account role reads only the allowed lake dataset.
- A controlled object read produces a traceable data event with expected context.
- Enable reviewed CloudTrail data events for the required S3 buckets or prefixes.
- Restore least-privilege S3 actions and evaluate the role's endpoint and bucket policies.
- Assume management event logging records every S3 GetObject operation.
Explanation
Correct Answers
B:A controlled object read produces a traceable data event with expected context. This is the observable result required before accepting the correction.
C:Enable reviewed CloudTrail data events for the required S3 buckets or prefixes. The underlying cause is: Object-level S3 reads require appropriate data-event collection scope.
Incorrect Answers
A:This would validate a different 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 does not verify the outcome required here.
D:That corrective action is for a different case: A Glue job in a private VPC cannot read a governed S3 source after the executor role loses permission, although its worker network is healthy. It does not resolve this incident.
E:Assume management event logging records every S3 GetObject operation. That shortcut conflicts with the stated requirement.
Question 732
An Athena table uses daily partitions on a timestamp with millions of near-empty partition folders. Which engineering change best addresses the underlying issue?
- Trace lineage and apply approved deletion to all eligible retained copies under policy.
- Configure the supported classifier and decompression-aware source layout.
- Use appropriately partitioned Parquet or another supported format, and verify partition predicates.
- Reassess partition keys/granularity and apply efficient columnar file layout.
Explanation
Correct Answer
D:Reassess partition keys/granularity and apply efficient columnar file layout. It directly addresses the case cause (Partition granularity is too fine for data volume and query predicates.) and should be verified by: Average scanned bytes and query planning time improve without data loss.
Incorrect Answers
A:That change addresses an analytics partition must be removed under a deletion request, yet its historical copies persist in untracked S3 archive paths; it would not repair this incident.
B:That change addresses an S3 prefix contains `.json.gz` objects but the Glue crawler labels them as raw JSON and downstream parsers fail; it would not repair this incident.
C:That change addresses an Athena query reads huge raw JSON partitions for a narrow timestamp filter and scans far more bytes than expected; it would not repair this incident.
Question 733
A scheduled ETL uses an API token embedded in source code; rotation breaks the batch without an alert. Which engineering change best addresses the underlying issue?
- Inspect EXPLAIN and workload metrics; review distribution, sort and join design.
- Move credentials to a protected managed secret and implement controlled refresh and failure alerts.
- Keep identifiers typed as strings and apply field-specific whitespace rules only.
- Define a representative sampling plan or full-data check and report uncertainty.
Explanation
Correct Answer
B:Move credentials to a protected managed secret and implement controlled refresh and failure alerts. It directly addresses the case cause (Credential retrieval and rotation are not part of the workload lifecycle.) and should be verified by: A test rotation preserves authorized API access without redeploying embedded credentials.
Incorrect Answers
A:That change addresses a Redshift reporting job suddenly spends time redistributing a large fact table after a schema change; it would not repair this incident.
C:That change addresses an analyst creates a Glue DataBrew visual cleaning step that trims all leading zeros from product IDs, breaking lookups; it would not repair this incident.
D:That change addresses an Athena Spark notebook reads only a handful of development files yet a manager interprets its average as an entire production trend; it would not repair this incident.
Question 734
A team applies a reviewed fix for this situation: A daily sensor batch is duplicated after retry, causing every aggregate event count to double. Which observed outcome would most convincingly validate the fix?
- A zero-activity test customer remains in denominator without fake activity.
- A user with several event retries contributes once to unique-user counts.
- A repeated batch does not change the accepted distinct event count.
- A transient injected failure remains logged, while persistent failures trigger on-call alerts.
Explanation
Correct Answer
C:A repeated batch does not change the accepted distinct event count. This verifies the result of deduplicate on a documented source event key and verify idempotent load state.
Incorrect Answers
A:This would verify another situation: An Athena view compares monthly cohorts using an inner join that drops customers with no activity, overstating retention. It does not validate the current case.
B:This would verify another situation: A marketing report uses COUNT(*) of event records as its active user metric and overstates adoption when users retry. It does not validate the current case.
D:This would verify another situation: A monitoring rule sees one Athena query failure and pages the full team despite a known transient backend retry. It does not validate the current case.
Question 735
A Lambda ETL process writes temporary files larger than its configured /tmp capacity and receives storage errors. Which engineering change best addresses the underlying issue?
- Update reviewed DMS table mapping and validate permissions and schema-change handling.
- Use a stable ingestion event ID with conditional writes or a deduplicating transaction design.
- Right-size supported Lambda ephemeral storage or stream/process in bounded chunks.
- Evaluate a broadcast join or other optimized join strategy within Glue/Spark memory limits.
Explanation
Correct Answer
C:Right-size supported Lambda ephemeral storage or stream/process in bounded chunks. It directly addresses the case cause (Ephemeral storage is insufficient for the actual intermediate workload.) and should be verified by: A maximum-size fixture completes without filling local temporary storage.
Incorrect Answers
A:That change addresses an on-premises Oracle source feeds DMS, but newly added tables never appear in a configured migration; it would not repair this incident.
B:That change addresses an ingestion app writes identical DynamoDB item updates after a network retry and an audit counter increments twice; it would not repair this incident.
D:That change addresses a Glue job joins a tiny lookup table to billions of rows and performs a full distributed shuffle; it would not repair this incident.
Question 736
After resolving the following incident, which ongoing safeguard most directly prevents recurrence? An ETL pipeline calls a Bedrock model on full records containing account secrets merely to extract public product categories.
- Keep job-run IDs and manifest IDs linked in operational metadata.
- Profile algorithmic complexity for hot-path data structures.
- Enforce producer-consumer handoff contracts and late-arrival tests.
- Add privacy gates and prompt-injection resilience tests before model integration.
Explanation
Correct Answer
D:Add privacy gates and prompt-injection resilience tests before model integration. This safeguards against a recurring cause: The processing path sends unnecessary sensitive content to an external model workflow.
Incorrect Answers
A:That safeguard addresses another case: A production Glue workflow receives the same completed-file notification twice and creates two warehouse loads. It is not the control for this recurring failure.
B:That safeguard addresses another case: A large ETL data structure uses a list for repeated membership checks and CPU use grows unexpectedly. It is not the control for this recurring failure.
C:That safeguard addresses another case: An EventBridge schedule starts a warehouse load during an upstream S3 export rather than after all files are ready. It is not the control for this recurring failure.
Question 737
A Glue processing library has no pinned dependency versions and a release pulls a new incompatible parser. Select THREE complementary measures that correctly repair and validate, and prevent recurrence of this failure.
- Pin and test dependency versions within the supported Glue runtime and publish a locked artifact.
- Duplicate notifications create one committed warehouse batch and auditable duplicate attempts.
- Disable all library updates forever without testing vulnerabilities.
- Maintain dependency compatibility matrices and security update rehearsals.
- Precompute consistent normalized join keys and select suitable partitioning and join strategies.
- A rebuild reproduces the tested parser and expected input transformation.
Explanation
Correct Answers
A:Pin and test dependency versions within the supported Glue runtime and publish a locked artifact. The underlying cause is: Uncontrolled dependency drift changes execution behavior.
D:Maintain dependency compatibility matrices and security update rehearsals. This protects against the following risk: Uncontrolled dependency drift changes execution behavior.
F:A rebuild reproduces the tested parser and expected input transformation. This is the observable result required before accepting the correction.
Incorrect Answers
B:This would validate a different case: A production Glue workflow receives the same completed-file notification twice and creates two warehouse loads. It does not verify the outcome required here.
C:Disable all library updates forever without testing vulnerabilities. That shortcut conflicts with the stated requirement.
E:That corrective action is for a different case: A Spark pipeline includes a wide shuffle stage because it joins on a function applied to both tables, preventing efficient key reuse. It does not resolve this incident.
Question 738
A team applies a reviewed fix for this situation: An on-premises Oracle source feeds DMS, but newly added tables never appear in a configured migration. Which observed outcome would most convincingly validate the fix?
- A known new table's rows and later changes reach the approved target.
- Join output stays correct while shuffle cost and job duration decline.
- A forced mid-run failure leaves the previous published partition available.
- A mixed-currency fixture reproduces independently computed accepted totals.
Explanation
Correct Answer
A:A known new table's rows and later changes reach the approved target. This verifies the result of update reviewed DMS table mapping and validate permissions and schema-change handling.
Incorrect Answers
B:This would verify another situation: A Spark pipeline includes a wide shuffle stage because it joins on a function applied to both tables, preventing efficient key reuse. It does not validate the current case.
C:This would verify another situation: A Glue workflow reruns yesterday's partition after a partially failed daily job but overwrites already-approved historical results. It does not validate the current case.
D: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.
Question 739
A Redshift reporting job suddenly spends time redistributing a large fact table after a schema change. Which technical dependency most directly explains this behavior?
- The changed table layout or join pattern increases data movement.
- Recipe selection and deployment version are not aligned.
- Runtime success is not equivalent to expected source completeness.
- The orchestration integration returns before the asynchronous ETL work finishes.
Explanation
Correct Answer
A:The changed table layout or join pattern increases data movement. The corresponding fix is to inspect EXPLAIN and workload metrics; review distribution, sort and join design.
Incorrect Answers
B:This diagnosis addresses another AWS case: A Glue DataBrew recipe was changed interactively but the production pipeline still applies a previous published recipe version. The dependency here is different.
C:This diagnosis addresses another AWS case: A feed arrives with 30% fewer rows than normal, but a transformation succeeds and marks the data product complete. The dependency here is different.
D:This diagnosis addresses another AWS case: A Step Functions data pipeline invokes Glue using a request/response integration and immediately launches Athena against unfinished output. The dependency here is different.
Question 740
An API payload includes optional addresses but a transformation fails when a nullable nested object is absent. Select THREE complementary measures that correctly repair and validate, and prevent recurrence of this failure.
- Fill missing addresses with fabricated real customer details.
- Fixtures with present, null, and missing fields receive expected values or rejects.
- Use nullable-aware extraction and document sensible default or reject handling per field.
- Include sparse and schema-evolution samples in transformation tests.
- The DAG parses and a controlled run completes its expected task graph.
- Retry bounded transient exceptions and catch permanent validation failures for quarantine.
Explanation
Correct Answers
B:Fixtures with present, null, and missing fields receive expected values or rejects. This is the observable result required before accepting the correction.
C:Use nullable-aware extraction and document sensible default or reject handling per field. The underlying cause is: The pipeline assumes every optional path exists for every row.
D:Include sparse and schema-evolution samples in transformation tests. This protects against the following risk: The pipeline assumes every optional path exists for every row.
Incorrect Answers
A:Fill missing addresses with fabricated real customer details. That shortcut conflicts with the stated requirement.
E:This would validate a different case: An MWAA DAG was deployed but its Python import fails, so no scheduled run appears. It does not verify the outcome required here.
F:That corrective action is for a different case: A Step Functions state retries every failure including invalid schema, consuming budget without possibility of success. It does not resolve this incident.
AWS Certified Data Engineer - Associate DEA-C01 Practice Tests