100% Latest & Updated Databricks Certified Data Engineer Associate Practice Test Questions, Exam Dumps & Verified Answers!
30 Days Free Updates, Instant Download!
Question 570
A multi-tenant orders table stores tenant_id and each customer team may read only its tenant rows. Which implementation step is most appropriate before production use?
- Create an external UC table pointing at the authorized external Delta path with approved permissions.
- Use the supported REVOKE operation and review effective permissions through the hierarchy.
- Review and add only the missing usage privilege at the correct parent level.
- Configure the row-filter function and attach it at the appropriate securable scope.
Explanation
Correct Answer
D:Configure the row-filter function and attach it at the appropriate securable scope. Two distinct tenant users each see only their own rows through the same query.
Incorrect Answers
A:An organization has existing Delta files owned by an external data steward that Databricks must not delete. In those circumstances, “Create an external UC table pointing at the authorized external Delta path with approved permissions” fits. Configure the row-filter function and attach it at the appropriate securable scope.
B: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. Configure the row-filter function and attach it at the appropriate securable scope.
C:If 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” may be the appropriate response. Configure the row-filter function and attach it at the appropriate securable scope.
Question 571
A multi-tenant orders table stores tenant_id and each customer team may read only its tenant rows. Which acceptance test provides the strongest evidence that the intended outcome has been achieved?
- The contractor's access test fails while current authorized roles still succeed.
- Two distinct tenant users each see only their own rows through the same query.
- Queries read the correct new data path with unchanged authorized access scope.
- Dropping the table metadata leaves underlying externally owned files under their independent lifecycle.
Explanation
Correct Answer
B:Two distinct tenant users each see only their own rows through the same query.
Incorrect Answers
A:When a departed contractor still has an inherited query privilege on a restricted data table, “The contractor's access test fails while current authorized roles still succeed” could be relevant. Two distinct tenant users each see only their own rows through the same query.
C: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. Two distinct tenant users each see only their own rows through the same query.
D:When an organization has existing Delta files owned by an external data steward that Databricks must not delete, “Dropping the table metadata leaves underlying externally owned files under their independent lifecycle” could be relevant. Two distinct tenant users each see only their own rows through the same query.
Question 572
A multi-tenant orders table stores tenant_id and each customer team may read only its tenant rows. The team observes: A user sees another customer's orders despite read-only table grants. Which root cause should be addressed first given this evidence?
- The data was never registered in the required UC catalog and schema.
- The team changed the table name instead of running the supported conversion workflow.
- Overbroad MODIFY or ownership privileges were granted instead of least privilege.
- A row-level authorization filter was absent or matched the wrong identity.
Explanation
Correct Answer
D:A row-level authorization filter was absent or matched the wrong identity. Configure the row-filter function and attach it at the appropriate securable scope.
Incorrect Answers
A:If a finance team wants to create a Delta table and retain queryable schema history across routine updates, “The data was never registered in the required UC catalog and schema” may be the appropriate response. A row-level authorization filter was absent or matched the wrong identity.
B:A data team must move a qualifying UC external Delta table into Databricks-managed storage. In those circumstances, “The team changed the table name instead of running the supported conversion workflow” fits. A row-level authorization filter was absent or matched the wrong identity.
C:When an analyst group should read a production customer table but must not modify it, “Overbroad MODIFY or ownership privileges were granted instead of least privilege” could be relevant. A row-level authorization filter was absent or matched the wrong identity.
Question 573
A regulated table needs both redaction of tax IDs and exclusion of unauthorized region rows. Which technical design is most appropriate for the stated constraint?
- Apply an explicit supported ALTER TABLE schema change on the governed table.
- Evaluate an explicit supported DENY control and its current limitations before claiming an override.
- Combine appropriate column mask and row filter controls without replacing the underlying source dataset.
- Check parent USE CATALOG and USE SCHEMA authorization alongside table SELECT.
Explanation
Correct Answer
C:Combine appropriate column mask and row filter controls without replacing the underlying source dataset. A restricted principal sees permitted rows with masked tax IDs, while an authorized principal sees the intended broader view.
Incorrect Answers
A:A managed table needs a schema change to add an optional reporting column while retaining existing rows. In those circumstances, “Apply an explicit supported ALTER TABLE schema change on the governed table” fits. Combine appropriate column mask and row filter controls without replacing the underlying source dataset.
B: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. Combine appropriate column mask and row filter controls without replacing the underlying source dataset.
D:A team grants SELECT on a table but receives a missing privilege error traversing its catalog. In those circumstances, “Check parent USE CATALOG and USE SCHEMA authorization alongside table SELECT” fits. Combine appropriate column mask and row filter controls without replacing the underlying source dataset.
Question 574
A regulated table needs both redaction of tax IDs and exclusion of unauthorized region rows. Which action should the engineer perform to establish the intended control?
- Create the table as managed under the approved catalog and schema without a separate LOCATION path.
- Review compatibility and apply the supported conversion operation for the external Delta table.
- Apply the permitted denial configuration where supported and test effective permissions for the target group.
- Configure supported masking and filtering functions or policies with proper privileges and execution support.
Explanation
Correct Answer
D:Configure supported masking and filtering functions or policies with proper privileges and execution support. A restricted principal sees permitted rows with masked tax IDs, while an authorized principal sees the intended broader view.
Incorrect Answers
A:When a governed table stores regulated transaction records and the organization wants Databricks to manage data-file lifecycle on deletion, “Create the table as managed under the approved catalog and schema without a separate LOCATION path” could be relevant. Configure supported masking and filtering functions or policies with proper privileges and execution support.
B: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. Configure supported masking and filtering functions or policies with proper privileges and execution support.
C:A highly restricted catalog must prevent a temporary group from seeing specified records despite broad organizational grants. In those circumstances, “Apply the permitted denial configuration where supported and test effective permissions for the target group” fits. Configure supported masking and filtering functions or policies with proper privileges and execution support.
Question 575
A regulated table needs both redaction of tax IDs and exclusion of unauthorized region rows. Which observation best proves the workload meets its requirement?
- Existing records remain accessible and the new column is visible with nulls where expected.
- An analyst can SELECT but cannot UPDATE or DELETE the protected table.
- A restricted principal sees permitted rows with masked tax IDs, while an authorized principal sees the intended broader view.
- Access tests show that the restricted principal is denied while intended groups retain access.
Explanation
Correct Answer
C:A restricted principal sees permitted rows with masked tax IDs, while an authorized principal sees the intended broader view.
Incorrect Answers
A:If a managed table needs a schema change to add an optional reporting column while retaining existing rows, “Existing records remain accessible and the new column is visible with nulls where expected” may be the appropriate response. A restricted principal sees permitted rows with masked tax IDs, while an authorized principal sees the intended broader view.
B: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. A restricted principal sees permitted rows with masked tax IDs, while an authorized principal sees the intended broader view.
D:If a highly restricted catalog must prevent a temporary group from seeing specified records despite broad organizational grants, “Access tests show that the restricted principal is denied while intended groups retain access” may be the appropriate response. A restricted principal sees permitted rows with masked tax IDs, while an authorized principal sees the intended broader view.
Question 576
A regulated table needs both redaction of tax IDs and exclusion of unauthorized region rows. The team observes: Sensitive tax IDs are hidden but records from forbidden regions remain visible. Which underlying cause most directly explains this failure?
- The deployment applied column masking but omitted row filtering.
- Managed and external lifecycle ownership were conflated.
- One of the needed parent namespace usage permissions is absent.
- The intended explicit restriction was not applied through a supported enforcement path.
Explanation
Correct Answer
A:The deployment applied column masking but omitted row filtering. Configure supported masking and filtering functions or policies with proper privileges and execution support.
Incorrect Answers
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 deployment applied column masking but omitted row filtering.
C: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 deployment applied column masking but omitted row filtering.
D: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 deployment applied column masking but omitted row filtering.
Question 577
A new group is admitted to a masked analytics view and controls must still enforce least privilege. Which design choice best addresses the stated business and technical requirement?
- Use a Unity Catalog managed Delta table when platform-managed storage lifecycle is required.
- Grant only required usage and SELECT privileges to the group on the intended securables.
- Register the appropriate governed Delta table rather than using untracked raw CSV objects.
- Verify policy behavior using identities from both the new group and an exempt approved role.
Explanation
Correct Answer
D:Verify policy behavior using identities from both the new group and an exempt approved role. New-group users receive the intended redaction while exempt principals are unaffected per policy.
Incorrect Answers
A:When a governed table stores regulated transaction records and the organization wants Databricks to manage data-file lifecycle on deletion, “Use a Unity Catalog managed Delta table when platform-managed storage lifecycle is required” could be relevant. Verify policy behavior using identities from both the new group and an exempt approved role.
B:If an analyst group should read a production customer table but must not modify it, “Grant only required usage and SELECT privileges to the group on the intended securables” may be the appropriate response. Verify policy behavior using identities from both the new group and an exempt approved role.
C:A finance team wants to create a Delta table and retain queryable schema history across routine updates. In those circumstances, “Register the appropriate governed Delta table rather than using untracked raw CSV objects” fits. Verify policy behavior using identities from both the new group and an exempt approved role.
Question 578
A new group is admitted to a masked analytics view and controls must still enforce least privilege. Which setup step most directly realizes the proposed design?
- Run authorized positive/negative test queries and inspect actual masked and filtered output.
- Configure service-principal access and scope the UC grants required for its job.
- Configure catalog and schema USE plus table SELECT where required, avoiding MODIFY and ALL PRIVILEGES.
- Review compatibility and apply the supported conversion operation for the external Delta table.
Explanation
Correct Answer
A:Run authorized positive/negative test queries and inspect actual masked and filtered output. New-group users receive the intended redaction while exempt principals are unaffected per policy.
Incorrect Answers
B:A production integration needs machine-to-machine access without using a personal engineer login. In those circumstances, “Configure service-principal access and scope the UC grants required for its job” fits. Run authorized positive/negative test queries and inspect actual masked and filtered output.
C:When an analyst group should read a production customer table but must not modify it, “Configure catalog and schema USE plus table SELECT where required, avoiding MODIFY and ALL PRIVILEGES” could be relevant. Run authorized positive/negative test queries and inspect actual masked and filtered output.
D: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. Run authorized positive/negative test queries and inspect actual masked and filtered output.
Question 579
A new group is admitted to a masked analytics view and controls must still enforce least privilege. What is the most relevant verification evidence for this case?
- The table is catalog-governed and dropping it follows the supported managed data lifecycle.
- Queries read the correct new data path with unchanged authorized access scope.
- New-group users receive the intended redaction while exempt principals are unaffected per policy.
- The catalog records a managed table, the data remains queryable and ownership semantics are verified.
Explanation
Correct Answer
C:New-group users receive the intended redaction while exempt principals are unaffected per policy.
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, “The table is catalog-governed and dropping it follows the supported managed data lifecycle” fits. New-group users receive the intended redaction while exempt principals are unaffected per policy.
B:When an external table moved to a new permitted storage directory and the registration must refer to correct data, “Queries read the correct new data path with unchanged authorized access scope” could be relevant. New-group users receive the intended redaction while exempt principals are unaffected per policy.
D:A data team must move a qualifying UC external Delta table into Databricks-managed storage. In those circumstances, “The catalog records a managed table, the data remains queryable and ownership semantics are verified” fits. New-group users receive the intended redaction while exempt principals are unaffected per policy.
Question 580
A new group is admitted to a masked analytics view and controls must still enforce least privilege. The team observes: Both groups see full unmasked data after a permission change. What is the most likely mechanism behind the observed defect?
- The effective filtering or masking policy is not attached or scoped correctly.
- The operator used destructive replacement rather than a supported schema alteration.
- Overbroad MODIFY or ownership privileges were granted instead of least privilege.
- The team changed the table name instead of running the supported conversion workflow.
Explanation
Correct Answer
A:The effective filtering or masking policy is not attached or scoped correctly. Run authorized positive/negative test queries and inspect actual masked and filtered output.
Incorrect Answers
B:If a managed table needs a schema change to add an optional reporting column while retaining existing rows, “The operator used destructive replacement rather than a supported schema alteration” may be the appropriate response. The effective filtering or masking policy is not attached or scoped correctly.
C: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 effective filtering or masking policy is not attached or scoped correctly.
D:When a data team must move a qualifying UC external Delta table into Databricks-managed storage, “The team changed the table name instead of running the supported conversion workflow” could be relevant. The effective filtering or masking policy is not attached or scoped correctly.
Certified Data Engineer Associate Practice Tests