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 360
An application seeks low-latency semantic recommendations but indexes product names as plain text without generated embeddings. Which technical dependency most directly explains this behavior?
- The two metastore environments are not synchronized.
- Lexical text indexing does not implement the intended vector similarity retrieval.
- Primary key design does not support a dominant lookup pattern.
- The UNLOAD role and destination policy do not authorize the intended cross-account write.
Explanation
Correct Answer
B:Lexical text indexing does not implement the intended vector similarity retrieval. The corresponding fix is to generate versioned embeddings and store/index vectors in a supported eligible vector-capable service.
Incorrect Answers
A:This diagnosis addresses another AWS case: A Hive metastore-based EMR Spark job writes a new partition but Athena never sees it through Glue Data Catalog. The dependency here is different.
C:This diagnosis addresses another AWS case: A DynamoDB table uses composite key `tenant#date` but most reads are by `transaction_id` only and become scans. 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 361
A crawler changes a decimal sales column to string after encountering a nonnumeric banner row in one export. Select TWO complementary measures that correctly repair and validate this failure.
- Apply a stable catalog schema and quarantine malformed headers or records upstream.
- A test with a banner row keeps numeric fields correctly typed and records the reject.
- Allow every consumer to coerce the field independently.
- Trace lineage and apply approved deletion to all eligible retained copies under policy.
- Session lookups meet the accepted p95 target without unnecessary archive reads.
Explanation
Correct Answers
A:Apply a stable catalog schema and quarantine malformed headers or records upstream. The underlying cause is: Unvalidated mixed-format source rows contaminated schema inference.
B:A test with a banner row keeps numeric fields correctly typed and records the reject. This is the observable result required before accepting the correction.
Incorrect Answers
C:Allow every consumer to coerce the field independently. That shortcut conflicts with the stated requirement.
D:That corrective action is for a different case: An analytics partition must be removed under a deletion request, yet its historical copies persist in untracked S3 archive paths. It does not resolve this incident.
E:This would validate a different 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 does not verify the outcome required here.
Question 362
A CI pipeline promotes an ETL artifact after syntax checks but without a representative integration job against staged data. Which engineering change best addresses the underlying issue?
- Use nullable-aware extraction and document sensible default or reject handling per field.
- Gate promotion on integration tests using a restricted fixture and expected output assertions.
- Use a stable ingestion event ID with conditional writes or a deduplicating transaction design.
- Use guaranteed finalization or compensating cleanup states after terminal failures.
Explanation
Correct Answer
B:Gate promotion on integration tests using a restricted fixture and expected output assertions. It directly addresses the case cause (Compilation alone does not validate service permissions, schema, and output semantics.) and should be verified by: A deliberately invalid permission or schema change blocks release.
Incorrect Answers
A:That change addresses an API payload includes optional addresses but a transformation fails when a nullable nested object is absent; it would not repair this incident.
C:That change addresses an ingestion app writes identical DynamoDB item updates after a network retry and an audit counter increments twice; it would not repair this incident.
D:That change addresses a workflow that provisions a temporary staging cluster leaks resources after a later transform fails; it would not repair this incident.
Question 363
An AWS MWAA DAG has no task-level retries or SLA alerts, and a brief Glue API throttle causes a missed daily close. Select TWO complementary measures that correctly repair and validate this failure.
- A simulated transient failure recovers and persistent failures produce timely alerts.
- Use an explicit completed-manifest event or a sensor/check against expected export state.
- The new deployment fails validation before production if a required parameter is missing.
- Silence task alerts until the next billing period.
- Configure bounded task retries, failure callbacks and deadline-aware notifications.
Explanation
Correct Answers
A:A simulated transient failure recovers and persistent failures produce timely alerts. This is the observable result required before accepting the correction.
E:Configure bounded task retries, failure callbacks and deadline-aware notifications. The underlying cause is: Airflow task failure handling does not match known transient dependency behavior.
Incorrect Answers
B:That corrective action is for a different case: An EventBridge schedule starts a warehouse load during an upstream S3 export rather than after all files are ready. It does not resolve this incident.
C:This would validate a different case: A code deployment changes an ETL function's parameter name but unit tests exercise only the old pipeline entry point. It does not verify the outcome required here.
D:Silence task alerts until the next billing period. That shortcut conflicts with the stated requirement.
Question 364
A team applies a reviewed fix for this 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. Which observed outcome would most convincingly validate the fix?
- The transfer rejects an untrusted endpoint and succeeds over the intended encrypted connection.
- A test export contains permitted pseudonyms and omits restricted raw fields.
- A nominated team member can access only the project assets approved for the role.
- A controlled bucket configuration change is detected with historical and current evidence.
Explanation
Correct Answer
C:A nominated team member can access only the project assets approved for the role. This verifies the result of assign supported domain/project membership and dataset entitlements through reviewed workflows.
Incorrect Answers
A:This would verify another situation: An S3 export writes regulated data to an unencrypted partner endpoint despite source-at-rest SSE-KMS protection. It does not validate the current case.
B:This would verify another situation: A DynamoDB-backed application needs to redact sensitive values before exporting analytics but relies only on table encryption. It does not validate the current case.
D:This would verify another situation: An AWS Config rule flags altered S3 encryption settings but the team uses CloudTrail alone as its continuous current-state configuration inventory. It does not validate the current case.
Question 365
A team applies a reviewed fix for this situation: An online session store uses S3 object listing as a low-latency millisecond key lookup service and response times are erratic. Which observed outcome would most convincingly validate the fix?
- Representative key lookups meet the expected latency and consistency requirements.
- Known files appear under the intended distinct catalog schemas.
- Both controlled queries return the expected published dataset version.
- The correct new steward and entitlement appear in a controlled project query.
Explanation
Correct Answer
A:Representative key lookups meet the expected latency and consistency requirements. This verifies the result of choose an appropriately modeled DynamoDB or other eligible low-latency store with measured capacity.
Incorrect Answers
B:This would verify another situation: A Glue crawler discovers an S3 path containing two incompatible CSV header layouts and produces a wide schema with ambiguous columns. It does not validate the current case.
C:This would verify another situation: Two Athena workgroups query identically named tables but one references a different data catalog and gets old records. It does not validate the current case.
D:This would verify another situation: A SageMaker Catalog project references a dataset whose owner changed but permissions and business definitions still point to the former team. It does not validate the current case.
Question 366
After resolving the following incident, which ongoing safeguard most directly prevents recurrence? A fraud detector needs to reread yesterday's Kinesis records but the stream uses its short default retention window.
- Add grain and cardinality assertions after each flattening step.
- Review retention and recovery objectives whenever downstream processing latency changes.
- Profile algorithmic complexity for hot-path data structures.
- Version prompts/models and monitor false positives and sensitive-data exposure.
Explanation
Correct Answer
B:Review retention and recovery objectives whenever downstream processing latency changes. This safeguards against a recurring cause: The consumer's recovery period exceeds the stream's retained data duration.
Incorrect Answers
A:That safeguard addresses another case: A Glue job reading nested JSON flattens arrays incorrectly and duplicates parent order totals. It is not the control for this recurring failure.
C:That safeguard addresses another case: A large ETL data structure uses a list for repeated membership checks and CPU use grows unexpectedly. It is not the control for this recurring failure.
D:That safeguard addresses another case: An application sends semi-structured documents to an LLM to classify regulated labels but stores model output without schema checking. It is not the control for this recurring failure.
Question 367
A team applies a reviewed fix for this situation: 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. Which observed outcome would most convincingly validate the fix?
- The intended job reads only its approved data prefix while unrelated access remains denied.
- A sample output meets organizational reidentification risk requirements.
- The approved role reads the encrypted object but cannot decrypt unrelated keys.
- The analyst queries authorized views but cannot modify their source tables.
Explanation
Correct Answer
A:The intended job reads only its approved data prefix while unrelated access remains denied. This verifies the result of restore least-privilege S3 actions and evaluate the role's endpoint and bucket policies.
Incorrect Answers
B:This would verify another situation: A tokenization pipeline uses a deterministic unkeyed hash on low-entropy postal identifiers and calls them irreversibly anonymous. It does not validate the current case.
C:This would verify another situation: A Glue job reads an S3 object encrypted with a customer-managed KMS key and fails even though it has `s3:GetObject`. It does not validate the current case.
D:This would verify another situation: A Redshift data analyst has a role granting broad schema CREATE and DROP despite requiring only SELECT on a few views. It does not validate the current case.
Question 368
A team applies a reviewed fix for this situation: A pipeline uses long-lived IAM user access keys embedded in a Glue script instead of an execution role. Which observed outcome would most convincingly validate the fix?
- The analyst queries permitted columns while sensitive excluded fields remain inaccessible.
- A deliberate invalid record yields actionable error metadata without raw PII.
- The job operates without embedded secrets and permissions stay narrowly scoped.
- The transfer rejects an untrusted endpoint and succeeds over the intended encrypted connection.
Explanation
Correct Answer
C:The job operates without embedded secrets and permissions stay narrowly scoped. This verifies the result of use an AWS Glue service role and approved short-lived credentials instead of hard-coded keys.
Incorrect Answers
A: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.
B:This would verify another situation: A central CloudWatch Logs group for Glue jobs retains all raw customer payloads in debug messages across many teams. It does not validate the current case.
D:This would verify another situation: An S3 export writes regulated data to an unencrypted partner endpoint despite source-at-rest SSE-KMS protection. It does not validate the current case.
Question 369
A Glue streaming job writes duplicate target rows when a microbatch is retried after a worker restart. Which technical dependency most directly explains this behavior?
- The external sink operation is not idempotent across checkpoint replay.
- Ephemeral storage is insufficient for the actual intermediate workload.
- Linear repeated lookups are inefficient for a high-cardinality membership workload.
- Multiple polling consumers contend for the same shard read allowance.
Explanation
Correct Answer
A:The external sink operation is not idempotent across checkpoint replay. The corresponding fix is to use stable event identities and a sink merge/conditional-write design tied to checkpoint semantics.
Incorrect Answers
B:This diagnosis addresses another AWS case: A Lambda ETL process writes temporary files larger than its configured /tmp capacity and receives storage errors. The dependency here is different.
C:This diagnosis addresses another AWS case: A large ETL data structure uses a list for repeated membership checks and CPU use grows unexpectedly. The dependency here is different.
D:This diagnosis addresses another AWS case: Three independent Kinesis applications compete for shared shard read throughput and their IteratorAge rises together. The dependency here is different.
Question 370
An Athena Spark notebook reads only a handful of development files yet a manager interprets its average as an entire production trend. Which technical dependency most directly explains this behavior?
- The sample does not represent the target population and interval.
- The data quality contract omits numeric precision and tolerance.
- Credential retrieval and rotation are not part of the workload lifecycle.
- The pipeline has no required-field data quality gate before publishing.
Explanation
Correct Answer
A:The sample does not represent the target population and interval. The corresponding fix is to define a representative sampling plan or full-data check and report uncertainty.
Incorrect Answers
B:This diagnosis addresses another AWS case: An upstream system changes a decimal field from two to four digits of precision and rounding introduces revenue drift. The dependency here is different.
C:This diagnosis addresses another AWS case: A scheduled ETL uses an API token embedded in source code; rotation breaks the batch without an alert. The dependency here is different.
D:This diagnosis addresses another AWS case: A batch containing a required `customer_id` null value is committed to Redshift and breaks joins the next day. The dependency here is different.
AWS Certified Data Engineer - Associate DEA-C01 Practice Tests