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 510
A daily batch extraction reads only the first page of a vendor REST API and silently loses subsequent records. Which technical dependency most directly explains this behavior?
- Row-based text storage undermines predicate and column projection efficiencies.
- The pipeline assumes every optional path exists for every row.
- The join strategy ignores a safe broadcastable small dimension.
- The ingestion client ignores pagination tokens or cursor continuation.
Explanation
Correct Answer
D:The ingestion client ignores pagination tokens or cursor continuation. The corresponding fix is to follow documented API pagination and persist progress in resumable checkpoints.
Incorrect Answers
A:This diagnosis addresses another AWS case: An ETL job writes CSV to a large analytics lake and Athena scans every column for two-field reports. The dependency here is different.
B:This diagnosis addresses another AWS case: An API payload includes optional addresses but a transformation fails when a nullable nested object is absent. The dependency here is different.
C:This diagnosis addresses another AWS case: A Glue job joins a tiny lookup table to billions of rows and performs a full distributed shuffle. The dependency here is different.
Question 511
After resolving the following incident, which ongoing safeguard most directly prevents recurrence? A workflow that provisions a temporary staging cluster leaks resources after a later transform fails.
- Test poison-message recovery and batch retry behavior.
- Test large responses, page limits, and interrupted cursors in CI.
- Test cleanup after timeout, cancellation, and transform exceptions.
- Add grain and cardinality assertions after each flattening step.
Explanation
Correct Answer
C:Test cleanup after timeout, cancellation, and transform exceptions. This safeguards against a recurring cause: Failure paths omit cleanup or compensation stages.
Incorrect Answers
A:That safeguard addresses another case: A Lambda Kinesis event-source mapping repeatedly delivers the same batch after one malformed record fails. It is not the control for this recurring failure.
B:That safeguard addresses another case: A daily batch extraction reads only the first page of a vendor REST API and silently loses subsequent records. It is not the control for this recurring failure.
D: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.
Question 512
A team applies a reviewed fix for this situation: A pipeline sends database credentials in plaintext environment variables and writes them to CloudWatch on failure. Which observed outcome would most convincingly validate the fix?
- The job operates without embedded secrets and permissions stay narrowly scoped.
- The partner can query intended views without accessing unrelated source objects.
- A controlled secret rotation works and logs contain no secret values.
- A controlled test subject is absent from eligible data products after verified deletion.
Explanation
Correct Answer
C:A controlled secret rotation works and logs contain no secret values. This verifies the result of store and rotate credentials in Secrets Manager with scoped runtime retrieval and redacted logs.
Incorrect Answers
A:This would verify another situation: A pipeline uses long-lived IAM user access keys embedded in a Glue script instead of an execution role. It does not validate the current case.
B:This would verify another situation: A Redshift datashare exposes more tables than a partner is contractually allowed to query. It does not validate the current case.
D:This would verify another situation: A personal-data deletion request removes a row from an Athena external table view but leaves original S3 objects and downstream extracts. It does not validate the current case.
Question 513
A code deployment changes an ETL function's parameter name but unit tests exercise only the old pipeline entry point. Select TWO complementary measures that correctly repair and validate this failure.
- The new deployment fails validation before production if a required parameter is missing.
- Check Glue connection subnet, ENIs, VPC routing, DNS, and the source's inbound rule.
- The second job starts only after the first has committed the required partition.
- Run contract and integration tests on the packaged pipeline artifact with versioned parameters.
- Skip tests when changes appear to be a simple rename.
Explanation
Correct Answers
A:The new deployment fails validation before production if a required parameter is missing. This is the observable result required before accepting the correction.
D:Run contract and integration tests on the packaged pipeline artifact with versioned parameters. The underlying cause is: Test coverage fails to represent the actual deployed interface.
Incorrect Answers
B:That corrective action is for a different case: A Glue connection to a source RDS database times out, although the JDBC credentials are valid. It does not resolve this incident.
C:This would validate a different case: A scheduled Glue workflow triggers two jobs concurrently though the second requires the first output's partition. It does not verify the outcome required here.
E:Skip tests when changes appear to be a simple rename. That shortcut conflicts with the stated requirement.
Question 514
An MWAA scheduled data DAG waits forever for an upstream batch because the external task reports completion through a different status name. Which engineering change best addresses the underlying issue?
- Inspect the service response contract and update the sensor or operator success conditions.
- Profile physical plans and remove unintended cross joins or use reviewed predicates.
- Normalize currencies using approved rates and label dates, units and calculation rules.
- Implement event-time windows with a supported lateness allowance and correction/backfill strategy.
Explanation
Correct Answer
A:Inspect the service response contract and update the sensor or operator success conditions. It directly addresses the case cause (The workflow's sensor condition does not match the actual upstream terminal status.) and should be verified by: A completed upstream fixture unblocks the DAG while failures follow the error path.
Incorrect Answers
B:That change addresses a Glue job begins consuming twice its normal DPU budget after a transformation adds a repeated cross join; it would not repair this incident.
C:That change addresses a QuickSight dashboard compares two branch cost reports, one in local currency and one in USD, without conversion; it would not repair this incident.
D:That change addresses a nightly data product uses a moving seven-day window but incoming source events arrive late and are excluded without a watermark policy; it would not repair this incident.
Question 515
A data lake in an EU Region replicates raw customer records to an unapproved Region for convenience. Which technical dependency most directly explains this behavior?
- Replication destination conflicts with the required data sovereignty boundary.
- Object-level S3 reads require appropriate data-event collection scope.
- A service role cannot replace blocked VPC routes or security group rules.
- Audit log delivery and analytics catalog partition visibility are separate requirements.
Explanation
Correct Answer
A:Replication destination conflicts with the required data sovereignty boundary. The corresponding fix is to restrict cross-Region replication and backup destinations to approved residency Regions.
Incorrect Answers
B:This diagnosis addresses another AWS case: An S3 data-access investigation searches CloudTrail for object reads but only management events were enabled. The dependency here is different.
C:This diagnosis addresses another AWS case: A Glue crawler in a VPC fails connection to a private RDS source even with the right IAM service role. The dependency here is different.
D:This diagnosis addresses another AWS case: An Athena query for CloudTrail logs shows a missing day because the log data lake partitions were never registered. The dependency here is different.
Question 516
A team applies a reviewed fix for this situation: An EventBridge rule matches both replayed and new events and starts two identical pipelines for the same batch. Which observed outcome would most convincingly validate the fix?
- Multiple tasks use the available cluster and total runtime improves.
- Replayed identical events create one accepted workflow while independent batches proceed.
- A maximum-size fixture completes without filling local temporary storage.
- Join output stays correct while shuffle cost and job duration decline.
Explanation
Correct Answer
B:Replayed identical events create one accepted workflow while independent batches proceed. This verifies the result of store an execution identity and use conditional state transitions before starting work.
Incorrect Answers
A: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.
C:This would verify another situation: A Lambda ETL process writes temporary files larger than its configured /tmp capacity and receives storage errors. It does not validate the current case.
D: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.
Question 517
After resolving the following incident, which ongoing safeguard most directly prevents recurrence? A CI pipeline promotes an ETL artifact after syntax checks but without a representative integration job against staged data.
- Inspect Spark physical plans and skewed partitions after release.
- Use transformation-contract tests before promoting Lambda versions.
- Define deployment acceptance criteria for contracts and IAM access.
- Test cleanup after timeout, cancellation, and transform exceptions.
Explanation
Correct Answer
C:Define deployment acceptance criteria for contracts and IAM access. This safeguards against a recurring cause: Compilation alone does not validate service permissions, schema, and output semantics.
Incorrect Answers
A:That safeguard addresses another case: A data transformation uses one Spark partition for a terabyte input and only one executor stays busy. It is not the control for this recurring failure.
B:That safeguard addresses another case: A Firehose transformation Lambda returns malformed record status envelopes and some messages enter an error prefix. It is not the control for this recurring failure.
D:That safeguard addresses another case: A workflow that provisions a temporary staging cluster leaks resources after a later transform fails. It is not the control for this recurring failure.
Question 518
A feed arrives with 30% fewer rows than normal, but a transformation succeeds and marks the data product complete. Select TWO complementary measures that correctly repair and validate this failure.
- Scale expected row counts to the observed partial batch.
- A deliberately truncated file triggers a quality alert and prevents false success.
- Inspect EXPLAIN and workload metrics; review distribution, sort and join design.
- Athena reads only successfully committed transform output after the Glue run ends.
- Check expected row counts against source manifest and tolerances before release.
Explanation
Correct Answers
B:A deliberately truncated file triggers a quality alert and prevents false success. This is the observable result required before accepting the correction.
E:Check expected row counts against source manifest and tolerances before release. The underlying cause is: Runtime success is not equivalent to expected source completeness.
Incorrect Answers
A:Scale expected row counts to the observed partial batch. That shortcut conflicts with the stated requirement.
C:That corrective action is for a different case: A Redshift reporting job suddenly spends time redistributing a large fact table after a schema change. It does not resolve this incident.
D:This would validate a different case: A Step Functions data pipeline invokes Glue using a request/response integration and immediately launches Athena against unfinished output. It does not verify the outcome required here.
Question 519
After resolving the following incident, which ongoing safeguard most directly prevents recurrence? A Glue processing library has no pinned dependency versions and a release pulls a new incompatible parser.
- Profile costly UDFs before accepting new ETL code.
- Maintain dependency compatibility matrices and security update rehearsals.
- Include duplicate-event and retry fixtures in integration tests.
- Track transformation-key contracts and explain-plan changes.
Explanation
Correct Answer
B:Maintain dependency compatibility matrices and security update rehearsals. This safeguards against a recurring cause: Uncontrolled dependency drift changes execution behavior.
Incorrect Answers
A:That safeguard addresses another case: A PySpark transformation uses Python row-by-row loops to parse simple scalar fields and runs slowly. It is not the control for this recurring failure.
C:That safeguard addresses another case: An EventBridge rule matches both replayed and new events and starts two identical pipelines for the same batch. It is not the control for this recurring failure.
D:That safeguard addresses another case: A Spark pipeline includes a wide shuffle stage because it joins on a function applied to both tables, preventing efficient key reuse. It is not the control for this recurring failure.
Question 520
An S3 event notification triggers Glue for every file of a large export, producing hundreds of competing jobs. Which engineering change best addresses the underlying issue?
- Use supported synchronous integration or task token/wait-and-poll completion logic.
- Aggregate object events or publish a manifest/ready signal and start bounded ETL batches.
- Normalize timestamp types during ingestion and optimize the relevant table layout.
- Inspect DAG import errors and validate packaging dependencies before deployment.
Explanation
Correct Answer
B:Aggregate object events or publish a manifest/ready signal and start bounded ETL batches. It directly addresses the case cause (The event-to-job design starts a run per object without a batch completion boundary.) and should be verified by: One controlled export yields the intended bounded job count and all objects are processed.
Incorrect Answers
A:That change addresses a Step Functions pipeline sends a notification before the ETL task's asynchronous execution actually completes; it would not repair this incident.
C:That change addresses a Redshift query repeatedly casts a large timestamp string field during aggregation and consumes excess CPU; it would not repair this incident.
D:That change addresses an MWAA DAG was deployed but its Python import fails, so no scheduled run appears; it would not repair this incident.
AWS Certified Data Engineer - Associate DEA-C01 Practice Tests