Certified Data Engineer Associate Practice Test 65
Question 640
At a public housing agency, an analyst has SELECT on a Unity Catalog table but receives a permission error because catalog and schema usage were not granted. The dataset `course_enrollments` is in scope, and the underlying data retention policy must be preserved. Before release, which acceptance test would actually demonstrate that the root problem is controlled?
- Review a platform-level availability report for `course_enrollments` without testing whether table-level SELECT alone is insufficient without parent namespace usage privileges.
- Run only a normal, unchanged `course_enrollments` sample and review effective grants on catalog.
- Query as the analyst before and after the minimum grants and confirm unrelated schemas remain inaccessible
- Check that the intended configuration exists for `course_enrollments` and that a healthy run succeeded, without inducing the earlier failure.
Explanation
Correct Answer
C:Query as the analyst before and after the minimum grants and confirm unrelated schemas remain inaccessible. This reproduces the scenario-dependent condition, verifies effective grants on catalog, schema and table, denied query error, and test principal identity, and directly tests whether table-level SELECT alone is insufficient without parent namespace usage privileges is resolved. Observed results, not intent, determine approval.
Incorrect Answers
A:Review a platform-level availability report for `course_enrollments` without testing whether table-level SELECT alone is insufficient without parent namespace usage privileges. Aggregate availability does not establish the behavior of affected `course_enrollments` records. It cannot replace the direct exercise: query as the analyst before and after the minimum grants and confirm unrelated schemas remain inaccessible.
B:Run only a normal, unchanged `course_enrollments` sample and review effective grants on catalog. A normal sample does not challenge table-level SELECT alone is insufficient without parent namespace usage privileges.
D:Check that the intended configuration exists for `course_enrollments` 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 table-level SELECT alone is insufficient without parent namespace usage privileges.
Question 641
At a scientific imaging provider, a temporary contractor retains SELECT on a confidential table after project completion and access review flags the grant. The dataset `vehicle_arrivals` is in scope, and effective access must follow least privilege. What evidence should the engineer collect to establish the cause rather than a coincidental symptom?
- Review aggregate cluster availability and job completion for `vehicle_arrivals` without correlating the observed error path.
- Examine only a normal successful run of `vehicle_arrivals` and trend principal group membership without recreating the fault.
- Compare the saved configuration with the signed change ticket for `vehicle_arrivals` while omitting source and output records.
- Correlate principal group membership, direct and inherited grants across affected and unaffected `R034-CASE-129` runs.
Explanation
Correct Answer
D:Correlate principal group membership, direct and inherited grants across affected and unaffected `R034-CASE-129` runs.. By joining principal group membership, direct and inherited grants, query audit, and denied access after revocation across the affected and unaffected conditions, the investigation directly tests the recorded mechanism: a stale direct or inherited grant can leave access after the intended authorization ends. It also sets a measurable baseline for revoke the relevant grants and verify the contractor cannot query while approved staff still can.
Incorrect Answers
A:Review aggregate cluster availability and job completion for `vehicle_arrivals` without correlating the observed error path. A successful aggregate platform state can coexist with a stale direct or inherited grant can leave access after the intended authorization ends. This check never observes the affected `vehicle_arrivals` records or their causal path.
B:Examine only a normal successful run of `vehicle_arrivals` and trend principal group membership without recreating the fault. A healthy-run trend can be useful, but it does not expose a stale direct or inherited grant can leave access after the intended authorization ends. The failing-path principal group membership, direct and inherited grants, query audit, and denied access after revocation has to be correlated before attributing cause.
C:Compare the saved configuration with the signed change ticket for `vehicle_arrivals` while omitting source and output records. A desired configuration and approval ticket are not runtime proof. In this case they omit principal group membership, direct and inherited grants, query audit, and denied access after revocation, the direct means of distinguishing a stale direct or inherited grant can leave access after the intended authorization ends.
Question 642
At a scientific imaging provider, a temporary contractor retains SELECT on a confidential table after project completion and access review flags the grant. The dataset `vehicle_arrivals` is in scope, and effective access must follow least privilege. Which platform configuration or data-engineering change is most defensible?
- Remove the contractor from one notebook share while leaving table privileges active; use that approach for `vehicle_arrivals`.
- Change the table name but leave the same grants effective; use that approach for `vehicle_arrivals`.
- Revoke the contractor group’s table SELECT and test the effective privilege path, including inherited grants
- Rely on a verbal instruction not to query the table; use that approach for `vehicle_arrivals`.
Explanation
Correct Answer
C:Revoke the contractor group’s table SELECT and test the effective privilege path, including inherited grants. This directly addresses a stale direct or inherited grant can leave access after the intended authorization ends. The design should be accepted only after revoke the relevant grants and verify the contractor cannot query while approved staff still can; the related operational boundary is to restore least privilege with a tested denial rather than disrupting authorized users.
Incorrect Answers
A:Remove the contractor from one notebook share while leaving table privileges active; use that approach for `vehicle_arrivals`. Notebook visibility does not determine underlying table SELECT authorization. For `vehicle_arrivals`, this cannot remove the causal limitation: a stale direct or inherited grant can leave access after the intended authorization ends.
B:Change the table name but leave the same grants effective; use that approach for `vehicle_arrivals`. Renaming an object does not reliably eliminate permissions or access. For `vehicle_arrivals`, this cannot remove the causal limitation: a stale direct or inherited grant can leave access after the intended authorization ends.
D:Rely on a verbal instruction not to query the table; use that approach for `vehicle_arrivals`. An unenforced request is not a revocation of access rights. For `vehicle_arrivals`, this cannot remove the causal limitation: a stale direct or inherited grant can leave access after the intended authorization ends.
Question 643
At a scientific imaging provider, a temporary contractor retains SELECT on a confidential table after project completion and access review flags the grant. The dataset `vehicle_arrivals` is in scope, and effective access must follow least privilege. A teammate proposes: "Remove the contractor from one notebook share while leaving table privileges active." Which technical limitation is the decisive reason not to approve that specific proposal?
- Notebook visibility does not determine underlying table SELECT authorization. The proposal does not repair `vehicle_arrivals`.
- The failed query is caused only by a temporary notebook session, not catalog scope or security settings.
- An unenforced request is not a revocation of access rights. This would apply to an alternative change for `vehicle_arrivals`.
- Renaming an object does not reliably eliminate permissions or access. This would apply to another option for `vehicle_arrivals`.
Explanation
Correct Answer
A:Notebook visibility does not determine underlying table SELECT authorization. The proposal does not repair `vehicle_arrivals`. This identifies the known limitation of the exact proposed action. Notebook visibility does not determine underlying table SELECT authorization. The underlying problem remains a stale direct or inherited grant can leave access after the intended authorization ends; Revoke the contractor group’s table SELECT and test the effective privilege path, including inherited grants instead targets that failure.
Incorrect Answers
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 a stale direct or inherited grant can leave access after the intended authorization ends.
C:An unenforced request is not a revocation of access rights. This would apply to an alternative change for `vehicle_arrivals`. This failure applies to the separate proposal "Rely on a verbal instruction not to query the table".
D:Renaming an object does not reliably eliminate permissions or access. This would apply to another option for `vehicle_arrivals`. This limitation belongs to the different alternative "Change the table name but leave the same grants effective". The stem calls for the specific failure of "Remove the contractor from one notebook share while leaving table privileges active".
Question 644
At a scientific imaging provider, a temporary contractor retains SELECT on a confidential table after project completion and access review flags the grant. The dataset `vehicle_arrivals` is in scope, and effective access must follow least privilege. What risk-and-cost compromise should the owner accept instead of the proposed shortcuts?
- Remove the contractor from one notebook share while leaving table privileges active; monitor results only after launch of `vehicle_arrivals`.
- Rely on a verbal instruction not to query the table; monitor results only after launch of `vehicle_arrivals`.
- Change the table name but leave the same grants effective; monitor results only after launch of `vehicle_arrivals`.
- Restore least privilege with a tested denial rather than disrupting authorized users
Explanation
Correct Answer
D:Restore least privilege with a tested denial rather than disrupting authorized users. This explicitly bounds the compromise while still addressing a stale direct or inherited grant can leave access after the intended authorization ends. Acceptance relies on revoke the relevant grants and verify the contractor cannot query while approved staff still can rather than simply declaring the change complete.
Incorrect Answers
A:Remove the contractor from one notebook share while leaving table privileges active; monitor results only after launch of `vehicle_arrivals`. Notebook visibility does not determine underlying table SELECT authorization. Monitoring after deployment does not make this approach a safe bounded tradeoff for `vehicle_arrivals`.
B:Rely on a verbal instruction not to query the table; monitor results only after launch of `vehicle_arrivals`. An unenforced request is not a revocation of access rights. Monitoring after deployment does not make this approach a safe bounded tradeoff for `vehicle_arrivals`.
C:Change the table name but leave the same grants effective; monitor results only after launch of `vehicle_arrivals`. Renaming an object does not reliably eliminate permissions or access. Monitoring after deployment does not make this approach a safe bounded tradeoff for `vehicle_arrivals`.
Question 645
At a scientific imaging provider, a temporary contractor retains SELECT on a confidential table after project completion and access review flags the grant. The dataset `vehicle_arrivals` is in scope, and effective access must follow least privilege. Which direct test could falsify the proposed fix instead of only confirming deployment?
- Check that the intended configuration exists for `vehicle_arrivals` and that a healthy run succeeded, without inducing the earlier failure.
- Run only a normal, unchanged `vehicle_arrivals` sample and review principal group membership.
- Revoke the relevant grants and verify the contractor cannot query while approved staff still can
- Review a platform-level availability report for `vehicle_arrivals` without testing whether a stale direct or inherited grant can leave access after the intended authorization ends.
Explanation
Correct Answer
C:Revoke the relevant grants and verify the contractor cannot query while approved staff still can. This reproduces the scenario-dependent condition, verifies principal group membership, direct and inherited grants, query audit, and denied access after revocation, and directly tests whether a stale direct or inherited grant can leave access after the intended authorization ends is resolved. Observed results, not intent, determine approval.
Incorrect Answers
A:Check that the intended configuration exists for `vehicle_arrivals` 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 a stale direct or inherited grant can leave access after the intended authorization ends.
B:Run only a normal, unchanged `vehicle_arrivals` sample and review principal group membership. A normal sample does not challenge a stale direct or inherited grant can leave access after the intended authorization ends.
D:Review a platform-level availability report for `vehicle_arrivals` without testing whether a stale direct or inherited grant can leave access after the intended authorization ends. Aggregate availability does not establish the behavior of affected `vehicle_arrivals` records. It cannot replace the direct exercise: revoke the relevant grants and verify the contractor cannot query while approved staff still can.
Question 646
At an agricultural sensor program, an analyst has SELECT on a Unity Catalog table but receives a permission error because catalog and schema usage were not granted. The dataset `payment_decisions` is in scope, and the underlying data retention policy must be preserved. Which correlated observation is the strongest basis for the change decision?
- Review completed run status and aggregate cluster health without record-level correlation
- Correlate effective grants on catalog, schema and table across affected and unaffected `R034-CASE-130` runs.
- Inspect normal-period success metrics for the stated dataset without reproducing the source error
- Compare the saved configuration with the signed change ticket for `payment_decisions` while omitting source and output records.
Explanation
Correct Answer
B:Correlate effective grants on catalog, schema and table across affected and unaffected `R034-CASE-130` runs.. By joining effective grants on catalog, schema and table, denied query error, and test principal identity across the affected and unaffected conditions, the investigation directly tests the recorded mechanism: table-level SELECT alone is insufficient without parent namespace usage privileges. It also sets a measurable baseline for query as the analyst before and after the minimum grants and confirm unrelated schemas remain inaccessible.
Incorrect Answers
A:Review completed run status and aggregate cluster health without record-level correlation. A successful aggregate platform state can coexist with table-level SELECT alone is insufficient without parent namespace usage privileges. This check never observes the affected `payment_decisions` records or their causal path.
C: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 table-level SELECT alone is insufficient without parent namespace usage privileges. The failing-path effective grants on catalog, schema and table, denied query error, and test principal identity has to be correlated before attributing cause.
D:Compare the saved configuration with the signed change ticket for `payment_decisions` while omitting source and output records. A desired configuration and approval ticket are not runtime proof. In this case they omit effective grants on catalog, schema and table, denied query error, and test principal identity, the direct means of distinguishing table-level SELECT alone is insufficient without parent namespace usage privileges.
Question 647
At an agricultural sensor program, an analyst has SELECT on a Unity Catalog table but receives a permission error because catalog and schema usage were not granted. The dataset `payment_decisions` is in scope, and the underlying data retention policy must be preserved. What implementation should the engineer select for the failing workflow?
- Create a personal ungoverned copy of the table to bypass catalog checks; use that approach for `payment_decisions`.
- Grant the needed USE CATALOG and USE SCHEMA along the object hierarchy in addition to table SELECT
- Grant ALL PRIVILEGES on the entire metastore to the analyst; use that approach for `payment_decisions`.
- Transfer ownership of the table to the analyst; use that approach for `payment_decisions`.
Explanation
Correct Answer
B:Grant the needed USE CATALOG and USE SCHEMA along the object hierarchy in addition to table SELECT. This directly addresses table-level SELECT alone is insufficient without parent namespace usage privileges. The design should be accepted only after query as the analyst before and after the minimum grants and confirm unrelated schemas remain inaccessible; the related operational boundary is to grant only the traversal and read permissions required for the approved data object.
Incorrect Answers
A:Create a personal ungoverned copy of the table to bypass catalog checks; use that approach for `payment_decisions`. Bypass copies defeat object-level governance and lineage. For `payment_decisions`, this cannot remove the causal limitation: table-level SELECT alone is insufficient without parent namespace usage privileges.
C:Grant ALL PRIVILEGES on the entire metastore to the analyst; use that approach for `payment_decisions`. Global privileges are excessive for a single governed table read. For `payment_decisions`, this cannot remove the causal limitation: table-level SELECT alone is insufficient without parent namespace usage privileges.
D:Transfer ownership of the table to the analyst; use that approach for `payment_decisions`. Ownership gives unwanted control and does not follow least privilege. For `payment_decisions`, this cannot remove the causal limitation: table-level SELECT alone is insufficient without parent namespace usage privileges.
Question 648
At an agricultural sensor program, an analyst has SELECT on a Unity Catalog table but receives a permission error because catalog and schema usage were not granted. The dataset `payment_decisions` is in scope, and the underlying data retention policy must be preserved. A teammate proposes: "Create a personal ungoverned copy of the table to bypass catalog checks." Which technical limitation is the decisive reason not to approve that specific proposal?
- Global privileges are excessive for a single governed table read. This would apply to an alternative change for `payment_decisions`.
- The failed query is caused only by a temporary notebook session, not catalog scope or security settings.
- Ownership gives unwanted control and does not follow least privilege. This would apply to another option for `payment_decisions`.
- Bypass copies defeat object-level governance and lineage. The proposal does not repair `payment_decisions`.
Explanation
Correct Answer
D:Bypass copies defeat object-level governance and lineage. The proposal does not repair `payment_decisions`. This identifies the known limitation of the exact proposed action. Bypass copies defeat object-level governance and lineage. The underlying problem remains table-level SELECT alone is insufficient without parent namespace usage privileges; Grant the needed USE CATALOG and USE SCHEMA along the object hierarchy in addition to table SELECT instead targets that failure.
Incorrect Answers
A:Global privileges are excessive for a single governed table read. This would apply to an alternative change for `payment_decisions`. This failure applies to the separate proposal "Grant ALL PRIVILEGES on the entire metastore to the analyst".
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 table-level SELECT alone is insufficient without parent namespace usage privileges.
C:Ownership gives unwanted control and does not follow least privilege. This would apply to another option for `payment_decisions`. This limitation belongs to the different alternative "Transfer ownership of the table to the analyst". The stem calls for the specific failure of "Create a personal ungoverned copy of the table to bypass catalog checks".
Question 649
At an agricultural sensor program, an analyst has SELECT on a Unity Catalog table but receives a permission error because catalog and schema usage were not granted. The dataset `payment_decisions` is in scope, and the underlying data retention policy must be preserved. Which decision preserves the stated data contract while keeping the change scope proportionate?
- Transfer ownership of the table to the analyst
- Grant ALL PRIVILEGES on the entire metastore to the analyst
- Grant only the traversal and read permissions required for the approved data object
- Create a personal ungoverned copy of the table to bypass catalog checks; monitor results only after launch of `payment_decisions`.
Explanation
Correct Answer
C:Grant only the traversal and read permissions required for the approved data object. This explicitly bounds the compromise while still addressing table-level SELECT alone is insufficient without parent namespace usage privileges. Acceptance relies on query as the analyst before and after the minimum grants and confirm unrelated schemas remain inaccessible rather than simply declaring the change complete.
Incorrect Answers
A:Transfer ownership of the table to the analyst. Ownership gives unwanted control and does not follow least privilege. Monitoring after deployment does not make this approach a safe bounded tradeoff for `payment_decisions`.
B:Grant ALL PRIVILEGES on the entire metastore to the analyst. Global privileges are excessive for a single governed table read. Monitoring after deployment does not make this approach a safe bounded tradeoff for `payment_decisions`.
D:Create a personal ungoverned copy of the table to bypass catalog checks; monitor results only after launch of `payment_decisions`. Bypass copies defeat object-level governance and lineage. Monitoring after deployment does not make this approach a safe bounded tradeoff for `payment_decisions`.
Question 650
At an agricultural sensor program, an analyst has SELECT on a Unity Catalog table but receives a permission error because catalog and schema usage were not granted. The dataset `payment_decisions` is in scope, and the underlying data retention policy must be preserved. What verification provides evidence of correct behavior under the original adverse condition?
- Review a platform-level availability report for `payment_decisions` without testing whether table-level SELECT alone is insufficient without parent namespace usage privileges.
- Query as the analyst before and after the minimum grants and confirm unrelated schemas remain inaccessible
- Run only a normal, unchanged `payment_decisions` sample and review effective grants on catalog.
- Check that the intended configuration exists for `payment_decisions` and that a healthy run succeeded, without inducing the earlier failure.
Explanation
Correct Answer
B:Query as the analyst before and after the minimum grants and confirm unrelated schemas remain inaccessible. This reproduces the scenario-dependent condition, verifies effective grants on catalog, schema and table, denied query error, and test principal identity, and directly tests whether table-level SELECT alone is insufficient without parent namespace usage privileges is resolved. Observed results, not intent, determine approval.
Incorrect Answers
A:Review a platform-level availability report for `payment_decisions` without testing whether table-level SELECT alone is insufficient without parent namespace usage privileges. Aggregate availability does not establish the behavior of affected `payment_decisions` records. It cannot replace the direct exercise: query as the analyst before and after the minimum grants and confirm unrelated schemas remain inaccessible.
C:Run only a normal, unchanged `payment_decisions` sample and review effective grants on catalog. A normal sample does not challenge table-level SELECT alone is insufficient without parent namespace usage privileges.
D:Check that the intended configuration exists for `payment_decisions` 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 table-level SELECT alone is insufficient without parent namespace usage privileges.