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 750
A team applies a reviewed fix for this situation: A Glue streaming job writes duplicate target rows when a microbatch is retried after a worker restart. Which observed outcome would most convincingly validate the fix?
- The Lambda retrieves the intended object without an unrestricted internet route.
- A forced retry leaves one intended row per business event.
- The consumer selects the exact intended output without relying on a guessed path.
- The malformed record is isolated and good records do not create duplicate side effects.
Explanation
Correct Answer
B:A forced retry leaves one intended row per business event. This verifies the result of use stable event identities and a sink merge/conditional-write design tied to checkpoint semantics.
Incorrect Answers
A:This would verify another situation: A batch import uses a Lambda in a private subnet that cannot reach S3 because no NAT or S3 endpoint path is configured. It does not validate the current case.
C:This would verify another situation: An ETL task finishes but its success event omits the S3 prefix and schema version needed downstream. It does not validate the current case.
D:This would verify another situation: A Lambda Kinesis event-source mapping repeatedly delivers the same batch after one malformed record fails. It does not validate the current case.
Question 751
An S3 lake read works with an administrator role but fails with the production ETL role, and the team assumes the dataset is corrupt. Which engineering change best addresses the underlying issue?
- Inventory staging artifacts and enforce approved secure cleanup/retention and access.
- Restrict cross-Region replication and backup destinations to approved residency Regions.
- Review CloudTrail denied access and compare effective role, bucket and KMS permissions.
- Require supported TLS transport and approved destination identity/key handling.
Explanation
Correct Answer
C:Review CloudTrail denied access and compare effective role, bucket and KMS permissions. It directly addresses the case cause (Principal-dependent authorization is being confused with data integrity.) and should be verified by: The production role reads an approved sample without expanded administrative rights.
Incorrect Answers
A:That change addresses a lake-to-warehouse pipeline removes raw PII from visible tables but keeps an untracked temporary S3 staging prefix indefinitely; it would not repair this incident.
B:That change addresses a data lake in an EU Region replicates raw customer records to an unapproved Region for convenience; it would not repair this incident.
D:That change addresses an S3 export writes regulated data to an unencrypted partner endpoint despite source-at-rest SSE-KMS protection; it would not repair this incident.
Question 752
After resolving the following incident, which ongoing safeguard most directly prevents recurrence? An analytics team relies on Glue technical table names to determine which datasets are permitted for finance reporting.
- Test functional expiration separately from background storage cleanup.
- Document every required query pattern before schema rollout.
- Classify transactional versus analytical requirements in storage design reviews.
- Review business classification and glossary terms during onboarding.
Explanation
Correct Answer
D:Review business classification and glossary terms during onboarding. This safeguards against a recurring cause: Physical metadata alone does not express authoritative business meaning and stewardship.
Incorrect Answers
A:That safeguard addresses another case: A DynamoDB table contains session records with expired timestamps but items remain visible immediately after expiry. It is not the control for this recurring failure.
B:That safeguard addresses another case: A DynamoDB table needs lookup by email but stores only user ID and relies on full-table Scan for each login. It is not the control for this recurring failure.
C:That safeguard addresses another case: A Redshift analytics warehouse holds transactional checkout rows that require thousands of short atomic row updates per second. It is not the control for this recurring failure.
Question 753
After resolving the following incident, which ongoing safeguard most directly prevents recurrence? A personal-data deletion request removes a row from an Athena external table view but leaves original S3 objects and downstream extracts.
- Validate CloudTrail event selectors during forensic readiness checks.
- Require negative privilege tests for wildcard policy changes.
- Keep lineage-based deletion runbooks and retention-exception records.
- Monitor both log ingestion and queryable coverage per date.
Explanation
Correct Answer
C:Keep lineage-based deletion runbooks and retention-exception records. This safeguards against a recurring cause: Deleting catalog metadata does not erase all underlying or derived personal data.
Incorrect Answers
A:That safeguard addresses another case: An S3 data-access investigation searches CloudTrail for object reads but only management events were enabled. It is not the control for this recurring failure.
B:That safeguard addresses another case: A data access policy permits all S3 prefixes under `reports/*`, unintentionally including payroll records stored beneath that path. It is not the control for this recurring failure.
D:That safeguard addresses another case: An Athena query for CloudTrail logs shows a missing day because the log data lake partitions were never registered. It is not the control for this recurring failure.
Question 754
After resolving the following incident, which ongoing safeguard most directly prevents recurrence? Two Kinesis consumers must independently recover after a deployment, but one team reuses the other's checkpoint store.
- Test point-in-time correctness with future reference updates.
- Maintain documented error classes and bounded retry budgets.
- Audit ownership and naming of consumer checkpoints.
- Review subscription ownership and dead-letter paths periodically.
Explanation
Correct Answer
C:Audit ownership and naming of consumer checkpoints. This safeguards against a recurring cause: Consumer applications share state intended to represent separate progress positions.
Incorrect Answers
A:That safeguard addresses another case: A Glue transform joins events to reference data refreshed weekly, but old events are silently reclassified on every rerun. It is not the control for this recurring failure.
B:That safeguard addresses another case: A Step Functions state retries every failure including invalid schema, consuming budget without possibility of success. It is not the control for this recurring failure.
D:That safeguard addresses another case: A multi-account data pipeline sends operational alerts through an SNS topic that no engineer subscribes to. It is not the control for this recurring failure.
Question 755
An AWS DMS migration creates a new database table but foreign-key dependencies fail during cutover because schema compatibility was never rehearsed. Which engineering change best addresses the underlying issue?
- Model validated numeric coordinate fields with units and location quality checks.
- Add correct scoped KMS decrypt permissions and key-policy authorization for the loading role.
- Inventory schema conversion separately, apply validated DDL and rehearse dependency ordering.
- Grant scoped bucket permissions and necessary KMS access to the Redshift execution role.
Explanation
Correct Answer
C:Inventory schema conversion separately, apply validated DDL and rehearse dependency ordering. It directly addresses the case cause (Data migration alone does not resolve source/target schema and constraint differences.) and should be verified by: Representative referential integrity tests pass after a controlled cutover.
Incorrect Answers
A: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.
B:That change addresses a Redshift COPY command reads encrypted S3 files but the IAM role lacks decryption permission for the customer KMS key; it would not repair this incident.
D:That change addresses a Redshift UNLOAD writes reporting data to an S3 bucket in another account but fails with access denied; it would not repair this incident.
Question 756
After resolving the following incident, which ongoing safeguard most directly prevents recurrence? A batch ETL task combines USD and EUR amounts under the same column and computes invalid totals.
- Test large responses, page limits, and interrupted cursors in CI.
- Require DAG import and syntax checks in CI.
- Test the network path independently of password verification.
- Check units and conversion-rate provenance in data quality controls.
Explanation
Correct Answer
D:Check units and conversion-rate provenance in data quality controls. This safeguards against a recurring cause: The transformation omits currency and units normalization.
Incorrect Answers
A: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.
B:That safeguard addresses another case: An MWAA DAG was deployed but its Python import fails, so no scheduled run appears. It is not the control for this recurring failure.
C:That safeguard addresses another case: A Glue connection to a source RDS database times out, although the JDBC credentials are valid. It is not the control for this recurring failure.
Question 757
After resolving the following incident, which ongoing safeguard most directly prevents recurrence? An EMR Spark job sends all rows for a popular customer to one reducer and fails despite plenty of idle cores.
- Test asynchronous lifecycle and timeouts during orchestration review.
- Monitor replication lag against source log-retention safety margins.
- Add skew fixtures and per-task duration thresholds to performance tests.
- Visualize and test dependency DAGs on new schedule changes.
Explanation
Correct Answer
C:Add skew fixtures and per-task duration thresholds to performance tests. This safeguards against a recurring cause: Skewed join/group keys concentrate disproportionate workload in one task.
Incorrect Answers
A:That safeguard addresses another case: A Step Functions pipeline sends a notification before the ETL task's asynchronous execution actually completes. It is not the control for this recurring failure.
B:That safeguard addresses another case: A DMS CDC task finishes a full-load phase but stops capturing source table changes when the source transaction log expires. It is not the control for this recurring failure.
D:That safeguard addresses another case: A scheduled Glue workflow triggers two jobs concurrently though the second requires the first output's partition. It is not the control for this recurring failure.
Question 758
A Redshift COPY command reads encrypted S3 files but the IAM role lacks decryption permission for the customer KMS key. Which technical dependency most directly explains this behavior?
- Schema discovery crosses incompatible source populations in one catalog grouping.
- External-table query capability is confused with supported table mutation semantics.
- Analytical query workload competes with the transaction service.
- Storage read authorization does not supply the required cryptographic key access.
Explanation
Correct Answer
D:Storage read authorization does not supply the required cryptographic key access. The corresponding fix is to add correct scoped KMS decrypt permissions and key-policy authorization for the loading role.
Incorrect Answers
A:This diagnosis addresses another AWS case: A Glue crawler discovers an S3 path containing two incompatible CSV header layouts and produces a wide schema with ambiguous columns. The dependency here is different.
B:This diagnosis addresses another AWS case: A Redshift query joins external and local datasets but expects Spectrum to automatically overwrite remote S3 data during UPDATE. The dependency here is different.
C:This diagnosis addresses another AWS case: An operational RDS database has a complex read-only report consuming most CPU at peak checkout time. The dependency here is different.
Question 759
A Spark aggregation produces incorrect category totals because one hot key is dropped after a task retry and the target doesn't reconcile. Which technical dependency most directly explains this behavior?
- The changed table layout or join pattern increases data movement.
- Pipeline retry handling and final quality checks do not preserve all expected groups.
- Alarm logic lacks an agreed signal threshold and actionable severity.
- A display label is not a stable relational join key.
Explanation
Correct Answer
B:Pipeline retry handling and final quality checks do not preserve all expected groups. The corresponding fix is to validate per-key aggregates and end-to-end counts with replay-safe commit semantics.
Incorrect Answers
A:This diagnosis addresses another AWS case: A Redshift reporting job suddenly spends time redistributing a large fact table after a schema change. The dependency here is different.
C:This diagnosis addresses another AWS case: A monitoring rule sees one Athena query failure and pages the full team despite a known transient backend retry. The dependency here is different.
D:This diagnosis addresses another AWS case: A Redshift SQL view joins two tables on customer name, and a same-name collision merges unrelated accounts. The dependency here is different.
Question 760
After resolving the following incident, which ongoing safeguard most directly prevents recurrence? A PySpark transformation uses Python row-by-row loops to parse simple scalar fields and runs slowly.
- Record end-to-end latency separately from producer acknowledgement.
- Profile costly UDFs before accepting new ETL code.
- Monitor Lambda concurrent executions and event-source lag together.
- Apply schema and timestamp quality tests at ingress.
Explanation
Correct Answer
B:Profile costly UDFs before accepting new ETL code. This safeguards against a recurring cause: Per-record interpreter overhead replaces optimized distributed expressions.
Incorrect Answers
A:That safeguard addresses another case: A Firehose pipeline is expected to deliver individual records instantly, yet it buffers batches before S3 delivery. It is not the control for this recurring failure.
C:That safeguard addresses another case: A Lambda ETL function exhausts concurrency during a flash sale, causing fresh events to be throttled. It is not the control for this recurring failure.
D:That safeguard addresses another case: A data ingestion service accepts API JSON but passes inconsistent event time zones to downstream partitions. It is not the control for this recurring failure.
AWS Certified Data Engineer - Associate DEA-C01 Practice Tests