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 1090
A data catalog stores PII labels only as free-text comments, so new tables bypass a tagging-based access process. Which engineering change best addresses the underlying issue?
- Grant scoped bucket permissions and necessary KMS access to the Redshift execution role.
- Apply approved standardized catalog classification tags or LF-Tags and validate inherited rules.
- Apply application-level expiry checks where strict visibility is required and keep TTL for eventual cleanup.
- Plan a suitable alternate index or redesign around known query requirements.
Explanation
Correct Answer
B:Apply approved standardized catalog classification tags or LF-Tags and validate inherited rules. It directly addresses the case cause (Inconsistent metadata taxonomies prevent reliable automated governance.) and should be verified by: A newly onboarded sensitive table receives the intended governed classification.
Incorrect Answers
A: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.
C:That change addresses a DynamoDB table contains session records with expired timestamps but items remain visible immediately after expiry; it would not repair this incident.
D:That change addresses a DynamoDB table uses composite key `tenant#date` but most reads are by `transaction_id` only and become scans; it would not repair this incident.
Question 1091
A team applies a reviewed fix for this situation: A partner uploads a CSV over SFTP to Transfer Family but a load starts before the file finishes writing. Which observed outcome would most convincingly validate the fix?
- Driver memory remains stable while full dataset results are produced.
- The new deployment fails validation before production if a required parameter is missing.
- The loader processes the complete expected byte count and checksum only once.
- A maximum-size fixture completes without filling local temporary storage.
Explanation
Correct Answer
C:The loader processes the complete expected byte count and checksum only once. This verifies the result of consume a supported completion event or atomic finalized object naming before ingestion.
Incorrect Answers
A:This would verify another situation: A distributed Spark process collects a large dataset to the driver and crashes from memory exhaustion. It does not validate the current case.
B:This would verify another situation: A code deployment changes an ETL function's parameter name but unit tests exercise only the old pipeline entry point. It does not validate the current case.
D:This would verify another situation: A Lambda ETL process writes temporary files larger than its configured /tmp capacity and receives storage errors. It does not validate the current case.
Question 1092
A Glue job reading nested JSON flattens arrays incorrectly and duplicates parent order totals. Which engineering change best addresses the underlying issue?
- Use deterministic batch output keys or conditional commits and reconcile existing results on retry.
- Use a stable manifest identifier with transactional state before launching or committing loads.
- Keep transformations distributed and collect only bounded diagnostic samples.
- Normalize arrays with stable parent identifiers and aggregate only at the intended business grain.
Explanation
Correct Answer
D:Normalize arrays with stable parent identifiers and aggregate only at the intended business grain. It directly addresses the case cause (The transformation changes record granularity without an explicit explode/join design.) and should be verified by: A fixture with two nested lines produces correct line and order totals.
Incorrect Answers
A: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.
B:That change addresses a production Glue workflow receives the same completed-file notification twice and creates two warehouse loads; it would not repair this incident.
C:That change addresses a distributed Spark process collects a large dataset to the driver and crashes from memory exhaustion; it would not repair this incident.
Question 1093
A DynamoDB application requires strongly consistent reads immediately after a successful critical write but queries a global secondary index. Select TWO complementary measures that correctly repair and validate this failure.
- Use a supported strongly consistent base-table or local-index read design where necessary.
- A conflicting schema change is rejected before the production job runs.
- A controlled write/read test meets the documented consistency requirement.
- Request ConsistentRead=true on a GSI and assume it will work.
- Apply a stable catalog schema and quarantine malformed headers or records upstream.
Explanation
Correct Answers
A:Use a supported strongly consistent base-table or local-index read design where necessary. The underlying cause is: The chosen read path cannot provide strong consistency on the GSI.
C:A controlled write/read test meets the documented consistency requirement. This is the observable result required before accepting the correction.
Incorrect Answers
B:This would validate a different case: Two developers independently edit Glue Data Catalog schema types during release, and a job fails after the last writer wins. It does not verify the outcome required here.
D:Request ConsistentRead=true on a GSI and assume it will work. That shortcut conflicts with the stated requirement.
E:That corrective action is for a different case: A crawler changes a decimal sales column to string after encountering a nonnumeric banner row in one export. It does not resolve this incident.
Question 1094
A Redshift transformation materializes a complex subquery repeatedly in one reporting workflow and exceeds its compute budget. Which engineering change best addresses the underlying issue?
- Gate promotion on integration tests using a restricted fixture and expected output assertions.
- Evaluate a compatible materialized view or staged aggregate with an explicit refresh policy.
- Persist scoped task-token correlation securely and use supported callback completion.
- Publish versioned manifest metadata containing output location, partition, checksum, and schema identity.
Explanation
Correct Answer
B:Evaluate a compatible materialized view or staged aggregate with an explicit refresh policy. It directly addresses the case cause (Repeated equivalent computation is not reused or pre-aggregated appropriately.) and should be verified by: Reports return correct current results with reduced repeated computation.
Incorrect Answers
A:That change addresses a CI pipeline promotes an ETL artifact after syntax checks but without a representative integration job against staged data; it would not repair this incident.
C:That change addresses a Step Functions Standard workflow waits for an external vendor callback but the task token is lost in logs; it would not repair this incident.
D:That change addresses an ETL task finishes but its success event omits the S3 prefix and schema version needed downstream; it would not repair this incident.
Question 1095
An AWS MWAA DAG has no task-level retries or SLA alerts, and a brief Glue API throttle causes a missed daily close. Which engineering change best addresses the underlying issue?
- Use supported partial batch failure handling and idempotent sink writes with a failure destination.
- Use reproducible clean builds and validate the packaged Lambda handler in CI.
- Use a stable ingestion event ID with conditional writes or a deduplicating transaction design.
- Configure bounded task retries, failure callbacks and deadline-aware notifications.
Explanation
Correct Answer
D:Configure bounded task retries, failure callbacks and deadline-aware notifications. It directly addresses the case cause (Airflow task failure handling does not match known transient dependency behavior.) and should be verified by: A simulated transient failure recovers and persistent failures produce timely alerts.
Incorrect Answers
A: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.
B:That change addresses a SAM deployment packages an outdated Lambda handler because build artifacts from a previous branch were reused; it would not repair this incident.
C:That change addresses an ingestion app writes identical DynamoDB item updates after a network retry and an audit counter increments twice; it would not repair this incident.
Question 1096
A legal-hold dataset is subject to an S3 Lifecycle expiration rule that would remove evidence at the usual age. Which engineering change best addresses the underlying issue?
- Use a supported strongly consistent base-table or local-index read design where necessary.
- Select an appropriate supported index or purpose-built query store using measured predicates.
- Use supported S3 Object Lock legal hold/retention and review lifecycle interactions.
- Use appropriately partitioned Parquet or another supported format, and verify partition predicates.
Explanation
Correct Answer
C:Use supported S3 Object Lock legal hold/retention and review lifecycle interactions. It directly addresses the case cause (Retention policy must not override active preservation requirements.) and should be verified by: Protected test objects remain undeletable under expected retention conditions.
Incorrect Answers
A:That change addresses a DynamoDB application requires strongly consistent reads immediately after a successful critical write but queries a global secondary index; it would not repair this incident.
B:That change addresses a geospatial data catalog is placed in DynamoDB with no defined access key and engineers scan the entire table for each location; it would not repair this incident.
D:That change addresses an Athena query reads huge raw JSON partitions for a narrow timestamp filter and scans far more bytes than expected; it would not repair this incident.
Question 1097
A Lambda Kinesis event-source mapping repeatedly delivers the same batch after one malformed record fails. Which technical dependency most directly explains this behavior?
- Row-based text storage undermines predicate and column projection efficiencies.
- Airflow task failure handling does not match known transient dependency behavior.
- Persisted dataset lifetimes exceed the stages that need them.
- Batch failure and checkpoint behavior cause previously successful records to be retried.
Explanation
Correct Answer
D:Batch failure and checkpoint behavior cause previously successful records to be retried. The corresponding fix is to use supported partial batch failure handling and idempotent sink writes with a failure destination.
Incorrect Answers
A:This diagnosis addresses another AWS case: An ETL job writes CSV to a large analytics lake and Athena scans every column for two-field reports. The dependency here is different.
B:This diagnosis addresses another AWS case: An AWS MWAA DAG has no task-level retries or SLA alerts, and a brief Glue API throttle causes a missed daily close. The dependency here is different.
C:This diagnosis addresses another AWS case: An EMR Spark pipeline runs near memory limits because it caches multiple large datasets and never releases them. The dependency here is different.
Question 1098
After resolving the following incident, which ongoing safeguard most directly prevents recurrence? A DynamoDB-backed application needs to redact sensitive values before exporting analytics but relies only on table encryption.
- Document data minimization rules in export contracts.
- Include negative column-access tests in governed dataset onboarding.
- Validate IAM trust and permission policy pairs in deployment checks.
- Use policy-simulator and negative-access tests during access changes.
Explanation
Correct Answer
A:Document data minimization rules in export contracts. This safeguards against a recurring cause: Encryption at rest does not implement field-level privacy minimization in plaintext exports.
Incorrect Answers
B:That safeguard addresses another case: A Lake Formation table exposes a private salary column through a broad Athena SELECT grant when an analyst needs only aggregated headcount. It is not the control for this recurring failure.
C:That safeguard addresses another case: A Step Functions state invokes a Lambda using a role that trusts EC2 instead of the Step Functions service. It is not the control for this recurring failure.
D:That safeguard addresses another case: An S3 lake access point exists but a cross-account principal still receives AccessDenied when its IAM and bucket policies are not aligned. It is not the control for this recurring failure.
Question 1099
A Glue job in a private VPC cannot read a governed S3 source after the executor role loses permission, although its worker network is healthy. Which technical dependency most directly explains this behavior?
- The published data access layer does not implement required masking or view restrictions.
- Network reachability is distinct from the execution role's S3 authorization.
- At-rest encryption does not secure data transmission on an external path.
- Data sharing scope was defined too broadly for the partner's agreed dataset.
Explanation
Correct Answer
B:Network reachability is distinct from the execution role's S3 authorization. The corresponding fix is to restore least-privilege S3 actions and evaluate the role's endpoint and bucket policies.
Incorrect Answers
A:This diagnosis addresses another AWS case: A Redshift view exposes unmasked customer SSNs to a general BI role despite a requirement for partial disclosure. The dependency here is different.
C:This diagnosis addresses another AWS case: An S3 export writes regulated data to an unencrypted partner endpoint despite source-at-rest SSE-KMS protection. The dependency here is different.
D:This diagnosis addresses another AWS case: A Redshift datashare exposes more tables than a partner is contractually allowed to query. The dependency here is different.
Question 1100
After resolving the following incident, which ongoing safeguard most directly prevents recurrence? An Athena query of yesterday's S3 partition returns zero rows because its table metadata lacks that partition.
- Make partition-registration a verified publish step.
- Require verified replacement and retention checks before garbage collection.
- Benchmark partition count and size distributions.
- Make lineage publication part of pipeline completion.
Explanation
Correct Answer
A:Make partition-registration a verified publish step. This safeguards against a recurring cause: The catalog partition listing is not synchronized with newly written S3 prefixes.
Incorrect Answers
B:That safeguard addresses another case: A nightly lake job publishes versioned S3 snapshots but deletes all old snapshots before the replacement is fully validated. It is not the control for this recurring failure.
C:That safeguard addresses another case: An Athena table uses daily partitions on a timestamp with millions of near-empty partition folders. It is not the control for this recurring failure.
D:That safeguard addresses another case: A data team cannot determine whether a report column came from the original CRM source or an intermediate cleansing step. It is not the control for this recurring failure.
AWS Certified Data Engineer - Associate DEA-C01 Practice Tests