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 100
A Step Functions state retries every failure including invalid schema, consuming budget without possibility of success. Select THREE complementary measures that correctly repair and validate, and prevent recurrence of this failure.
- Hot-key tasks finish within acceptable time with unchanged aggregates.
- Retry bounded transient exceptions and catch permanent validation failures for quarantine.
- Validate the model response against an explicit schema, use bounded retries and route uncertain results for review.
- Transient injected failures recover while invalid source data stops deterministically.
- Retry a malformed payload indefinitely until the state expires.
- Maintain documented error classes and bounded retry budgets.
Explanation
Correct Answers
B:Retry bounded transient exceptions and catch permanent validation failures for quarantine. The underlying cause is: Transient and permanent errors are not classified in the retry and catch policy.
D:Transient injected failures recover while invalid source data stops deterministically. This is the observable result required before accepting the correction.
F:Maintain documented error classes and bounded retry budgets. This protects against the following risk: Transient and permanent errors are not classified in the retry and catch policy.
Incorrect Answers
A:This would validate a different case: An EMR Spark job sends all rows for a popular customer to one reducer and fails despite plenty of idle cores. It does not verify the outcome required here.
C:That corrective action is for a different case: An application sends semi-structured documents to an LLM to classify regulated labels but stores model output without schema checking. It does not resolve this incident.
E:Retry a malformed payload indefinitely until the state expires. That shortcut conflicts with the stated requirement.
Question 101
A team applies a reviewed fix for this situation: A scheduled Glue workflow triggers two jobs concurrently though the second requires the first output's partition. Which observed outcome would most convincingly validate the fix?
- The published job serializes work to executors and produces correct output.
- Replica or source CPU stays bounded while expected rows are extracted.
- The second job starts only after the first has committed the required partition.
- Driver memory remains stable while full dataset results are produced.
Explanation
Correct Answer
C:The second job starts only after the first has committed the required partition. This verifies the result of add an explicit predecessor-success trigger or workflow state dependency.
Incorrect Answers
A:This would verify another situation: A team changes an analytics library but releases a job without checking distributed task serialization compatibility. It does not validate the current case.
B:This would verify another situation: A Glue JDBC extraction overloads a small OLTP database when hundreds of partitions open simultaneous connections. It does not validate the current case.
D:This would verify another situation: A distributed Spark process collects a large dataset to the driver and crashes from memory exhaustion. It does not validate the current case.
Question 102
A SageMaker Catalog project references a dataset whose owner changed but permissions and business definitions still point to the former team. 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.
- Generate versioned embeddings and store/index vectors in a supported eligible vector-capable service.
- Evaluate Redshift AUTO distribution or a justified ALL/KEY strategy from query plans.
Explanation
Correct Answer
B:Update dataset ownership, metadata and authorized project access through approved catalog workflows. It directly addresses the case cause (Business catalog stewardship and access context have drifted from the source asset.) and should be verified by: The correct new steward and entitlement appear in a controlled project query.
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.
C:That change addresses an application seeks low-latency semantic recommendations but indexes product names as plain text without generated embeddings; it would not repair this incident.
D: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 103
A DynamoDB application requires strongly consistent reads immediately after a successful critical write but queries a global secondary index. Which engineering change best addresses the underlying issue?
- Validate retention requirements and apply supported retention/lock controls before approving lifecycle changes.
- Run supported snapshot expiration and metadata cleanup with retention safeguards.
- Separate source prefixes/classifiers and create versioned tables with validated schema mappings.
- Use a supported strongly consistent base-table or local-index read design where necessary.
Explanation
Correct Answer
D:Use a supported strongly consistent base-table or local-index read design where necessary. It directly addresses the case cause (The chosen read path cannot provide strong consistency on the GSI.) and should be verified by: A controlled write/read test meets the documented consistency requirement.
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:That change addresses an Iceberg table's snapshot history grows as frequent small commits accumulate and query planning becomes slow; it would not repair this incident.
C:That change addresses a Glue crawler discovers an S3 path containing two incompatible CSV header layouts and produces a wide schema with ambiguous columns; it would not repair this incident.
Question 104
After resolving the following incident, which ongoing safeguard most directly prevents recurrence? A DynamoDB table needs lookup by email but stores only user ID and relies on full-table Scan for each login.
- Document a single metadata owner for cross-engine lake datasets.
- Capture Athena bytes-scanned baselines for frequent queries.
- Review hot/cold access patterns and storage-tier choices.
- Document every required query pattern before schema rollout.
Explanation
Correct Answer
D:Document every required query pattern before schema rollout. This safeguards against a recurring cause: The application lacks an access path for the documented alternate lookup key.
Incorrect Answers
A:That safeguard addresses another case: A Hive metastore-based EMR Spark job writes a new partition but Athena never sees it through Glue Data Catalog. It is not the control for this recurring failure.
B: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.
C:That safeguard addresses another case: A customer expects fast key-value reads over frequently accessed session state yet stores every session in a multi-megabyte compressed S3 archive. It is not the control for this recurring failure.
Question 105
A Glue crawler in a VPC fails connection to a private RDS source even with the right IAM service role. Which engineering change best addresses the underlying issue?
- Validate Glue network connection resources, subnets, SGs and database credentials together.
- Apply supported column-level permissions or a governed aggregate view and deny raw salary access.
- Confirm event data store selectors and query filters include intended account and Region events.
- Complete supported AWS RAM share acceptance and consumer-side permission delegation.
Explanation
Correct Answer
A:Validate Glue network connection resources, subnets, SGs and database credentials together. It directly addresses the case cause (A service role cannot replace blocked VPC routes or security group rules.) and should be verified by: The crawler accesses the RDS schema from its actual VPC context.
Incorrect Answers
B:That change addresses a Lake Formation table exposes a private salary column through a broad Athena SELECT grant when an analyst needs only aggregated headcount; it would not repair this incident.
C:That change addresses a CloudTrail Lake query lists IAM role changes but its event filter omits the Regions holding the relevant data pipelines; it would not repair this incident.
D:That change addresses a cross-account Lake Formation share is granted but the consumer account has not accepted its RAM invitation where required; it would not repair this incident.
Question 106
A team applies a reviewed fix for this situation: A streaming producer writes compressed messages into a format the Lambda consumer assumes is plain UTF-8. Which observed outcome would most convincingly validate the fix?
- Injected cancelled and failed jobs exit with correctly classified outcomes.
- Athena scanned bytes and cost decrease while results stay equivalent.
- A representative compressed event reaches the expected normalized target once.
- Only permitted attributes enter the model request and classification remains usable.
Explanation
Correct Answer
C:A representative compressed event reaches the expected normalized target once. This verifies the result of document and validate the record envelope and implement the matching decode path.
Incorrect Answers
A:This would verify another situation: A workflow branches on a job-status string but overlooks the Cancelled terminal state, leaving executions stuck. It does not validate the current case.
B:This would verify another situation: An ETL job writes CSV to a large analytics lake and Athena scans every column for two-field reports. It does not validate the current case.
D:This would verify another situation: An ETL pipeline calls a Bedrock model on full records containing account secrets merely to extract public product categories. It does not validate the current case.
Question 107
An AWS Config rule flags altered S3 encryption settings but the team uses CloudTrail alone as its continuous current-state configuration inventory. Which technical dependency most directly explains this behavior?
- An IAM resource wildcard is broader than the intended least-privilege dataset.
- Cross-account cryptographic key and replica policies do not match the consumer identities.
- API activity history does not directly replace configuration-state/compliance evaluation.
- Attribute-based permissions have a policy scope broader than the approved audience.
Explanation
Correct Answer
C:API activity history does not directly replace configuration-state/compliance evaluation. The corresponding fix is to use AWS Config resource history/rules alongside CloudTrail API events as appropriate.
Incorrect Answers
A: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.
B:This diagnosis addresses another AWS case: A data lake copies SSE-KMS objects across AWS accounts but the destination principal cannot decrypt the replica. 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 108
A customer expects fast key-value reads over frequently accessed session state yet stores every session in a multi-megabyte compressed S3 archive. Which technical dependency most directly explains this behavior?
- Dataset lineage and transformation provenance are not recorded.
- Join/distribution key cardinality is unsuitable for balanced data movement.
- The UNLOAD role and destination policy do not authorize the intended cross-account write.
- The object layout introduces avoidable fetch/decompression overhead for granular hot data.
Explanation
Correct Answer
D:The object layout introduces avoidable fetch/decompression overhead for granular hot data. The corresponding fix is to separate hot operational state from archival S3 objects using a measured suitable database/cache.
Incorrect Answers
A:This diagnosis addresses another AWS case: A data team cannot determine whether a report column came from the original CRM source or an intermediate cleansing step. The dependency here is different.
B:This diagnosis addresses another AWS case: A Redshift table has highly skewed account IDs as a distribution key and one compute slice processes most rows. The dependency here is different.
C: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 109
After resolving the following incident, which ongoing safeguard most directly prevents recurrence? A data science notebook uses a rolling 7-day average without ordering by event date, so results change with input row order.
- Test analytic calculations against shuffled and missing-day series.
- Test idempotency and unknown-success network failure scenarios.
- Capacity-test event bursts and coordinate account concurrency budgets.
- Maintain release/version compatibility tests for third-party connectors.
Explanation
Correct Answer
A:Test analytic calculations against shuffled and missing-day series. This safeguards against a recurring cause: The window aggregation does not specify a deterministic temporal frame.
Incorrect Answers
B:That safeguard addresses another case: A pipeline calls an AWS SDK to invoke Glue but drops the request token on network timeout and starts duplicate ETL runs. It is not the control for this recurring failure.
C:That safeguard addresses another case: An orchestrated data processing task receives tens of thousands of S3 events, causing Lambda reserved concurrency exhaustion. It is not the control for this recurring failure.
D:That safeguard addresses another case: A data pipeline updates its Glue version but custom connector dependencies fail at initialization. It is not the control for this recurring failure.
Question 110
After resolving the following incident, which ongoing safeguard most directly prevents recurrence? An ETL role invokes KMS Decrypt repeatedly, but the pipeline's incident review examines only application logs without recording AWS API actor identity.
- Keep lineage-based deletion runbooks and retention-exception records.
- Link pipeline run IDs to audit role and request context.
- Review registered data locations and role rights during ETL deployment.
- Test transport security separately from storage encryption.
Explanation
Correct Answer
B:Link pipeline run IDs to audit role and request context. This safeguards against a recurring cause: Operational logs omit relevant cloud audit-plane evidence.
Incorrect Answers
A:That safeguard addresses another case: A personal-data deletion request removes a row from an Athena external table view but leaves original S3 objects and downstream extracts. It is not the control for this recurring failure.
C:That safeguard addresses another case: An AWS Glue job writes to a governed S3 target but lacks the Lake Formation data-location access permission required for its workflow. It is not the control for this recurring failure.
D:That safeguard addresses another case: An S3 export writes regulated data to an unencrypted partner endpoint despite source-at-rest SSE-KMS protection. It is not the control for this recurring failure.
AWS Certified Data Engineer - Associate DEA-C01 Practice Tests