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 660
An AWS Glue job writes to a governed S3 target but lacks the Lake Formation data-location access permission required for its workflow. Which engineering change best addresses the underlying issue?
- Publish ownership, purpose, classification and scoped project access before sharing.
- Enable reviewed CloudTrail data events for the required S3 buckets or prefixes.
- Locate affected source and derivative assets via lineage and apply approved deletion/retention policy.
- Grant scoped data-location and catalog permissions alongside required IAM policies.
Explanation
Correct Answer
D:Grant scoped data-location and catalog permissions alongside required IAM policies. It directly addresses the case cause (Underlying S3 IAM rights alone do not satisfy applicable Lake Formation location governance.) and should be verified by: The job writes only its registered approved table location.
Incorrect Answers
A:That change addresses a SageMaker Catalog project shares a data product broadly across teams without recording owner and allowed purpose; it would not repair this incident.
B:That change addresses an S3 data-access investigation searches CloudTrail for object reads but only management events were enabled; it would not repair this incident.
C:That change addresses a personal-data deletion request removes a row from an Athena external table view but leaves original S3 objects and downstream extracts; it would not repair this incident.
Question 661
A team applies a reviewed fix for this situation: A Step Functions pipeline sends a notification before the ETL task's asynchronous execution actually completes. Which observed outcome would most convincingly validate the fix?
- Notifications fire only after the transform reaches a recorded successful terminal state.
- Observed record-to-S3 latency meets the documented achievable target.
- The published job serializes work to executors and produces correct output.
- A forced retry leaves one intended row per business event.
Explanation
Correct Answer
A:Notifications fire only after the transform reaches a recorded successful terminal state. This verifies the result of use supported synchronous integration or task token/wait-and-poll completion logic.
Incorrect Answers
B:This would verify another situation: A Firehose pipeline is expected to deliver individual records instantly, yet it buffers batches before S3 delivery. It does not validate the current case.
C:This would verify another situation: A team changes an analytics library but releases a job without checking distributed task serialization compatibility. It does not validate the current case.
D:This would verify another situation: A Glue streaming job writes duplicate target rows when a microbatch is retried after a worker restart. It does not validate the current case.
Question 662
A Redshift SQL view joins two tables on customer name, and a same-name collision merges unrelated accounts. Which engineering change best addresses the underlying issue?
- Move bulk transformation to a suitable managed batch/distributed service and orchestrate it.
- Use defensible stratified sampling with confidence limits or full checks for critical constraints.
- Configure supported persistent log delivery to a controlled durable location.
- Join on documented unique customer identifiers and enforce suitable grain.
Explanation
Correct Answer
D:Join on documented unique customer identifiers and enforce suitable grain. It directly addresses the case cause (A display label is not a stable relational join key.) and should be verified by: Two different same-name fixtures remain distinct in the resulting view.
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 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.
C:That change addresses an EMR job intermittently fails due to capacity interruptions but its logs are stored only on the terminated instance; it would not repair this incident.
Question 663
A team applies a reviewed fix for this situation: An S3 data product has an approved seven-year retention requirement, but an engineer adds a 30-day expiration lifecycle rule. Which observed outcome would most convincingly validate the fix?
- The remote data change is visible through the supported external query path.
- Queries return comparable relevant neighbors from a consistent model representation.
- Compliance fixtures remain available for the required duration.
- Network redistribution and join latency improve with unchanged outputs.
Explanation
Correct Answer
C:Compliance fixtures remain available for the required duration. This verifies the result of validate retention requirements and apply supported retention/lock controls before approving lifecycle changes.
Incorrect Answers
A:This would verify another situation: A Redshift query joins external and local datasets but expects Spectrum to automatically overwrite remote S3 data during UPDATE. It does not validate the current case.
B:This would verify another situation: A vector retrieval index stores embeddings from two incompatible model versions in one dimension-dependent collection. It does not validate the current case.
D:This would verify another situation: A small dimension table joins huge Redshift facts, but an unnecessarily EVEN distribution causes repeated data transfer. It does not validate the current case.
Question 664
A team applies a reviewed fix for this situation: An S3 data-access investigation searches CloudTrail for object reads but only management events were enabled. Which observed outcome would most convincingly validate the fix?
- The authorized destination role reads replicas and unapproved accounts remain denied.
- A controlled invocation succeeds only for authorized source actions.
- A controlled object read produces a traceable data event with expected context.
- The analyst queries authorized views but cannot modify their source tables.
Explanation
Correct Answer
C:A controlled object read produces a traceable data event with expected context. This verifies the result of enable reviewed CloudTrail data events for the required S3 buckets or prefixes.
Incorrect Answers
A:This would verify another situation: A data lake copies SSE-KMS objects across AWS accounts but the destination principal cannot decrypt the replica. It does not validate the current case.
B:This would verify another situation: A Lambda data extractor assumes an EC2 instance profile is available when running as a Lambda function. It does not validate the current case.
D: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.
Question 665
A Glue JDBC extraction overloads a small OLTP database when hundreds of partitions open simultaneous connections. Which technical dependency most directly explains this behavior?
- Consumer applications share state intended to represent separate progress positions.
- Infrastructure drift makes deployments non-repeatable.
- Test coverage fails to represent the actual deployed interface.
- Extraction parallelism ignores source capacity and transaction impact.
Explanation
Correct Answer
D:Extraction parallelism ignores source capacity and transaction impact. The corresponding fix is to limit partitioned reads and schedule extraction within source performance budgets.
Incorrect Answers
A:This diagnosis addresses another AWS case: Two Kinesis consumers must independently recover after a deployment, but one team reuses the other's checkpoint store. The dependency here is different.
B:This diagnosis addresses another AWS case: A serverless pipeline deploys with hand-edited IAM and S3 settings that differ among test and production accounts. The dependency here is different.
C:This diagnosis addresses another AWS case: A code deployment changes an ETL function's parameter name but unit tests exercise only the old pipeline entry point. The dependency here is different.
Question 666
A fact table in Redshift filters mostly on event date but load order does not correlate with the filter, driving wide block scans. Which technical dependency most directly explains this behavior?
- Storage read authorization does not supply the required cryptographic key access.
- Unvalidated mixed-format source rows contaminated schema inference.
- Schema discovery crosses incompatible source populations in one catalog grouping.
- The current sort/physical layout is unhelpful for common predicates.
Explanation
Correct Answer
D:The current sort/physical layout is unhelpful for common predicates. The corresponding fix is to measure query plans and evaluate AUTO or an appropriate event-time sort design.
Incorrect Answers
A:This diagnosis addresses another AWS case: A Redshift COPY command reads encrypted S3 files but the IAM role lacks decryption permission for the customer KMS key. The dependency here is different.
B:This diagnosis addresses another AWS case: A crawler changes a decimal sales column to string after encountering a nonnumeric banner row in one export. The dependency here is different.
C: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.
Question 667
After resolving the following incident, which ongoing safeguard most directly prevents recurrence? A Glue DataBrew recipe was changed interactively but the production pipeline still applies a previous published recipe version.
- Maintain release/version compatibility tests for third-party connectors.
- Check measure units and aggregation grain in dashboard reviews.
- Use primary business keys and collision tests for join logic.
- Record recipe revision and project ownership in pipeline manifests.
Explanation
Correct Answer
D:Record recipe revision and project ownership in pipeline manifests. This safeguards against a recurring cause: Recipe selection and deployment version are not aligned.
Incorrect Answers
A:That safeguard addresses another case: A data pipeline updates its Glue version but custom connector dependencies fail at initialization. It is not the control for this recurring failure.
B:That safeguard addresses another case: A QuickSight dashboard compares two branch cost reports, one in local currency and one in USD, without conversion. It is not the control for this recurring failure.
C:That safeguard addresses another case: A Redshift SQL view joins two tables on customer name, and a same-name collision merges unrelated accounts. It is not the control for this recurring failure.
Question 668
An orchestrator invokes a Lambda that writes to S3 then times out; the retry writes a second output under a new random key. Which engineering change best addresses the underlying issue?
- Check Glue connection subnet, ENIs, VPC routing, DNS, and the source's inbound rule.
- Use deterministic batch output keys or conditional commits and reconcile existing results on retry.
- Configure a supported S3 VPC endpoint or justified outbound path with required IAM and endpoint policies.
- Use supported batching, buffering, compaction, or columnar write paths appropriate to latency.
Explanation
Correct Answer
B:Use deterministic batch output keys or conditional commits and reconcile existing results on retry. It directly addresses the case cause (Retries use non-idempotent output identity with uncertain prior completion.) and should be verified by: A forced timeout yields one authoritative committed output for the batch.
Incorrect Answers
A:That change addresses a Glue connection to a source RDS database times out, although the JDBC credentials are valid; it would not repair this incident.
C:That change addresses a batch import uses a Lambda in a private subnet that cannot reach S3 because no NAT or S3 endpoint path is configured; it would not repair this incident.
D:That change addresses a Lambda process writes individual small S3 JSON files for millions of events and downstream scans slow dramatically; it would not repair this incident.
Question 669
An Athena view compares monthly cohorts using an inner join that drops customers with no activity, overstating retention. Which technical dependency most directly explains this behavior?
- Pipeline health is not connected to operational alert thresholds.
- The join excludes the population that must remain in the denominator.
- Recipe selection and deployment version are not aligned.
- Pipeline retry handling and final quality checks do not preserve all expected groups.
Explanation
Correct Answer
B:The join excludes the population that must remain in the denominator. The corresponding fix is to retain the baseline cohort and left-join subsequent activity with explicit null handling.
Incorrect Answers
A:This diagnosis addresses another AWS case: A Glue job has failed for three mornings but no CloudWatch alarm exists, so dashboards show stale data. The dependency here is different.
C:This diagnosis addresses another AWS case: A Glue DataBrew recipe was changed interactively but the production pipeline still applies a previous published recipe version. The dependency here is different.
D:This diagnosis addresses another AWS case: A Spark aggregation produces incorrect category totals because one hot key is dropped after a task retry and the target doesn't reconcile. The dependency here is different.
Question 670
A project migrates its authoritative EU records to another AWS Region and management assumes an S3 bucket policy alone enforces future residency. Which technical dependency most directly explains this behavior?
- API activity history does not directly replace configuration-state/compliance evaluation.
- Governance requires controls across replication, backups and all services, not one bucket policy.
- A service role cannot replace blocked VPC routes or security group rules.
- Encryption at rest does not implement field-level privacy minimization in plaintext exports.
Explanation
Correct Answer
B:Governance requires controls across replication, backups and all services, not one bucket policy. The corresponding fix is to apply account/organization guardrails, regional resource rules and audited exception processes.
Incorrect Answers
A:This diagnosis addresses another AWS case: An AWS Config rule flags altered S3 encryption settings but the team uses CloudTrail alone as its continuous current-state configuration inventory. 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: A DynamoDB-backed application needs to redact sensitive values before exporting analytics but relies only on table encryption. The dependency here is different.
AWS Certified Data Engineer - Associate DEA-C01 Practice Tests