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 170
A dataset uses Iceberg but Spark and Athena query different catalogs and show conflicting table snapshots. Which engineering change best addresses the underlying issue?
- Validate retention requirements and apply supported retention/lock controls before approving lifecycle changes.
- Align approved partition key definitions and S3 path generation or repair registered metadata.
- Join using correct surrogate keys or as-of effective dates for SCD history.
- Unify the supported catalog/table identity and validate snapshot visibility across engines.
Explanation
Correct Answer
D:Unify the supported catalog/table identity and validate snapshot visibility across engines. It directly addresses the case cause (Consumers are not referencing the same authoritative table metadata location and snapshot.) and should be verified by: Both engines read the same committed table snapshot within planned freshness bounds.
Incorrect Answers
A:That change addresses an S3 data product has an approved seven-year retention requirement, but an engineer adds a 30-day expiration lifecycle rule; it would not repair this incident.
B:This change is appropriate to another case: A table claims a `region` partition key but the written S3 paths use `geography=...`, so Athena pruning fails. It does not directly repair this incident.
C:That change addresses a warehouse fact table is joined to customer history using only customer ID, multiplying matches across changing customer versions; it would not repair this incident.
Question 171
A legal-hold dataset is subject to an S3 Lifecycle expiration rule that would remove evidence at the usual age. Select THREE complementary measures that correctly repair and validate, and prevent recurrence of this failure.
- Bypass legal hold by changing file extensions before expiration.
- Verify legal-hold operations in compliance test scenarios.
- Known files appear under the intended distinct catalog schemas.
- Use supported S3 Object Lock legal hold/retention and review lifecycle interactions.
- Separate or explicitly model fact grain and join to dimensions at compatible levels.
- Protected test objects remain undeletable under expected retention conditions.
Explanation
Correct Answers
B:Verify legal-hold operations in compliance test scenarios. This protects against the following risk: Retention policy must not override active preservation requirements.
D:Use supported S3 Object Lock legal hold/retention and review lifecycle interactions. The underlying cause is: Retention policy must not override active preservation requirements.
F:Protected test objects remain undeletable under expected retention conditions. This is the observable result required before accepting the correction.
Incorrect Answers
A:Bypass legal hold by changing file extensions before expiration. That shortcut conflicts with the stated requirement.
C:This would validate a different case: A Glue crawler discovers an S3 path containing two incompatible CSV header layouts and produces a wide schema with ambiguous columns. It does not verify the outcome required here.
E:That corrective action is for a different case: A Redshift star schema mixes order-line and order-header facts in the same table and reports double-count revenue. It does not resolve this incident.
Question 172
A geospatial data catalog is placed in DynamoDB with no defined access key and engineers scan the entire table for each location. Which technical dependency most directly explains this behavior?
- The data model does not match the required predicate/access pattern.
- Retention policy must not override active preservation requirements.
- Concurrent metadata changes lack a controlled version/change process.
- The application lacks an access path for the documented alternate lookup key.
Explanation
Correct Answer
A:The data model does not match the required predicate/access pattern. The corresponding fix is to select an appropriate supported index or purpose-built query store using measured predicates.
Incorrect Answers
B:This diagnosis addresses another AWS case: A legal-hold dataset is subject to an S3 Lifecycle expiration rule that would remove evidence at the usual age. The dependency here is different.
C:This diagnosis addresses another AWS case: Two developers independently edit Glue Data Catalog schema types during release, and a job fails after the last writer wins. The dependency here is different.
D:This diagnosis addresses another AWS case: A DynamoDB table needs lookup by email but stores only user ID and relies on full-table Scan for each login. The dependency here is different.
Question 173
A team applies a reviewed fix for this situation: A Glue job reads an S3 object encrypted with a customer-managed KMS key and fails even though it has `s3:GetObject`. Which observed outcome would most convincingly validate the fix?
- A controlled test subject is absent from eligible data products after verified deletion.
- The analyst queries permitted columns while sensitive excluded fields remain inaccessible.
- A controlled invocation succeeds only for authorized source actions.
- The approved role reads the encrypted object but cannot decrypt unrelated keys.
Explanation
Correct Answer
D:The approved role reads the encrypted object but cannot decrypt unrelated keys. This verifies the result of grant scoped KMS decrypt through both applicable IAM and key policy controls.
Incorrect Answers
A:This would verify another situation: A personal-data deletion request removes a row from an Athena external table view but leaves original S3 objects and downstream extracts. It does not validate the current case.
B:This would verify another situation: A Lake Formation-enabled S3 table is visible in Glue Data Catalog, but Athena SELECT is denied to the analyst role. It does not validate the current case.
C: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.
Question 174
After resolving the following incident, which ongoing safeguard most directly prevents recurrence? A project migrates its authoritative EU records to another AWS Region and management assumes an S3 bucket policy alone enforces future residency.
- Test execution-role permissions and denied-resource fixtures before release.
- Review residency control coverage across data services after architecture changes.
- Test catalog visibility and data read permissions separately.
- Include IAM and network path checks as separate crawler deployment gates.
Explanation
Correct Answer
B:Review residency control coverage across data services after architecture changes. This safeguards against a recurring cause: Governance requires controls across replication, backups and all services, not one bucket policy.
Incorrect Answers
A:That safeguard addresses another case: 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 is not the control for this recurring failure.
C:That safeguard addresses another case: A Lake Formation-enabled S3 table is visible in Glue Data Catalog, but Athena SELECT is denied to the analyst role. It is not the control for this recurring failure.
D:That safeguard addresses another case: A Glue crawler in a VPC fails connection to a private RDS source even with the right IAM service role. It is not the control for this recurring failure.
Question 175
An AWS MWAA DAG has no task-level retries or SLA alerts, and a brief Glue API throttle causes a missed daily close. Which technical dependency most directly explains this behavior?
- Delivery buffering settings and destination behavior conflict with the required freshness.
- Batch and streaming clients compete without workload isolation or rate budgets.
- Airflow task failure handling does not match known transient dependency behavior.
- Row-based text storage undermines predicate and column projection efficiencies.
Explanation
Correct Answer
C:Airflow task failure handling does not match known transient dependency behavior. The corresponding fix is to configure bounded task retries, failure callbacks and deadline-aware notifications.
Incorrect Answers
A:This diagnosis addresses another AWS case: A Firehose pipeline is expected to deliver individual records instantly, yet it buffers batches before S3 delivery. The dependency here is different.
B:This diagnosis addresses another AWS case: A large historical data export shares the same small API rate limit as near-real-time orders and delays critical events. The dependency here is different.
D: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.
Question 176
An ingestion app writes identical DynamoDB item updates after a network retry and an audit counter increments twice. Select TWO complementary measures that correctly repair and validate this failure.
- A forced retry leaves one intended row per business event.
- Replaying the same event leaves one intended item state and audit increment.
- Use a stable ingestion event ID with conditional writes or a deduplicating transaction design.
- Use a stable manifest identifier with transactional state before launching or committing loads.
- Assume the network acknowledgement means a write cannot be repeated.
Explanation
Correct Answers
B:Replaying the same event leaves one intended item state and audit increment. This is the observable result required before accepting the correction.
C:Use a stable ingestion event ID with conditional writes or a deduplicating transaction design. The underlying cause is: A retried write lacks an idempotent state transition or conditional guard.
Incorrect Answers
A:This would validate a different case: A Glue streaming job writes duplicate target rows when a microbatch is retried after a worker restart. It does not verify the outcome required here.
D:That corrective action is for a different case: A production Glue workflow receives the same completed-file notification twice and creates two warehouse loads. It does not resolve this incident.
E:Assume the network acknowledgement means a write cannot be repeated. That shortcut conflicts with the stated requirement.
Question 177
A team applies a reviewed fix for this situation: A Redshift UNLOAD writes reporting data to an S3 bucket in another account but fails with access denied. Which observed outcome would most convincingly validate the fix?
- A controlled UNLOAD produces output in only the approved S3 prefix.
- Planning overhead falls while required rollback snapshots remain available.
- Athena and Spark recognize the same test partition and schema.
- Representative key lookups meet the expected latency and consistency requirements.
Explanation
Correct Answer
A:A controlled UNLOAD produces output in only the approved S3 prefix. This verifies the result of grant scoped bucket permissions and necessary KMS access to the Redshift execution role.
Incorrect Answers
B:This would verify another situation: An Iceberg table's snapshot history grows as frequent small commits accumulate and query planning becomes slow. It does not validate the current case.
C:This would verify another situation: A Hive metastore-based EMR Spark job writes a new partition but Athena never sees it through Glue Data Catalog. It does not validate the current case.
D:This would verify another situation: An online session store uses S3 object listing as a low-latency millisecond key lookup service and response times are erratic. It does not validate the current case.
Question 178
A warehouse fact table is joined to customer history using only customer ID, multiplying matches across changing customer versions. Which technical dependency most directly explains this behavior?
- External-table query capability is confused with supported table mutation semantics.
- Dimension joins ignore the effective time range for slowly changing records.
- Object storage access patterns do not match the required high-frequency key-value access.
- The UNLOAD role and destination policy do not authorize the intended cross-account write.
Explanation
Correct Answer
B:Dimension joins ignore the effective time range for slowly changing records. The corresponding fix is to join using correct surrogate keys or as-of effective dates for SCD history.
Incorrect Answers
A:This diagnosis addresses another AWS case: A Redshift query joins external and local datasets but expects Spectrum to automatically overwrite remote S3 data during UPDATE. The dependency here is different.
C:This diagnosis addresses another AWS case: An online session store uses S3 object listing as a low-latency millisecond key lookup service and response times are erratic. The dependency here is different.
D:This diagnosis addresses another AWS case: A Redshift UNLOAD writes reporting data to an S3 bucket in another account but fails with access denied. The dependency here is different.
Question 179
A team applies a reviewed fix for this situation: A lake dataset adds an optional JSON field and an older consumer fails because it expects an exact fixed set of keys. Which observed outcome would most convincingly validate the fix?
- A test encrypted file loads, while unrelated key access remains denied.
- Old records remain readable and new optional fields are preserved for updated consumers.
- Session lookups meet the accepted p95 target without unnecessary archive reads.
- Region-filtered queries prune to the expected physical prefixes.
Explanation
Correct Answer
B:Old records remain readable and new optional fields are preserved for updated consumers. This verifies the result of use versioned compatible schemas and tolerant reads with explicit unknown-field handling.
Incorrect Answers
A:This would verify another situation: A Redshift COPY command reads encrypted S3 files but the IAM role lacks decryption permission for the customer KMS key. It does not validate the current case.
C:This would verify another situation: A customer expects fast key-value reads over frequently accessed session state yet stores every session in a multi-megabyte compressed S3 archive. It does not validate the current case.
D:This check verifies a different issue: A table claims a `region` partition key but the written S3 paths use `geography=...`, so Athena pruning fails. It is not sufficient evidence for this case.
Question 180
A data access policy permits all S3 prefixes under `reports/*`, unintentionally including payroll records stored beneath that path. Select THREE complementary measures that correctly repair and validate, and prevent recurrence of this failure.
- The report job reads its approved prefix but payroll reads fail.
- Require negative privilege tests for wildcard policy changes.
- Treat matching `reports` as sufficient proof the data is nonsensitive.
- Narrow bucket and access-point resource ARNs and test effective explicit deny boundaries.
- A synthetic approved role change in a test Region is queryable by the auditor.
- Assign supported domain/project membership and dataset entitlements through reviewed workflows.
Explanation
Correct Answers
A:The report job reads its approved prefix but payroll reads fail. This is the observable result required before accepting the correction.
B:Require negative privilege tests for wildcard policy changes. This protects against the following risk: An IAM resource wildcard is broader than the intended least-privilege dataset.
D:Narrow bucket and access-point resource ARNs and test effective explicit deny boundaries. The underlying cause is: An IAM resource wildcard is broader than the intended least-privilege dataset.
Incorrect Answers
C:Treat matching `reports` as sufficient proof the data is nonsensitive. That shortcut conflicts with the stated requirement.
E:This would validate a different case: A CloudTrail Lake query lists IAM role changes but its event filter omits the Regions holding the relevant data pipelines. It does not verify the outcome required here.
F:That corrective action is for a different case: An admin provisions a SageMaker Unified Studio project but the intended team cannot open governed domain assets despite being added to a general account group. It does not resolve this incident.
AWS Certified Data Engineer - Associate DEA-C01 Practice Tests