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 930
An S3 data-access investigation searches CloudTrail for object reads but only management events were enabled. Which technical dependency most directly explains this behavior?
- Object-level S3 reads require appropriate data-event collection scope.
- Governance requires controls across replication, backups and all services, not one bucket policy.
- An IAM resource wildcard is broader than the intended least-privilege dataset.
- Data minimization rules are not applied to every intermediate copy.
Explanation
Correct Answer
A:Object-level S3 reads require appropriate data-event collection scope. The corresponding fix is to enable reviewed CloudTrail data events for the required S3 buckets or prefixes.
Incorrect Answers
B:This diagnosis addresses another AWS case: A project migrates its authoritative EU records to another AWS Region and management assumes an S3 bucket policy alone enforces future residency. The dependency here is different.
C:This diagnosis addresses another AWS case: A data access policy permits all S3 prefixes under `reports/*`, unintentionally including payroll records stored beneath that path. The dependency here is different.
D:This diagnosis addresses another AWS case: A lake-to-warehouse pipeline removes raw PII from visible tables but keeps an untracked temporary S3 staging prefix indefinitely. The dependency here is different.
Question 931
An analyst creates a Glue DataBrew visual cleaning step that trims all leading zeros from product IDs, breaking lookups. Which engineering change best addresses the underlying issue?
- Keep identifiers typed as strings and apply field-specific whitespace rules only.
- Move bulk transformation to a suitable managed batch/distributed service and orchestrate it.
- Add explicit row-count, schema, and quality validation before the publish step.
- Reference the approved immutable recipe/version in the scheduled data workflow.
Explanation
Correct Answer
A:Keep identifiers typed as strings and apply field-specific whitespace rules only. It directly addresses the case cause (The transformation treats identifiers as numeric measures rather than text keys.) and should be verified by: A product ID such as 00027 remains unchanged after the approved cleaning step.
Incorrect Answers
B:That change addresses a monthly data load uses Lambda to copy hundreds of gigabytes in a single invocation and repeatedly times out; it would not repair this incident.
C:That change addresses a Glue ETL job completes with warnings but the orchestrator assumes success despite a downstream quality check failing; it would not repair this incident.
D:That change addresses a Glue DataBrew recipe was changed interactively but the production pipeline still applies a previous published recipe version; it would not repair this incident.
Question 932
A DynamoDB table uses the same partition key for all new daily events, producing throttled writes during each morning burst. Which technical dependency most directly explains this behavior?
- Recovery snapshot and change-stream offsets do not represent a consistent recovery point.
- Logical key design concentrates physical write pressure.
- Crawler scope is broader than the governed dataset and includes nonauthoritative paths.
- Catalog recreation destroys governance metadata and stable table identity.
Explanation
Correct Answer
B:Logical key design concentrates physical write pressure. The corresponding fix is to redesign keys using appropriately distributed entity/shard identifiers while preserving retrieval needs.
Incorrect Answers
A:This diagnosis addresses another AWS case: A cross-region disaster recovery table is restored from an old snapshot, and CDC replication starts from an incompatible new checkpoint. The dependency here is different.
C:This diagnosis addresses another AWS case: A Glue crawler crawls the entire lake for every hourly feed and adds unexpected tables from temporary staging prefixes. The dependency here is different.
D:This diagnosis addresses another AWS case: An ETL job drops a Glue Data Catalog table and recreates it daily, deleting important tags and permissions. The dependency here is different.
Question 933
An upstream system changes a decimal field from two to four digits of precision and rounding introduces revenue drift. Select TWO complementary measures that correctly repair and validate this failure.
- Use appropriate decimal types and compare reconciliation sums within approved tolerance.
- The report matches known numeric test totals and identifies malformed values.
- Silently cast all amounts to integers to avoid decimal differences.
- A high-precision fixture survives transformation without unexpected rounding loss.
- Model the notification as a checked task with failure handling or durable outbox.
Explanation
Correct Answers
A:Use appropriate decimal types and compare reconciliation sums within approved tolerance. The underlying cause is: The data quality contract omits numeric precision and tolerance.
D:A high-precision fixture survives transformation without unexpected rounding loss. This is the observable result required before accepting the correction.
Incorrect Answers
B:This would validate a different case: An Athena SQL query sums decimal prices stored as strings and uses lexicographic ordering on text. It does not verify the outcome required here.
C:Silently cast all amounts to integers to avoid decimal differences. That shortcut conflicts with the stated requirement.
E:That corrective action is for a different case: A Step Functions run is marked succeeded although a downstream notification publish fails and no incident ticket is opened. It does not resolve this incident.
Question 934
An orchestrator invokes a Lambda that writes to S3 then times out; the retry writes a second output under a new random key. Select THREE complementary measures that correctly repair and validate, and prevent recurrence of this failure.
- Delete all S3 objects whenever a task times out.
- A forced timeout yields one authoritative committed output for the batch.
- Use deterministic batch output keys or conditional commits and reconcile existing results on retry.
- Mixed old/new fixtures produce expected typed output or documented rejects.
- Design outputs around replay-safe execution IDs and partial-failure tests.
- Gate promotion on integration tests using a restricted fixture and expected output assertions.
Explanation
Correct Answers
B:A forced timeout yields one authoritative committed output for the batch. This is the observable result required before accepting the correction.
C:Use deterministic batch output keys or conditional commits and reconcile existing results on retry. The underlying cause is: Retries use non-idempotent output identity with uncertain prior completion.
E:Design outputs around replay-safe execution IDs and partial-failure tests. This protects against the following risk: Retries use non-idempotent output identity with uncertain prior completion.
Incorrect Answers
A:Delete all S3 objects whenever a task times out. That shortcut conflicts with the stated requirement.
D:This would validate a different case: A Glue PySpark job fails when an upstream field changes from integer to string in some JSON documents. It does not verify the outcome required here.
F:That corrective action is for a different case: A CI pipeline promotes an ETL artifact after syntax checks but without a representative integration job against staged data. It does not resolve this incident.
Question 935
A data lake copies SSE-KMS objects across AWS accounts but the destination principal cannot decrypt the replica. Which engineering change best addresses the underlying issue?
- Confirm CloudTrail delivery, then repair Athena catalog partitions or approved projection.
- Configure the intended Lambda execution role with scoped API permissions.
- Configure supported KMS key policy, IAM and replication encryption settings for the intended accounts.
- Define and grant a read-only database role on approved schemas and views.
Explanation
Correct Answer
C:Configure supported KMS key policy, IAM and replication encryption settings for the intended accounts. It directly addresses the case cause (Cross-account cryptographic key and replica policies do not match the consumer identities.) and should be verified by: The authorized destination role reads replicas and unapproved accounts remain denied.
Incorrect Answers
A:That change addresses an Athena query for CloudTrail logs shows a missing day because the log data lake partitions were never registered; it would not repair this incident.
B:That change addresses a Lambda data extractor assumes an EC2 instance profile is available when running as a Lambda function; it would not repair this incident.
D:That change addresses a Redshift data analyst has a role granting broad schema CREATE and DROP despite requiring only SELECT on a few views; it would not repair this incident.
Question 936
An ETL job drops a Glue Data Catalog table and recreates it daily, deleting important tags and permissions. Which engineering change best addresses the underlying issue?
- Update supported partitions and schema in place instead of drop-and-create.
- Use a supported ETL/write path to update the authoritative source, then refresh catalog metadata.
- Stage an additive nullable field, backfill and validate before enforcing stricter semantics.
- Separate or migrate embeddings under explicit model versions and index compatibility rules.
Explanation
Correct Answer
A:Update supported partitions and schema in place instead of drop-and-create. It directly addresses the case cause (Catalog recreation destroys governance metadata and stable table identity.) and should be verified by: Consumers retain table permissions while newly published partitions appear.
Incorrect Answers
B:That change addresses a Redshift query joins external and local datasets but expects Spectrum to automatically overwrite remote S3 data during UPDATE; it would not repair this incident.
C:That change addresses a team adds a nonnullable required field to an Iceberg table but old rows have no value and downstream reads fail; it would not repair this incident.
D:That change addresses a vector retrieval index stores embeddings from two incompatible model versions in one dimension-dependent collection; it would not repair this incident.
Question 937
An S3 lifecycle rule expires noncurrent object versions immediately, preventing recovery from accidental overwrites. Which engineering change best addresses the underlying issue?
- Select an appropriate supported index or purpose-built query store using measured predicates.
- Choose an appropriately modeled DynamoDB or other eligible low-latency store with measured capacity.
- Apply a stable catalog schema and quarantine malformed headers or records upstream.
- Set separately reviewed current and noncurrent version lifecycle policies.
Explanation
Correct Answer
D:Set separately reviewed current and noncurrent version lifecycle policies. It directly addresses the case cause (Noncurrent-version retention is shorter than the required rollback window.) and should be verified by: An overwritten fixture can be restored within the intended recovery interval.
Incorrect Answers
A: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.
B:That change addresses an online session store uses S3 object listing as a low-latency millisecond key lookup service and response times are erratic; it would not repair this incident.
C:That change addresses a crawler changes a decimal sales column to string after encountering a nonnumeric banner row in one export; it would not repair this incident.
Question 938
A project migrates its authoritative EU records to another AWS Region and management assumes an S3 bucket policy alone enforces future residency. Which engineering change best addresses the underlying issue?
- Apply approved tokenization, masking, or projection before data exits the trusted boundary.
- Apply account/organization guardrails, regional resource rules and audited exception processes.
- Grant explicit least-privilege permissions to the Glue execution role and verify the data access path.
- Define and grant a read-only database role on approved schemas and views.
Explanation
Correct Answer
B:Apply account/organization guardrails, regional resource rules and audited exception processes. It directly addresses the case cause (Governance requires controls across replication, backups and all services, not one bucket policy.) and should be verified by: An attempted unapproved replication or snapshot is blocked and logged.
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 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 Redshift data analyst has a role granting broad schema CREATE and DROP despite requiring only SELECT on a few views; it would not repair this incident.
Question 939
A Glue job reads an S3 object encrypted with a customer-managed KMS key and fails even though it has `s3:GetObject`. Which technical dependency most directly explains this behavior?
- API activity history does not directly replace configuration-state/compliance evaluation.
- S3 object retrieval may also require KMS decrypt authorization for the encryption key.
- Business catalog sharing lacks stewardship and usage-governance metadata.
- Database privilege scope exceeds the analyst's reporting purpose.
Explanation
Correct Answer
B:S3 object retrieval may also require KMS decrypt authorization for the encryption key. The corresponding fix is to grant scoped KMS decrypt through both applicable IAM and key policy controls.
Incorrect Answers
A:This diagnosis addresses another AWS case: An AWS Config rule flags altered S3 encryption settings but the team uses CloudTrail alone as its continuous current-state configuration inventory. The dependency here is different.
C:This diagnosis addresses another AWS case: A SageMaker Catalog project shares a data product broadly across teams without recording owner and allowed purpose. The dependency here is different.
D:This diagnosis addresses another AWS case: A Redshift data analyst has a role granting broad schema CREATE and DROP despite requiring only SELECT on a few views. The dependency here is different.
Question 940
A team needs ACID updates and time-travel queries against a governed S3 lake but writes plain Parquet files with no table transaction metadata. Which engineering change best addresses the underlying issue?
- Separate or explicitly model fact grain and join to dimensions at compatible levels.
- Design a supported Apache Iceberg table with compatible catalog and compute engines.
- Trace lineage and apply approved deletion to all eligible retained copies under policy.
- Apply approved standardized catalog classification tags or LF-Tags and validate inherited rules.
Explanation
Correct Answer
B:Design a supported Apache Iceberg table with compatible catalog and compute engines. It directly addresses the case cause (Raw object files do not by themselves provide open-table transaction semantics.) and should be verified by: Concurrent reads see committed snapshots and managed updates are queryable.
Incorrect Answers
A:That change addresses a Redshift star schema mixes order-line and order-header facts in the same table and reports double-count revenue; it would not repair this incident.
C:That change addresses an analytics partition must be removed under a deletion request, yet its historical copies persist in untracked S3 archive paths; it would not repair this incident.
D: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.
AWS Certified Data Engineer - Associate DEA-C01 Practice Tests