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 970
An ETL job writes CSV to a large analytics lake and Athena scans every column for two-field reports. Which technical dependency most directly explains this behavior?
- The consuming workflow lacks a reliable transfer-completion boundary.
- Row-based text storage undermines predicate and column projection efficiencies.
- Queue-consumer concurrency exceeds the sink's sustainable write capacity.
- An unbounded driver collect breaks distributed processing assumptions.
Explanation
Correct Answer
B:Row-based text storage undermines predicate and column projection efficiencies. The corresponding fix is to convert cleaned data to appropriately compressed Parquet with suitable partitions.
Incorrect Answers
A:This diagnosis addresses another AWS case: A partner uploads a CSV over SFTP to Transfer Family but a load starts before the file finishes writing. The dependency here is different.
C:This diagnosis addresses another AWS case: An SQS-backed processor overwhelms a downstream database after scaling consumers without any concurrency cap. The dependency here is different.
D:This diagnosis addresses another AWS case: A distributed Spark process collects a large dataset to the driver and crashes from memory exhaustion. The dependency here is different.
Question 971
An Athena view compares monthly cohorts using an inner join that drops customers with no activity, overstating retention. Select THREE complementary measures that correctly repair and validate, and prevent recurrence of this failure.
- A zero-activity test customer remains in denominator without fake activity.
- A forced timeout leads to one accepted logical batch and auditable retries.
- Exclude users with zero sessions to improve apparent retention.
- Test cohort queries against absent-activity fixtures.
- Use the supported paginator/continuation token and durable inventory checkpoints.
- Retain the baseline cohort and left-join subsequent activity with explicit null handling.
Explanation
Correct Answers
A:A zero-activity test customer remains in denominator without fake activity. This is the observable result required before accepting the correction.
D:Test cohort queries against absent-activity fixtures. This protects against the following risk: The join excludes the population that must remain in the denominator.
F:Retain the baseline cohort and left-join subsequent activity with explicit null handling. The underlying cause is: The join excludes the population that must remain in the denominator.
Incorrect Answers
B:This would validate a different case: A pipeline calls an AWS SDK to invoke Glue but drops the request token on network timeout and starts duplicate ETL runs. It does not verify the outcome required here.
C:Exclude users with zero sessions to improve apparent retention. That shortcut conflicts with the stated requirement.
E:That corrective action is for a different case: A daily Python ingestion script calls S3 ListObjectsV2 only once and misses most keys after data growth. It does not resolve this incident.
Question 972
After resolving the following incident, which ongoing safeguard most directly prevents recurrence? A team adds a nonnullable required field to an Iceberg table but old rows have no value and downstream reads fail.
- Test query plans and cost at expected data volume.
- Review evolution compatibility and snapshot rollback requirements.
- Revalidate role, bucket and key permissions after account boundary changes.
- Make partition-registration a verified publish step.
Explanation
Correct Answer
B:Review evolution compatibility and snapshot rollback requirements. This safeguards against a recurring cause: Schema evolution introduced a requirement incompatible with existing records.
Incorrect Answers
A:That safeguard addresses another case: A geospatial data catalog is placed in DynamoDB with no defined access key and engineers scan the entire table for each location. It is not the control for this recurring failure.
C:That safeguard addresses another case: A Redshift UNLOAD writes reporting data to an S3 bucket in another account but fails with access denied. It is not the control for this recurring failure.
D:That safeguard addresses another case: An Athena query of yesterday's S3 partition returns zero rows because its table metadata lacks that partition. It is not the control for this recurring failure.
Question 973
A Glue job joins a tiny lookup table to billions of rows and performs a full distributed shuffle. Which engineering change best addresses the underlying issue?
- Consume a supported completion event or atomic finalized object naming before ingestion.
- Use a stable ingestion event ID with conditional writes or a deduplicating transaction design.
- Evaluate a broadcast join or other optimized join strategy within Glue/Spark memory limits.
- Document and validate the record envelope and implement the matching decode path.
Explanation
Correct Answer
C:Evaluate a broadcast join or other optimized join strategy within Glue/Spark memory limits. It directly addresses the case cause (The join strategy ignores a safe broadcastable small dimension.) and should be verified by: Shuffle volume declines and matching output rows remain identical.
Incorrect Answers
A:That change addresses a partner uploads a CSV over SFTP to Transfer Family but a load starts before the file finishes writing; it would not repair this incident.
B: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 streaming producer writes compressed messages into a format the Lambda consumer assumes is plain UTF-8; it would not repair this incident.
Question 974
A team applies a reviewed fix for this situation: A Glue job joins a tiny lookup table to billions of rows and performs a full distributed shuffle. Which observed outcome would most convincingly validate the fix?
- Shuffle volume declines and matching output rows remain identical.
- Each critical consumer recovers expected latency without throttling another.
- A known new table's rows and later changes reach the approved target.
- An injected failure leaves no orphaned temporary cluster and preserves incident evidence.
Explanation
Correct Answer
A:Shuffle volume declines and matching output rows remain identical. This verifies the result of evaluate a broadcast join or other optimized join strategy within Glue/Spark memory limits.
Incorrect Answers
B:This would verify another situation: Three independent Kinesis applications compete for shared shard read throughput and their IteratorAge rises together. It does not validate the current case.
C:This would verify another situation: An on-premises Oracle source feeds DMS, but newly added tables never appear in a configured migration. It does not validate the current case.
D:This would verify another situation: A workflow that provisions a temporary staging cluster leaks resources after a later transform fails. It does not validate the current case.
Question 975
A serverless pipeline deploys with hand-edited IAM and S3 settings that differ among test and production accounts. Which engineering change best addresses the underlying issue?
- Set supported concurrency/batch controls and scale throughput using measured sink limits.
- Declare reviewed environment-specific infrastructure using CloudFormation, CDK, or SAM.
- Use supported batching, buffering, compaction, or columnar write paths appropriate to latency.
- Refresh supported MSK bootstrap endpoints and validate client DNS, TLS, and network routes.
Explanation
Correct Answer
B:Declare reviewed environment-specific infrastructure using CloudFormation, CDK, or SAM. It directly addresses the case cause (Infrastructure drift makes deployments non-repeatable.) and should be verified by: A clean deployment reproduces expected resources and scoped permissions.
Incorrect Answers
A:That change addresses an SQS-backed processor overwhelms a downstream database after scaling consumers without any concurrency cap; it would not repair this incident.
C:That change addresses a Lambda process writes individual small S3 JSON files for millions of events and downstream scans slow dramatically; it would not repair this incident.
D:That change addresses an MSK producer succeeds only intermittently after brokers change because its connection string contains one retired broker address; it would not repair this incident.
Question 976
A Glue data job decrypts source objects using a wildcard KMS permission spanning unrelated client keys. Which engineering change best addresses the underlying issue?
- Locate affected source and derivative assets via lineage and apply approved deletion/retention policy.
- Scope KMS actions to intended keys and add appropriate conditions where supported.
- Apply supported column-level permissions or a governed aggregate view and deny raw salary access.
- Apply account/organization guardrails, regional resource rules and audited exception processes.
Explanation
Correct Answer
B:Scope KMS actions to intended keys and add appropriate conditions where supported. It directly addresses the case cause (Cryptographic permissions exceed the data processing task's required keys.) and should be verified by: The job decrypts authorized data but receives denial on a neighboring client's key.
Incorrect Answers
A:That change addresses a personal-data deletion request removes a row from an Athena external table view but leaves original S3 objects and downstream extracts; it would not repair this incident.
C: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.
D:That change addresses a project migrates its authoritative EU records to another AWS Region and management assumes an S3 bucket policy alone enforces future residency; it would not repair this incident.
Question 977
A Lake Formation table exposes a private salary column through a broad Athena SELECT grant when an analyst needs only aggregated headcount. Which engineering change best addresses the underlying issue?
- Apply an approved privacy design with keyed tokenization or stronger controls and threat modeling.
- Apply supported column-level permissions or a governed aggregate view and deny raw salary access.
- Grant scoped Lake Formation SELECT and required catalog permissions to the authorized principal.
- Store and rotate credentials in Secrets Manager with scoped runtime retrieval and redacted logs.
Explanation
Correct Answer
B:Apply supported column-level permissions or a governed aggregate view and deny raw salary access. It directly addresses the case cause (Data access governance does not constrain the columns needed for the approved use case.) and should be verified by: The user obtains aggregate headcount without querying raw compensation fields.
Incorrect Answers
A:That change addresses a tokenization pipeline uses a deterministic unkeyed hash on low-entropy postal identifiers and calls them irreversibly anonymous; it would not repair this incident.
C:That change addresses a Lake Formation-enabled S3 table is visible in Glue Data Catalog, but Athena SELECT is denied to the analyst role; it would not repair this incident.
D:That change addresses a pipeline sends database credentials in plaintext environment variables and writes them to CloudWatch on failure; it would not repair this incident.
Question 978
A Glue crawler in a VPC fails connection to a private RDS source even with the right IAM service role. Which technical dependency most directly explains this behavior?
- Database privilege scope exceeds the analyst's reporting purpose.
- Lake Formation grants and role identities are evaluated per workload principal.
- A service role cannot replace blocked VPC routes or security group rules.
- Low-entropy fields remain vulnerable to dictionary reversal despite hashing.
Explanation
Correct Answer
C:A service role cannot replace blocked VPC routes or security group rules. The corresponding fix is to validate Glue network connection resources, subnets, SGs and database credentials together.
Incorrect Answers
A:This diagnosis addresses another AWS case: A Redshift data analyst has a role granting broad schema CREATE and DROP despite requiring only SELECT on a few views. The dependency here is different.
B:This diagnosis addresses another AWS case: An Athena query against a Lake Formation resource succeeds for the analyst, yet a separate Glue ETL role cannot read that same table. The dependency here is different.
D:This diagnosis addresses another AWS case: A tokenization pipeline uses a deterministic unkeyed hash on low-entropy postal identifiers and calls them irreversibly anonymous. The dependency here is different.
Question 979
A table claims a `region` partition key but the written S3 paths use `geography=...`, so Athena pruning fails. Which engineering change best addresses the underlying issue?
- Migrate writers, metadata, and readers through a dual-read/reconciliation plan.
- Iterate with the supported LastEvaluatedKey mechanism and checkpoint progress.
- Align approved partition key definitions and S3 path generation or repair registered metadata.
- Grant scoped bucket permissions and necessary KMS access to the Redshift execution role.
Explanation
Correct Answer
C:Align approved partition key definitions and S3 path generation or repair registered metadata. It directly addresses the case cause (Partition metadata and physical prefix naming do not agree.) and should be verified by: Region-filtered queries prune to the expected physical prefixes.
Incorrect Answers
A:That change addresses an S3-based table changes from hourly to daily partitions while old writers still publish hourly paths, giving inconsistent query results; it would not repair this incident.
B:That change addresses a DynamoDB archival pipeline uses Scan without pagination and misses records beyond the first page; it would not repair this incident.
D:That change addresses a Redshift UNLOAD writes reporting data to an S3 bucket in another account but fails with access denied; it would not repair this incident.
Question 980
An upstream system changes a decimal field from two to four digits of precision and rounding introduces revenue drift. Which technical dependency most directly explains this behavior?
- The workflow has no buffering or explicit throughput regulation at the ingress boundary.
- The data quality contract omits numeric precision and tolerance.
- Service metrics represent different stages and may count retries or batches differently.
- The window aggregation does not specify a deterministic temporal frame.
Explanation
Correct Answer
B:The data quality contract omits numeric precision and tolerance. The corresponding fix is to use appropriate decimal types and compare reconciliation sums within approved tolerance.
Incorrect Answers
A:This diagnosis addresses another AWS case: An orchestrated data processing task receives tens of thousands of S3 events, causing Lambda reserved concurrency exhaustion. The dependency here is different.
C:This diagnosis addresses another AWS case: A CloudWatch dashboard mixes Glue processed-record counts with Kinesis PutRecords count and calls them identical pipeline throughput. The dependency here is different.
D:This diagnosis addresses another AWS case: A data science notebook uses a rolling 7-day average without ordering by event date, so results change with input row order. The dependency here is different.
AWS Certified Data Engineer - Associate DEA-C01 Practice Tests