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 610
An Athena query reads huge raw JSON partitions for a narrow timestamp filter and scans far more bytes than expected. Which technical dependency most directly explains this behavior?
- Crawler scope is broader than the governed dataset and includes nonauthoritative paths.
- A lake table lacks effective columnar layout and pruning for its query pattern.
- Partition granularity is too fine for data volume and query predicates.
- Schema discovery crosses incompatible source populations in one catalog grouping.
Explanation
Correct Answer
B:A lake table lacks effective columnar layout and pruning for its query pattern. The corresponding fix is to use appropriately partitioned Parquet or another supported format, and verify partition predicates.
Incorrect Answers
A: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.
C:This diagnosis addresses another AWS case: An Athena table uses daily partitions on a timestamp with millions of near-empty partition folders. The dependency here is different.
D:This diagnosis addresses another AWS case: A Glue crawler discovers an S3 path containing two incompatible CSV header layouts and produces a wide schema with ambiguous columns. The dependency here is different.
Question 611
A team applies a reviewed fix for this situation: A Glue DataBrew recipe was changed interactively but the production pipeline still applies a previous published recipe version. Which observed outcome would most convincingly validate the fix?
- A controlled fixture receives the exact reviewed cleaning steps.
- A known filtered fixture passes with every source record accounted for.
- A forced retry produces totals matching an independent known fixture.
- An injected null key blocks publication and supplies a triage record.
Explanation
Correct Answer
A:A controlled fixture receives the exact reviewed cleaning steps. This verifies the result of reference the approved immutable recipe/version in the scheduled data workflow.
Incorrect Answers
B:This would verify another situation: A data quality gate compares raw and target record totals without accounting for intentional filter exclusions, falsely failing clean batches. It does not validate the current case.
C:This would verify another situation: A Spark aggregation produces incorrect category totals because one hot key is dropped after a task retry and the target doesn't reconcile. It does not validate the current case.
D:This would verify another situation: A batch containing a required `customer_id` null value is committed to Redshift and breaks joins the next day. It does not validate the current case.
Question 612
An EventBridge schedule starts a warehouse load during an upstream S3 export rather than after all files are ready. Which technical dependency most directly explains this behavior?
- Uncontrolled dependency drift changes execution behavior.
- The processing layout prevents distributed parallelism.
- A wall-clock trigger is not a reliable data-completion dependency.
- Transient and permanent errors are not classified in the retry and catch policy.
Explanation
Correct Answer
C:A wall-clock trigger is not a reliable data-completion dependency. The corresponding fix is to use an explicit completed-manifest event or a sensor/check against expected export state.
Incorrect Answers
A:This diagnosis addresses another AWS case: A Glue processing library has no pinned dependency versions and a release pulls a new incompatible parser. The dependency here is different.
B:This diagnosis addresses another AWS case: A data transformation uses one Spark partition for a terabyte input and only one executor stays busy. The dependency here is different.
D:This diagnosis addresses another AWS case: A Step Functions state retries every failure including invalid schema, consuming budget without possibility of success. The dependency here is different.
Question 613
A team applies a reviewed fix for this situation: A Redshift star schema mixes order-line and order-header facts in the same table and reports double-count revenue. Which observed outcome would most convincingly validate the fix?
- A controlled external-table query reads the intended new partition only.
- Both engines read the same committed table snapshot within planned freshness bounds.
- Both controlled queries return the expected published dataset version.
- A multi-line order yields correct revenue and item counts in fixture reports.
Explanation
Correct Answer
D:A multi-line order yields correct revenue and item counts in fixture reports. This verifies the result of separate or explicitly model fact grain and join to dimensions at compatible levels.
Incorrect Answers
A:This would verify another situation: A Redshift Spectrum external table points to S3 partitions whose IAM role cannot read the new prefix after an account move. It does not validate the current case.
B:This would verify another situation: A dataset uses Iceberg but Spark and Athena query different catalogs and show conflicting table snapshots. 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.
Question 614
After resolving the following incident, which ongoing safeguard most directly prevents recurrence? An MSK producer succeeds only intermittently after brokers change because its connection string contains one retired broker address.
- Review DAG deadlines and failure paths for each critical dependency.
- Automate broker endpoint checks and rolling-client reconnection tests.
- Add lifecycle checks for persistence and executor memory use.
- Check service response enums when revising orchestration logic.
Explanation
Correct Answer
B:Automate broker endpoint checks and rolling-client reconnection tests. This safeguards against a recurring cause: Producer bootstrap configuration does not follow the advertised Kafka broker endpoint set.
Incorrect Answers
A: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.
C:That safeguard addresses another case: An EMR Spark pipeline runs near memory limits because it caches multiple large datasets and never releases them. It is not the control for this recurring failure.
D:That safeguard addresses another case: A workflow branches on a job-status string but overlooks the Cancelled terminal state, leaving executions stuck. It is not the control for this recurring failure.
Question 615
An EMR workflow submits five jobs simultaneously but two require the first job's generated HDFS staging output. Select TWO complementary measures that correctly repair and validate this failure.
- Consumers start only after the upstream staging output is committed.
- Inspect Spark stage metrics and split/salt hotspots or change skewed join strategy.
- Express ordered execution or an appropriate DAG with artifact-ready checks.
- Launch all jobs concurrently and assume filenames encode readiness.
- A simulated missed load triggers a delivered alert before the data SLA expires.
Explanation
Correct Answers
A:Consumers start only after the upstream staging output is committed. This is the observable result required before accepting the correction.
C:Express ordered execution or an appropriate DAG with artifact-ready checks. The underlying cause is: Workflow execution order lacks explicit job dependencies.
Incorrect Answers
B:That corrective action is for a different case: An ETL task in Glue times out only when a small fraction of keys dominate the daily partition. It does not resolve this incident.
D:Launch all jobs concurrently and assume filenames encode readiness. That shortcut conflicts with the stated requirement.
E:This would validate a different case: A Glue job has failed for three mornings but no CloudWatch alarm exists, so dashboards show stale data. It does not verify the outcome required here.
Question 616
A CloudTrail Lake query lists IAM role changes but its event filter omits the Regions holding the relevant data pipelines. Which technical dependency most directly explains this behavior?
- An IAM resource wildcard is broader than the intended least-privilege dataset.
- Audit query coverage does not match the monitored account/Region scope.
- Data sharing lifecycle does not reflect approved contractual authorization.
- Deleting catalog metadata does not erase all underlying or derived personal data.
Explanation
Correct Answer
B:Audit query coverage does not match the monitored account/Region scope. The corresponding fix is to confirm event data store selectors and query filters include intended account and Region events.
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.
C:This diagnosis addresses another AWS case: A Redshift datashare grants partner analysts access to a customer data mart without a purpose or term limit. The dependency here is different.
D: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.
Question 617
A clickstream pipeline converts all nested attributes to strings before storage, making numeric analytics unreliable. Select TWO complementary measures that correctly repair and validate this failure.
- Treat lexicographic sorting of numeric strings as valid numerical analysis.
- Price and duration fields support correct arithmetic on known test rows.
- Add an explicit predecessor-success trigger or workflow state dependency.
- A known new table's rows and later changes reach the approved target.
- Apply a defined typed schema, normalize units, and retain raw payloads for replay.
Explanation
Correct Answers
B:Price and duration fields support correct arithmetic on known test rows. This is the observable result required before accepting the correction.
E:Apply a defined typed schema, normalize units, and retain raw payloads for replay. The underlying cause is: Transformation discards intended field types and semantic metadata.
Incorrect Answers
A:Treat lexicographic sorting of numeric strings as valid numerical analysis. That shortcut conflicts with the stated requirement.
C:That corrective action is for a different case: A scheduled Glue workflow triggers two jobs concurrently though the second requires the first output's partition. It does not resolve this incident.
D:This would validate a different case: An on-premises Oracle source feeds DMS, but newly added tables never appear in a configured migration. It does not verify the outcome required here.
Question 618
After resolving the following incident, which ongoing safeguard most directly prevents recurrence? An organization exports audit logs to S3 without lifecycle retention review and required records expire before annual audit.
- Review role ownership and permissions after organizational changes.
- Test retention and deletion restrictions during compliance reviews.
- Use role-based acceptance tests, not administrator-only smoke tests.
- Enforce residency rules in IaC/policy checks and governance reviews.
Explanation
Correct Answer
B:Test retention and deletion restrictions during compliance reviews. This safeguards against a recurring cause: The audit evidence store's retention does not match compliance requirements.
Incorrect Answers
A:That safeguard addresses another case: A data engineering service uses one unrestricted role for production ETL, development notebooks and reporting. It is not the control for this recurring failure.
C:That safeguard addresses another case: 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 is not the control for this recurring failure.
D:That safeguard addresses another case: A data lake in an EU Region replicates raw customer records to an unapproved Region for convenience. It is not the control for this recurring failure.
Question 619
A Redshift datashare exposes more tables than a partner is contractually allowed to query. Which engineering change best addresses the underlying issue?
- Restrict authorized shared schema/object grants and verify consumer access.
- Scope shared views, roles and periodic reauthorization with a documented owner.
- Inventory staging artifacts and enforce approved secure cleanup/retention and access.
- Review the required access-point and identity/bucket permissions for the approved path.
Explanation
Correct Answer
A:Restrict authorized shared schema/object grants and verify consumer access. It directly addresses the case cause (Data sharing scope was defined too broadly for the partner's agreed dataset.) and should be verified by: The partner can query intended views without accessing unrelated source objects.
Incorrect Answers
B:That change addresses a Redshift datashare grants partner analysts access to a customer data mart without a purpose or term limit; it would not repair this incident.
C:That change addresses a lake-to-warehouse pipeline removes raw PII from visible tables but keeps an untracked temporary S3 staging prefix indefinitely; it would not repair this incident.
D:That change addresses an S3 lake access point exists but a cross-account principal still receives AccessDenied when its IAM and bucket policies are not aligned; it would not repair this incident.
Question 620
A Redshift query repeatedly casts a large timestamp string field during aggregation and consumes excess CPU. Which engineering change best addresses the underlying issue?
- Configure appropriate reserved/provisioned concurrency and buffer events to match sustainable throughput.
- Normalize timestamp types during ingestion and optimize the relevant table layout.
- Configure sufficient Kinesis retention and checkpoint offsets before the outage window expires.
- Keep transformations distributed and collect only bounded diagnostic samples.
Explanation
Correct Answer
B:Normalize timestamp types during ingestion and optimize the relevant table layout. It directly addresses the case cause (The warehouse is storing a frequently analyzed typed attribute in an inefficient representation.) and should be verified by: A representative time-window report has correct results with lower CPU/runtime.
Incorrect Answers
A:That change addresses a Lambda ETL function exhausts concurrency during a flash sale, causing fresh events to be throttled; it would not repair this incident.
C:That change addresses a fraud detector needs to reread yesterday's Kinesis records but the stream uses its short default retention window; it would not repair this incident.
D:That change addresses a distributed Spark process collects a large dataset to the driver and crashes from memory exhaustion; it would not repair this incident.
AWS Certified Data Engineer - Associate DEA-C01 Practice Tests