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 990
After resolving the following incident, which ongoing safeguard most directly prevents recurrence? A distributed Spark process collects a large dataset to the driver and crashes from memory exhaustion.
- Audit DMS selection mappings after source schema changes.
- Add lifecycle checks for persistence and executor memory use.
- Version and validate the event envelope contract at ingestion.
- Prohibit unbounded collect operations in production ETL code reviews.
Explanation
Correct Answer
D:Prohibit unbounded collect operations in production ETL code reviews. This safeguards against a recurring cause: An unbounded driver collect breaks distributed processing assumptions.
Incorrect Answers
A:That safeguard addresses another case: An on-premises Oracle source feeds DMS, but newly added tables never appear in a configured migration. It is not the control for this recurring failure.
B:That safeguard addresses another case: An EMR Spark pipeline runs near memory limits because it caches multiple large datasets and never releases them. It is not the control for this recurring failure.
C:That safeguard addresses another case: A mobile event producer uses timestamp as the only deduplication key and collapses unrelated events recorded in one millisecond. It is not the control for this recurring failure.
Question 991
A cross-account Lake Formation share is granted but the consumer account has not accepted its RAM invitation where required. Which engineering change best addresses the underlying issue?
- Apply approved tokenization, masking, or projection before data exits the trusted boundary.
- Complete supported AWS RAM share acceptance and consumer-side permission delegation.
- Validate Glue network connection resources, subnets, SGs and database credentials together.
- Restore least-privilege S3 actions and evaluate the role's endpoint and bucket policies.
Explanation
Correct Answer
B:Complete supported AWS RAM share acceptance and consumer-side permission delegation. It directly addresses the case cause (Cross-account resource sharing has a recipient-side acceptance and grant step.) and should be verified by: An authorized consumer principal can resolve and read the shared table.
Incorrect Answers
A:That change addresses a DynamoDB-backed application needs to redact sensitive values before exporting analytics but relies only on table encryption; it would not repair this incident.
C:That change addresses a Glue crawler in a VPC fails connection to a private RDS source even with the right IAM service role; it would not repair this incident.
D:That change addresses 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; it would not repair this incident.
Question 992
A mobile event producer uses timestamp as the only deduplication key and collapses unrelated events recorded in one millisecond. 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.
- Limit partitioned reads and schedule extraction within source performance budgets.
- Use stable producer event IDs and appropriate per-source sequence information.
- Use supported synchronous integration or task token/wait-and-poll completion logic.
Explanation
Correct Answer
C:Use stable producer event IDs and appropriate per-source sequence information. It directly addresses the case cause (The event identity is not unique across simultaneously generated records.) and should be verified by: Two distinct same-timestamp events survive, while a retried ID deduplicates.
Incorrect Answers
A:That change addresses an application sends semi-structured documents to an LLM to classify regulated labels but stores model output without schema checking; it would not repair this incident.
B:That change addresses a Glue JDBC extraction overloads a small OLTP database when hundreds of partitions open simultaneous connections; it would not repair this incident.
D:That change addresses a Step Functions pipeline sends a notification before the ETL task's asynchronous execution actually completes; it would not repair this incident.
Question 993
A team adds a nonnullable required field to an Iceberg table but old rows have no value and downstream reads fail. Select THREE complementary measures that correctly repair and validate, and prevent recurrence of this failure.
- Review evolution compatibility and snapshot rollback requirements.
- Stage an additive nullable field, backfill and validate before enforcing stricter semantics.
- Iterate with the supported LastEvaluatedKey mechanism and checkpoint progress.
- Rewrite Iceberg metadata JSON manually to fabricate old values.
- Recall and latency meet agreed thresholds on representative embeddings.
- Historical snapshots and new rows remain queryable during the migration.
Explanation
Correct Answers
A:Review evolution compatibility and snapshot rollback requirements. This protects against the following risk: Schema evolution introduced a requirement incompatible with existing records.
B:Stage an additive nullable field, backfill and validate before enforcing stricter semantics. The underlying cause is: Schema evolution introduced a requirement incompatible with existing records.
F:Historical snapshots and new rows remain queryable during the migration. This is the observable result required before accepting the correction.
Incorrect Answers
C:That corrective action is for a different case: A DynamoDB archival pipeline uses Scan without pagination and misses records beyond the first page. It does not resolve this incident.
D:Rewrite Iceberg metadata JSON manually to fabricate old values. That shortcut conflicts with the stated requirement.
E:This would validate a different case: An Aurora PostgreSQL vector workload uses a vector index tuned for approximate nearest neighbors without checking recall for a new embedding model. It does not verify the outcome required here.
Question 994
An engineer adds a new processing step to an AWS Glue workflow but never connects its trigger to the existing dependency chain. Select THREE complementary measures that correctly repair and validate, and prevent recurrence of this failure.
- Test workflow reachability and trigger states after DAG edits.
- A controlled workflow run invokes the added job exactly in the expected order.
- Assume listing a Glue job in the console schedules it automatically.
- A shuffled fixture returns the same expected seven-day windows.
- Use an ordered and explicitly framed rolling calculation on normalized dates.
- Add and validate the correct conditional trigger path from the predecessor job.
Explanation
Correct Answers
A:Test workflow reachability and trigger states after DAG edits. This protects against the following risk: The new job is present but unreachable from the workflow's actual trigger graph.
B:A controlled workflow run invokes the added job exactly in the expected order. This is the observable result required before accepting the correction.
F:Add and validate the correct conditional trigger path from the predecessor job. The underlying cause is: The new job is present but unreachable from the workflow's actual trigger graph.
Incorrect Answers
C:Assume listing a Glue job in the console schedules it automatically. That shortcut conflicts with the stated requirement.
D:This would validate a different case: A data science notebook uses a rolling 7-day average without ordering by event date, so results change with input row order. It does not verify the outcome required here.
E:That corrective action is for a different case: A data science notebook uses a rolling 7-day average without ordering by event date, so results change with input row order. It does not resolve this incident.
Question 995
After resolving the following incident, which ongoing safeguard most directly prevents recurrence? A table claims a `region` partition key but the written S3 paths use `geography=...`, so Athena pruning fails.
- Contract-test the partition naming convention at writer and catalog boundaries.
- Include KMS access in data-load integration tests.
- Test version rollback and expiration dates before enabling cleanup.
- Add temporal join and duplicate-cardinality tests to dimensional models.
Explanation
Correct Answer
A:Contract-test the partition naming convention at writer and catalog boundaries. This safeguards against a recurring cause: Partition metadata and physical prefix naming do not agree.
Incorrect Answers
B:That safeguard addresses another case: A Redshift COPY command reads encrypted S3 files but the IAM role lacks decryption permission for the customer KMS key. It is not the control for this recurring failure.
C:That safeguard addresses another case: An S3 lifecycle rule expires noncurrent object versions immediately, preventing recovery from accidental overwrites. It is not the control for this recurring failure.
D:That safeguard addresses another case: A warehouse fact table is joined to customer history using only customer ID, multiplying matches across changing customer versions. It is not the control for this recurring failure.
Question 996
A data engineering service uses one unrestricted role for production ETL, development notebooks and reporting. Select TWO complementary measures that correctly repair and validate this failure.
- Development cannot write production data while ETL still runs correctly.
- After a test run, temporary sensitive artifacts are removed or retained only under policy.
- Apply account/organization guardrails, regional resource rules and audited exception processes.
- Reuse the root account for each pipeline to simplify credentials.
- Separate service roles and policies by environment, workload and required resources.
Explanation
Correct Answers
A:Development cannot write production data while ETL still runs correctly. This is the observable result required before accepting the correction.
E:Separate service roles and policies by environment, workload and required resources. The underlying cause is: Shared broadly privileged identities obscure duties and violate least privilege.
Incorrect Answers
B:This would validate a different case: A lake-to-warehouse pipeline removes raw PII from visible tables but keeps an untracked temporary S3 staging prefix indefinitely. It does not verify the outcome required here.
C:That corrective action is for a different case: A project migrates its authoritative EU records to another AWS Region and management assumes an S3 bucket policy alone enforces future residency. It does not resolve this incident.
D:Reuse the root account for each pipeline to simplify credentials. That shortcut conflicts with the stated requirement.
Question 997
A team applies a reviewed fix for this situation: An orchestrated data processing task receives tens of thousands of S3 events, causing Lambda reserved concurrency exhaustion. Which observed outcome would most convincingly validate the fix?
- A burst drains within the recovery SLA without widespread throttling.
- Malformed fixture values fail quality checks without discarding unrelated valid records.
- A terminated cluster's step and executor logs remain available for diagnosis.
- A product ID such as 00027 remains unchanged after the approved cleaning step.
Explanation
Correct Answer
A:A burst drains within the recovery SLA without widespread throttling. This verifies the result of buffer events with a supported queue or stream and cap downstream concurrent workers.
Incorrect Answers
B:This would verify another situation: A Glue data quality rule checks only that an email column is nonnull but accepts invalid malformed addresses. It does not validate the current case.
C:This would verify another situation: An EMR job intermittently fails due to capacity interruptions but its logs are stored only on the terminated instance. It does not validate the current case.
D:This would verify another situation: An analyst creates a Glue DataBrew visual cleaning step that trims all leading zeros from product IDs, breaking lookups. It does not validate the current case.
Question 998
A team changes an analytics library but releases a job without checking distributed task serialization compatibility. Which engineering change best addresses the underlying issue?
- Retry bounded transient exceptions and catch permanent validation failures for quarantine.
- Use stable producer event IDs and appropriate per-source sequence information.
- Join by intended as-of validity and persist versioned reference mappings.
- Run end-to-end tests on the actual Glue/EMR executor runtime and compatible libraries.
Explanation
Correct Answer
D:Run end-to-end tests on the actual Glue/EMR executor runtime and compatible libraries. It directly addresses the case cause (Developer tests omit execution-context serialization and worker runtime dependencies.) and should be verified by: The published job serializes work to executors and produces correct output.
Incorrect Answers
A:That change addresses a Step Functions state retries every failure including invalid schema, consuming budget without possibility of success; it would not repair this incident.
B:That change addresses a mobile event producer uses timestamp as the only deduplication key and collapses unrelated events recorded in one millisecond; it would not repair this incident.
C:That change addresses a Glue transform joins events to reference data refreshed weekly, but old events are silently reclassified on every rerun; it would not repair this incident.
Question 999
After resolving the following incident, which ongoing safeguard most directly prevents recurrence? An ingestion app writes identical DynamoDB item updates after a network retry and an audit counter increments twice.
- Add retry/replay regression tests to API clients.
- Test asynchronous lifecycle and timeouts during orchestration review.
- Record source revision and artifact hash on every job run.
- Version prompts/models and monitor false positives and sensitive-data exposure.
Explanation
Correct Answer
A:Add retry/replay regression tests to API clients. This safeguards against a recurring cause: A retried write lacks an idempotent state transition or conditional guard.
Incorrect Answers
B: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.
C:That safeguard addresses another case: A data engineering team manually changes Glue scripts on S3 without source control or a rollback identifier. It is not the control for this recurring failure.
D:That safeguard addresses another case: An application sends semi-structured documents to an LLM to classify regulated labels but stores model output without schema checking. It is not the control for this recurring failure.
Question 1000
An operational RDS database has a complex read-only report consuming most CPU at peak checkout time. Which engineering change best addresses the underlying issue?
- Offload reporting to an appropriately refreshed warehouse, replica or approved analytical system.
- Qualify or configure the intended catalog/database and verify metadata references.
- Apply approved standardized catalog classification tags or LF-Tags and validate inherited rules.
- Update supported partitions and schema in place instead of drop-and-create.
Explanation
Correct Answer
A:Offload reporting to an appropriately refreshed warehouse, replica or approved analytical system. It directly addresses the case cause (Analytical query workload competes with the transaction service.) and should be verified by: Transaction latency stays stable while report freshness meets requirements.
Incorrect Answers
B:That change addresses two Athena workgroups query identically named tables but one references a different data catalog and gets old records; it would not repair this incident.
C:That change addresses a data catalog stores PII labels only as free-text comments, so new tables bypass a tagging-based access process; it would not repair this incident.
D:That change addresses an ETL job drops a Glue Data Catalog table and recreates it daily, deleting important tags and permissions; it would not repair this incident.
AWS Certified Data Engineer - Associate DEA-C01 Practice Tests