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 690
After resolving the following incident, which ongoing safeguard most directly prevents recurrence? A Firehose pipeline is expected to deliver individual records instantly, yet it buffers batches before S3 delivery.
- Track average object size alongside throughput and query planning time.
- Record end-to-end latency separately from producer acknowledgement.
- Associate build artifacts with immutable source hashes.
- Include duplicate-event and retry fixtures in integration tests.
Explanation
Correct Answer
B:Record end-to-end latency separately from producer acknowledgement. This safeguards against a recurring cause: Delivery buffering settings and destination behavior conflict with the required freshness.
Incorrect Answers
A:That safeguard addresses another case: A Lambda process writes individual small S3 JSON files for millions of events and downstream scans slow dramatically. It is not the control for this recurring failure.
C:That safeguard addresses another case: A SAM deployment packages an outdated Lambda handler because build artifacts from a previous branch were reused. It is not the control for this recurring failure.
D: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.
Question 691
A team applies a reviewed fix for this situation: A Redshift datashare exposes more tables than a partner is contractually allowed to query. Which observed outcome would most convincingly validate the fix?
- An aged controlled audit fixture remains retrievable for the required period.
- The partner can query intended views without accessing unrelated source objects.
- The partner accesses only intended assets and access ends when approval expires.
- An ordinary BI user sees only the approved masked representation.
Explanation
Correct Answer
B:The partner can query intended views without accessing unrelated source objects. This verifies the result of restrict authorized shared schema/object grants and verify consumer access.
Incorrect Answers
A:This would verify another situation: An organization exports audit logs to S3 without lifecycle retention review and required records expire before annual audit. It does not validate the current case.
C:This would verify another situation: A Redshift datashare grants partner analysts access to a customer data mart without a purpose or term limit. It does not validate the current case.
D:This would verify another situation: A Redshift view exposes unmasked customer SSNs to a general BI role despite a requirement for partial disclosure. It does not validate the current case.
Question 692
A batch containing a required `customer_id` null value is committed to Redshift and breaks joins the next day. Which technical dependency most directly explains this behavior?
- Visualization dimensions and units are inconsistent between sources.
- The join excludes the population that must remain in the denominator.
- The pipeline has no required-field data quality gate before publishing.
- Operational log retention is not aligned with audit or incident policy.
Explanation
Correct Answer
C:The pipeline has no required-field data quality gate before publishing. The corresponding fix is to run a null/uniqueness check in Glue or SQL and quarantine failing rows or batches.
Incorrect Answers
A: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.
B:This diagnosis addresses another AWS case: An Athena view compares monthly cohorts using an inner join that drops customers with no activity, overstating retention. The dependency here is different.
D:This diagnosis addresses another AWS case: A Lambda processor logs errors but its CloudWatch Logs retention is shorter than the postmortem evidence requirement. The dependency here is different.
Question 693
An on-premises Oracle source feeds DMS, but newly added tables never appear in a configured migration. Select TWO complementary measures that correctly repair and validate this failure.
- Multiple tasks use the available cluster and total runtime improves.
- Use an appropriate hashed lookup structure while preserving deterministic output behavior.
- Update reviewed DMS table mapping and validate permissions and schema-change handling.
- A known new table's rows and later changes reach the approved target.
- Grant the migration role unrestricted database administrator rights by default.
Explanation
Correct Answers
C:Update reviewed DMS table mapping and validate permissions and schema-change handling. The underlying cause is: Table selection rules cover only the original schema or table set.
D:A known new table's rows and later changes reach the approved target. This is the observable result required before accepting the correction.
Incorrect Answers
A:This would validate a different case: A data transformation uses one Spark partition for a terabyte input and only one executor stays busy. It does not verify the outcome required here.
B:That corrective action is for a different case: A large ETL data structure uses a list for repeated membership checks and CPU use grows unexpectedly. It does not resolve this incident.
E:Grant the migration role unrestricted database administrator rights by default. That shortcut conflicts with the stated requirement.
Question 694
A Lambda processor logs errors but its CloudWatch Logs retention is shorter than the postmortem evidence requirement. Which technical dependency most directly explains this behavior?
- The new job is present but unreachable from the workflow's actual trigger graph.
- Single-metric quality scoring hides unintended data loss.
- The report does not wait for the asynchronous query to reach SUCCEEDED.
- Operational log retention is not aligned with audit or incident policy.
Explanation
Correct Answer
D:Operational log retention is not aligned with audit or incident policy. The corresponding fix is to set an appropriate retention and controlled access policy for log groups.
Incorrect Answers
A:This diagnosis addresses another AWS case: An engineer adds a new processing step to an AWS Glue workflow but never connects its trigger to the existing dependency chain. The dependency here is different.
B:This diagnosis addresses another AWS case: A data team declares a successful cleanup because duplicate percentage fell, but the job also dropped valid unique rows. The dependency here is different.
C:This diagnosis addresses another AWS case: An Athena automated report tries to read query results immediately after StartQueryExecution returns a query ID. The dependency here is different.
Question 695
After resolving the following incident, which ongoing safeguard most directly prevents recurrence? A Kinesis stream is receiving writes but downstream analytics remain empty after the consumer IAM role lost read permission.
- Monitor end-to-end flow, not producer success alone.
- Document allowed lateness and watermark monitoring by source.
- Test async completion and timeout paths in workflow CI.
- Use key-format fixtures in data preparation recipes.
Explanation
Correct Answer
A:Monitor end-to-end flow, not producer success alone. This safeguards against a recurring cause: Stream producer health is separate from the consumer's authorization and processing.
Incorrect Answers
B:That safeguard addresses another case: A nightly data product uses a moving seven-day window but incoming source events arrive late and are excluded without a watermark policy. It is not the control for this recurring failure.
C:That safeguard addresses another case: A Step Functions data pipeline invokes Glue using a request/response integration and immediately launches Athena against unfinished output. It is not the control for this recurring failure.
D:That safeguard addresses another case: An analyst creates a Glue DataBrew visual cleaning step that trims all leading zeros from product IDs, breaking lookups. It is not the control for this recurring failure.
Question 696
A Redshift star schema mixes order-line and order-header facts in the same table and reports double-count revenue. Which engineering change best addresses the underlying issue?
- Separate or explicitly model fact grain and join to dimensions at compatible levels.
- Align approved partition key definitions and S3 path generation or repair registered metadata.
- Grant scoped S3 and catalog/Lake Formation access to the Redshift authorized role.
- Tune supported export parallelism and downstream compaction based on file size and latency.
Explanation
Correct Answer
A:Separate or explicitly model fact grain and join to dimensions at compatible levels. It directly addresses the case cause (The modeled fact grain is inconsistent across record types.) and should be verified by: A multi-line order yields correct revenue and item counts in fixture reports.
Incorrect Answers
B:This change is appropriate to another case: A table claims a `region` partition key but the written S3 paths use `geography=...`, so Athena pruning fails. It does not directly repair this incident.
C:That change addresses a Redshift Spectrum external table points to S3 partitions whose IAM role cannot read the new prefix after an account move; it would not repair this incident.
D:That change addresses a warehouse unload creates thousands of tiny output files, raising downstream S3 request and processing overhead; it would not repair this incident.
Question 697
A pipeline sends database credentials in plaintext environment variables and writes them to CloudWatch on failure. Which technical dependency most directly explains this behavior?
- The audit evidence store's retention does not match compliance requirements.
- Lake Formation grants and role identities are evaluated per workload principal.
- Static credentials create unnecessary exposure and rotation burden.
- Secrets are handled as ordinary configuration and leaked through diagnostics.
Explanation
Correct Answer
D:Secrets are handled as ordinary configuration and leaked through diagnostics. The corresponding fix is to store and rotate credentials in Secrets Manager with scoped runtime retrieval and redacted logs.
Incorrect Answers
A:This diagnosis addresses another AWS case: An organization exports audit logs to S3 without lifecycle retention review and required records expire before annual audit. The dependency here is different.
B:This diagnosis addresses another AWS case: An Athena query against a Lake Formation resource succeeds for the analyst, yet a separate Glue ETL role cannot read that same table. The dependency here is different.
C:This diagnosis addresses another AWS case: A pipeline uses long-lived IAM user access keys embedded in a Glue script instead of an execution role. The dependency here is different.
Question 698
A team applies a reviewed fix for this situation: A Glue crawler discovers an S3 path containing two incompatible CSV header layouts and produces a wide schema with ambiguous columns. Which observed outcome would most convincingly validate the fix?
- Peak writes distribute without losing required entity queries.
- A controlled delete produces the documented target behavior within accepted lag.
- Known files appear under the intended distinct catalog schemas.
- A controlled external-table query reads the intended new partition only.
Explanation
Correct Answer
C:Known files appear under the intended distinct catalog schemas. This verifies the result of separate source prefixes/classifiers and create versioned tables with validated schema mappings.
Incorrect Answers
A:This would verify another situation: A DynamoDB table uses the same partition key for all new daily events, producing throttled writes during each morning burst. It does not validate the current case.
B:This would verify another situation: An S3 replication configuration excludes delete markers, but a team assumes target data will reflect source deletes instantly. It does not validate the current case.
D:This would verify another situation: A Redshift Spectrum external table points to S3 partitions whose IAM role cannot read the new prefix after an account move. It does not validate the current case.
Question 699
A team applies a reviewed fix for this situation: An S3 lake access point exists but a cross-account principal still receives AccessDenied when its IAM and bucket policies are not aligned. Which observed outcome would most convincingly validate the fix?
- The intended cross-account role reads only the allowed lake dataset.
- The analyst queries authorized views but cannot modify their source tables.
- The approved Glue job reads its required table without inheriting analyst-admin rights.
- A synthetic approved role change in a test Region is queryable by the auditor.
Explanation
Correct Answer
A:The intended cross-account role reads only the allowed lake dataset. This verifies the result of review the required access-point and identity/bucket permissions for the approved path.
Incorrect Answers
B:This would verify another situation: A Redshift data analyst has a role granting broad schema CREATE and DROP despite requiring only SELECT on a few views. It does not validate the current case.
C:This would verify another situation: An Athena query against a Lake Formation resource succeeds for the analyst, yet a separate Glue ETL role cannot read that same table. It does not validate the current case.
D:This would verify another situation: A CloudTrail Lake query lists IAM role changes but its event filter omits the Regions holding the relevant data pipelines. It does not validate the current case.
Question 700
A marketing report uses COUNT(*) of event records as its active user metric and overstates adoption when users retry. Which engineering change best addresses the underlying issue?
- Rebuild and test connector libraries against the supported new Glue runtime.
- Add and validate the correct conditional trigger path from the predecessor job.
- Aggregate by validated stable user identity and the intended time-window rules.
- Reconcile accepted, filtered and quarantined records with explicit balance equations.
Explanation
Correct Answer
C:Aggregate by validated stable user identity and the intended time-window rules. It directly addresses the case cause (Events and distinct users are different measurement grains.) and should be verified by: A user with several event retries contributes once to unique-user counts.
Incorrect Answers
A:That change addresses a data pipeline updates its Glue version but custom connector dependencies fail at initialization; it would not repair this incident.
B:That change addresses an engineer adds a new processing step to an AWS Glue workflow but never connects its trigger to the existing dependency chain; it would not repair this incident.
D:That change addresses a data quality gate compares raw and target record totals without accounting for intentional filter exclusions, falsely failing clean batches; it would not repair this incident.
AWS Certified Data Engineer - Associate DEA-C01 Practice Tests