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 250
After resolving the following incident, which ongoing safeguard most directly prevents recurrence? An S3 lake read works with an administrator role but fails with the production ETL role, and the team assumes the dataset is corrupt.
- Use role-based acceptance tests, not administrator-only smoke tests.
- Test encrypted cross-account replication with intended and forbidden principals.
- Document data minimization rules in export contracts.
- Use policy-simulator and negative-access tests during access changes.
Explanation
Correct Answer
A:Use role-based acceptance tests, not administrator-only smoke tests. This safeguards against a recurring cause: Principal-dependent authorization is being confused with data integrity.
Incorrect Answers
B:That safeguard addresses another case: A data lake copies SSE-KMS objects across AWS accounts but the destination principal cannot decrypt the replica. It is not the control for this recurring failure.
C:That safeguard addresses another case: A DynamoDB-backed application needs to redact sensitive values before exporting analytics but relies only on table encryption. 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 251
A team applies a reviewed fix for this situation: A clickstream pipeline converts all nested attributes to strings before storage, making numeric analytics unreliable. Which observed outcome would most convincingly validate the fix?
- A deliberately invalid permission or schema change blocks release.
- A simulated transient failure recovers and persistent failures produce timely alerts.
- A rebuild reproduces the tested parser and expected input transformation.
- Price and duration fields support correct arithmetic on known test rows.
Explanation
Correct Answer
D:Price and duration fields support correct arithmetic on known test rows. This verifies the result of apply a defined typed schema, normalize units, and retain raw payloads for replay.
Incorrect Answers
A:This would verify another situation: A CI pipeline promotes an ETL artifact after syntax checks but without a representative integration job against staged data. It does not validate the current case.
B:This would verify another situation: An AWS MWAA DAG has no task-level retries or SLA alerts, and a brief Glue API throttle causes a missed daily close. It does not validate the current case.
C:This would verify another situation: A Glue processing library has no pinned dependency versions and a release pulls a new incompatible parser. It does not validate the current case.
Question 252
A central CloudWatch Logs group for Glue jobs retains all raw customer payloads in debug messages across many teams. Which engineering change best addresses the underlying issue?
- Configure supported KMS key policy, IAM and replication encryption settings for the intended accounts.
- Redact values at source and restrict log retention and access by least privilege.
- Grant explicit least-privilege permissions to the Glue execution role and verify the data access path.
- Locate affected source and derivative assets via lineage and apply approved deletion/retention policy.
Explanation
Correct Answer
B:Redact values at source and restrict log retention and access by least privilege. It directly addresses the case cause (Logging captures sensitive data beyond authorized operational requirements.) and should be verified by: A deliberate invalid record yields actionable error metadata without raw PII.
Incorrect Answers
A:That change addresses a data lake copies SSE-KMS objects across AWS accounts but the destination principal cannot decrypt the replica; it would not repair this incident.
C:That change addresses an Athena query against a Lake Formation resource succeeds for the analyst, yet a separate Glue ETL role cannot read that same table; it would not repair this incident.
D: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 253
Two Athena workgroups query identically named tables but one references a different data catalog and gets old records. Which technical dependency most directly explains this behavior?
- Lexical text indexing does not implement the intended vector similarity retrieval.
- Query context includes the catalog and database, not just table name.
- Table metadata maintenance does not match commit frequency and retention needs.
- The publish process removes its rollback point prematurely.
Explanation
Correct Answer
B:Query context includes the catalog and database, not just table name. The corresponding fix is to qualify or configure the intended catalog/database and verify metadata references.
Incorrect Answers
A:This diagnosis addresses another AWS case: An application seeks low-latency semantic recommendations but indexes product names as plain text without generated embeddings. The dependency here is different.
C:This diagnosis addresses another AWS case: An Iceberg table's snapshot history grows as frequent small commits accumulate and query planning becomes slow. The dependency here is different.
D:This diagnosis addresses another AWS case: A nightly lake job publishes versioned S3 snapshots but deletes all old snapshots before the replacement is fully validated. The dependency here is different.
Question 254
After resolving the following incident, which ongoing safeguard most directly prevents recurrence? A Step Functions Standard workflow waits for an external vendor callback but the task token is lost in logs.
- Record dimension-size thresholds and explain plans for joins.
- Check schema types and units in transformation contracts.
- Test token expiry, duplicate callbacks and secret redaction.
- Apply schema and timestamp quality tests at ingress.
Explanation
Correct Answer
C:Test token expiry, duplicate callbacks and secret redaction. This safeguards against a recurring cause: The callback correlation contract is missing or insecure.
Incorrect Answers
A:That safeguard addresses another case: A Glue job joins a tiny lookup table to billions of rows and performs a full distributed shuffle. It is not the control for this recurring failure.
B:That safeguard addresses another case: A clickstream pipeline converts all nested attributes to strings before storage, making numeric analytics unreliable. 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.
Question 255
An API payload includes optional addresses but a transformation fails when a nullable nested object is absent. Which technical dependency most directly explains this behavior?
- The pipeline assumes every optional path exists for every row.
- Ephemeral storage is insufficient for the actual intermediate workload.
- The event-to-job design starts a run per object without a batch completion boundary.
- The delivery layout lacks event-derived partition selection.
Explanation
Correct Answer
A:The pipeline assumes every optional path exists for every row. The corresponding fix is to use nullable-aware extraction and document sensible default or reject handling per field.
Incorrect Answers
B:This diagnosis addresses another AWS case: A Lambda ETL process writes temporary files larger than its configured /tmp capacity and receives storage errors. The dependency here is different.
C:This diagnosis addresses another AWS case: An S3 event notification triggers Glue for every file of a large export, producing hundreds of competing jobs. The dependency here is different.
D:This diagnosis addresses another AWS case: A Firehose stream delivering transactions to S3 mixes every customer into the same prefix, making Athena queries scan all tenants. The dependency here is different.
Question 256
A Step Functions pipeline sends a notification before the ETL task's asynchronous execution actually completes. Which engineering change best addresses the underlying issue?
- Use supported synchronous integration or task token/wait-and-poll completion logic.
- Minimize input fields, mask prohibited values, and apply approved data-handling and output-validation controls.
- Run end-to-end tests on the actual Glue/EMR executor runtime and compatible libraries.
- Configure supported decompression and validate input format before parsing.
Explanation
Correct Answer
A:Use supported synchronous integration or task token/wait-and-poll completion logic. It directly addresses the case cause (The workflow treats the service invocation acknowledgement as a completed workload.) and should be verified by: Notifications fire only after the transform reaches a recorded successful terminal state.
Incorrect Answers
B: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.
C:That change addresses a team changes an analytics library but releases a job without checking distributed task serialization compatibility; it would not repair this incident.
D:That change addresses a processing job ingests gzipped files but its connector treats their contents as uncompressed text and creates corrupt rows; it would not repair this incident.
Question 257
A team applies a reviewed fix for this situation: A Redshift COPY command reads encrypted S3 files but the IAM role lacks decryption permission for the customer KMS key. Which observed outcome would most convincingly validate the fix?
- A test with a banner row keeps numeric fields correctly typed and records the reject.
- A test encrypted file loads, while unrelated key access remains denied.
- A controlled write/read test meets the documented consistency requirement.
- A conflicting schema change is rejected before the production job runs.
Explanation
Correct Answer
B:A test encrypted file loads, while unrelated key access remains denied. This verifies the result of add correct scoped KMS decrypt permissions and key-policy authorization for the loading role.
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.
C:This would verify another situation: A DynamoDB application requires strongly consistent reads immediately after a successful critical write but queries a global secondary index. It does not validate the current case.
D:This would verify another situation: Two developers independently edit Glue Data Catalog schema types during release, and a job fails after the last writer wins. It does not validate the current case.
Question 258
An Iceberg table's snapshot history grows as frequent small commits accumulate and query planning becomes slow. Select TWO complementary measures that correctly repair and validate this failure.
- Planning overhead falls while required rollback snapshots remain available.
- Run supported snapshot expiration and metadata cleanup with retention safeguards.
- Delete active manifest files from S3 without table-aware maintenance.
- A controlled subject deletion is absent from permitted current and derived query paths.
- Select an appropriate supported index or purpose-built query store using measured predicates.
Explanation
Correct Answers
A:Planning overhead falls while required rollback snapshots remain available. This is the observable result required before accepting the correction.
B:Run supported snapshot expiration and metadata cleanup with retention safeguards. The underlying cause is: Table metadata maintenance does not match commit frequency and retention needs.
Incorrect Answers
C:Delete active manifest files from S3 without table-aware maintenance. That shortcut conflicts with the stated requirement.
D:This would validate a different case: An analytics partition must be removed under a deletion request, yet its historical copies persist in untracked S3 archive paths. It does not verify the outcome required here.
E:That corrective action is for a different case: A geospatial data catalog is placed in DynamoDB with no defined access key and engineers scan the entire table for each location. It does not resolve this incident.
Question 259
A scheduled ETL uses an API token embedded in source code; rotation breaks the batch without an alert. Select THREE complementary measures that correctly repair and validate, and prevent recurrence of this failure.
- Log the full secret in task failure messages for quicker debugging.
- Set an appropriate retention and controlled access policy for log groups.
- Track secret age and test rotation during disaster-recovery drills.
- A known delayed event updates the intended window according to policy.
- Move credentials to a protected managed secret and implement controlled refresh and failure alerts.
- A test rotation preserves authorized API access without redeploying embedded credentials.
Explanation
Correct Answers
C:Track secret age and test rotation during disaster-recovery drills. This protects against the following risk: Credential retrieval and rotation are not part of the workload lifecycle.
E:Move credentials to a protected managed secret and implement controlled refresh and failure alerts. The underlying cause is: Credential retrieval and rotation are not part of the workload lifecycle.
F:A test rotation preserves authorized API access without redeploying embedded credentials. This is the observable result required before accepting the correction.
Incorrect Answers
A:Log the full secret in task failure messages for quicker debugging. That shortcut conflicts with the stated requirement.
B:That corrective action is for a different case: A Lambda processor logs errors but its CloudWatch Logs retention is shorter than the postmortem evidence requirement. It does not resolve this incident.
D:This would validate a different case: A nightly data product uses a moving seven-day window but incoming source events arrive late and are excluded without a watermark policy. It does not verify the outcome required here.
Question 260
A Redshift star schema mixes order-line and order-header facts in the same table and reports double-count revenue. Which technical dependency most directly explains this behavior?
- The modeled fact grain is inconsistent across record types.
- Business catalog stewardship and access context have drifted from the source asset.
- The two metastore environments are not synchronized.
- Inconsistent metadata taxonomies prevent reliable automated governance.
Explanation
Correct Answer
A:The modeled fact grain is inconsistent across record types. The corresponding fix is to separate or explicitly model fact grain and join to dimensions at compatible levels.
Incorrect Answers
B:This diagnosis addresses another AWS case: A SageMaker Catalog project references a dataset whose owner changed but permissions and business definitions still point to the former team. The dependency here is different.
C:This diagnosis addresses another AWS case: A Hive metastore-based EMR Spark job writes a new partition but Athena never sees it through Glue Data Catalog. The dependency here is different.
D:This diagnosis addresses another AWS case: A data catalog stores PII labels only as free-text comments, so new tables bypass a tagging-based access process. The dependency here is different.
AWS Certified Data Engineer - Associate DEA-C01 Practice Tests