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 20
A Redshift analytics warehouse holds transactional checkout rows that require thousands of short atomic row updates per second. Select TWO complementary measures that correctly repair and validate this failure.
- Reassess partition keys/granularity and apply efficient columnar file layout.
- Move the transactional system of record to a suitable relational operational database and replicate analysis data to Redshift.
- Replaying the same batch leaves one intended current version per key.
- Make every checkout a full Redshift table rebuild.
- Checkouts commit atomically while analytic queries remain isolated from OLTP load.
Explanation
Correct Answers
B:Move the transactional system of record to a suitable relational operational database and replicate analysis data to Redshift. The underlying cause is: Columnar analytical storage is misaligned with the application's OLTP write workload.
E:Checkouts commit atomically while analytic queries remain isolated from OLTP load. This is the observable result required before accepting the correction.
Incorrect Answers
A:That corrective action is for a different case: An Athena table uses daily partitions on a timestamp with millions of near-empty partition folders. It does not resolve this incident.
C:This would validate a different case: A Redshift reporting pipeline accumulates duplicate business keys after retries because it appends without reconciling current versions. It does not verify the outcome required here.
D:Make every checkout a full Redshift table rebuild. That shortcut conflicts with the stated requirement.
Question 21
After resolving the following incident, which ongoing safeguard most directly prevents recurrence? A DMS CDC task finishes a full-load phase but stops capturing source table changes when the source transaction log expires.
- Keep job-run IDs and manifest IDs linked in operational metadata.
- Monitor replication lag against source log-retention safety margins.
- Review DAG deadlines and failure paths for each critical dependency.
- Version the ingestion schema and alert on incompatible type drift.
Explanation
Correct Answer
B:Monitor replication lag against source log-retention safety margins. This safeguards against a recurring cause: Change capture cannot read required historical database logs after source retention.
Incorrect Answers
A:That safeguard addresses another case: A production Glue workflow receives the same completed-file notification twice and creates two warehouse loads. It is not the control for this recurring failure.
C:That safeguard addresses another case: An AWS MWAA DAG has no task-level retries or SLA alerts, and a brief Glue API throttle causes a missed daily close. It is not the control for this recurring failure.
D:That safeguard addresses another case: A Glue PySpark job fails when an upstream field changes from integer to string in some JSON documents. It is not the control for this recurring failure.
Question 22
After resolving the following incident, which ongoing safeguard most directly prevents recurrence? An Athena table uses daily partitions on a timestamp with millions of near-empty partition folders.
- Maintain schema/constraint migration checklists and rollback plans.
- Track catalog and snapshot IDs across pipeline steps.
- Reassess sort-key benefit as query patterns evolve.
- Benchmark partition count and size distributions.
Explanation
Correct Answer
D:Benchmark partition count and size distributions. This safeguards against a recurring cause: Partition granularity is too fine for data volume and query predicates.
Incorrect Answers
A:That safeguard addresses another case: An AWS DMS migration creates a new database table but foreign-key dependencies fail during cutover because schema compatibility was never rehearsed. It is not the control for this recurring failure.
B:That safeguard addresses another case: A dataset uses Iceberg but Spark and Athena query different catalogs and show conflicting table snapshots. It is not the control for this recurring failure.
C:That safeguard addresses another case: A fact table in Redshift filters mostly on event date but load order does not correlate with the filter, driving wide block scans. It is not the control for this recurring failure.
Question 23
A Step Functions pipeline sends a notification before the ETL task's asynchronous execution actually completes. Which technical dependency most directly explains this behavior?
- The event identity is not unique across simultaneously generated records.
- The transformation response does not comply with the expected record IDs, data encoding, and result status.
- The event grain is different from the intended business entity grain.
- The workflow treats the service invocation acknowledgement as a completed workload.
Explanation
Correct Answer
D:The workflow treats the service invocation acknowledgement as a completed workload. The corresponding fix is to use supported synchronous integration or task token/wait-and-poll completion logic.
Incorrect Answers
A:This diagnosis addresses another AWS case: A mobile event producer uses timestamp as the only deduplication key and collapses unrelated events recorded in one millisecond. The dependency here is different.
B:This diagnosis addresses another AWS case: A Firehose transformation Lambda returns malformed record status envelopes and some messages enter an error prefix. The dependency here is different.
C:This diagnosis addresses another AWS case: A nightly aggregation counts an order once per status-change event rather than once per order ID. The dependency here is different.
Question 24
A cross-account Lake Formation share is granted but the consumer account has not accepted its RAM invitation where required. Which technical dependency most directly explains this behavior?
- Cryptographic permissions exceed the data processing task's required keys.
- Governance requires controls across replication, backups and all services, not one bucket policy.
- Audit query coverage does not match the monitored account/Region scope.
- Cross-account resource sharing has a recipient-side acceptance and grant step.
Explanation
Correct Answer
D:Cross-account resource sharing has a recipient-side acceptance and grant step. The corresponding fix is to complete supported AWS RAM share acceptance and consumer-side permission delegation.
Incorrect Answers
A:This diagnosis addresses another AWS case: A Glue data job decrypts source objects using a wildcard KMS permission spanning unrelated client keys. The dependency here is different.
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 CloudTrail Lake query lists IAM role changes but its event filter omits the Regions holding the relevant data pipelines. The dependency here is different.
Question 25
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. Which engineering change best addresses the underlying issue?
- Use AWS Config resource history/rules alongside CloudTrail API events as appropriate.
- Assign supported domain/project membership and dataset entitlements through reviewed workflows.
- Configure supported KMS key policy, IAM and replication encryption settings for the intended accounts.
- Grant scoped Lake Formation SELECT and required catalog permissions to the authorized principal.
Explanation
Correct Answer
B:Assign supported domain/project membership and dataset entitlements through reviewed workflows. It directly addresses the case cause (Studio domain/project membership and resource governance are separate access contexts.) and should be verified by: A nominated team member can access only the project assets approved for the role.
Incorrect Answers
A:That change addresses an AWS Config rule flags altered S3 encryption settings but the team uses CloudTrail alone as its continuous current-state configuration inventory; it would not repair this incident.
C: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.
D:That change addresses a Lake Formation-enabled S3 table is visible in Glue Data Catalog, but Athena SELECT is denied to the analyst role; it would not repair this incident.
Question 26
A team applies a reviewed fix for this situation: A lake stores customer location coordinates as one unparsed text field while downstream joins require numeric latitude and longitude. Which observed outcome would most convincingly validate the fix?
- Invalid coordinates are rejected and valid ones support intended filters.
- Session lookups meet the accepted p95 target without unnecessary archive reads.
- A selective date query scans fewer blocks without losing late records.
- Checkouts commit atomically while analytic queries remain isolated from OLTP load.
Explanation
Correct Answer
A:Invalid coordinates are rejected and valid ones support intended filters. This verifies the result of model validated numeric coordinate fields with units and location quality checks.
Incorrect Answers
B: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.
C:This would verify another situation: A fact table in Redshift filters mostly on event date but load order does not correlate with the filter, driving wide block scans. It does not validate the current case.
D:This would verify another situation: A Redshift analytics warehouse holds transactional checkout rows that require thousands of short atomic row updates per second. It does not validate the current case.
Question 27
A team applies a reviewed fix for this situation: A multi-account data pipeline sends operational alerts through an SNS topic that no engineer subscribes to. Which observed outcome would most convincingly validate the fix?
- Two distinct same-timestamp events survive, while a retried ID deduplicates.
- Producer reconnects and publishes through broker failover without hard-coded single-host dependency.
- The deployed function identifies the intended release and completes a fixture invocation.
- A real on-call endpoint receives a test failure with actionable context.
Explanation
Correct Answer
D:A real on-call endpoint receives a test failure with actionable context. This verifies the result of configure validated subscriptions, policies and controlled test notifications.
Incorrect Answers
A:This would verify another situation: A mobile event producer uses timestamp as the only deduplication key and collapses unrelated events recorded in one millisecond. It does not validate the current case.
B:This would verify another situation: An MSK producer succeeds only intermittently after brokers change because its connection string contains one retired broker address. It does not validate the current case.
C:This would verify another situation: A SAM deployment packages an outdated Lambda handler because build artifacts from a previous branch were reused. It does not validate the current case.
Question 28
A nightly lake job publishes versioned S3 snapshots but deletes all old snapshots before the replacement is fully validated. Which engineering change best addresses the underlying issue?
- Separate or explicitly model fact grain and join to dimensions at compatible levels.
- Inventory schema conversion separately, apply validated DDL and rehearse dependency ordering.
- Evaluate Redshift AUTO distribution or a justified ALL/KEY strategy from query plans.
- Use staged validation and controlled retention/cleanup of replaced snapshots.
Explanation
Correct Answer
D:Use staged validation and controlled retention/cleanup of replaced snapshots. It directly addresses the case cause (The publish process removes its rollback point prematurely.) and should be verified by: An injected failed publish leaves the last approved snapshot accessible.
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.
B:That change addresses an AWS DMS migration creates a new database table but foreign-key dependencies fail during cutover because schema compatibility was never rehearsed; it would not repair this incident.
C:That change addresses a small dimension table joins huge Redshift facts, but an unnecessarily EVEN distribution causes repeated data transfer; it would not repair this incident.
Question 29
A Spark aggregation produces incorrect category totals because one hot key is dropped after a task retry and the target doesn't reconcile. Which engineering change best addresses the underlying issue?
- Validate per-key aggregates and end-to-end counts with replay-safe commit semantics.
- Aggregate by validated stable user identity and the intended time-window rules.
- Reference the approved immutable recipe/version in the scheduled data workflow.
- Track a per-partition completion watermark and validate expected event-time coverage.
Explanation
Correct Answer
A:Validate per-key aggregates and end-to-end counts with replay-safe commit semantics. It directly addresses the case cause (Pipeline retry handling and final quality checks do not preserve all expected groups.) and should be verified by: A forced retry produces totals matching an independent known fixture.
Incorrect Answers
B:That change addresses a marketing report uses COUNT(*) of event records as its active user metric and overstates adoption when users retry; it would not repair this incident.
C: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.
D:That change addresses a daily S3 data lake output is present but the last successful ETL timestamp is two days old; it would not repair this incident.
Question 30
A team applies a reviewed fix for this situation: A Glue data job decrypts source objects using a wildcard KMS permission spanning unrelated client keys. Which observed outcome would most convincingly validate the fix?
- A nominated team member can access only the project assets approved for the role.
- The production role reads an approved sample without expanded administrative rights.
- The partner accesses only intended assets and access ends when approval expires.
- The job decrypts authorized data but receives denial on a neighboring client's key.
Explanation
Correct Answer
D:The job decrypts authorized data but receives denial on a neighboring client's key. This verifies the result of scope KMS actions to intended keys and add appropriate conditions where supported.
Incorrect Answers
A:This would verify another situation: 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 validate the current case.
B:This would verify another situation: An S3 lake read works with an administrator role but fails with the production ETL role, and the team assumes the dataset is corrupt. It does not validate the current case.
C:This would verify another situation: A Redshift datashare grants partner analysts access to a customer data mart without a purpose or term limit. It does not validate the current case.
AWS Certified Data Engineer - Associate DEA-C01 Practice Tests