Certified Data Engineer Associate Practice Test 19
Question 180
At a hospital analytics group, semi-structured sensor payloads add optional nested attributes that vary by device firmware. The dataset `shipment_status` is in scope, and the target must retain every valid late-arriving event. Before release, which acceptance test would actually demonstrate that the root problem is controlled?
- Review a platform-level availability report for `shipment_status` without testing whether premature rigid flattening loses attributes that are absent or newly introduced in some firmware versions.
- Replay two firmware versions with different optional fields and check bronze fidelity plus silver validation
- Run only a normal, unchanged `shipment_status` sample and review firmware variant.
- Check that the intended configuration exists for `shipment_status` and that a healthy run succeeded, without inducing the earlier failure.
Explanation
Correct Answer
B:Replay two firmware versions with different optional fields and check bronze fidelity plus silver validation. This reproduces the scenario-dependent condition, verifies firmware variant, rescued/optional nested paths, parse error counts, and downstream schema conformance, and directly tests whether premature rigid flattening loses attributes that are absent or newly introduced in some firmware versions is resolved. Observed results, not intent, determine approval.
Incorrect Answers
A:Review a platform-level availability report for `shipment_status` without testing whether premature rigid flattening loses attributes that are absent or newly introduced in some firmware versions. Aggregate availability does not establish the behavior of affected `shipment_status` records. It cannot replace the direct exercise: replay two firmware versions with different optional fields and check bronze fidelity plus silver validation.
C:Run only a normal, unchanged `shipment_status` sample and review firmware variant. A normal sample does not challenge premature rigid flattening loses attributes that are absent or newly introduced in some firmware versions.
D:Check that the intended configuration exists for `shipment_status` 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 premature rigid flattening loses attributes that are absent or newly introduced in some firmware versions.
Question 181
At a consumer-lending business, e-commerce events contain an array of purchased items, but the reporting table stores the array as a raw opaque string. The dataset `image_metadata` is in scope, and an interrupted delivery must be recoverable without data loss. What evidence should the engineer collect to establish the cause rather than a coincidental symptom?
- Compare the current configuration and the signed change approval, without source-row evidence
- Correlate nested array length, event count across affected and unaffected `R034-CASE-037` runs.
- Review completed run status and aggregate cluster health without record-level correlation
- Examine only a normal successful run of `image_metadata` and trend nested array length without recreating the fault.
Explanation
Correct Answer
B:Correlate nested array length, event count across affected and unaffected `R034-CASE-037` runs.. By joining nested array length, event count, exploded item count, and item-level schema across the affected and unaffected conditions, the investigation directly tests the recorded mechanism: an array-valued field is not automatically one row per element in the relational reporting model. It also sets a measurable baseline for ingest an order with three line items and assert exactly three correctly associated silver item rows.
Incorrect Answers
A: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 nested array length, event count, exploded item count, and item-level schema, the direct means of distinguishing an array-valued field is not automatically one row per element in the relational reporting model.
C:Review completed run status and aggregate cluster health without record-level correlation. A successful aggregate platform state can coexist with an array-valued field is not automatically one row per element in the relational reporting model. This check never observes the affected `image_metadata` records or their causal path.
D:Examine only a normal successful run of `image_metadata` and trend nested array length without recreating the fault. A healthy-run trend can be useful, but it does not expose an array-valued field is not automatically one row per element in the relational reporting model. The failing-path nested array length, event count, exploded item count, and item-level schema has to be correlated before attributing cause.
Question 182
At a consumer-lending business, e-commerce events contain an array of purchased items, but the reporting table stores the array as a raw opaque string. The dataset `image_metadata` is in scope, and an interrupted delivery must be recoverable without data loss. Which platform configuration or data-engineering change is most defensible?
- Apply a top-level COUNT to JSON event rows and call it an item count; use that approach for `image_metadata`.
- Discard the nested item array and keep only the event identifier; use that approach for `image_metadata`.
- Preserve nested JSON in bronze and use explode on the item array when producing one silver row per purchased item
- Split the raw JSON string at every comma to create item records; use that approach for `image_metadata`.
Explanation
Correct Answer
C:Preserve nested JSON in bronze and use explode on the item array when producing one silver row per purchased item. This directly addresses an array-valued field is not automatically one row per element in the relational reporting model. The design should be accepted only after ingest an order with three line items and assert exactly three correctly associated silver item rows; the related operational boundary is to retain original nested payload for audit while normalizing item-level silver records.
Incorrect Answers
A:Apply a top-level COUNT to JSON event rows and call it an item count; use that approach for `image_metadata`. Counting event rows ignores multiple items embedded in one event. For `image_metadata`, this cannot remove the causal limitation: an array-valued field is not automatically one row per element in the relational reporting model.
B:Discard the nested item array and keep only the event identifier; use that approach for `image_metadata`. Dropping the array removes the item-level facts required downstream. For `image_metadata`, this cannot remove the causal limitation: an array-valued field is not automatically one row per element in the relational reporting model.
D:Split the raw JSON string at every comma to create item records; use that approach for `image_metadata`. String splitting breaks escaped strings and nested JSON structures. For `image_metadata`, this cannot remove the causal limitation: an array-valued field is not automatically one row per element in the relational reporting model.
Question 183
At a consumer-lending business, e-commerce events contain an array of purchased items, but the reporting table stores the array as a raw opaque string. The dataset `image_metadata` is in scope, and an interrupted delivery must be recoverable without data loss. A teammate proposes: "Apply a top-level COUNT to JSON event rows and call it an item count." Which technical limitation is the decisive reason not to approve that specific proposal?
- Counting event rows ignores multiple items embedded in one event. The proposal does not repair `image_metadata`.
- Insufficient executor memory is the primary fault; source-file handling and ingestion checkpoints are correct.
- String splitting breaks escaped strings and nested JSON structures. This would apply to an alternative change for `image_metadata`.
- Dropping the array removes the item-level facts required downstream. This would apply to another option for `image_metadata`.
Explanation
Correct Answer
A:Counting event rows ignores multiple items embedded in one event. The proposal does not repair `image_metadata`. This identifies the known limitation of the exact proposed action. Counting event rows ignores multiple items embedded in one event. The underlying problem remains an array-valued field is not automatically one row per element in the relational reporting model; Preserve nested JSON in bronze and use explode on the item array when producing one silver row per purchased item instead targets that failure.
Incorrect Answers
B:Insufficient executor memory is the primary fault; source-file handling and ingestion checkpoints are correct. The case provides a concrete failing data or control path; a mere alternate theory does not address an array-valued field is not automatically one row per element in the relational reporting model.
C:String splitting breaks escaped strings and nested JSON structures. This would apply to an alternative change for `image_metadata`. This failure applies to the separate proposal "Split the raw JSON string at every comma to create item records".
D:Dropping the array removes the item-level facts required downstream. This would apply to another option for `image_metadata`. This limitation belongs to the different alternative "Discard the nested item array and keep only the event identifier". The stem calls for the specific failure of "Apply a top-level COUNT to JSON event rows and call it an item count".
Question 184
At a consumer-lending business, e-commerce events contain an array of purchased items, but the reporting table stores the array as a raw opaque string. The dataset `image_metadata` is in scope, and an interrupted delivery must be recoverable without data loss. What risk-and-cost compromise should the owner accept instead of the proposed shortcuts?
- Discard the nested item array and keep only the event identifier
- Split the raw JSON string at every comma to create item records
- Apply a top-level COUNT to JSON event rows and call it an item count; monitor results only after launch of `image_metadata`.
- Retain original nested payload for audit while normalizing item-level silver records
Explanation
Correct Answer
D:Retain original nested payload for audit while normalizing item-level silver records. This explicitly bounds the compromise while still addressing an array-valued field is not automatically one row per element in the relational reporting model. Acceptance relies on ingest an order with three line items and assert exactly three correctly associated silver item rows rather than simply declaring the change complete.
Incorrect Answers
A:Discard the nested item array and keep only the event identifier. Dropping the array removes the item-level facts required downstream. Monitoring after deployment does not make this approach a safe bounded tradeoff for `image_metadata`.
B:Split the raw JSON string at every comma to create item records. String splitting breaks escaped strings and nested JSON structures. Monitoring after deployment does not make this approach a safe bounded tradeoff for `image_metadata`.
C:Apply a top-level COUNT to JSON event rows and call it an item count; monitor results only after launch of `image_metadata`. Counting event rows ignores multiple items embedded in one event. Monitoring after deployment does not make this approach a safe bounded tradeoff for `image_metadata`.
Question 185
At a consumer-lending business, e-commerce events contain an array of purchased items, but the reporting table stores the array as a raw opaque string. The dataset `image_metadata` is in scope, and an interrupted delivery must be recoverable without data loss. Which direct test could falsify the proposed fix instead of only confirming deployment?
- Review a platform-level availability report for `image_metadata` without testing whether an array-valued field is not automatically one row per element in the relational reporting model.
- Ingest an order with three line items and assert exactly three correctly associated silver item rows
- Check that the intended configuration exists for `image_metadata` and that a healthy run succeeded, without inducing the earlier failure.
- Run only a normal, unchanged `image_metadata` sample and review nested array length.
Explanation
Correct Answer
B:Ingest an order with three line items and assert exactly three correctly associated silver item rows. This reproduces the scenario-dependent condition, verifies nested array length, event count, exploded item count, and item-level schema, and directly tests whether an array-valued field is not automatically one row per element in the relational reporting model is resolved. Observed results, not intent, determine approval.
Incorrect Answers
A:Review a platform-level availability report for `image_metadata` without testing whether an array-valued field is not automatically one row per element in the relational reporting model. Aggregate availability does not establish the behavior of affected `image_metadata` records. It cannot replace the direct exercise: ingest an order with three line items and assert exactly three correctly associated silver item rows.
C:Check that the intended configuration exists for `image_metadata` 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 an array-valued field is not automatically one row per element in the relational reporting model.
D:Run only a normal, unchanged `image_metadata` sample and review nested array length. A normal sample does not challenge an array-valued field is not automatically one row per element in the relational reporting model.
Question 186
At a wholesale pharmacy group, semi-structured sensor payloads add optional nested attributes that vary by device firmware. The dataset `route_updates` is in scope, and the target must retain every valid late-arriving event. Which correlated observation is the strongest basis for the change decision?
- Inspect normal-period success metrics for the stated dataset without reproducing the source error
- Review completed run status and aggregate cluster health without record-level correlation
- Compare the current configuration and the signed change approval, without source-row evidence
- Correlate firmware variant, rescued/optional nested paths across affected and unaffected `R034-CASE-038` runs.
Explanation
Correct Answer
D:Correlate firmware variant, rescued/optional nested paths across affected and unaffected `R034-CASE-038` runs.. By joining firmware variant, rescued/optional nested paths, parse error counts, and downstream schema conformance across the affected and unaffected conditions, the investigation directly tests the recorded mechanism: premature rigid flattening loses attributes that are absent or newly introduced in some firmware versions. It also sets a measurable baseline for replay two firmware versions with different optional fields and check bronze fidelity plus silver validation.
Incorrect Answers
A: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 premature rigid flattening loses attributes that are absent or newly introduced in some firmware versions. The failing-path firmware variant, rescued/optional nested paths, parse error counts, and downstream schema conformance has to be correlated before attributing cause.
B:Review completed run status and aggregate cluster health without record-level correlation. A successful aggregate platform state can coexist with premature rigid flattening loses attributes that are absent or newly introduced in some firmware versions. This check never observes the affected `route_updates` records or their causal path.
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 firmware variant, rescued/optional nested paths, parse error counts, and downstream schema conformance, the direct means of distinguishing premature rigid flattening loses attributes that are absent or newly introduced in some firmware versions.
Question 187
At a wholesale pharmacy group, semi-structured sensor payloads add optional nested attributes that vary by device firmware. The dataset `route_updates` is in scope, and the target must retain every valid late-arriving event. What implementation should the engineer select for the failing workflow?
- Store JSON in user workspace files without Unity Catalog metadata; use that approach for `route_updates`.
- Cast the entire JSON object to a single numeric column; use that approach for `route_updates`.
- Land the raw nested payload in a governed Delta bronze table and selectively project validated nested fields into silver
- Reject every payload without all optional fields; use that approach for `route_updates`.
Explanation
Correct Answer
C:Land the raw nested payload in a governed Delta bronze table and selectively project validated nested fields into silver. This directly addresses premature rigid flattening loses attributes that are absent or newly introduced in some firmware versions. The design should be accepted only after replay two firmware versions with different optional fields and check bronze fidelity plus silver validation; the related operational boundary is to allow flexible bronze ingestion while enforcing stable downstream typed attributes.
Incorrect Answers
A:Store JSON in user workspace files without Unity Catalog metadata; use that approach for `route_updates`. Ungoverned workspace copies bypass the required catalog access boundary. For `route_updates`, this cannot remove the causal limitation: premature rigid flattening loses attributes that are absent or newly introduced in some firmware versions.
B:Cast the entire JSON object to a single numeric column; use that approach for `route_updates`. A nested structure cannot be represented as one numeric measurement. For `route_updates`, this cannot remove the causal limitation: premature rigid flattening loses attributes that are absent or newly introduced in some firmware versions.
D:Reject every payload without all optional fields; use that approach for `route_updates`. Optional fields should not cause the whole valid device event to be dropped. For `route_updates`, this cannot remove the causal limitation: premature rigid flattening loses attributes that are absent or newly introduced in some firmware versions.
Question 188
At a wholesale pharmacy group, semi-structured sensor payloads add optional nested attributes that vary by device firmware. The dataset `route_updates` is in scope, and the target must retain every valid late-arriving event. A teammate proposes: "Store JSON in user workspace files without Unity Catalog metadata." Which technical limitation is the decisive reason not to approve that specific proposal?
- Insufficient executor memory is the primary fault; source-file handling and ingestion checkpoints are correct.
- Optional fields should not cause the whole valid device event to be dropped. This would apply to an alternative change for `route_updates`.
- A nested structure cannot be represented as one numeric measurement. This would apply to another option for `route_updates`.
- Ungoverned workspace copies bypass the required catalog access boundary. The proposal does not repair `route_updates`.
Explanation
Correct Answer
D:Ungoverned workspace copies bypass the required catalog access boundary. The proposal does not repair `route_updates`. This identifies the known limitation of the exact proposed action. Ungoverned workspace copies bypass the required catalog access boundary. The underlying problem remains premature rigid flattening loses attributes that are absent or newly introduced in some firmware versions; Land the raw nested payload in a governed Delta bronze table and selectively project validated nested fields into silver instead targets that failure.
Incorrect Answers
A:Insufficient executor memory is the primary fault; source-file handling and ingestion checkpoints are correct. The case provides a concrete failing data or control path; a mere alternate theory does not address premature rigid flattening loses attributes that are absent or newly introduced in some firmware versions.
B:Optional fields should not cause the whole valid device event to be dropped. This would apply to an alternative change for `route_updates`. This failure applies to the separate proposal "Reject every payload without all optional fields".
C:A nested structure cannot be represented as one numeric measurement. This would apply to another option for `route_updates`. This limitation belongs to the different alternative "Cast the entire JSON object to a single numeric column". The stem calls for the specific failure of "Store JSON in user workspace files without Unity Catalog metadata".
Question 189
At a wholesale pharmacy group, semi-structured sensor payloads add optional nested attributes that vary by device firmware. The dataset `route_updates` is in scope, and the target must retain every valid late-arriving event. Which decision preserves the stated data contract while keeping the change scope proportionate?
- Store JSON in user workspace files without Unity Catalog metadata
- Allow flexible bronze ingestion while enforcing stable downstream typed attributes
- Reject every payload without all optional fields
- Cast the entire JSON object to a single numeric column
Explanation
Correct Answer
B:Allow flexible bronze ingestion while enforcing stable downstream typed attributes. This explicitly bounds the compromise while still addressing premature rigid flattening loses attributes that are absent or newly introduced in some firmware versions. Acceptance relies on replay two firmware versions with different optional fields and check bronze fidelity plus silver validation rather than simply declaring the change complete.
Incorrect Answers
A:Store JSON in user workspace files without Unity Catalog metadata. Ungoverned workspace copies bypass the required catalog access boundary. Monitoring after deployment does not make this approach a safe bounded tradeoff for `route_updates`.
C:Reject every payload without all optional fields. Optional fields should not cause the whole valid device event to be dropped. Monitoring after deployment does not make this approach a safe bounded tradeoff for `route_updates`.
D:Cast the entire JSON object to a single numeric column. A nested structure cannot be represented as one numeric measurement. Monitoring after deployment does not make this approach a safe bounded tradeoff for `route_updates`.
Question 190
At a wholesale pharmacy group, semi-structured sensor payloads add optional nested attributes that vary by device firmware. The dataset `route_updates` is in scope, and the target must retain every valid late-arriving event. What verification provides evidence of correct behavior under the original adverse condition?
- Check that the intended configuration exists for `route_updates` and that a healthy run succeeded, without inducing the earlier failure.
- Review a platform-level availability report for `route_updates` without testing whether premature rigid flattening loses attributes that are absent or newly introduced in some firmware versions.
- Run only a normal, unchanged `route_updates` sample and review firmware variant.
- Replay two firmware versions with different optional fields and check bronze fidelity plus silver validation
Explanation
Correct Answer
D:Replay two firmware versions with different optional fields and check bronze fidelity plus silver validation. This reproduces the scenario-dependent condition, verifies firmware variant, rescued/optional nested paths, parse error counts, and downstream schema conformance, and directly tests whether premature rigid flattening loses attributes that are absent or newly introduced in some firmware versions is resolved. Observed results, not intent, determine approval.
Incorrect Answers
A:Check that the intended configuration exists for `route_updates` 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 premature rigid flattening loses attributes that are absent or newly introduced in some firmware versions.
B:Review a platform-level availability report for `route_updates` without testing whether premature rigid flattening loses attributes that are absent or newly introduced in some firmware versions. Aggregate availability does not establish the behavior of affected `route_updates` records. It cannot replace the direct exercise: replay two firmware versions with different optional fields and check bronze fidelity plus silver validation.
C:Run only a normal, unchanged `route_updates` sample and review firmware variant. A normal sample does not challenge premature rigid flattening loses attributes that are absent or newly introduced in some firmware versions.