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 920
Three independent Kinesis applications compete for shared shard read throughput and their IteratorAge rises together. Which engineering change best addresses the underlying issue?
- Inspect DAG import errors and validate packaging dependencies before deployment.
- Evaluate a broadcast join or other optimized join strategy within Glue/Spark memory limits.
- Use deterministic batch output keys or conditional commits and reconcile existing results on retry.
- Evaluate enhanced fan-out registered consumers or a revised shard capacity plan.
Explanation
Correct Answer
D:Evaluate enhanced fan-out registered consumers or a revised shard capacity plan. It directly addresses the case cause (Multiple polling consumers contend for the same shard read allowance.) and should be verified by: Each critical consumer recovers expected latency without throttling another.
Incorrect Answers
A:That change addresses an MWAA DAG was deployed but its Python import fails, so no scheduled run appears; it would not repair this incident.
B:That change addresses a Glue job joins a tiny lookup table to billions of rows and performs a full distributed shuffle; it would not repair this incident.
C:That change addresses an orchestrator invokes a Lambda that writes to S3 then times out; the retry writes a second output under a new random key; it would not repair this incident.
Question 921
After resolving the following incident, which ongoing safeguard most directly prevents recurrence? A vector retrieval index stores embeddings from two incompatible model versions in one dimension-dependent collection.
- Treat catalog identities and permissions as persistent infrastructure.
- Track model ID, vector dimension and index build provenance.
- Benchmark the required access patterns before choosing a data store.
- Capture Athena bytes-scanned baselines for frequent queries.
Explanation
Correct Answer
B:Track model ID, vector dimension and index build provenance. This safeguards against a recurring cause: Embedding dimensionality and semantic spaces are not aligned.
Incorrect Answers
A:That safeguard addresses another case: An ETL job drops a Glue Data Catalog table and recreates it daily, deleting important tags and permissions. It is not the control for this recurring failure.
C:That safeguard addresses another case: An online session store uses S3 object listing as a low-latency millisecond key lookup service and response times are erratic. It is not the control for this recurring failure.
D:That safeguard addresses another case: An Athena query reads huge raw JSON partitions for a narrow timestamp filter and scans far more bytes than expected. It is not the control for this recurring failure.
Question 922
A data privacy analyst needs to identify PII in unknown S3 datasets but assumes object names reveal sensitive content. Which technical dependency most directly explains this behavior?
- Object naming is not a reliable classifier of data content.
- The runtime identity is supplied by the Lambda execution role, not a host instance profile.
- Logging captures sensitive data beyond authorized operational requirements.
- A service role cannot replace blocked VPC routes or security group rules.
Explanation
Correct Answer
A:Object naming is not a reliable classifier of data content. The corresponding fix is to use approved Macie sensitive-data discovery and validated data classifications with access review.
Incorrect Answers
B:This diagnosis addresses another AWS case: A Lambda data extractor assumes an EC2 instance profile is available when running as a Lambda function. The dependency here is different.
C:This diagnosis addresses another AWS case: A central CloudWatch Logs group for Glue jobs retains all raw customer payloads in debug messages across many teams. The dependency here is different.
D:This diagnosis addresses another AWS case: A Glue crawler in a VPC fails connection to a private RDS source even with the right IAM service role. The dependency here is different.
Question 923
A small dimension table joins huge Redshift facts, but an unnecessarily EVEN distribution causes repeated data transfer. Which engineering change best addresses the underlying issue?
- Trace lineage and apply approved deletion to all eligible retained copies under policy.
- Update dataset ownership, metadata and authorized project access through approved catalog workflows.
- Stage an additive nullable field, backfill and validate before enforcing stricter semantics.
- Evaluate Redshift AUTO distribution or a justified ALL/KEY strategy from query plans.
Explanation
Correct Answer
D:Evaluate Redshift AUTO distribution or a justified ALL/KEY strategy from query plans. It directly addresses the case cause (Data placement increases redistribution for a frequently used join.) and should be verified by: Network redistribution and join latency improve with unchanged outputs.
Incorrect Answers
A: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.
B:That change addresses a SageMaker Catalog project references a dataset whose owner changed but permissions and business definitions still point to the former team; 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.
Question 924
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 technical dependency most directly explains this behavior?
- Deleting catalog metadata does not erase all underlying or derived personal data.
- API activity history does not directly replace configuration-state/compliance evaluation.
- The audit evidence store's retention does not match compliance requirements.
- Studio domain/project membership and resource governance are separate access contexts.
Explanation
Correct Answer
D:Studio domain/project membership and resource governance are separate access contexts. The corresponding fix is to assign supported domain/project membership and dataset entitlements through reviewed workflows.
Incorrect Answers
A:This diagnosis addresses another AWS case: A personal-data deletion request removes a row from an Athena external table view but leaves original S3 objects and downstream extracts. The dependency here is different.
B: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: An organization exports audit logs to S3 without lifecycle retention review and required records expire before annual audit. The dependency here is different.
Question 925
A pipeline uses long-lived IAM user access keys embedded in a Glue script instead of an execution role. Which technical dependency most directly explains this behavior?
- Static credentials create unnecessary exposure and rotation burden.
- Object naming is not a reliable classifier of data content.
- Object-level S3 reads require appropriate data-event collection scope.
- Attribute-based permissions have a policy scope broader than the approved audience.
Explanation
Correct Answer
A:Static credentials create unnecessary exposure and rotation burden. The corresponding fix is to use an AWS Glue service role and approved short-lived credentials instead of hard-coded keys.
Incorrect Answers
B:This diagnosis addresses another AWS case: A data privacy analyst needs to identify PII in unknown S3 datasets but assumes object names reveal sensitive content. The dependency here is different.
C:This diagnosis addresses another AWS case: An S3 data-access investigation searches CloudTrail for object reads but only management events were enabled. The dependency here is different.
D:This diagnosis addresses another AWS case: An S3 table is tagged `classification=restricted`, but its Lake Formation LF-Tag grant allows a broad organizational unit with no business need. The dependency here is different.
Question 926
A nightly data product uses a moving seven-day window but incoming source events arrive late and are excluded without a watermark policy. Which technical dependency most directly explains this behavior?
- The transformation treats identifiers as numeric measures rather than text keys.
- Data freshness and event-time completeness assumptions are not explicit.
- Changed query logic multiplies intermediate data and compute cost.
- The schedule target's Region, ARN, role, or cross-account authorization is misconfigured.
Explanation
Correct Answer
B:Data freshness and event-time completeness assumptions are not explicit. The corresponding fix is to implement event-time windows with a supported lateness allowance and correction/backfill strategy.
Incorrect Answers
A:This diagnosis addresses another AWS case: An analyst creates a Glue DataBrew visual cleaning step that trims all leading zeros from product IDs, breaking lookups. The dependency here is different.
C:This diagnosis addresses another AWS case: A Glue job begins consuming twice its normal DPU budget after a transformation adds a repeated cross join. The dependency here is different.
D:This diagnosis addresses another AWS case: An EventBridge schedule was configured in one Region but the receiving Step Functions state machine lives in another without a reviewed target design. The dependency here is different.
Question 927
A DynamoDB table contains session records with expired timestamps but items remain visible immediately after expiry. Which engineering change best addresses the underlying issue?
- Use reviewed schema contracts and serialized catalog publication through CI.
- Apply application-level expiry checks where strict visibility is required and keep TTL for eventual cleanup.
- Separate hot operational state from archival S3 objects using a measured suitable database/cache.
- Qualify or configure the intended catalog/database and verify metadata references.
Explanation
Correct Answer
B:Apply application-level expiry checks where strict visibility is required and keep TTL for eventual cleanup. It directly addresses the case cause (DynamoDB TTL deletion is asynchronous rather than an instantaneous query filter.) and should be verified by: Expired sessions are denied immediately even if the physical item persists briefly.
Incorrect Answers
A:That change addresses two developers independently edit Glue Data Catalog schema types during release, and a job fails after the last writer wins; it would not repair this incident.
C:That change addresses a customer expects fast key-value reads over frequently accessed session state yet stores every session in a multi-megabyte compressed S3 archive; it would not repair this incident.
D:That change addresses two Athena workgroups query identically named tables but one references a different data catalog and gets old records; it would not repair this incident.
Question 928
A multi-account data pipeline sends operational alerts through an SNS topic that no engineer subscribes to. Which engineering change best addresses the underlying issue?
- Configure validated subscriptions, policies and controlled test notifications.
- Align source transaction-log retention, DMS checkpoints, and CDC task health with the recovery objective.
- Use an explicit completed-manifest event or a sensor/check against expected export state.
- Apply bounded exponential backoff, jitter, and documented API quotas with durable checkpoints.
Explanation
Correct Answer
A:Configure validated subscriptions, policies and controlled test notifications. It directly addresses the case cause (Publishing events is not equivalent to having a viable incident notification path.) and should be verified by: A real on-call endpoint receives a test failure with actionable context.
Incorrect Answers
B:That change addresses a DMS CDC task finishes a full-load phase but stops capturing source table changes when the source transaction log expires; it would not repair this incident.
C:That change addresses an EventBridge schedule starts a warehouse load during an upstream S3 export rather than after all files are ready; it would not repair this incident.
D:That change addresses a partner API returns HTTP 429, and a Glue ETL job immediately retries in tight loops until access is suspended; it would not repair this incident.
Question 929
An Athena query of yesterday's S3 partition returns zero rows because its table metadata lacks that partition. Select THREE complementary measures that correctly repair and validate, and prevent recurrence of this failure.
- Add supported partition projection or update Glue partitions in the ingestion workflow.
- Protected test objects remain undeletable under expected retention conditions.
- Make partition-registration a verified publish step.
- Yesterday's test row becomes queryable without a broad table recreation.
- Change the SQL WHERE clause to omit all date constraints.
- Evaluate Redshift AUTO distribution or a justified ALL/KEY strategy from query plans.
Explanation
Correct Answers
A:Add supported partition projection or update Glue partitions in the ingestion workflow. The underlying cause is: The catalog partition listing is not synchronized with newly written S3 prefixes.
C:Make partition-registration a verified publish step. This protects against the following risk: The catalog partition listing is not synchronized with newly written S3 prefixes.
D:Yesterday's test row becomes queryable without a broad table recreation. This is the observable result required before accepting the correction.
Incorrect Answers
B:This would validate a different case: A legal-hold dataset is subject to an S3 Lifecycle expiration rule that would remove evidence at the usual age. It does not verify the outcome required here.
E:Change the SQL WHERE clause to omit all date constraints. That shortcut conflicts with the stated requirement.
F:That corrective action is for a different case: A small dimension table joins huge Redshift facts, but an unnecessarily EVEN distribution causes repeated data transfer. It does not resolve this incident.
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.
AWS Certified Data Engineer - Associate DEA-C01 Practice Tests