Certified Data Engineer Associate Practice Test 69
Question 680
At a regional banking group, several catalogs contain newly created SSN columns, and manually attaching masks table by table leaves sensitive columns uncovered. The dataset `patient_visits` is in scope, and effective access must follow least privilege. Before release, which acceptance test would actually demonstrate that the root problem is controlled?
- Check that the intended configuration exists for `patient_visits` and that a healthy run succeeded, without inducing the earlier failure.
- Review a platform-level availability report for `patient_visits` without testing whether per-table discretionary masking is hard to apply consistently as new tagged columns arrive.
- Run only a normal, unchanged `patient_visits` sample and review governed tag assignments.
- Create a newly tagged SSN column in scope and confirm the central policy masks it for unauthorized users
Explanation
Correct Answer
D:Create a newly tagged SSN column in scope and confirm the central policy masks it for unauthorized users. This reproduces the scenario-dependent condition, verifies governed tag assignments, ABAC policy scope, runtime support, and masked query results by user, and directly tests whether per-table discretionary masking is hard to apply consistently as new tagged columns arrive is resolved. Observed results, not intent, determine approval.
Incorrect Answers
A:Check that the intended configuration exists for `patient_visits` 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 per-table discretionary masking is hard to apply consistently as new tagged columns arrive.
B:Review a platform-level availability report for `patient_visits` without testing whether per-table discretionary masking is hard to apply consistently as new tagged columns arrive. Aggregate availability does not establish the behavior of affected `patient_visits` records. It cannot replace the direct exercise: create a newly tagged SSN column in scope and confirm the central policy masks it for unauthorized users.
C:Run only a normal, unchanged `patient_visits` sample and review governed tag assignments. A normal sample does not challenge per-table discretionary masking is hard to apply consistently as new tagged columns arrive.
Question 681
At a census statistics agency, a government data lake applies a central region row filter but one new table lacks the governed region tag and is unexpectedly visible. The dataset `courier_events` is in scope, and the underlying data retention policy must be preserved. 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
- Inspect normal-period success metrics for the stated dataset without reproducing the source error
- Correlate governed tag key/value, effective policy definitions across affected and unaffected `R034-CASE-137` runs.
- Review completed run status and aggregate cluster health without record-level correlation
Explanation
Correct Answer
C:Correlate governed tag key/value, effective policy definitions across affected and unaffected `R034-CASE-137` runs.. By joining governed tag key/value, effective policy definitions, allowed group identities, and row filter query results across the affected and unaffected conditions, the investigation directly tests the recorded mechanism: ABAC policy matching depends on the governed attributes attached to the intended target objects. It also sets a measurable baseline for query as two regional principals before and after tagging and confirm only their permitted rows are visible.
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 governed tag key/value, effective policy definitions, allowed group identities, and row filter query results, the direct means of distinguishing ABAC policy matching depends on the governed attributes attached to the intended target objects.
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 ABAC policy matching depends on the governed attributes attached to the intended target objects. The failing-path governed tag key/value, effective policy definitions, allowed group identities, and row filter query results has to be correlated before attributing cause.
D:Review completed run status and aggregate cluster health without record-level correlation. A successful aggregate platform state can coexist with ABAC policy matching depends on the governed attributes attached to the intended target objects. This check never observes the affected `courier_events` records or their causal path.
Question 682
At a census statistics agency, a government data lake applies a central region row filter but one new table lacks the governed region tag and is unexpectedly visible. The dataset `courier_events` is in scope, and the underlying data retention policy must be preserved. Which platform configuration or data-engineering change is most defensible?
- Assign an arbitrary ungoverned label without testing policy matching; use that approach for `courier_events`.
- Assign the required governed tag and verify the centrally scoped ABAC row filter applies to the table
- Remove the ABAC policy because one table was not matched; use that approach for `courier_events`.
- Rewrite every analyst notebook query to add its own region predicate; use that approach for `courier_events`.
Explanation
Correct Answer
B:Assign the required governed tag and verify the centrally scoped ABAC row filter applies to the table. This directly addresses ABAC policy matching depends on the governed attributes attached to the intended target objects. The design should be accepted only after query as two regional principals before and after tagging and confirm only their permitted rows are visible; the related operational boundary is to retain central policy ownership while making onboarding checks require correct tags.
Incorrect Answers
A:Assign an arbitrary ungoverned label without testing policy matching; use that approach for `courier_events`. A free-text label may not satisfy governed tag policy predicates. For `courier_events`, this cannot remove the causal limitation: ABAC policy matching depends on the governed attributes attached to the intended target objects.
C:Remove the ABAC policy because one table was not matched; use that approach for `courier_events`. Disabling the guardrail broadens access and ignores the missing attribute. For `courier_events`, this cannot remove the causal limitation: ABAC policy matching depends on the governed attributes attached to the intended target objects.
D:Rewrite every analyst notebook query to add its own region predicate; use that approach for `courier_events`. Client-side WHERE clauses are bypassable and do not repair central policy coverage. For `courier_events`, this cannot remove the causal limitation: ABAC policy matching depends on the governed attributes attached to the intended target objects.
Question 683
At a census statistics agency, a government data lake applies a central region row filter but one new table lacks the governed region tag and is unexpectedly visible. The dataset `courier_events` is in scope, and the underlying data retention policy must be preserved. A teammate proposes: "Rewrite every analyst notebook query to add its own region predicate." Which technical limitation is the decisive reason not to approve that specific proposal?
- A free-text label may not satisfy governed tag policy predicates. This would apply to another option for `courier_events`.
- The failed query is caused only by a temporary notebook session, not catalog scope or security settings.
- Client-side WHERE clauses are bypassable and do not repair central policy coverage. The proposal does not repair `courier_events`.
- Disabling the guardrail broadens access and ignores the missing attribute. This would apply to an alternative change for `courier_events`.
Explanation
Correct Answer
C:Client-side WHERE clauses are bypassable and do not repair central policy coverage. The proposal does not repair `courier_events`. This identifies the known limitation of the exact proposed action. Client-side WHERE clauses are bypassable and do not repair central policy coverage. The underlying problem remains ABAC policy matching depends on the governed attributes attached to the intended target objects; Assign the required governed tag and verify the centrally scoped ABAC row filter applies to the table instead targets that failure.
Incorrect Answers
A:A free-text label may not satisfy governed tag policy predicates. This would apply to another option for `courier_events`. This limitation belongs to the different alternative "Assign an arbitrary ungoverned label without testing policy matching". The stem calls for the specific failure of "Rewrite every analyst notebook query to add its own region predicate".
B:The failed query is caused only by a temporary notebook session, not catalog scope or security settings. The case provides a concrete failing data or control path; a mere alternate theory does not address ABAC policy matching depends on the governed attributes attached to the intended target objects.
D:Disabling the guardrail broadens access and ignores the missing attribute. This would apply to an alternative change for `courier_events`. This failure applies to the separate proposal "Remove the ABAC policy because one table was not matched".
Question 684
At a census statistics agency, a government data lake applies a central region row filter but one new table lacks the governed region tag and is unexpectedly visible. The dataset `courier_events` is in scope, and the underlying data retention policy must be preserved. What risk-and-cost compromise should the owner accept instead of the proposed shortcuts?
- Remove the ABAC policy because one table was not matched
- Rewrite every analyst notebook query to add its own region predicate
- Assign an arbitrary ungoverned label without testing policy matching
- Retain central policy ownership while making onboarding checks require correct tags
Explanation
Correct Answer
D:Retain central policy ownership while making onboarding checks require correct tags. This explicitly bounds the compromise while still addressing ABAC policy matching depends on the governed attributes attached to the intended target objects. Acceptance relies on query as two regional principals before and after tagging and confirm only their permitted rows are visible rather than simply declaring the change complete.
Incorrect Answers
A:Remove the ABAC policy because one table was not matched. Disabling the guardrail broadens access and ignores the missing attribute. Monitoring after deployment does not make this approach a safe bounded tradeoff for `courier_events`.
B:Rewrite every analyst notebook query to add its own region predicate. Client-side WHERE clauses are bypassable and do not repair central policy coverage. Monitoring after deployment does not make this approach a safe bounded tradeoff for `courier_events`.
C:Assign an arbitrary ungoverned label without testing policy matching. A free-text label may not satisfy governed tag policy predicates. Monitoring after deployment does not make this approach a safe bounded tradeoff for `courier_events`.
Question 685
At a census statistics agency, a government data lake applies a central region row filter but one new table lacks the governed region tag and is unexpectedly visible. The dataset `courier_events` is in scope, and the underlying data retention policy must be preserved. Which direct test could falsify the proposed fix instead of only confirming deployment?
- Query as two regional principals before and after tagging and confirm only their permitted rows are visible
- Check that the intended configuration exists for `courier_events` and that a healthy run succeeded, without inducing the earlier failure.
- Review a platform-level availability report for `courier_events` without testing whether ABAC policy matching depends on the governed attributes attached to the intended target objects.
- Run only a normal, unchanged `courier_events` sample and review governed tag key/value.
Explanation
Correct Answer
A:Query as two regional principals before and after tagging and confirm only their permitted rows are visible. This reproduces the scenario-dependent condition, verifies governed tag key/value, effective policy definitions, allowed group identities, and row filter query results, and directly tests whether ABAC policy matching depends on the governed attributes attached to the intended target objects is resolved. Observed results, not intent, determine approval.
Incorrect Answers
B:Check that the intended configuration exists for `courier_events` 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 ABAC policy matching depends on the governed attributes attached to the intended target objects.
C:Review a platform-level availability report for `courier_events` without testing whether ABAC policy matching depends on the governed attributes attached to the intended target objects. Aggregate availability does not establish the behavior of affected `courier_events` records. It cannot replace the direct exercise: query as two regional principals before and after tagging and confirm only their permitted rows are visible.
D:Run only a normal, unchanged `courier_events` sample and review governed tag key/value. A normal sample does not challenge ABAC policy matching depends on the governed attributes attached to the intended target objects.
Question 686
At a logistics carrier, several catalogs contain newly created SSN columns, and manually attaching masks table by table leaves sensitive columns uncovered. The dataset `soil_measurements` is in scope, and effective access must follow least privilege. Which correlated observation is the strongest basis for the change decision?
- Compare the saved configuration with the signed change ticket for `soil_measurements` while omitting source and output records.
- Correlate governed tag assignments, ABAC policy scope across affected and unaffected `R034-CASE-138` runs.
- Examine only a normal successful run of `soil_measurements` and trend governed tag assignments without recreating the fault.
- Review aggregate cluster availability and job completion for `soil_measurements` without correlating the observed error path.
Explanation
Correct Answer
B:Correlate governed tag assignments, ABAC policy scope across affected and unaffected `R034-CASE-138` runs.. By joining governed tag assignments, ABAC policy scope, runtime support, and masked query results by user across the affected and unaffected conditions, the investigation directly tests the recorded mechanism: per-table discretionary masking is hard to apply consistently as new tagged columns arrive. It also sets a measurable baseline for create a newly tagged SSN column in scope and confirm the central policy masks it for unauthorized users.
Incorrect Answers
A:Compare the saved configuration with the signed change ticket for `soil_measurements` while omitting source and output records. A desired configuration and approval ticket are not runtime proof. In this case they omit governed tag assignments, ABAC policy scope, runtime support, and masked query results by user, the direct means of distinguishing per-table discretionary masking is hard to apply consistently as new tagged columns arrive.
C:Examine only a normal successful run of `soil_measurements` and trend governed tag assignments without recreating the fault. A healthy-run trend can be useful, but it does not expose per-table discretionary masking is hard to apply consistently as new tagged columns arrive. The failing-path governed tag assignments, ABAC policy scope, runtime support, and masked query results by user has to be correlated before attributing cause.
D:Review aggregate cluster availability and job completion for `soil_measurements` without correlating the observed error path. A successful aggregate platform state can coexist with per-table discretionary masking is hard to apply consistently as new tagged columns arrive. This check never observes the affected `soil_measurements` records or their causal path.
Question 687
At a logistics carrier, several catalogs contain newly created SSN columns, and manually attaching masks table by table leaves sensitive columns uncovered. The dataset `soil_measurements` is in scope, and effective access must follow least privilege. What implementation should the engineer select for the failing workflow?
- Grant every consumer direct access then rely on application code to redact; use that approach for `soil_measurements`.
- Use Unity Catalog ABAC with governed sensitive-data tags and a centrally scoped column mask policy on matching objects
- Use ungoverned text tags and expect them to enforce a security mask automatically; use that approach for `soil_measurements`.
- Create one user-managed view for each current table and ignore new objects; use that approach for `soil_measurements`.
Explanation
Correct Answer
B:Use Unity Catalog ABAC with governed sensitive-data tags and a centrally scoped column mask policy on matching objects. This directly addresses per-table discretionary masking is hard to apply consistently as new tagged columns arrive. The design should be accepted only after create a newly tagged SSN column in scope and confirm the central policy masks it for unauthorized users; the related operational boundary is to manage the security rule once at the catalog or schema scope rather than ad hoc user-managed copies.
Incorrect Answers
A:Grant every consumer direct access then rely on application code to redact; use that approach for `soil_measurements`. Application-only masking can be bypassed by direct query access. For `soil_measurements`, this cannot remove the causal limitation: per-table discretionary masking is hard to apply consistently as new tagged columns arrive.
C:Use ungoverned text tags and expect them to enforce a security mask automatically; use that approach for `soil_measurements`. Descriptive tags alone do not create an active ABAC enforcement policy. For `soil_measurements`, this cannot remove the causal limitation: per-table discretionary masking is hard to apply consistently as new tagged columns arrive.
D:Create one user-managed view for each current table and ignore new objects; use that approach for `soil_measurements`. Manual views do not automatically cover newly created sensitive tables. For `soil_measurements`, this cannot remove the causal limitation: per-table discretionary masking is hard to apply consistently as new tagged columns arrive.
Question 688
At a logistics carrier, several catalogs contain newly created SSN columns, and manually attaching masks table by table leaves sensitive columns uncovered. The dataset `soil_measurements` is in scope, and effective access must follow least privilege. A teammate proposes: "Grant every consumer direct access then rely on application code to redact." Which technical limitation is the decisive reason not to approve that specific proposal?
- Manual views do not automatically cover newly created sensitive tables. This would apply to another option for `soil_measurements`.
- Application-only masking can be bypassed by direct query access. The proposal does not repair `soil_measurements`.
- Descriptive tags alone do not create an active ABAC enforcement policy. This would apply to an alternative change for `soil_measurements`.
- The failed query is caused only by a temporary notebook session, not catalog scope or security settings.
Explanation
Correct Answer
B:Application-only masking can be bypassed by direct query access. The proposal does not repair `soil_measurements`. This identifies the known limitation of the exact proposed action. Application-only masking can be bypassed by direct query access. The underlying problem remains per-table discretionary masking is hard to apply consistently as new tagged columns arrive; Use Unity Catalog ABAC with governed sensitive-data tags and a centrally scoped column mask policy on matching objects instead targets that failure.
Incorrect Answers
A:Manual views do not automatically cover newly created sensitive tables. This would apply to another option for `soil_measurements`. This limitation belongs to the different alternative "Create one user-managed view for each current table and ignore new objects". The stem calls for the specific failure of "Grant every consumer direct access then rely on application code to redact".
C:Descriptive tags alone do not create an active ABAC enforcement policy. This would apply to an alternative change for `soil_measurements`. This failure applies to the separate proposal "Use ungoverned text tags and expect them to enforce a security mask automatically".
D:The failed query is caused only by a temporary notebook session, not catalog scope or security settings. The case provides a concrete failing data or control path; a mere alternate theory does not address per-table discretionary masking is hard to apply consistently as new tagged columns arrive.
Question 689
At a logistics carrier, several catalogs contain newly created SSN columns, and manually attaching masks table by table leaves sensitive columns uncovered. The dataset `soil_measurements` is in scope, and effective access must follow least privilege. Which decision preserves the stated data contract while keeping the change scope proportionate?
- Manage the security rule once at the catalog or schema scope rather than ad hoc user-managed copies
- Grant every consumer direct access then rely on application code to redact; monitor results only after launch of `soil_measurements`.
- Create one user-managed view for each current table and ignore new objects; monitor results only after launch of `soil_measurements`.
- Use ungoverned text tags and expect them to enforce a security mask automatically; monitor results only after launch of `soil_measurements`.
Explanation
Correct Answer
A:Manage the security rule once at the catalog or schema scope rather than ad hoc user-managed copies. This explicitly bounds the compromise while still addressing per-table discretionary masking is hard to apply consistently as new tagged columns arrive. Acceptance relies on create a newly tagged SSN column in scope and confirm the central policy masks it for unauthorized users rather than simply declaring the change complete.
Incorrect Answers
B:Grant every consumer direct access then rely on application code to redact; monitor results only after launch of `soil_measurements`. Application-only masking can be bypassed by direct query access. Monitoring after deployment does not make this approach a safe bounded tradeoff for `soil_measurements`.
C:Create one user-managed view for each current table and ignore new objects; monitor results only after launch of `soil_measurements`. Manual views do not automatically cover newly created sensitive tables. Monitoring after deployment does not make this approach a safe bounded tradeoff for `soil_measurements`.
D:Use ungoverned text tags and expect them to enforce a security mask automatically; monitor results only after launch of `soil_measurements`. Descriptive tags alone do not create an active ABAC enforcement policy. Monitoring after deployment does not make this approach a safe bounded tradeoff for `soil_measurements`.
Question 690
At a logistics carrier, several catalogs contain newly created SSN columns, and manually attaching masks table by table leaves sensitive columns uncovered. The dataset `soil_measurements` is in scope, and effective access must follow least privilege. What verification provides evidence of correct behavior under the original adverse condition?
- Review a platform-level availability report for `soil_measurements` without testing whether per-table discretionary masking is hard to apply consistently as new tagged columns arrive.
- Create a newly tagged SSN column in scope and confirm the central policy masks it for unauthorized users
- Run only a normal, unchanged `soil_measurements` sample and review governed tag assignments.
- Check that the intended configuration exists for `soil_measurements` and that a healthy run succeeded, without inducing the earlier failure.
Explanation
Correct Answer
B:Create a newly tagged SSN column in scope and confirm the central policy masks it for unauthorized users. This reproduces the scenario-dependent condition, verifies governed tag assignments, ABAC policy scope, runtime support, and masked query results by user, and directly tests whether per-table discretionary masking is hard to apply consistently as new tagged columns arrive is resolved. Observed results, not intent, determine approval.
Incorrect Answers
A:Review a platform-level availability report for `soil_measurements` without testing whether per-table discretionary masking is hard to apply consistently as new tagged columns arrive. Aggregate availability does not establish the behavior of affected `soil_measurements` records. It cannot replace the direct exercise: create a newly tagged SSN column in scope and confirm the central policy masks it for unauthorized users.
C:Run only a normal, unchanged `soil_measurements` sample and review governed tag assignments. A normal sample does not challenge per-table discretionary masking is hard to apply consistently as new tagged columns arrive.
D:Check that the intended configuration exists for `soil_measurements` 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 per-table discretionary masking is hard to apply consistently as new tagged columns arrive.