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 890
After resolving the following incident, which ongoing safeguard most directly prevents recurrence? A central CloudWatch Logs group for Glue jobs retains all raw customer payloads in debug messages across many teams.
- Validate IAM trust and permission policy pairs in deployment checks.
- Add direct-versus-view access checks for sensitive attributes.
- Run privacy checks on log fields and permissions.
- Review registered data locations and role rights during ETL deployment.
Explanation
Correct Answer
C:Run privacy checks on log fields and permissions. This safeguards against a recurring cause: Logging captures sensitive data beyond authorized operational requirements.
Incorrect Answers
A: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.
B:That safeguard addresses another case: A Redshift view exposes unmasked customer SSNs to a general BI role despite a requirement for partial disclosure. It is not the control for this recurring failure.
D:That safeguard addresses another case: An AWS Glue job writes to a governed S3 target but lacks the Lake Formation data-location access permission required for its workflow. It is not the control for this recurring failure.
Question 891
A team applies a reviewed fix for this situation: An S3 prefix contains `.json.gz` objects but the Glue crawler labels them as raw JSON and downstream parsers fail. Which observed outcome would most convincingly validate the fix?
- Per-slice row distribution and runtime meet expected thresholds.
- Average scanned bytes and query planning time improve without data loss.
- A test compressed object creates the expected typed catalog columns.
- Test similar products rank appropriately for documented benchmark queries.
Explanation
Correct Answer
C:A test compressed object creates the expected typed catalog columns. This verifies the result of configure the supported classifier and decompression-aware source layout.
Incorrect Answers
A:This would verify another situation: A Redshift table has highly skewed account IDs as a distribution key and one compute slice processes most rows. It does not validate the current case.
B:This would verify another situation: An Athena table uses daily partitions on a timestamp with millions of near-empty partition folders. It does not validate the current case.
D:This would verify another situation: An application seeks low-latency semantic recommendations but indexes product names as plain text without generated embeddings. It does not validate the current case.
Question 892
A lake-to-warehouse pipeline removes raw PII from visible tables but keeps an untracked temporary S3 staging prefix indefinitely. Select THREE complementary measures that correctly repair and validate, and prevent recurrence of this failure.
- Add staging locations to lineage and data deletion plans.
- Apply approved tokenization, masking, or projection before data exits the trusted boundary.
- After a test run, temporary sensitive artifacts are removed or retained only under policy.
- Claim GDPR or privacy compliance solely because the final table lacks PII.
- Development cannot write production data while ETL still runs correctly.
- Inventory staging artifacts and enforce approved secure cleanup/retention and access.
Explanation
Correct Answers
A:Add staging locations to lineage and data deletion plans. This protects against the following risk: Data minimization rules are not applied to every intermediate copy.
C:After a test run, temporary sensitive artifacts are removed or retained only under policy. This is the observable result required before accepting the correction.
F:Inventory staging artifacts and enforce approved secure cleanup/retention and access. The underlying cause is: Data minimization rules are not applied to every intermediate copy.
Incorrect Answers
B:That corrective action is for a different case: A DynamoDB-backed application needs to redact sensitive values before exporting analytics but relies only on table encryption. It does not resolve this incident.
D:Claim GDPR or privacy compliance solely because the final table lacks PII. That shortcut conflicts with the stated requirement.
E:This would validate a different case: A data engineering service uses one unrestricted role for production ETL, development notebooks and reporting. It does not verify the outcome required here.
Question 893
A team applies a reviewed fix for this situation: A team adds a nonnullable required field to an Iceberg table but old rows have no value and downstream reads fail. Which observed outcome would most convincingly validate the fix?
- A test with a banner row keeps numeric fields correctly typed and records the reject.
- An injected failed publish leaves the last approved snapshot accessible.
- Historical snapshots and new rows remain queryable during the migration.
- Both engines read the same committed table snapshot within planned freshness bounds.
Explanation
Correct Answer
C:Historical snapshots and new rows remain queryable during the migration. This verifies the result of stage an additive nullable field, backfill and validate before enforcing stricter semantics.
Incorrect Answers
A:This would verify another situation: A crawler changes a decimal sales column to string after encountering a nonnumeric banner row in one export. It does not validate the current case.
B:This would verify another situation: A nightly lake job publishes versioned S3 snapshots but deletes all old snapshots before the replacement is fully validated. It does not validate the current case.
D:This would verify another situation: A dataset uses Iceberg but Spark and Athena query different catalogs and show conflicting table snapshots. It does not validate the current case.
Question 894
An on-premises Oracle source feeds DMS, but newly added tables never appear in a configured migration. Which engineering change best addresses the underlying issue?
- Pin and test dependency versions within the supported Glue runtime and publish a locked artifact.
- Use supported Spark SQL built-in transformations and predicate pushdown where possible.
- Update reviewed DMS table mapping and validate permissions and schema-change handling.
- Minimize input fields, mask prohibited values, and apply approved data-handling and output-validation controls.
Explanation
Correct Answer
C:Update reviewed DMS table mapping and validate permissions and schema-change handling. It directly addresses the case cause (Table selection rules cover only the original schema or table set.) and should be verified by: A known new table's rows and later changes reach the approved target.
Incorrect Answers
A:That change addresses a Glue processing library has no pinned dependency versions and a release pulls a new incompatible parser; it would not repair this incident.
B:That change addresses a PySpark transformation uses Python row-by-row loops to parse simple scalar fields and runs slowly; it would not repair this incident.
D:That change addresses an ETL pipeline calls a Bedrock model on full records containing account secrets merely to extract public product categories; it would not repair this incident.
Question 895
After resolving the following incident, which ongoing safeguard most directly prevents recurrence? Two developers independently edit Glue Data Catalog schema types during release, and a job fails after the last writer wins.
- Require governance signoff for expiration policy changes.
- Test large scans and mid-scan interruption recovery.
- Track metadata version and compatible migration steps per release.
- Validate Iceberg maintenance, schema evolution and engine compatibility.
Explanation
Correct Answer
C:Track metadata version and compatible migration steps per release. This safeguards against a recurring cause: Concurrent metadata changes lack a controlled version/change process.
Incorrect Answers
A:That safeguard addresses another case: An S3 data product has an approved seven-year retention requirement, but an engineer adds a 30-day expiration lifecycle rule. It is not the control for this recurring failure.
B:That safeguard addresses another case: A DynamoDB archival pipeline uses Scan without pagination and misses records beyond the first page. It is not the control for this recurring failure.
D:That safeguard addresses another case: A team needs ACID updates and time-travel queries against a governed S3 lake but writes plain Parquet files with no table transaction metadata. It is not the control for this recurring failure.
Question 896
After resolving the following incident, which ongoing safeguard most directly prevents recurrence? A Lambda data extractor assumes an EC2 instance profile is available when running as a Lambda function.
- Keep lineage-based deletion runbooks and retention-exception records.
- Maintain and test account/Region audit coverage inventories.
- Review external share inventory and renewal evidence regularly.
- Document the actual service execution principal per compute platform.
Explanation
Correct Answer
D:Document the actual service execution principal per compute platform. This safeguards against a recurring cause: The runtime identity is supplied by the Lambda execution role, not a host instance profile.
Incorrect Answers
A:That safeguard addresses another case: A personal-data deletion request removes a row from an Athena external table view but leaves original S3 objects and downstream extracts. It is not the control for this recurring failure.
B:That safeguard addresses another case: A CloudTrail Lake query lists IAM role changes but its event filter omits the Regions holding the relevant data pipelines. It is not the control for this recurring failure.
C:That safeguard addresses another case: A Redshift datashare grants partner analysts access to a customer data mart without a purpose or term limit. It is not the control for this recurring failure.
Question 897
An S3 export writes regulated data to an unencrypted partner endpoint despite source-at-rest SSE-KMS protection. Which engineering change best addresses the underlying issue?
- Validate Glue network connection resources, subnets, SGs and database credentials together.
- Grant scoped data-location and catalog permissions alongside required IAM policies.
- Require supported TLS transport and approved destination identity/key handling.
- Apply approved protected S3 retention, access and lifecycle safeguards for logs.
Explanation
Correct Answer
C:Require supported TLS transport and approved destination identity/key handling. It directly addresses the case cause (At-rest encryption does not secure data transmission on an external path.) and should be verified by: The transfer rejects an untrusted endpoint and succeeds over the intended encrypted connection.
Incorrect Answers
A: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.
B:That change addresses an AWS Glue job writes to a governed S3 target but lacks the Lake Formation data-location access permission required for its workflow; it would not repair this incident.
D:That change addresses an organization exports audit logs to S3 without lifecycle retention review and required records expire before annual audit; it would not repair this incident.
Question 898
After resolving the following incident, which ongoing safeguard most directly prevents recurrence? An EMR Spark pipeline runs near memory limits because it caches multiple large datasets and never releases them.
- Enforce producer-consumer handoff contracts and late-arrival tests.
- Add lifecycle checks for persistence and executor memory use.
- Automate broker endpoint checks and rolling-client reconnection tests.
- Exercise long-running records and rebalance scenarios in load tests.
Explanation
Correct Answer
B:Add lifecycle checks for persistence and executor memory use. This safeguards against a recurring cause: Persisted dataset lifetimes exceed the stages that need them.
Incorrect Answers
A:That safeguard addresses another case: An EventBridge schedule starts a warehouse load during an upstream S3 export rather than after all files are ready. It is not the control for this recurring failure.
C:That safeguard addresses another case: An MSK producer succeeds only intermittently after brokers change because its connection string contains one retired broker address. It is not the control for this recurring failure.
D:That safeguard addresses another case: An MSK consumer group repeatedly rebalances during long processing, causing duplicate deliveries. It is not the control for this recurring failure.
Question 899
After resolving the following incident, which ongoing safeguard most directly prevents recurrence? An MSK consumer group repeatedly rebalances during long processing, causing duplicate deliveries.
- Track transformation-key contracts and explain-plan changes.
- Test token expiry, duplicate callbacks and secret redaction.
- Load-test consumer concurrency against downstream capacity.
- Exercise long-running records and rebalance scenarios in load tests.
Explanation
Correct Answer
D:Exercise long-running records and rebalance scenarios in load tests. This safeguards against a recurring cause: Processing exceeds configured consumer poll or session expectations without adequate checkpoint strategy.
Incorrect Answers
A:That safeguard addresses another case: A Spark pipeline includes a wide shuffle stage because it joins on a function applied to both tables, preventing efficient key reuse. It is not the control for this recurring failure.
B:That safeguard addresses another case: A Step Functions Standard workflow waits for an external vendor callback but the task token is lost in logs. It is not the control for this recurring failure.
C:That safeguard addresses another case: An SQS-backed processor overwhelms a downstream database after scaling consumers without any concurrency cap. It is not the control for this recurring failure.
Question 900
An AWS Config rule flags altered S3 encryption settings but the team uses CloudTrail alone as its continuous current-state configuration inventory. Select THREE complementary measures that correctly repair and validate, and prevent recurrence of this failure.
- Publish ownership, purpose, classification and scoped project access before sharing.
- Conclude an unchanged API event count proves no configuration drift.
- A controlled bucket configuration change is detected with historical and current evidence.
- Map required change evidence to the appropriate audit services.
- Use AWS Config resource history/rules alongside CloudTrail API events as appropriate.
- The crawler accesses the RDS schema from its actual VPC context.
Explanation
Correct Answers
C:A controlled bucket configuration change is detected with historical and current evidence. This is the observable result required before accepting the correction.
D:Map required change evidence to the appropriate audit services. This protects against the following risk: API activity history does not directly replace configuration-state/compliance evaluation.
E:Use AWS Config resource history/rules alongside CloudTrail API events as appropriate. The underlying cause is: API activity history does not directly replace configuration-state/compliance evaluation.
Incorrect Answers
A:That corrective action is for a different case: A SageMaker Catalog project shares a data product broadly across teams without recording owner and allowed purpose. It does not resolve this incident.
B:Conclude an unchanged API event count proves no configuration drift. That shortcut conflicts with the stated requirement.
F:This would validate a different case: A Glue crawler in a VPC fails connection to a private RDS source even with the right IAM service role. It does not verify the outcome required here.
AWS Certified Data Engineer - Associate DEA-C01 Practice Tests