100% Latest & Updated Databricks Certified Data Engineer Associate Practice Test Questions, Exam Dumps & Verified Answers!
30 Days Free Updates, Instant Download!
Question 520
An organization has existing Delta files owned by an external data steward that Databricks must not delete. The team observes: A metadata cleanup destroys source files still needed by another system. Which configuration or design gap best explains the symptom?
- The intended explicit restriction was not applied through a supported enforcement path.
- The sensitive column lacks an effective mask for that principal.
- The effective filtering or masking policy is not attached or scoped correctly.
- The dataset had been migrated to managed storage without considering external file ownership.
Explanation
Correct Answer
D:The dataset had been migrated to managed storage without considering external file ownership. Create an external UC table pointing at the authorized external Delta path with approved permissions.
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 dataset had been migrated to managed storage without considering external file ownership.
B:If a clinical data table contains patient identifiers but analysts should see masked values while retaining aggregate use, “The sensitive column lacks an effective mask for that principal” may be the appropriate response. The dataset had been migrated to managed storage without considering external file ownership.
C:A new group is admitted to a masked analytics view and controls must still enforce least privilege. In those circumstances, “The effective filtering or masking policy is not attached or scoped correctly” fits. The dataset had been migrated to managed storage without considering external file ownership.
Question 521
A security reviewer wants to distinguish the consequences of dropping an external table from dropping a managed one. Which architecture or engineering decision best fits this scenario?
- Revoke the no-longer-authorized privilege from the relevant principal or group membership.
- Use effective-policy inspection rather than listing only policies directly attached to the table.
- Test effective policy evaluation using representative identities and tagged columns.
- Document and test the different metadata and data-lifecycle semantics on a disposable dataset.
Explanation
Correct Answer
D:Document and test the different metadata and data-lifecycle semantics on a disposable dataset. The external files persist after metadata removal and managed data follows its documented lifecycle.
Incorrect Answers
A: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. Document and test the different metadata and data-lifecycle semantics on a disposable dataset.
B:An auditor needs to understand which inherited ABAC policies actually apply to a newly tagged table. In those circumstances, “Use effective-policy inspection rather than listing only policies directly attached to the table” fits. Document and test the different metadata and data-lifecycle semantics on a disposable dataset.
C:When a tag-driven ABAC mask was changed, and the security team needs to confirm its effect on analysts and exempt staff, “Test effective policy evaluation using representative identities and tagged columns” could be relevant. Document and test the different metadata and data-lifecycle semantics on a disposable dataset.
Question 522
A security reviewer wants to distinguish the consequences of dropping an external table from dropping a managed one. Which implementation step is most appropriate before production use?
- Query the protected table under authorized test principals after policy change, allowing documented propagation time.
- Review and add only the missing usage privilege at the correct parent level.
- Create disposable examples of both types and inspect data persistence after supported drop operations.
- Configure the delegated management permission and verify the steward can administer grants.
Explanation
Correct Answer
C:Create disposable examples of both types and inspect data persistence after supported drop operations. The external files persist after metadata removal and managed data follows its documented lifecycle.
Incorrect Answers
A:A tag-driven ABAC mask was changed, and the security team needs to confirm its effect on analysts and exempt staff. In those circumstances, “Query the protected table under authorized test principals after policy change, allowing documented propagation time” fits. Create disposable examples of both types and inspect data persistence after supported drop operations.
B:When a team grants SELECT on a table but receives a missing privilege error traversing its catalog, “Review and add only the missing usage privilege at the correct parent level” could be relevant. Create disposable examples of both types and inspect data persistence after supported drop operations.
D:A new data steward needs authority to delegate access to a governed table while other analysts remain read-only. In those circumstances, “Configure the delegated management permission and verify the steward can administer grants” fits. Create disposable examples of both types and inspect data persistence after supported drop operations.
Question 523
A security reviewer wants to distinguish the consequences of dropping an external table from dropping a managed one. Which acceptance test provides the strongest evidence that the intended outcome has been achieved?
- The steward manages authorized access while ordinary analysts cannot grant themselves privileges.
- An analyst can SELECT but cannot UPDATE or DELETE the protected table.
- Two distinct tenant users each see only their own rows through the same query.
- The external files persist after metadata removal and managed data follows its documented lifecycle.
Explanation
Correct Answer
D:The external files persist after metadata removal and managed data follows its documented lifecycle.
Incorrect Answers
A: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. The external files persist after metadata removal and managed data follows its documented lifecycle.
B:If 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” may be the appropriate response. The external files persist after metadata removal and managed data follows its documented lifecycle.
C:A multi-tenant orders table stores tenant_id and each customer team may read only its tenant rows. In those circumstances, “Two distinct tenant users each see only their own rows through the same query” fits. The external files persist after metadata removal and managed data follows its documented lifecycle.
Question 524
A security reviewer wants to distinguish the consequences of dropping an external table from dropping a managed one. The team observes: A policy assumes both table types have identical deletion behavior. Which root cause should be addressed first given this evidence?
- The cluster runtime or access mode does not meet ABAC policy requirements.
- Managed and external lifecycle ownership were conflated.
- The deployment applied column masking but omitted row filtering.
- The job depended on personal credentials and grants.
Explanation
Correct Answer
B:Managed and external lifecycle ownership were conflated. Create disposable examples of both types and inspect data persistence after supported drop operations.
Incorrect Answers
A:If an ABAC policy appears configured, but a job running an old cluster runtime cannot query its protected table, “The cluster runtime or access mode does not meet ABAC policy requirements” may be the appropriate response. Managed and external lifecycle ownership were conflated.
C:When a regulated table needs both redaction of tax IDs and exclusion of unauthorized region rows, “The deployment applied column masking but omitted row filtering” could be relevant. Managed and external lifecycle ownership were conflated.
D:If a production integration needs machine-to-machine access without using a personal engineer login, “The job depended on personal credentials and grants” may be the appropriate response. Managed and external lifecycle ownership were conflated.
Question 525
A data team must move a qualifying UC external Delta table into Databricks-managed storage. Which technical design is most appropriate for the stated constraint?
- Use effective-policy inspection rather than listing only policies directly attached to the table.
- Check parent USE CATALOG and USE SCHEMA authorization alongside table SELECT.
- Assign object ownership or a narrowly appropriate MANAGE privilege rather than general content-edit rights.
- Use a documented supported conversion-to-managed workflow after checking prerequisites.
Explanation
Correct Answer
D:Use a documented supported conversion-to-managed workflow after checking prerequisites. The catalog records a managed table, the data remains queryable and ownership semantics are verified.
Incorrect Answers
A:An auditor needs to understand which inherited ABAC policies actually apply to a newly tagged table. In those circumstances, “Use effective-policy inspection rather than listing only policies directly attached to the table” fits. Use a documented supported conversion-to-managed workflow after checking prerequisites.
B:When 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” could be relevant. Use a documented supported conversion-to-managed workflow after checking prerequisites.
C:If 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” may be the appropriate response. Use a documented supported conversion-to-managed workflow after checking prerequisites.
Question 526
A data team must move a qualifying UC external Delta table into Databricks-managed storage. Which action should the engineer perform to establish the intended control?
- Define the policy at eligible scopes with the required UDF or expression, tag condition and principals.
- Review compatibility and apply the supported conversion operation for the external Delta table.
- Configure the delegated management permission and verify the steward can administer grants.
- Query the protected table under authorized test principals after policy change, allowing documented propagation time.
Explanation
Correct Answer
B:Review compatibility and apply the supported conversion operation for the external Delta table. The catalog records a managed table, the data remains queryable and ownership semantics are verified.
Incorrect Answers
A:When a security policy should restrict rows according to a governed region tag across multiple catalogs where supported, “Define the policy at eligible scopes with the required UDF or expression, tag condition and principals” could be relevant. Review compatibility and apply the supported conversion operation for the external Delta table.
C:A new data steward needs authority to delegate access to a governed table while other analysts remain read-only. In those circumstances, “Configure the delegated management permission and verify the steward can administer grants” fits. Review compatibility and apply the supported conversion operation for the external Delta table.
D:When a tag-driven ABAC mask was changed, and the security team needs to confirm its effect on analysts and exempt staff, “Query the protected table under authorized test principals after policy change, allowing documented propagation time” could be relevant. Review compatibility and apply the supported conversion operation for the external Delta table.
Question 527
A data team must move a qualifying UC external Delta table into Databricks-managed storage. Which observation best proves the workload meets its requirement?
- A regular analyst sees masked identifiers while an approved clinical role sees authorized values.
- New-group users receive the intended redaction while exempt principals are unaffected per policy.
- The audit reveals applicable inherited masking and row-filter policies and their origins.
- The catalog records a managed table, the data remains queryable and ownership semantics are verified.
Explanation
Correct Answer
D:The catalog records a managed table, the data remains queryable and ownership semantics are verified.
Incorrect Answers
A:If a clinical data table contains patient identifiers but analysts should see masked values while retaining aggregate use, “A regular analyst sees masked identifiers while an approved clinical role sees authorized values” may be the appropriate response. The catalog records a managed table, the data remains queryable and ownership semantics are verified.
B:A new group is admitted to a masked analytics view and controls must still enforce least privilege. In those circumstances, “New-group users receive the intended redaction while exempt principals are unaffected per policy” fits. The catalog records a managed table, the data remains queryable and ownership semantics are verified.
C:When an auditor needs to understand which inherited ABAC policies actually apply to a newly tagged table, “The audit reveals applicable inherited masking and row-filter policies and their origins” could be relevant. The catalog records a managed table, the data remains queryable and ownership semantics are verified.
Question 528
A data team must move a qualifying UC external Delta table into Databricks-managed storage. The team observes: A rename is treated as conversion, but external storage ownership stays unchanged. Which underlying cause most directly explains this failure?
- The sensitive column lacks an effective mask for that principal.
- A stale group or object-level grant remains effective.
- The team changed the table name instead of running the supported conversion workflow.
- Overbroad MODIFY or ownership privileges were granted instead of least privilege.
Explanation
Correct Answer
C:The team changed the table name instead of running the supported conversion workflow. Review compatibility and apply the supported conversion operation for the external Delta table.
Incorrect Answers
A:A clinical data table contains patient identifiers but analysts should see masked values while retaining aggregate use. In those circumstances, “The sensitive column lacks an effective mask for that principal” fits. The team changed the table name instead of running the supported conversion workflow.
B:When a departed contractor still has an inherited query privilege on a restricted data table, “A stale group or object-level grant remains effective” could be relevant. The team changed the table name instead of running the supported conversion workflow.
D:An analyst group should read a production customer table but must not modify it. In those circumstances, “Overbroad MODIFY or ownership privileges were granted instead of least privilege” fits. The team changed the table name instead of running the supported conversion workflow.
Question 529
A managed table needs a schema change to add an optional reporting column while retaining existing rows. Which design choice best addresses the stated business and technical requirement?
- Evaluate an explicit supported DENY control and its current limitations before claiming an override.
- Apply an explicit supported ALTER TABLE schema change on the governed table.
- Combine appropriate column mask and row filter controls without replacing the underlying source dataset.
- Assign object ownership or a narrowly appropriate MANAGE privilege rather than general content-edit rights.
Explanation
Correct Answer
B:Apply an explicit supported ALTER TABLE schema change on the governed table. Existing records remain accessible and the new column is visible with nulls where expected.
Incorrect Answers
A:When a highly restricted catalog must prevent a temporary group from seeing specified records despite broad organizational grants, “Evaluate an explicit supported DENY control and its current limitations before claiming an override” could be relevant. Apply an explicit supported ALTER TABLE schema change on the governed table.
C:A regulated table needs both redaction of tax IDs and exclusion of unauthorized region rows. In those circumstances, “Combine appropriate column mask and row filter controls without replacing the underlying source dataset” fits. Apply an explicit supported ALTER TABLE schema change on the governed table.
D: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. Apply an explicit supported ALTER TABLE schema change on the governed table.
Question 530
A managed table needs a schema change to add an optional reporting column while retaining existing rows. Which setup step most directly realizes the proposed design?
- Define the policy at eligible scopes with the required UDF or expression, tag condition and principals.
- Use eligible serverless or supported Databricks Runtime and fine-grained access settings as required.
- Add the nullable column through approved DDL and update downstream consumers.
- Configure the delegated management permission and verify the steward can administer grants.
Explanation
Correct Answer
C:Add the nullable column through approved DDL and update downstream consumers. Existing records remain accessible and the new column is visible with nulls where expected.
Incorrect Answers
A:If a security policy should restrict rows according to a governed region tag across multiple catalogs where supported, “Define the policy at eligible scopes with the required UDF or expression, tag condition and principals” may be the appropriate response. Add the nullable column through approved DDL and update downstream consumers.
B:An ABAC policy appears configured, but a job running an old cluster runtime cannot query its protected table. In those circumstances, “Use eligible serverless or supported Databricks Runtime and fine-grained access settings as required” fits. Add the nullable column through approved DDL and update downstream consumers.
D: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. Add the nullable column through approved DDL and update downstream consumers.
Certified Data Engineer Associate Practice Tests