100% Latest & Updated Databricks Certified Data Engineer Associate Practice Test Questions, Exam Dumps & Verified Answers!
30 Days Free Updates, Instant Download!
Question 590
An ABAC policy appears configured, but a job running an old cluster runtime cannot query its protected table. Which action should the engineer perform to establish the intended control?
- Review compatibility and apply the supported conversion operation for the external Delta table.
- Use eligible serverless or supported Databricks Runtime and fine-grained access settings as required.
- Use the supported REVOKE operation and review effective permissions through the hierarchy.
- Perform an approved change of external table location under supported constraints and verify object access.
Explanation
Correct Answer
B:Use eligible serverless or supported Databricks Runtime and fine-grained access settings as required. The same authorized principal can read governed data on eligible compute while the unsupported runtime is rejected.
Incorrect Answers
A:If a data team must move a qualifying UC external Delta table into Databricks-managed storage, “Review compatibility and apply the supported conversion operation for the external Delta table” may be the appropriate response. Use eligible serverless or supported Databricks Runtime and fine-grained access settings as required.
C:When a departed contractor still has an inherited query privilege on a restricted data table, “Use the supported REVOKE operation and review effective permissions through the hierarchy” could be relevant. Use eligible serverless or supported Databricks Runtime and fine-grained access settings as required.
D:If an external table moved to a new permitted storage directory and the registration must refer to correct data, “Perform an approved change of external table location under supported constraints and verify object access” may be the appropriate response. Use eligible serverless or supported Databricks Runtime and fine-grained access settings as required.
Question 591
An ABAC policy appears configured, but a job running an old cluster runtime cannot query its protected table. Which observation best proves the workload meets its requirement?
- The same authorized principal can read governed data on eligible compute while the unsupported runtime is rejected.
- An analyst can SELECT but cannot UPDATE or DELETE the protected table.
- Authorized users can query table metadata and transactional updates through Unity Catalog.
- Dropping the table metadata leaves underlying externally owned files under their independent lifecycle.
Explanation
Correct Answer
A:The same authorized principal can read governed data on eligible compute while the unsupported runtime is rejected.
Incorrect Answers
B:When an analyst group should read a production customer table but must not modify it, “An analyst can SELECT but cannot UPDATE or DELETE the protected table” could be relevant. The same authorized principal can read governed data on eligible compute while the unsupported runtime is rejected.
C:If a finance team wants to create a Delta table and retain queryable schema history across routine updates, “Authorized users can query table metadata and transactional updates through Unity Catalog” may be the appropriate response. The same authorized principal can read governed data on eligible compute while the unsupported runtime is rejected.
D:An organization has existing Delta files owned by an external data steward that Databricks must not delete. In those circumstances, “Dropping the table metadata leaves underlying externally owned files under their independent lifecycle” fits. The same authorized principal can read governed data on eligible compute while the unsupported runtime is rejected.
Question 592
An ABAC policy appears configured, but a job running an old cluster runtime cannot query its protected table. The team observes: The protected table fails only for one legacy job cluster. Which underlying cause most directly explains this failure?
- The intended explicit restriction was not applied through a supported enforcement path.
- Management privileges were granted to the general reader group.
- The cluster runtime or access mode does not meet ABAC policy requirements.
- Managed and external lifecycle ownership were conflated.
Explanation
Correct Answer
C:The cluster runtime or access mode does not meet ABAC policy requirements. Use eligible serverless or supported Databricks Runtime and fine-grained access settings as required.
Incorrect Answers
A:When a highly restricted catalog must prevent a temporary group from seeing specified records despite broad organizational grants, “The intended explicit restriction was not applied through a supported enforcement path” could be relevant. The cluster runtime or access mode does not meet ABAC policy requirements.
B:If a new data steward needs authority to delegate access to a governed table while other analysts remain read-only, “Management privileges were granted to the general reader group” may be the appropriate response. The cluster runtime or access mode does not meet ABAC policy requirements.
D:When a security reviewer wants to distinguish the consequences of dropping an external table from dropping a managed one, “Managed and external lifecycle ownership were conflated” could be relevant. The cluster runtime or access mode does not meet ABAC policy requirements.
Question 593
An auditor needs to understand which inherited ABAC policies actually apply to a newly tagged table. Which design choice best addresses the stated business and technical requirement?
- Use effective-policy inspection rather than listing only policies directly attached to the table.
- Grant only required usage and SELECT privileges to the group on the intended securables.
- Assign object ownership or a narrowly appropriate MANAGE privilege rather than general content-edit rights.
- Check parent USE CATALOG and USE SCHEMA authorization alongside table SELECT.
Explanation
Correct Answer
A:Use effective-policy inspection rather than listing only policies directly attached to the table. The audit reveals applicable inherited masking and row-filter policies and their origins.
Incorrect Answers
B:An analyst group should read a production customer table but must not modify it. In those circumstances, “Grant only required usage and SELECT privileges to the group on the intended securables” fits. Use effective-policy inspection rather than listing only policies directly attached to the table.
C:When a new data steward needs authority to delegate access to a governed table while other analysts remain read-only, “Assign object ownership or a narrowly appropriate MANAGE privilege rather than general content-edit rights” could be relevant. Use effective-policy inspection rather than listing only policies directly attached to the table.
D:If a team grants SELECT on a table but receives a missing privilege error traversing its catalog, “Check parent USE CATALOG and USE SCHEMA authorization alongside table SELECT” may be the appropriate response. Use effective-policy inspection rather than listing only policies directly attached to the table.
Question 594
An auditor needs to understand which inherited ABAC policies actually apply to a newly tagged table. Which setup step most directly realizes the proposed design?
- Create the table as managed under the approved catalog and schema without a separate LOCATION path.
- Configure the delegated management permission and verify the steward can administer grants.
- Create an external UC table pointing at the authorized external Delta path with approved permissions.
- Run the supported SHOW EFFECTIVE POLICIES inspection on the securable and review scope/tags.
Explanation
Correct Answer
D:Run the supported SHOW EFFECTIVE POLICIES inspection on the securable and review scope/tags. The audit reveals applicable inherited masking and row-filter policies and their origins.
Incorrect Answers
A:A governed table stores regulated transaction records and the organization wants Databricks to manage data-file lifecycle on deletion. In those circumstances, “Create the table as managed under the approved catalog and schema without a separate LOCATION path” fits. Run the supported SHOW EFFECTIVE POLICIES inspection on the securable and review scope/tags.
B:When a new data steward needs authority to delegate access to a governed table while other analysts remain read-only, “Configure the delegated management permission and verify the steward can administer grants” could be relevant. Run the supported SHOW EFFECTIVE POLICIES inspection on the securable and review scope/tags.
C:If an organization has existing Delta files owned by an external data steward that Databricks must not delete, “Create an external UC table pointing at the authorized external Delta path with approved permissions” may be the appropriate response. Run the supported SHOW EFFECTIVE POLICIES inspection on the securable and review scope/tags.
Question 595
An auditor needs to understand which inherited ABAC policies actually apply to a newly tagged table. What is the most relevant verification evidence for this case?
- The job authenticates as the service principal and fails to access unrelated catalogs.
- The audit reveals applicable inherited masking and row-filter policies and their origins.
- An analyst can SELECT but cannot UPDATE or DELETE the protected table.
- The catalog records a managed table, the data remains queryable and ownership semantics are verified.
Explanation
Correct Answer
B:The audit reveals applicable inherited masking and row-filter policies and their origins.
Incorrect Answers
A:When a production integration needs machine-to-machine access without using a personal engineer login, “The job authenticates as the service principal and fails to access unrelated catalogs” could be relevant. The audit reveals applicable inherited masking and row-filter policies and their origins.
C:An analyst group should read a production customer table but must not modify it. In those circumstances, “An analyst can SELECT but cannot UPDATE or DELETE the protected table” fits. The audit reveals applicable inherited masking and row-filter policies and their origins.
D:When a data team must move a qualifying UC external Delta table into Databricks-managed storage, “The catalog records a managed table, the data remains queryable and ownership semantics are verified” could be relevant. The audit reveals applicable inherited masking and row-filter policies and their origins.
Question 596
An auditor needs to understand which inherited ABAC policies actually apply to a newly tagged table. The team observes: The table appears to have no policies although users see masked data. What is the most likely mechanism behind the observed defect?
- The auditor inspected only direct table-level policies and missed inherited scope policies.
- The intended explicit restriction was not applied through a supported enforcement path.
- The dataset had been migrated to managed storage without considering external file ownership.
- One of the needed parent namespace usage permissions is absent.
Explanation
Correct Answer
A:The auditor inspected only direct table-level policies and missed inherited scope policies. Run the supported SHOW EFFECTIVE POLICIES inspection on the securable and review scope/tags.
Incorrect Answers
B:A highly restricted catalog must prevent a temporary group from seeing specified records despite broad organizational grants. In those circumstances, “The intended explicit restriction was not applied through a supported enforcement path” fits. The auditor inspected only direct table-level policies and missed inherited scope policies.
C:When an organization has existing Delta files owned by an external data steward that Databricks must not delete, “The dataset had been migrated to managed storage without considering external file ownership” could be relevant. The auditor inspected only direct table-level policies and missed inherited scope policies.
D:If a team grants SELECT on a table but receives a missing privilege error traversing its catalog, “One of the needed parent namespace usage permissions is absent” may be the appropriate response. The auditor inspected only direct table-level policies and missed inherited scope policies.
Question 597
A tag-driven ABAC mask was changed, and the security team needs to confirm its effect on analysts and exempt staff. Which approach most directly satisfies the requirement?
- Test effective policy evaluation using representative identities and tagged columns.
- Document and test the different metadata and data-lifecycle semantics on a disposable dataset.
- Revoke the no-longer-authorized privilege from the relevant principal or group membership.
- Use a least-privileged service principal for the integration identity.
Explanation
Correct Answer
A:Test effective policy evaluation using representative identities and tagged columns. Analyst queries remain masked and exempt test identities see only their intended values.
Incorrect Answers
B:When a security reviewer wants to distinguish the consequences of dropping an external table from dropping a managed one, “Document and test the different metadata and data-lifecycle semantics on a disposable dataset” could be relevant. Test effective policy evaluation using representative identities and tagged columns.
C:If a departed contractor still has an inherited query privilege on a restricted data table, “Revoke the no-longer-authorized privilege from the relevant principal or group membership” may be the appropriate response. Test effective policy evaluation using representative identities and tagged columns.
D:A production integration needs machine-to-machine access without using a personal engineer login. In those circumstances, “Use a least-privileged service principal for the integration identity” fits. Test effective policy evaluation using representative identities and tagged columns.
Question 598
A tag-driven ABAC mask was changed, and the security team needs to confirm its effect on analysts and exempt staff. Which configuration or engineering action would most directly implement the requirement?
- Query the protected table under authorized test principals after policy change, allowing documented propagation time.
- Configure the delegated management permission and verify the steward can administer grants.
- Add the nullable column through approved DDL and update downstream consumers.
- Use the supported REVOKE operation and review effective permissions through the hierarchy.
Explanation
Correct Answer
A:Query the protected table under authorized test principals after policy change, allowing documented propagation time. Analyst queries remain masked and exempt test identities see only their intended values.
Incorrect Answers
B:If a new data steward needs authority to delegate access to a governed table while other analysts remain read-only, “Configure the delegated management permission and verify the steward can administer grants” may be the appropriate response. Query the protected table under authorized test principals after policy change, allowing documented propagation time.
C:A managed table needs a schema change to add an optional reporting column while retaining existing rows. In those circumstances, “Add the nullable column through approved DDL and update downstream consumers” fits. Query the protected table under authorized test principals after policy change, allowing documented propagation time.
D:When a departed contractor still has an inherited query privilege on a restricted data table, “Use the supported REVOKE operation and review effective permissions through the hierarchy” could be relevant. Query the protected table under authorized test principals after policy change, allowing documented propagation time.
Question 599
A tag-driven ABAC mask was changed, and the security team needs to confirm its effect on analysts and exempt staff. Which test would establish that the change worked as intended?
- Analyst queries remain masked and exempt test identities see only their intended values.
- Queries read the correct new data path with unchanged authorized access scope.
- The steward manages authorized access while ordinary analysts cannot grant themselves privileges.
- The authorized user can access the intended table without obtaining broader edit rights.
Explanation
Correct Answer
A:Analyst queries remain masked and exempt test identities see only their intended values.
Incorrect Answers
B:An external table moved to a new permitted storage directory and the registration must refer to correct data. In those circumstances, “Queries read the correct new data path with unchanged authorized access scope” fits. Analyst queries remain masked and exempt test identities see only their intended values.
C:When a new data steward needs authority to delegate access to a governed table while other analysts remain read-only, “The steward manages authorized access while ordinary analysts cannot grant themselves privileges” could be relevant. Analyst queries remain masked and exempt test identities see only their intended values.
D:If a team grants SELECT on a table but receives a missing privilege error traversing its catalog, “The authorized user can access the intended table without obtaining broader edit rights” may be the appropriate response. Analyst queries remain masked and exempt test identities see only their intended values.
Question 600
A tag-driven ABAC mask was changed, and the security team needs to confirm its effect on analysts and exempt staff. The team observes: Analysts temporarily see unmasked identifiers after an incorrect tag or policy revision. Which configuration or design gap best explains the symptom?
- The intended explicit restriction was not applied through a supported enforcement path.
- Managed and external lifecycle ownership were conflated.
- The table was created with an external location rather than as a managed table.
- The policy condition or principal scope no longer matches the intended sensitive data.
Explanation
Correct Answer
D:The policy condition or principal scope no longer matches the intended sensitive data. Query the protected table under authorized test principals after policy change, allowing documented propagation time.
Incorrect Answers
A:A highly restricted catalog must prevent a temporary group from seeing specified records despite broad organizational grants. In those circumstances, “The intended explicit restriction was not applied through a supported enforcement path” fits. The policy condition or principal scope no longer matches the intended sensitive data.
B:When a security reviewer wants to distinguish the consequences of dropping an external table from dropping a managed one, “Managed and external lifecycle ownership were conflated” could be relevant. The policy condition or principal scope no longer matches the intended sensitive data.
C:If a governed table stores regulated transaction records and the organization wants Databricks to manage data-file lifecycle on deletion, “The table was created with an external location rather than as a managed table” may be the appropriate response. The policy condition or principal scope no longer matches the intended sensitive data.
Certified Data Engineer Associate Practice Tests