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 110
After resolving the following incident, which ongoing safeguard most directly prevents recurrence? An ETL role invokes KMS Decrypt repeatedly, but the pipeline's incident review examines only application logs without recording AWS API actor identity.
- Keep lineage-based deletion runbooks and retention-exception records.
- Link pipeline run IDs to audit role and request context.
- Review registered data locations and role rights during ETL deployment.
- Test transport security separately from storage encryption.
Explanation
Correct Answer
B:Link pipeline run IDs to audit role and request context. This safeguards against a recurring cause: Operational logs omit relevant cloud audit-plane evidence.
Incorrect Answers
A: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.
C:That safeguard addresses another case: An AWS Glue job writes to a governed S3 target but lacks the Lake Formation data-location access permission required for its workflow. It is not the control for this recurring failure.
D:That safeguard addresses another case: An S3 export writes regulated data to an unencrypted partner endpoint despite source-at-rest SSE-KMS protection. It is not the control for this recurring failure.
Question 111
A team applies a reviewed fix for this situation: A streaming pipeline evaluates quality from a random sample of 10 messages and assumes it proves a million-row batch is correct. Which observed outcome would most convincingly validate the fix?
- A test log remains available through the required investigation period.
- A simulated missed load triggers a delivered alert before the data SLA expires.
- An injected rare invalid population is caught by the chosen quality gate.
- Athena reads only successfully committed transform output after the Glue run ends.
Explanation
Correct Answer
C:An injected rare invalid population is caught by the chosen quality gate. This verifies the result of use defensible stratified sampling with confidence limits or full checks for critical constraints.
Incorrect Answers
A:This would verify another situation: A Lambda processor logs errors but its CloudWatch Logs retention is shorter than the postmortem evidence requirement. It does not validate the current case.
B:This would verify another situation: A Glue job has failed for three mornings but no CloudWatch alarm exists, so dashboards show stale data. It does not validate the current case.
D:This would verify another situation: A Step Functions data pipeline invokes Glue using a request/response integration and immediately launches Athena against unfinished output. It does not validate the current case.
Question 112
A team applies a reviewed fix for this situation: A Glue JDBC extraction overloads a small OLTP database when hundreds of partitions open simultaneous connections. Which observed outcome would most convincingly validate the fix?
- Notifications fire only after the transform reaches a recorded successful terminal state.
- A simulated transient failure recovers and persistent failures produce timely alerts.
- A failed release can restore the prior script and reproduce its output.
- Replica or source CPU stays bounded while expected rows are extracted.
Explanation
Correct Answer
D:Replica or source CPU stays bounded while expected rows are extracted. This verifies the result of limit partitioned reads and schedule extraction within source performance budgets.
Incorrect Answers
A:This would verify another situation: A Step Functions pipeline sends a notification before the ETL task's asynchronous execution actually completes. It does not validate the current case.
B:This would verify another situation: An AWS MWAA DAG has no task-level retries or SLA alerts, and a brief Glue API throttle causes a missed daily close. It does not validate the current case.
C:This would verify another situation: A data engineering team manually changes Glue scripts on S3 without source control or a rollback identifier. It does not validate the current case.
Question 113
After resolving the following incident, which ongoing safeguard most directly prevents recurrence? A data catalog stores PII labels only as free-text comments, so new tables bypass a tagging-based access process.
- Verify legal-hold operations in compliance test scenarios.
- Require governance signoff for expiration policy changes.
- Enforce required tag vocabulary in dataset onboarding.
- Track distribution skew after major tenant growth.
Explanation
Correct Answer
C:Enforce required tag vocabulary in dataset onboarding. This safeguards against a recurring cause: Inconsistent metadata taxonomies prevent reliable automated governance.
Incorrect Answers
A:That safeguard addresses another case: A legal-hold dataset is subject to an S3 Lifecycle expiration rule that would remove evidence at the usual age. It is not the control for this recurring failure.
B:That safeguard addresses another case: An S3 data product has an approved seven-year retention requirement, but an engineer adds a 30-day expiration lifecycle rule. It is not the control for this recurring failure.
D:That safeguard addresses another case: A Redshift table has highly skewed account IDs as a distribution key and one compute slice processes most rows. It is not the control for this recurring failure.
Question 114
A Kinesis consumer reports healthy CPU yet its IteratorAge grows for hours during normal traffic. Which engineering change best addresses the underlying issue?
- Move bulk transformation to a suitable managed batch/distributed service and orchestrate it.
- Check expected row counts against source manifest and tolerances before release.
- Examine iterator age, shard utilization, downstream latency and consumer parallelism.
- Use defensible stratified sampling with confidence limits or full checks for critical constraints.
Explanation
Correct Answer
C:Examine iterator age, shard utilization, downstream latency and consumer parallelism. It directly addresses the case cause (Consumption lag is growing despite adequate compute metrics and may indicate insufficient read/processing throughput.) and should be verified by: Consumer lag decreases under a measured production-like load.
Incorrect Answers
A:That change addresses a monthly data load uses Lambda to copy hundreds of gigabytes in a single invocation and repeatedly times out; it would not repair this incident.
B:That change addresses a feed arrives with 30% fewer rows than normal, but a transformation succeeds and marks the data product complete; it would not repair this incident.
D:That change addresses a streaming pipeline evaluates quality from a random sample of 10 messages and assumes it proves a million-row batch is correct; it would not repair this incident.
Question 115
An Athena query of yesterday's S3 partition returns zero rows because its table metadata lacks that partition. Which technical dependency most directly explains this behavior?
- The catalog partition listing is not synchronized with newly written S3 prefixes.
- Logical key design concentrates physical write pressure.
- Primary key design does not support a dominant lookup pattern.
- Dataset lineage and transformation provenance are not recorded.
Explanation
Correct Answer
A:The catalog partition listing is not synchronized with newly written S3 prefixes. The corresponding fix is to add supported partition projection or update Glue partitions in the ingestion workflow.
Incorrect Answers
B:This diagnosis addresses another AWS case: A DynamoDB table uses the same partition key for all new daily events, producing throttled writes during each morning burst. The dependency here is different.
C:This diagnosis addresses another AWS case: A DynamoDB table uses composite key `tenant#date` but most reads are by `transaction_id` only and become scans. The dependency here is different.
D:This diagnosis addresses another AWS case: A data team cannot determine whether a report column came from the original CRM source or an intermediate cleansing step. The dependency here is different.
Question 116
A warehouse unload creates thousands of tiny output files, raising downstream S3 request and processing overhead. Which engineering change best addresses the underlying issue?
- Apply a stable catalog schema and quarantine malformed headers or records upstream.
- Tune supported export parallelism and downstream compaction based on file size and latency.
- Model validated numeric coordinate fields with units and location quality checks.
- Redesign keys using appropriately distributed entity/shard identifiers while preserving retrieval needs.
Explanation
Correct Answer
B:Tune supported export parallelism and downstream compaction based on file size and latency. It directly addresses the case cause (Output partitioning produces files much smaller than efficient batch units.) and should be verified by: The file layout reaches acceptable size targets with identical row counts.
Incorrect Answers
A:That change addresses a crawler changes a decimal sales column to string after encountering a nonnumeric banner row in one export; it would not repair this incident.
C:That change addresses a lake stores customer location coordinates as one unparsed text field while downstream joins require numeric latitude and longitude; it would not repair this incident.
D:That change addresses a DynamoDB table uses the same partition key for all new daily events, producing throttled writes during each morning burst; it would not repair this incident.
Question 117
An S3 data product has an approved seven-year retention requirement, but an engineer adds a 30-day expiration lifecycle rule. Which engineering change best addresses the underlying issue?
- Redesign keys using appropriately distributed entity/shard identifiers while preserving retrieval needs.
- Offload reporting to an appropriately refreshed warehouse, replica or approved analytical system.
- Validate retention requirements and apply supported retention/lock controls before approving lifecycle changes.
- Reassess partition keys/granularity and apply efficient columnar file layout.
Explanation
Correct Answer
C:Validate retention requirements and apply supported retention/lock controls before approving lifecycle changes. It directly addresses the case cause (Object lifecycle configuration conflicts with required retention and legal policy.) and should be verified by: Compliance fixtures remain available for the required duration.
Incorrect Answers
A:That change addresses a DynamoDB table uses the same partition key for all new daily events, producing throttled writes during each morning burst; it would not repair this incident.
B:That change addresses an operational RDS database has a complex read-only report consuming most CPU at peak checkout time; it would not repair this incident.
D:That change addresses an Athena table uses daily partitions on a timestamp with millions of near-empty partition folders; it would not repair this incident.
Question 118
A Step Functions state retries every failure including invalid schema, consuming budget without possibility of success. Which engineering change best addresses the underlying issue?
- Retry bounded transient exceptions and catch permanent validation failures for quarantine.
- Document and validate the record envelope and implement the matching decode path.
- Use an explicit completed-manifest event or a sensor/check against expected export state.
- Use supported partial batch failure handling and idempotent sink writes with a failure destination.
Explanation
Correct Answer
A:Retry bounded transient exceptions and catch permanent validation failures for quarantine. It directly addresses the case cause (Transient and permanent errors are not classified in the retry and catch policy.) and should be verified by: Transient injected failures recover while invalid source data stops deterministically.
Incorrect Answers
B:That change addresses a streaming producer writes compressed messages into a format the Lambda consumer assumes is plain UTF-8; it would not repair this incident.
C:That change addresses an EventBridge schedule starts a warehouse load during an upstream S3 export rather than after all files are ready; it would not repair this incident.
D:That change addresses a Lambda Kinesis event-source mapping repeatedly delivers the same batch after one malformed record fails; it would not repair this incident.
Question 119
A team applies a reviewed fix for this situation: A Step Functions run is marked succeeded although a downstream notification publish fails and no incident ticket is opened. Which observed outcome would most convincingly validate the fix?
- A completed upstream fixture unblocks the DAG while failures follow the error path.
- A product ID such as 00027 remains unchanged after the approved cleaning step.
- A simulated notification outage produces recoverable failure evidence and eventual delivery.
- A forced retry produces totals matching an independent known fixture.
Explanation
Correct Answer
C:A simulated notification outage produces recoverable failure evidence and eventual delivery. This verifies the result of model the notification as a checked task with failure handling or durable outbox.
Incorrect Answers
A:This would verify another situation: An MWAA scheduled data DAG waits forever for an upstream batch because the external task reports completion through a different status name. It does not validate the current case.
B:This would verify another situation: An analyst creates a Glue DataBrew visual cleaning step that trims all leading zeros from product IDs, breaking lookups. It does not validate the current case.
D:This would verify another situation: A Spark aggregation produces incorrect category totals because one hot key is dropped after a task retry and the target doesn't reconcile. It does not validate the current case.
Question 120
After resolving the following incident, which ongoing safeguard most directly prevents recurrence? A partner API returns HTTP 429, and a Glue ETL job immediately retries in tight loops until access is suspended.
- Monitor retry budgets and throttle rates per partner.
- Run schema/format contract tests before warehouse loading.
- Require test execution against deployable artifacts, not only helper functions.
- Check service response enums when revising orchestration logic.
Explanation
Correct Answer
A:Monitor retry budgets and throttle rates per partner. This safeguards against a recurring cause: Retry policy ignores rate limiting and server retry hints.
Incorrect Answers
B:That safeguard addresses another case: A Redshift COPY import fails on a changed date format in one batch even though prior files loaded. It is not the control for this recurring failure.
C:That safeguard addresses another case: A code deployment changes an ETL function's parameter name but unit tests exercise only the old pipeline entry point. It is not the control for this recurring failure.
D:That safeguard addresses another case: A workflow branches on a job-status string but overlooks the Cancelled terminal state, leaving executions stuck. It is not the control for this recurring failure.
AWS Certified Data Engineer - Associate DEA-C01 Practice Tests