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 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.
- Scan pipeline artifacts for access keys and enforce role-based access.
- Test project access with allowed and denied member fixtures.
- Test output redaction and secret access during incident injection.
- 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.
Question 341
A pipeline calls an AWS SDK to invoke Glue but drops the request token on network timeout and starts duplicate ETL runs. Which engineering change best addresses the underlying issue?
- Persist business run IDs and query existing job state before retrying execution creation.
- Use appropriate decimal types and compare reconciliation sums within approved tolerance.
- Use defensible stratified sampling with confidence limits or full checks for critical constraints.
- Normalize currencies using approved rates and label dates, units and calculation rules.
Explanation
Correct Answer
A:Persist business run IDs and query existing job state before retrying execution creation. It directly addresses the case cause (The caller lacks a durable run identity and reconciliation on uncertain acknowledgement.) and should be verified by: A forced timeout leads to one accepted logical batch and auditable retries.
Incorrect Answers
B:That change addresses an upstream system changes a decimal field from two to four digits of precision and rounding introduces revenue drift; it would not repair this incident.
C:That change addresses a streaming pipeline evaluates quality from a random sample of 10 messages and assumes it proves a million-row batch is correct; it would not repair this incident.
D:That change addresses a QuickSight dashboard compares two branch cost reports, one in local currency and one in USD, without conversion; it would not repair this incident.
Question 342
A Step Functions data pipeline invokes Glue using a request/response integration and immediately launches Athena against unfinished output. Select TWO complementary measures that correctly repair and validate this failure.
- Use supported wait-for-completion integration or a correctly bounded job-status polling loop.
- Insert a fixed three-second delay and assume all Glue jobs finish.
- Convert to validated decimal types upstream or with explicit safe casts before aggregation.
- A controlled event is consumed and appears in the authorized downstream sink.
- Athena reads only successfully committed transform output after the Glue run ends.
Explanation
Correct Answers
A:Use supported wait-for-completion integration or a correctly bounded job-status polling loop. The underlying cause is: The orchestration integration returns before the asynchronous ETL work finishes.
E:Athena reads only successfully committed transform output after the Glue run ends. This is the observable result required before accepting the correction.
Incorrect Answers
B:Insert a fixed three-second delay and assume all Glue jobs finish. That shortcut conflicts with the stated requirement.
C:That corrective action is for a different case: An Athena SQL query sums decimal prices stored as strings and uses lexicographic ordering on text. It does not resolve this incident.
D:This would validate a different case: A Kinesis stream is receiving writes but downstream analytics remain empty after the consumer IAM role lost read permission. It does not verify the outcome required here.
Question 343
A DynamoDB table uses composite key `tenant#date` but most reads are by `transaction_id` only and become scans. Which technical dependency most directly explains this behavior?
- Primary key design does not support a dominant lookup pattern.
- Analytical query workload competes with the transaction service.
- The two metastore environments are not synchronized.
- Data deletion workflow lacks a complete inventory of copies and derived datasets.
Explanation
Correct Answer
A:Primary key design does not support a dominant lookup pattern. The corresponding fix is to plan a suitable alternate index or redesign around known query requirements.
Incorrect Answers
B:This diagnosis addresses another AWS case: An operational RDS database has a complex read-only report consuming most CPU at peak checkout time. The dependency here is different.
C: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.
D:This diagnosis addresses another AWS case: An analytics partition must be removed under a deletion request, yet its historical copies persist in untracked S3 archive paths. The dependency here is different.
Question 344
A Glue data job decrypts source objects using a wildcard KMS permission spanning unrelated client keys. Select TWO complementary measures that correctly repair and validate this failure.
- The crawler accesses the RDS schema from its actual VPC context.
- The job decrypts authorized data but receives denial on a neighboring client's key.
- Scope KMS actions to intended keys and add appropriate conditions where supported.
- Use `kms:*` on every account key for convenience.
- Grant explicit least-privilege permissions to the Glue execution role and verify the data access path.
Explanation
Correct Answers
B:The job decrypts authorized data but receives denial on a neighboring client's key. This is the observable result required before accepting the correction.
C:Scope KMS actions to intended keys and add appropriate conditions where supported. The underlying cause is: Cryptographic permissions exceed the data processing task's required keys.
Incorrect Answers
A:This would validate a different case: A Glue crawler in a VPC fails connection to a private RDS source even with the right IAM service role. It does not verify the outcome required here.
D:Use `kms:*` on every account key for convenience. That shortcut conflicts with the stated requirement.
E:That corrective action is for a different case: An Athena query against a Lake Formation resource succeeds for the analyst, yet a separate Glue ETL role cannot read that same table. It does not resolve this incident.
Question 345
A geospatial data catalog is placed in DynamoDB with no defined access key and engineers scan the entire table for each location. Which engineering change best addresses the underlying issue?
- Use supported S3 Object Lock legal hold/retention and review lifecycle interactions.
- Select an appropriate supported index or purpose-built query store using measured predicates.
- Apply a stable catalog schema and quarantine malformed headers or records upstream.
- Set separately reviewed current and noncurrent version lifecycle policies.
Explanation
Correct Answer
B:Select an appropriate supported index or purpose-built query store using measured predicates. It directly addresses the case cause (The data model does not match the required predicate/access pattern.) and should be verified by: Representative spatial lookups return correctly without full-table scans.
Incorrect Answers
A:That change addresses a legal-hold dataset is subject to an S3 Lifecycle expiration rule that would remove evidence at the usual age; it would not repair this incident.
C:That change addresses a crawler changes a decimal sales column to string after encountering a nonnumeric banner row in one export; it would not repair this incident.
D:That change addresses an S3 lifecycle rule expires noncurrent object versions immediately, preventing recovery from accidental overwrites; it would not repair this incident.
Question 346
An organization exports audit logs to S3 without lifecycle retention review and required records expire before annual audit. Which technical dependency most directly explains this behavior?
- Secrets are handled as ordinary configuration and leaked through diagnostics.
- The audit evidence store's retention does not match compliance requirements.
- At-rest encryption does not secure data transmission on an external path.
- Network reachability is distinct from the execution role's S3 authorization.
Explanation
Correct Answer
B:The audit evidence store's retention does not match compliance requirements. The corresponding fix is to apply approved protected S3 retention, access and lifecycle safeguards for logs.
Incorrect Answers
A:This diagnosis addresses another AWS case: A pipeline sends database credentials in plaintext environment variables and writes them to CloudWatch on failure. The dependency here is different.
C:This diagnosis addresses another AWS case: An S3 export writes regulated data to an unencrypted partner endpoint despite source-at-rest SSE-KMS protection. The dependency here is different.
D:This diagnosis addresses another AWS case: 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. The dependency here is different.
Question 347
A team applies a reviewed fix for this situation: An Athena query for CloudTrail logs shows a missing day because the log data lake partitions were never registered. Which observed outcome would most convincingly validate the fix?
- The partner accesses only intended assets and access ends when approval expires.
- Controlled events from the missing day are queryable after catalog correction.
- The approved Glue job reads its required table without inheriting analyst-admin rights.
- A controlled secret rotation works and logs contain no secret values.
Explanation
Correct Answer
B:Controlled events from the missing day are queryable after catalog correction. This verifies the result of confirm CloudTrail delivery, then repair Athena catalog partitions or approved projection.
Incorrect Answers
A:This would verify another situation: A Redshift datashare grants partner analysts access to a customer data mart without a purpose or term limit. It does not validate the current case.
C:This would verify another situation: An Athena query against a Lake Formation resource succeeds for the analyst, yet a separate Glue ETL role cannot read that same table. It does not validate the current case.
D:This would verify another situation: A pipeline sends database credentials in plaintext environment variables and writes them to CloudWatch on failure. It does not validate the current case.
Question 348
A CI pipeline promotes an ETL artifact after syntax checks but without a representative integration job against staged data. Select THREE complementary measures that correctly repair and validate, and prevent recurrence of this failure.
- A deliberately invalid permission or schema change blocks release.
- Gate promotion on integration tests using a restricted fixture and expected output assertions.
- Define deployment acceptance criteria for contracts and IAM access.
- Peak concurrent calls stay bounded and all tasks finish without escalating throttles.
- Approve production whenever a source file passes syntax checks.
- Retry bounded transient exceptions and catch permanent validation failures for quarantine.
Explanation
Correct Answers
A:A deliberately invalid permission or schema change blocks release. This is the observable result required before accepting the correction.
B:Gate promotion on integration tests using a restricted fixture and expected output assertions. The underlying cause is: Compilation alone does not validate service permissions, schema, and output semantics.
C:Define deployment acceptance criteria for contracts and IAM access. This protects against the following risk: Compilation alone does not validate service permissions, schema, and output semantics.
Incorrect Answers
D:This would validate a different case: A pipeline launches thousands of concurrent Step Functions Map tasks and saturates a small partner API. It does not verify the outcome required here.
E:Approve production whenever a source file passes syntax checks. That shortcut conflicts with the stated requirement.
F:That corrective action is for a different case: A Step Functions state retries every failure including invalid schema, consuming budget without possibility of success. It does not resolve this incident.
Question 349
A team applies a reviewed fix for this situation: A cross-account Lake Formation share is granted but the consumer account has not accepted its RAM invitation where required. Which observed outcome would most convincingly validate the fix?
- An authorized consumer principal can resolve and read the shared table.
- A controlled object read produces a traceable data event with expected context.
- The job decrypts authorized data but receives denial on a neighboring client's key.
- The intended cross-account role reads only the allowed lake dataset.
Explanation
Correct Answer
A:An authorized consumer principal can resolve and read the shared table. This verifies the result of complete supported AWS RAM share acceptance and consumer-side permission delegation.
Incorrect Answers
B:This would verify another situation: An S3 data-access investigation searches CloudTrail for object reads but only management events were enabled. 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: An S3 lake access point exists but a cross-account principal still receives AccessDenied when its IAM and bucket policies are not aligned. It does not validate the current case.
Question 350
An ETL task in Glue times out only when a small fraction of keys dominate the daily partition. Select TWO complementary measures that correctly repair and validate this failure.
- Increase retry count on the same unmodified skewed job.
- A new unrecognized code is flagged before the data reaches reports.
- Compare uniqueness, completeness, reconciliation, and distribution against known fixtures.
- Long-running tasks improve without changing aggregate results.
- Inspect Spark stage metrics and split/salt hotspots or change skewed join strategy.
Explanation
Correct Answers
D:Long-running tasks improve without changing aggregate results. This is the observable result required before accepting the correction.
E:Inspect Spark stage metrics and split/salt hotspots or change skewed join strategy. The underlying cause is: Skew creates straggler executors and prevents completion within the SLA.
Incorrect Answers
A:Increase retry count on the same unmodified skewed job. That shortcut conflicts with the stated requirement.
B:This would validate a different case: A Glue transformation produces 100% nonnull rows but an upstream category mapping is outdated and mislabels every new source code. It does not verify the outcome required here.
C:That corrective action is for a different case: A data team declares a successful cleanup because duplicate percentage fell, but the job also dropped valid unique rows. It does not resolve this incident.
AWS Certified Data Engineer - Associate DEA-C01 Practice Tests