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 960
A team applies a reviewed fix for this situation: A processing job ingests gzipped files but its connector treats their contents as uncompressed text and creates corrupt rows. Which observed outcome would most convincingly validate the fix?
- A simulated transient failure recovers and persistent failures produce timely alerts.
- A controlled JDBC connection from the Glue execution context succeeds.
- A real on-call endpoint receives a test failure with actionable context.
- Decompressed samples match checksums and expected record counts.
Explanation
Correct Answer
D:Decompressed samples match checksums and expected record counts. This verifies the result of configure supported decompression and validate input format before parsing.
Incorrect Answers
A: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.
B:This would verify another situation: A Glue connection to a source RDS database times out, although the JDBC credentials are valid. It does not validate the current case.
C:This would verify another situation: A multi-account data pipeline sends operational alerts through an SNS topic that no engineer subscribes to. It does not validate the current case.
Question 961
A team applies a reviewed fix for this situation: A DynamoDB application requires strongly consistent reads immediately after a successful critical write but queries a global secondary index. Which observed outcome would most convincingly validate the fix?
- A controlled write/read test meets the documented consistency requirement.
- A controlled UNLOAD produces output in only the approved S3 prefix.
- A controlled report field traces back to the expected source attribute and job revision.
- Both controlled queries return the expected published dataset version.
Explanation
Correct Answer
A:A controlled write/read test meets the documented consistency requirement. This verifies the result of use a supported strongly consistent base-table or local-index read design where necessary.
Incorrect Answers
B:This would verify another situation: A Redshift UNLOAD writes reporting data to an S3 bucket in another account but fails with access denied. It does not validate the current case.
C:This would verify another situation: A data team cannot determine whether a report column came from the original CRM source or an intermediate cleansing step. It does not validate the current case.
D:This would verify another situation: Two Athena workgroups query identically named tables but one references a different data catalog and gets old records. It does not validate the current case.
Question 962
An S3 replication configuration excludes delete markers, but a team assumes target data will reflect source deletes instantly. Which technical dependency most directly explains this behavior?
- Concurrent metadata changes lack a controlled version/change process.
- The modeled fact grain is inconsistent across record types.
- Schema evolution is treated as a breaking change despite an optional additive field.
- Replication configuration and timing do not satisfy the assumed deletion semantics.
Explanation
Correct Answer
D:Replication configuration and timing do not satisfy the assumed deletion semantics. The corresponding fix is to review supported replication/delete-marker configuration and establish reconciliation monitoring.
Incorrect Answers
A:This diagnosis addresses another AWS case: Two developers independently edit Glue Data Catalog schema types during release, and a job fails after the last writer wins. The dependency here is different.
B:This diagnosis addresses another AWS case: A Redshift star schema mixes order-line and order-header facts in the same table and reports double-count revenue. The dependency here is different.
C:This diagnosis addresses another AWS case: A lake dataset adds an optional JSON field and an older consumer fails because it expects an exact fixed set of keys. The dependency here is different.
Question 963
An EventBridge rule matches both replayed and new events and starts two identical pipelines for the same batch. Select TWO complementary measures that correctly repair and validate this failure.
- Replayed identical events create one accepted workflow while independent batches proceed.
- Store an execution identity and use conditional state transitions before starting work.
- Price and duration fields support correct arithmetic on known test rows.
- Treat EventBridge as a global exactly-once workflow initiator.
- Choose a stable order identity and the correct aggregation or distinct-current-state logic.
Explanation
Correct Answers
A:Replayed identical events create one accepted workflow while independent batches proceed. This is the observable result required before accepting the correction.
B:Store an execution identity and use conditional state transitions before starting work. The underlying cause is: Event delivery and replay are not protected by a stable idempotency key.
Incorrect Answers
C:This would validate a different case: A clickstream pipeline converts all nested attributes to strings before storage, making numeric analytics unreliable. It does not verify the outcome required here.
D:Treat EventBridge as a global exactly-once workflow initiator. That shortcut conflicts with the stated requirement.
E:That corrective action is for a different case: A nightly aggregation counts an order once per status-change event rather than once per order ID. It does not resolve this incident.
Question 964
A team applies a reviewed fix for this situation: A Glue ETL job completes with warnings but the orchestrator assumes success despite a downstream quality check failing. Which observed outcome would most convincingly validate the fix?
- Accepted distinct keys remain complete while true duplicates are controlled.
- Correct row counts and bounded DPU-hours return in a repeatable fixture.
- Two-tenant fixture running totals are independent and correct.
- Only a validated output is promoted to the consumer-facing location.
Explanation
Correct Answer
D:Only a validated output is promoted to the consumer-facing location. This verifies the result of add explicit row-count, schema, and quality validation before the publish step.
Incorrect Answers
A:This would verify another situation: A data team declares a successful cleanup because duplicate percentage fell, but the job also dropped valid unique rows. It does not validate the current case.
B:This would verify another situation: A Glue job begins consuming twice its normal DPU budget after a transformation adds a repeated cross join. It does not validate the current case.
C:This would verify another situation: A Redshift window query uses SUM without the intended PARTITION BY and produces one cumulative total over all tenants. It does not validate the current case.
Question 965
A Step Functions run is marked succeeded although a downstream notification publish fails and no incident ticket is opened. Which engineering change best addresses the underlying issue?
- Model the notification as a checked task with failure handling or durable outbox.
- Normalize currencies using approved rates and label dates, units and calculation rules.
- Join on documented unique customer identifiers and enforce suitable grain.
- Combine nullable, format, and authorized-value validation with appropriate error routing.
Explanation
Correct Answer
A:Model the notification as a checked task with failure handling or durable outbox. It directly addresses the case cause (The workflow's success criteria omit an operationally required delivery dependency.) and should be verified by: A simulated notification outage produces recoverable failure evidence and eventual delivery.
Incorrect Answers
B: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.
C:That change addresses a Redshift SQL view joins two tables on customer name, and a same-name collision merges unrelated accounts; it would not repair this incident.
D:That change addresses a Glue data quality rule checks only that an email column is nonnull but accepts invalid malformed addresses; it would not repair this incident.
Question 966
A Glue job reads an S3 object encrypted with a customer-managed KMS key and fails even though it has `s3:GetObject`. Which engineering change best addresses the underlying issue?
- Use approved Macie sensitive-data discovery and validated data classifications with access review.
- Confirm event data store selectors and query filters include intended account and Region events.
- Narrow LF-Tag permissions to reviewed principals and classify data assets consistently.
- Grant scoped KMS decrypt through both applicable IAM and key policy controls.
Explanation
Correct Answer
D:Grant scoped KMS decrypt through both applicable IAM and key policy controls. It directly addresses the case cause (S3 object retrieval may also require KMS decrypt authorization for the encryption key.) and should be verified by: The approved role reads the encrypted object but cannot decrypt unrelated keys.
Incorrect Answers
A:That change addresses a data privacy analyst needs to identify PII in unknown S3 datasets but assumes object names reveal sensitive content; it would not repair this incident.
B:That change addresses a CloudTrail Lake query lists IAM role changes but its event filter omits the Regions holding the relevant data pipelines; it would not repair this incident.
C:That change addresses an S3 table is tagged `classification=restricted`, but its Lake Formation LF-Tag grant allows a broad organizational unit with no business need; it would not repair this incident.
Question 967
A team applies a reviewed fix for this situation: A monthly data load uses Lambda to copy hundreds of gigabytes in a single invocation and repeatedly times out. Which observed outcome would most convincingly validate the fix?
- A maximum-size sample completes with a checkpointed durable output.
- Correct row counts and bounded DPU-hours return in a repeatable fixture.
- Known midnight-edge events fall into the approved reporting day.
- A known delayed event updates the intended window according to policy.
Explanation
Correct Answer
A:A maximum-size sample completes with a checkpointed durable output. This verifies the result of move bulk transformation to a suitable managed batch/distributed service and orchestrate it.
Incorrect Answers
B:This would verify another situation: A Glue job begins consuming twice its normal DPU budget after a transformation adds a repeated cross join. It does not validate the current case.
C:This would verify another situation: A daily sales pivot groups event timestamps by the viewer's local date and differs from the regulatory UTC day. It does not validate the current case.
D:This would verify another situation: A nightly data product uses a moving seven-day window but incoming source events arrive late and are excluded without a watermark policy. It does not validate the current case.
Question 968
A data pipeline updates its Glue version but custom connector dependencies fail at initialization. Select THREE complementary measures that correctly repair and validate, and prevent recurrence of this failure.
- Maintain release/version compatibility tests for third-party connectors.
- Downgrade every unrelated security configuration as a workaround.
- Rebuild and test connector libraries against the supported new Glue runtime.
- Malformed fixture values fail quality checks without discarding unrelated valid records.
- Poll GetQueryExecution with bounded backoff and handle FAILED/CANCELLED before reading results.
- A representative connector read works in the target runtime without fallback hacks.
Explanation
Correct Answers
A:Maintain release/version compatibility tests for third-party connectors. This protects against the following risk: Runtime upgrade and dependency compatibility were not validated together.
C:Rebuild and test connector libraries against the supported new Glue runtime. The underlying cause is: Runtime upgrade and dependency compatibility were not validated together.
F:A representative connector read works in the target runtime without fallback hacks. This is the observable result required before accepting the correction.
Incorrect Answers
B:Downgrade every unrelated security configuration as a workaround. That shortcut conflicts with the stated requirement.
D:This would validate a different case: A Glue data quality rule checks only that an email column is nonnull but accepts invalid malformed addresses. It does not verify the outcome required here.
E:That corrective action is for a different case: An Athena automated report tries to read query results immediately after StartQueryExecution returns a query ID. It does not resolve this incident.
Question 969
An application sends semi-structured documents to an LLM to classify regulated labels but stores model output without schema checking. Which engineering change best addresses the underlying issue?
- Validate the model response against an explicit schema, use bounded retries and route uncertain results for review.
- Create a supported Firehose dynamic-partitioning delivery stream with well-chosen keys and S3 prefixes.
- Use deterministic batch output keys or conditional commits and reconcile existing results on retry.
- Use supported partial batch failure handling and idempotent sink writes with a failure destination.
Explanation
Correct Answer
A:Validate the model response against an explicit schema, use bounded retries and route uncertain results for review. It directly addresses the case cause (Generative output is probabilistic and not a trustworthy typed ETL result by itself.) and should be verified by: Malformed or ungrounded responses are quarantined while valid labels pass contract checks.
Incorrect Answers
B:That change addresses a Firehose stream delivering transactions to S3 mixes every customer into the same prefix, making Athena queries scan all tenants; it would not repair this incident.
C:That change addresses an orchestrator invokes a Lambda that writes to S3 then times out; the retry writes a second output under a new random key; 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 970
An ETL job writes CSV to a large analytics lake and Athena scans every column for two-field reports. Which technical dependency most directly explains this behavior?
- The consuming workflow lacks a reliable transfer-completion boundary.
- Row-based text storage undermines predicate and column projection efficiencies.
- Queue-consumer concurrency exceeds the sink's sustainable write capacity.
- An unbounded driver collect breaks distributed processing assumptions.
Explanation
Correct Answer
B:Row-based text storage undermines predicate and column projection efficiencies. The corresponding fix is to convert cleaned data to appropriately compressed Parquet with suitable partitions.
Incorrect Answers
A:This diagnosis addresses another AWS case: A partner uploads a CSV over SFTP to Transfer Family but a load starts before the file finishes writing. The dependency here is different.
C:This diagnosis addresses another AWS case: An SQS-backed processor overwhelms a downstream database after scaling consumers without any concurrency cap. 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.
AWS Certified Data Engineer - Associate DEA-C01 Practice Tests