Certified Data Engineer Associate Practice Test 21
Question 200
At a tax accounting service, bronze shipping events use mixed timezone strings and inconsistent carrier codes, making downstream shipment durations misleading. The dataset `meter_readings` is in scope, and a finance audit requires reproducible aggregated figures. Before release, which acceptance test would actually demonstrate that the root problem is controlled?
- Review a platform-level availability report for `meter_readings` without testing whether heterogeneous timestamps and code names cannot be compared or joined consistently without standardization.
- Run only a normal, unchanged `meter_readings` sample and review timestamp offsets.
- Replay two events at the same instant with different offsets and verify equal canonical time plus mapped carrier identity
- Check that the intended configuration exists for `meter_readings` and that a healthy run succeeded, without inducing the earlier failure.
Explanation
Correct Answer
C:Replay two events at the same instant with different offsets and verify equal canonical time plus mapped carrier identity. This reproduces the scenario-dependent condition, verifies timestamp offsets, normalized UTC values, reference lookups, and rejected code counts, and directly tests whether heterogeneous timestamps and code names cannot be compared or joined consistently without standardization is resolved. Observed results, not intent, determine approval.
Incorrect Answers
A:Review a platform-level availability report for `meter_readings` without testing whether heterogeneous timestamps and code names cannot be compared or joined consistently without standardization. Aggregate availability does not establish the behavior of affected `meter_readings` records. It cannot replace the direct exercise: replay two events at the same instant with different offsets and verify equal canonical time plus mapped carrier identity.
B:Run only a normal, unchanged `meter_readings` sample and review timestamp offsets. A normal sample does not challenge heterogeneous timestamps and code names cannot be compared or joined consistently without standardization.
D:Check that the intended configuration exists for `meter_readings` and that a healthy run succeeded, without inducing the earlier failure. Installed configuration and a healthy run are insufficient to prove the failure mode is gone. The original issue was heterogeneous timestamps and code names cannot be compared or joined consistently without standardization.
Question 201
At a telecom operations group, bronze orders arrive with currency totals as strings and null order dates, producing incorrect daily financial summaries. The dataset `device_health` is in scope, and the release must preserve the original source evidence. What evidence should the engineer collect to establish the cause rather than a coincidental symptom?
- Review completed run status and aggregate cluster health without record-level correlation
- Inspect normal-period success metrics for the stated dataset without reproducing the source error
- Compare the current configuration and the signed change approval, without source-row evidence
- Correlate source field types, invalid-row sample across affected and unaffected `R034-CASE-041` runs.
Explanation
Correct Answer
D:Correlate source field types, invalid-row sample across affected and unaffected `R034-CASE-041` runs.. By joining source field types, invalid-row sample, cast success count, and silver numeric reconciliation across the affected and unaffected conditions, the investigation directly tests the recorded mechanism: string amounts can aggregate incorrectly and missing business dates are not safe grouping keys. It also sets a measurable baseline for load zero, null and malformed amounts, then reconcile silver totals and quarantined rejects to bronze input.
Incorrect Answers
A:Review completed run status and aggregate cluster health without record-level correlation. A successful aggregate platform state can coexist with string amounts can aggregate incorrectly and missing business dates are not safe grouping keys. This check never observes the affected `device_health` records or their causal path.
B:Inspect normal-period success metrics for the stated dataset without reproducing the source error. A healthy-run trend can be useful, but it does not expose string amounts can aggregate incorrectly and missing business dates are not safe grouping keys. The failing-path source field types, invalid-row sample, cast success count, and silver numeric reconciliation has to be correlated before attributing cause.
C:Compare the current configuration and the signed change approval, without source-row evidence. A desired configuration and approval ticket are not runtime proof. In this case they omit source field types, invalid-row sample, cast success count, and silver numeric reconciliation, the direct means of distinguishing string amounts can aggregate incorrectly and missing business dates are not safe grouping keys.
Question 202
At a telecom operations group, bronze orders arrive with currency totals as strings and null order dates, producing incorrect daily financial summaries. The dataset `device_health` is in scope, and the release must preserve the original source evidence. Which platform configuration or data-engineering change is most defensible?
- Replace every missing date with today without provenance; use that approach for `device_health`.
- Validate and cast amounts to a numeric type, quarantine invalid dates, and write typed clean records to a silver Delta table
- Aggregate the raw string amount without conversion and skip null checks; use that approach for `device_health`.
- Overwrite the original bronze payload with only accepted rows; use that approach for `device_health`.
Explanation
Correct Answer
B:Validate and cast amounts to a numeric type, quarantine invalid dates, and write typed clean records to a silver Delta table. This directly addresses string amounts can aggregate incorrectly and missing business dates are not safe grouping keys. The design should be accepted only after load zero, null and malformed amounts, then reconcile silver totals and quarantined rejects to bronze input; the related operational boundary is to preserve immutable raw events but enforce typed, validated silver records for consumption.
Incorrect Answers
A:Replace every missing date with today without provenance; use that approach for `device_health`. Inventing transaction dates changes business facts and misstates historical revenue. For `device_health`, this cannot remove the causal limitation: string amounts can aggregate incorrectly and missing business dates are not safe grouping keys.
C:Aggregate the raw string amount without conversion and skip null checks; use that approach for `device_health`. String comparison or implicit casts can corrupt arithmetic and let invalid dates pass. For `device_health`, this cannot remove the causal limitation: string amounts can aggregate incorrectly and missing business dates are not safe grouping keys.
D:Overwrite the original bronze payload with only accepted rows; use that approach for `device_health`. Destructive cleaning loses the raw evidence needed to replay and audit rejected records. For `device_health`, this cannot remove the causal limitation: string amounts can aggregate incorrectly and missing business dates are not safe grouping keys.
Question 203
At a telecom operations group, bronze orders arrive with currency totals as strings and null order dates, producing incorrect daily financial summaries. The dataset `device_health` is in scope, and the release must preserve the original source evidence. A teammate proposes: "Replace every missing date with today without provenance." Which technical limitation is the decisive reason not to approve that specific proposal?
- Destructive cleaning loses the raw evidence needed to replay and audit rejected records. This would apply to an alternative change for `device_health`.
- String comparison or implicit casts can corrupt arithmetic and let invalid dates pass. This would apply to another option for `device_health`.
- The dashboard cached the prior result; no DataFrame operation or underlying data requires correction.
- Inventing transaction dates changes business facts and misstates historical revenue. The proposal does not repair `device_health`.
Explanation
Correct Answer
D:Inventing transaction dates changes business facts and misstates historical revenue. The proposal does not repair `device_health`. This identifies the known limitation of the exact proposed action. Inventing transaction dates changes business facts and misstates historical revenue. The underlying problem remains string amounts can aggregate incorrectly and missing business dates are not safe grouping keys; Validate and cast amounts to a numeric type, quarantine invalid dates, and write typed clean records to a silver Delta table instead targets that failure.
Incorrect Answers
A:Destructive cleaning loses the raw evidence needed to replay and audit rejected records. This would apply to an alternative change for `device_health`. This failure applies to the separate proposal "Overwrite the original bronze payload with only accepted rows".
B:String comparison or implicit casts can corrupt arithmetic and let invalid dates pass. This would apply to another option for `device_health`. This limitation belongs to the different alternative "Aggregate the raw string amount without conversion and skip null checks". The stem calls for the specific failure of "Replace every missing date with today without provenance".
C:The dashboard cached the prior result; no DataFrame operation or underlying data requires correction. The case provides a concrete failing data or control path; a mere alternate theory does not address string amounts can aggregate incorrectly and missing business dates are not safe grouping keys.
Question 204
At a telecom operations group, bronze orders arrive with currency totals as strings and null order dates, producing incorrect daily financial summaries. The dataset `device_health` is in scope, and the release must preserve the original source evidence. What risk-and-cost compromise should the owner accept instead of the proposed shortcuts?
- Aggregate the raw string amount without conversion and skip null checks
- Overwrite the original bronze payload with only accepted rows
- Replace every missing date with today without provenance
- Preserve immutable raw events but enforce typed, validated silver records for consumption
Explanation
Correct Answer
D:Preserve immutable raw events but enforce typed, validated silver records for consumption. This explicitly bounds the compromise while still addressing string amounts can aggregate incorrectly and missing business dates are not safe grouping keys. Acceptance relies on load zero, null and malformed amounts, then reconcile silver totals and quarantined rejects to bronze input rather than simply declaring the change complete.
Incorrect Answers
A:Aggregate the raw string amount without conversion and skip null checks. String comparison or implicit casts can corrupt arithmetic and let invalid dates pass. Monitoring after deployment does not make this approach a safe bounded tradeoff for `device_health`.
B:Overwrite the original bronze payload with only accepted rows. Destructive cleaning loses the raw evidence needed to replay and audit rejected records. Monitoring after deployment does not make this approach a safe bounded tradeoff for `device_health`.
C:Replace every missing date with today without provenance. Inventing transaction dates changes business facts and misstates historical revenue. Monitoring after deployment does not make this approach a safe bounded tradeoff for `device_health`.
Question 205
At a telecom operations group, bronze orders arrive with currency totals as strings and null order dates, producing incorrect daily financial summaries. The dataset `device_health` is in scope, and the release must preserve the original source evidence. Which direct test could falsify the proposed fix instead of only confirming deployment?
- Check that the intended configuration exists for `device_health` and that a healthy run succeeded, without inducing the earlier failure.
- Load zero, null and malformed amounts, then reconcile silver totals and quarantined rejects to bronze input
- Run only a normal, unchanged `device_health` sample and review source field types.
- Review a platform-level availability report for `device_health` without testing whether string amounts can aggregate incorrectly and missing business dates are not safe grouping keys.
Explanation
Correct Answer
B:Load zero, null and malformed amounts, then reconcile silver totals and quarantined rejects to bronze input. This reproduces the scenario-dependent condition, verifies source field types, invalid-row sample, cast success count, and silver numeric reconciliation, and directly tests whether string amounts can aggregate incorrectly and missing business dates are not safe grouping keys is resolved. Observed results, not intent, determine approval.
Incorrect Answers
A:Check that the intended configuration exists for `device_health` and that a healthy run succeeded, without inducing the earlier failure. Installed configuration and a healthy run are insufficient to prove the failure mode is gone. The original issue was string amounts can aggregate incorrectly and missing business dates are not safe grouping keys.
C:Run only a normal, unchanged `device_health` sample and review source field types. A normal sample does not challenge string amounts can aggregate incorrectly and missing business dates are not safe grouping keys.
D:Review a platform-level availability report for `device_health` without testing whether string amounts can aggregate incorrectly and missing business dates are not safe grouping keys. Aggregate availability does not establish the behavior of affected `device_health` records. It cannot replace the direct exercise: load zero, null and malformed amounts, then reconcile silver totals and quarantined rejects to bronze input.
Question 206
At a city utilities office, bronze shipping events use mixed timezone strings and inconsistent carrier codes, making downstream shipment durations misleading. The dataset `booking_changes` is in scope, and a finance audit requires reproducible aggregated figures. Which correlated observation is the strongest basis for the change decision?
- Examine only a normal successful run of `booking_changes` and trend timestamp offsets without recreating the fault.
- Correlate timestamp offsets, normalized UTC values across affected and unaffected `R034-CASE-042` runs.
- Compare the saved configuration with the signed change ticket for `booking_changes` while omitting source and output records.
- Review aggregate cluster availability and job completion for `booking_changes` without correlating the observed error path.
Explanation
Correct Answer
B:Correlate timestamp offsets, normalized UTC values across affected and unaffected `R034-CASE-042` runs.. By joining timestamp offsets, normalized UTC values, reference lookups, and rejected code counts across the affected and unaffected conditions, the investigation directly tests the recorded mechanism: heterogeneous timestamps and code names cannot be compared or joined consistently without standardization. It also sets a measurable baseline for replay two events at the same instant with different offsets and verify equal canonical time plus mapped carrier identity.
Incorrect Answers
A:Examine only a normal successful run of `booking_changes` and trend timestamp offsets without recreating the fault. A healthy-run trend can be useful, but it does not expose heterogeneous timestamps and code names cannot be compared or joined consistently without standardization. The failing-path timestamp offsets, normalized UTC values, reference lookups, and rejected code counts has to be correlated before attributing cause.
C:Compare the saved configuration with the signed change ticket for `booking_changes` while omitting source and output records. A desired configuration and approval ticket are not runtime proof. In this case they omit timestamp offsets, normalized UTC values, reference lookups, and rejected code counts, the direct means of distinguishing heterogeneous timestamps and code names cannot be compared or joined consistently without standardization.
D:Review aggregate cluster availability and job completion for `booking_changes` without correlating the observed error path. A successful aggregate platform state can coexist with heterogeneous timestamps and code names cannot be compared or joined consistently without standardization. This check never observes the affected `booking_changes` records or their causal path.
Question 207
At a city utilities office, bronze shipping events use mixed timezone strings and inconsistent carrier codes, making downstream shipment durations misleading. The dataset `booking_changes` is in scope, and a finance audit requires reproducible aggregated figures. What implementation should the engineer select for the failing workflow?
- Strip the timezone suffix and compare all timestamps as local wall-clock time; use that approach for `booking_changes`.
- Normalize timestamps to a documented timezone and map carrier codes through a validated reference table before silver writes
- Group the unnormalized carrier strings as distinct carriers; use that approach for `booking_changes`.
- Set all invalid carrier codes to the most common valid carrier; use that approach for `booking_changes`.
Explanation
Correct Answer
B:Normalize timestamps to a documented timezone and map carrier codes through a validated reference table before silver writes. This directly addresses heterogeneous timestamps and code names cannot be compared or joined consistently without standardization. The design should be accepted only after replay two events at the same instant with different offsets and verify equal canonical time plus mapped carrier identity; the related operational boundary is to permit auditable quarantine for unknown codes rather than introducing fabricated mappings.
Incorrect Answers
A:Strip the timezone suffix and compare all timestamps as local wall-clock time; use that approach for `booking_changes`. Removing offsets can reorder events across sites and distort elapsed time. For `booking_changes`, this cannot remove the causal limitation: heterogeneous timestamps and code names cannot be compared or joined consistently without standardization.
C:Group the unnormalized carrier strings as distinct carriers; use that approach for `booking_changes`. Aliases create duplicate carrier categories instead of one standardized code. For `booking_changes`, this cannot remove the causal limitation: heterogeneous timestamps and code names cannot be compared or joined consistently without standardization.
D:Set all invalid carrier codes to the most common valid carrier; use that approach for `booking_changes`. Guessing categorical values silently changes real shipment ownership. For `booking_changes`, this cannot remove the causal limitation: heterogeneous timestamps and code names cannot be compared or joined consistently without standardization.
Question 208
At a city utilities office, bronze shipping events use mixed timezone strings and inconsistent carrier codes, making downstream shipment durations misleading. The dataset `booking_changes` is in scope, and a finance audit requires reproducible aggregated figures. A teammate proposes: "Strip the timezone suffix and compare all timestamps as local wall-clock time." Which technical limitation is the decisive reason not to approve that specific proposal?
- Aliases create duplicate carrier categories instead of one standardized code. This would apply to an alternative change for `booking_changes`.
- Guessing categorical values silently changes real shipment ownership. This would apply to another option for `booking_changes`.
- Removing offsets can reorder events across sites and distort elapsed time. The proposal does not repair `booking_changes`.
- The dashboard cached the prior result; no DataFrame operation or underlying data requires correction.
Explanation
Correct Answer
C:Removing offsets can reorder events across sites and distort elapsed time. The proposal does not repair `booking_changes`. This identifies the known limitation of the exact proposed action. Removing offsets can reorder events across sites and distort elapsed time. The underlying problem remains heterogeneous timestamps and code names cannot be compared or joined consistently without standardization; Normalize timestamps to a documented timezone and map carrier codes through a validated reference table before silver writes instead targets that failure.
Incorrect Answers
A:Aliases create duplicate carrier categories instead of one standardized code. This would apply to an alternative change for `booking_changes`. This failure applies to the separate proposal "Group the unnormalized carrier strings as distinct carriers".
B:Guessing categorical values silently changes real shipment ownership. This would apply to another option for `booking_changes`. This limitation belongs to the different alternative "Set all invalid carrier codes to the most common valid carrier". The stem calls for the specific failure of "Strip the timezone suffix and compare all timestamps as local wall-clock time".
D:The dashboard cached the prior result; no DataFrame operation or underlying data requires correction. The case provides a concrete failing data or control path; a mere alternate theory does not address heterogeneous timestamps and code names cannot be compared or joined consistently without standardization.
Question 209
At a city utilities office, bronze shipping events use mixed timezone strings and inconsistent carrier codes, making downstream shipment durations misleading. The dataset `booking_changes` is in scope, and a finance audit requires reproducible aggregated figures. Which decision preserves the stated data contract while keeping the change scope proportionate?
- Permit auditable quarantine for unknown codes rather than introducing fabricated mappings
- Group the unnormalized carrier strings as distinct carriers; monitor results only after launch of `booking_changes`.
- Set all invalid carrier codes to the most common valid carrier; monitor results only after launch of `booking_changes`.
- Strip the timezone suffix and compare all timestamps as local wall-clock time; monitor results only after launch of `booking_changes`.
Explanation
Correct Answer
A:Permit auditable quarantine for unknown codes rather than introducing fabricated mappings. This explicitly bounds the compromise while still addressing heterogeneous timestamps and code names cannot be compared or joined consistently without standardization. Acceptance relies on replay two events at the same instant with different offsets and verify equal canonical time plus mapped carrier identity rather than simply declaring the change complete.
Incorrect Answers
B:Group the unnormalized carrier strings as distinct carriers; monitor results only after launch of `booking_changes`. Aliases create duplicate carrier categories instead of one standardized code. Monitoring after deployment does not make this approach a safe bounded tradeoff for `booking_changes`.
C:Set all invalid carrier codes to the most common valid carrier; monitor results only after launch of `booking_changes`. Guessing categorical values silently changes real shipment ownership. Monitoring after deployment does not make this approach a safe bounded tradeoff for `booking_changes`.
D:Strip the timezone suffix and compare all timestamps as local wall-clock time; monitor results only after launch of `booking_changes`. Removing offsets can reorder events across sites and distort elapsed time. Monitoring after deployment does not make this approach a safe bounded tradeoff for `booking_changes`.
Question 210
At a city utilities office, bronze shipping events use mixed timezone strings and inconsistent carrier codes, making downstream shipment durations misleading. The dataset `booking_changes` is in scope, and a finance audit requires reproducible aggregated figures. What verification provides evidence of correct behavior under the original adverse condition?
- Check that the intended configuration exists for `booking_changes` and that a healthy run succeeded, without inducing the earlier failure.
- Run only a normal, unchanged `booking_changes` sample and review timestamp offsets.
- Replay two events at the same instant with different offsets and verify equal canonical time plus mapped carrier identity
- Review a platform-level availability report for `booking_changes` without testing whether heterogeneous timestamps and code names cannot be compared or joined consistently without standardization.
Explanation
Correct Answer
C:Replay two events at the same instant with different offsets and verify equal canonical time plus mapped carrier identity. This reproduces the scenario-dependent condition, verifies timestamp offsets, normalized UTC values, reference lookups, and rejected code counts, and directly tests whether heterogeneous timestamps and code names cannot be compared or joined consistently without standardization is resolved. Observed results, not intent, determine approval.
Incorrect Answers
A:Check that the intended configuration exists for `booking_changes` and that a healthy run succeeded, without inducing the earlier failure. Installed configuration and a healthy run are insufficient to prove the failure mode is gone. The original issue was heterogeneous timestamps and code names cannot be compared or joined consistently without standardization.
B:Run only a normal, unchanged `booking_changes` sample and review timestamp offsets. A normal sample does not challenge heterogeneous timestamps and code names cannot be compared or joined consistently without standardization.
D:Review a platform-level availability report for `booking_changes` without testing whether heterogeneous timestamps and code names cannot be compared or joined consistently without standardization. Aggregate availability does not establish the behavior of affected `booking_changes` records. It cannot replace the direct exercise: replay two events at the same instant with different offsets and verify equal canonical time plus mapped carrier identity.