Amazon AWS Certified Data Engineer - Associate DEA-C01 Exam Dumps, Practice Test Questions

100% Latest & Updated Amazon AWS Certified Data Engineer - Associate DEA-C01 Practice Test Questions, Exam Dumps & Verified Answers!
30 Days Free Updates, Instant Download!

Amazon AWS Certified Data Engineer - Associate DEA-C01 Premium Bundle
$79.97
$59.98

AWS Certified Data Engineer - Associate DEA-C01 Premium Bundle

  • Premium File: 366 Questions & Answers. Last update: Nov 2, 2026
  • Training Course: 273 Video Lectures
  • Study Guide: 809 Pages
  • Latest Questions
  • 100% Accurate Answers
  • Fast Exam Updates

AWS Certified Data Engineer - Associate DEA-C01 Premium Bundle

Amazon AWS Certified Data Engineer - Associate DEA-C01 Premium Bundle
  • Premium File: 366 Questions & Answers. Last update: Nov 2, 2026
  • Training Course: 273 Video Lectures
  • Study Guide: 809 Pages
  • Latest Questions
  • 100% Accurate Answers
  • Fast Exam Updates
$79.97
$59.98

Amazon AWS Certified Data Engineer - Associate DEA-C01 Practice Test 34

Question 330

An S3 lake access point exists but a cross-account principal still receives AccessDenied when its IAM and bucket policies are not aligned. Select THREE complementary measures that correctly repair and validate, and prevent recurrence of this failure.

  1. Ignore explicit deny rules because the access-point name looks correct.
  2. Review the required access-point and identity/bucket permissions for the approved path.
  3. Apply supported column-level permissions or a governed aggregate view and deny raw salary access.
  4. A sample output meets organizational reidentification risk requirements.
  5. Use policy-simulator and negative-access tests during access changes.
  6. The intended cross-account role reads only the allowed lake dataset.

Explanation

Correct Answers

B:

Review the required access-point and identity/bucket permissions for the approved path. The underlying cause is: Permission evaluation spans identity, access-point, bucket and organizational controls.

E:

Use policy-simulator and negative-access tests during access changes. This protects against the following risk: Permission evaluation spans identity, access-point, bucket and organizational controls.

F:

The intended cross-account role reads only the allowed lake dataset. This is the observable result required before accepting the correction.

Incorrect Answers

A:

Ignore explicit deny rules because the access-point name looks correct. That shortcut conflicts with the stated requirement.

C:

That corrective action is for a different case: A Lake Formation table exposes a private salary column through a broad Athena SELECT grant when an analyst needs only aggregated headcount. It does not resolve this incident.

D:

This would validate a different case: A tokenization pipeline uses a deterministic unkeyed hash on low-entropy postal identifiers and calls them irreversibly anonymous. It does not verify the outcome required here.

Question 331

After resolving the following incident, which ongoing safeguard most directly prevents recurrence? A Hive metastore-based EMR Spark job writes a new partition but Athena never sees it through Glue Data Catalog.

  1. Maintain schema/constraint migration checklists and rollback plans.
  2. Document every required query pattern before schema rollout.
  3. Test version rollback and expiration dates before enabling cleanup.
  4. Document a single metadata owner for cross-engine lake datasets.

Explanation

Correct Answer

D:

Document a single metadata owner for cross-engine lake datasets. This safeguards against a recurring cause: The two metastore environments are not synchronized.

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 DynamoDB table needs lookup by email but stores only user ID and relies on full-table Scan for each login. It is not the control for this recurring failure.

C:

That safeguard addresses another case: An S3 lifecycle rule expires noncurrent object versions immediately, preventing recovery from accidental overwrites. It is not the control for this recurring failure.

Question 332

A pipeline launches thousands of concurrent Step Functions Map tasks and saturates a small partner API. Select THREE complementary measures that correctly repair and validate, and prevent recurrence of this failure.

  1. Remove all throttling safeguards to clear the Map faster.
  2. A replayed historical event receives its original applicable classification.
  3. Test Map concurrency under real vendor budgets before promotion.
  4. Use supported Map maximum concurrency and explicit backoff to respect provider quotas.
  5. Unpersist intermediate datasets and profile appropriate storage levels and partitions.
  6. Peak concurrent calls stay bounded and all tasks finish without escalating throttles.

Explanation

Correct Answers

C:

Test Map concurrency under real vendor budgets before promotion. This protects against the following risk: Map concurrency is uncapped relative to external rate limits.

D:

Use supported Map maximum concurrency and explicit backoff to respect provider quotas. The underlying cause is: Map concurrency is uncapped relative to external rate limits.

F:

Peak concurrent calls stay bounded and all tasks finish without escalating throttles. This is the observable result required before accepting the correction.

Incorrect Answers

A:

Remove all throttling safeguards to clear the Map faster. That shortcut conflicts with the stated requirement.

B:

This would validate a different case: A Glue transform joins events to reference data refreshed weekly, but old events are silently reclassified on every rerun. It does not verify the outcome required here.

E:

That corrective action is for a different case: An EMR Spark pipeline runs near memory limits because it caches multiple large datasets and never releases them. It does not resolve this incident.

Question 333

A Redshift query joins external and local datasets but expects Spectrum to automatically overwrite remote S3 data during UPDATE. Which technical dependency most directly explains this behavior?

  1. Catalog recreation destroys governance metadata and stable table identity.
  2. The catalog partition listing is not synchronized with newly written S3 prefixes.
  3. External-table query capability is confused with supported table mutation semantics.
  4. The modeled fact grain is inconsistent across record types.

Explanation

Correct Answer

C:

External-table query capability is confused with supported table mutation semantics. The corresponding fix is to use a supported ETL/write path to update the authoritative source, then refresh catalog metadata.

Incorrect Answers

A:

This diagnosis addresses another AWS case: An ETL job drops a Glue Data Catalog table and recreates it daily, deleting important tags and permissions. The dependency here is different.

B:

This diagnosis addresses another AWS case: An Athena query of yesterday's S3 partition returns zero rows because its table metadata lacks that partition. The dependency here is different.

D:

This diagnosis addresses another AWS case: A Redshift star schema mixes order-line and order-header facts in the same table and reports double-count revenue. The dependency here is different.

Question 334

A team applies a reviewed fix for this situation: An ETL role invokes KMS Decrypt repeatedly, but the pipeline's incident review examines only application logs without recording AWS API actor identity. Which observed outcome would most convincingly validate the fix?

  1. A controlled state machine execution invokes only its intended function.
  2. A controlled decrypt action can be attributed to the intended assumed role.
  3. The job decrypts authorized data but receives denial on a neighboring client's key.
  4. The report job reads its approved prefix but payroll reads fail.

Explanation

Correct Answer

B:

A controlled decrypt action can be attributed to the intended assumed role. This verifies the result of correlate CloudTrail and applicable KMS/service logs with job execution context.

Incorrect Answers

A:

This would verify another situation: A Step Functions state invokes a Lambda using a role that trusts EC2 instead of the Step Functions service. It does not validate the current case.

C:

This would verify another situation: A Glue data job decrypts source objects using a wildcard KMS permission spanning unrelated client keys. It does not validate the current case.

D:

This would verify another situation: A data access policy permits all S3 prefixes under `reports/*`, unintentionally including payroll records stored beneath that path. It does not validate the current case.

Question 335

A data quality gate compares raw and target record totals without accounting for intentional filter exclusions, falsely failing clean batches. Which engineering change best addresses the underlying issue?

  1. Examine iterator age, shard utilization, downstream latency and consumer parallelism.
  2. Reconcile accepted, filtered and quarantined records with explicit balance equations.
  3. Add explicit row-count, schema, and quality validation before the publish step.
  4. Validate supported cross-Region target patterns and scoped invocation permissions.

Explanation

Correct Answer

B:

Reconcile accepted, filtered and quarantined records with explicit balance equations. It directly addresses the case cause (The reconciliation rule ignores documented transformation semantics and accepted rejects.) and should be verified by: A known filtered fixture passes with every source record accounted for.

Incorrect Answers

A:

That change addresses a Kinesis consumer reports healthy CPU yet its IteratorAge grows for hours during normal traffic; it would not repair this incident.

C:

That change addresses a Glue ETL job completes with warnings but the orchestrator assumes success despite a downstream quality check failing; it would not repair this incident.

D:

That change addresses an EventBridge schedule was configured in one Region but the receiving Step Functions state machine lives in another without a reviewed target design; it would not repair this incident.

Question 336

After resolving the following incident, which ongoing safeguard most directly prevents recurrence? An EventBridge schedule was configured in one Region but the receiving Step Functions state machine lives in another without a reviewed target design.

  1. Version field rules and monitor exception rates by producer.
  2. Check exact ARNs and role trust in deployment tests.
  3. Check measure units and aggregation grain in dashboard reviews.
  4. Test daylight-saving and cross-timezone boundary cases.

Explanation

Correct Answer

B:

Check exact ARNs and role trust in deployment tests. This safeguards against a recurring cause: The schedule target's Region, ARN, role, or cross-account authorization is misconfigured.

Incorrect Answers

A:

That safeguard addresses another case: A Glue data quality rule checks only that an email column is nonnull but accepts invalid malformed addresses. It is not the control for this recurring failure.

C:

That safeguard addresses another case: A QuickSight dashboard compares two branch cost reports, one in local currency and one in USD, without conversion. It is not the control for this recurring failure.

D:

That safeguard addresses another case: A daily sales pivot groups event timestamps by the viewer's local date and differs from the regulatory UTC day. It is not the control for this recurring failure.

Question 337

After resolving the following incident, which ongoing safeguard most directly prevents recurrence? An S3 event notification triggers Glue for every file of a large export, producing hundreds of competing jobs.

  1. Visualize and test dependency DAGs on new schedule changes.
  2. Define a producer completion contract and deduplicate notifications.
  3. Run schema/format contract tests before warehouse loading.
  4. Prohibit unbounded collect operations in production ETL code reviews.

Explanation

Correct Answer

B:

Define a producer completion contract and deduplicate notifications. This safeguards against a recurring cause: The event-to-job design starts a run per object without a batch completion boundary.

Incorrect Answers

A:

That safeguard addresses another case: A scheduled Glue workflow triggers two jobs concurrently though the second requires the first output's partition. It is not the control for this recurring failure.

C:

That safeguard addresses another case: A Redshift COPY import fails on a changed date format in one batch even though prior files loaded. It is not the control for this recurring failure.

D:

That safeguard addresses another case: A distributed Spark process collects a large dataset to the driver and crashes from memory exhaustion. It is not the control for this recurring failure.

Question 338

A Redshift UNLOAD writes reporting data to an S3 bucket in another account but fails with access denied. Which technical dependency most directly explains this behavior?

  1. The object layout introduces avoidable fetch/decompression overhead for granular hot data.
  2. Raw object files do not by themselves provide open-table transaction semantics.
  3. The UNLOAD role and destination policy do not authorize the intended cross-account write.
  4. Dimension joins ignore the effective time range for slowly changing records.

Explanation

Correct Answer

C:

The UNLOAD role and destination policy do not authorize the intended cross-account write. The corresponding fix is to grant scoped bucket permissions and necessary KMS access to the Redshift execution role.

Incorrect Answers

A:

This diagnosis addresses another AWS case: A customer expects fast key-value reads over frequently accessed session state yet stores every session in a multi-megabyte compressed S3 archive. The dependency here is different.

B:

This diagnosis addresses another AWS case: A team needs ACID updates and time-travel queries against a governed S3 lake but writes plain Parquet files with no table transaction metadata. The dependency here is different.

D:

This diagnosis addresses another AWS case: A warehouse fact table is joined to customer history using only customer ID, multiplying matches across changing customer versions. The dependency here is different.

Question 339

A Redshift datashare grants partner analysts access to a customer data mart without a purpose or term limit. Select THREE complementary measures that correctly repair and validate, and prevent recurrence of this failure.

  1. Scope shared views, roles and periodic reauthorization with a documented owner.
  2. Review external share inventory and renewal evidence regularly.
  3. Complete supported AWS RAM share acceptance and consumer-side permission delegation.
  4. The partner accesses only intended assets and access ends when approval expires.
  5. A controlled secret rotation works and logs contain no secret values.
  6. Grant perpetual access to every table to avoid renewals.

Explanation

Correct Answers

A:

Scope shared views, roles and periodic reauthorization with a documented owner. The underlying cause is: Data sharing lifecycle does not reflect approved contractual authorization.

B:

Review external share inventory and renewal evidence regularly. This protects against the following risk: Data sharing lifecycle does not reflect approved contractual authorization.

D:

The partner accesses only intended assets and access ends when approval expires. This is the observable result required before accepting the correction.

Incorrect Answers

C:

That corrective action is for a different case: A cross-account Lake Formation share is granted but the consumer account has not accepted its RAM invitation where required. It does not resolve this incident.

E:

This would validate a different case: A pipeline sends database credentials in plaintext environment variables and writes them to CloudWatch on failure. It does not verify the outcome required here.

F:

Grant perpetual access to every table to avoid renewals. That shortcut conflicts with the stated requirement.

Question 340

After resolving the following incident, which ongoing safeguard most directly prevents recurrence? An S3 data-access investigation searches CloudTrail for object reads but only management events were enabled.

  1. Scan pipeline artifacts for access keys and enforce role-based access.
  2. Test project access with allowed and denied member fixtures.
  3. Test output redaction and secret access during incident injection.
  4. Validate CloudTrail event selectors during forensic readiness checks.

Explanation

Correct Answer

D:

Validate CloudTrail event selectors during forensic readiness checks. This safeguards against a recurring cause: Object-level S3 reads require appropriate data-event collection scope.

Incorrect Answers

A:

That safeguard addresses another case: A pipeline uses long-lived IAM user access keys embedded in a Glue script instead of an execution role. It is not the control for this recurring failure.

B:

That safeguard addresses another case: 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 is not the control for this recurring failure.

C:

That safeguard addresses another case: A pipeline sends database credentials in plaintext environment variables and writes them to CloudWatch on failure. It is not the control for this recurring failure.

AWS Certified Data Engineer - Associate DEA-C01 Practice Tests

UP

SPECIAL OFFER: GET 10% OFF

This is ONE TIME OFFER

ExamSnap Discount Offer
Enter Your Email Address to Receive Your 10% Off Discount Code

A confirmation link will be sent to this email address to verify your login. *We value your privacy. We will not rent or sell your email address.

Download Free Demo of VCE Exam Simulator

Experience Avanset VCE Exam Simulator for yourself.

Simply submit your e-mail address below to get started with our interactive software demo of your free trial.

Free Demo Limits: In the demo version you will be able to access only first 5 questions from exam.