100% Latest & Updated Databricks Certified Data Engineer Associate Practice Test Questions, Exam Dumps & Verified Answers!
30 Days Free Updates, Instant Download!
Question 540
A finance team wants to create a Delta table and retain queryable schema history across routine updates. The team observes: A query points directly at loose CSV objects with no governed table identity. Which root cause should be addressed first given this evidence?
- The data was never registered in the required UC catalog and schema.
- Only per-table controls were used instead of the required centrally scoped ABAC policy.
- A row-level authorization filter was absent or matched the wrong identity.
- One of the needed parent namespace usage permissions is absent.
Explanation
Correct Answer
A:The data was never registered in the required UC catalog and schema. Create the three-level named table with the supported Delta format and managed/external choice.
Incorrect Answers
B:When hundreds of sensitive tables share a governed sensitivity tag and need the same centrally controlled mask, “Only per-table controls were used instead of the required centrally scoped ABAC policy” could be relevant. The data was never registered in the required UC catalog and schema.
C:If a multi-tenant orders table stores tenant_id and each customer team may read only its tenant rows, “A row-level authorization filter was absent or matched the wrong identity” may be the appropriate response. The data was never registered in the required UC catalog and schema.
D:A team grants SELECT on a table but receives a missing privilege error traversing its catalog. In those circumstances, “One of the needed parent namespace usage permissions is absent” fits. The data was never registered in the required UC catalog and schema.
Question 541
An analyst group should read a production customer table but must not modify it. Which technical design is most appropriate for the stated constraint?
- Document and test the different metadata and data-lifecycle semantics on a disposable dataset.
- Register the appropriate governed Delta table rather than using untracked raw CSV objects.
- Use Unity Catalog ABAC governed-tag policies rather than maintaining hundreds of independent table edits.
- Grant only required usage and SELECT privileges to the group on the intended securables.
Explanation
Correct Answer
D:Grant only required usage and SELECT privileges to the group on the intended securables. An analyst can SELECT but cannot UPDATE or DELETE the protected table.
Incorrect Answers
A: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. Grant only required usage and SELECT privileges to the group on the intended securables.
B:If a finance team wants to create a Delta table and retain queryable schema history across routine updates, “Register the appropriate governed Delta table rather than using untracked raw CSV objects” may be the appropriate response. Grant only required usage and SELECT privileges to the group on the intended securables.
C:Hundreds of sensitive tables share a governed sensitivity tag and need the same centrally controlled mask. In those circumstances, “Use Unity Catalog ABAC governed-tag policies rather than maintaining hundreds of independent table edits” fits. Grant only required usage and SELECT privileges to the group on the intended securables.
Question 542
An analyst group should read a production customer table but must not modify it. Which action should the engineer perform to establish the intended control?
- Configure supported masking and filtering functions or policies with proper privileges and execution support.
- Review compatibility and apply the supported conversion operation for the external Delta table.
- Configure catalog and schema USE plus table SELECT where required, avoiding MODIFY and ALL PRIVILEGES.
- Create the supported tag-driven column mask policy at an eligible catalog or schema scope.
Explanation
Correct Answer
C:Configure catalog and schema USE plus table SELECT where required, avoiding MODIFY and ALL PRIVILEGES. An analyst can SELECT but cannot UPDATE or DELETE the protected table.
Incorrect Answers
A:If a regulated table needs both redaction of tax IDs and exclusion of unauthorized region rows, “Configure supported masking and filtering functions or policies with proper privileges and execution support” may be the appropriate response. Configure catalog and schema USE plus table SELECT where required, avoiding MODIFY and ALL PRIVILEGES.
B:A data team must move a qualifying UC external Delta table into Databricks-managed storage. In those circumstances, “Review compatibility and apply the supported conversion operation for the external Delta table” fits. Configure catalog and schema USE plus table SELECT where required, avoiding MODIFY and ALL PRIVILEGES.
D:If hundreds of sensitive tables share a governed sensitivity tag and need the same centrally controlled mask, “Create the supported tag-driven column mask policy at an eligible catalog or schema scope” may be the appropriate response. Configure catalog and schema USE plus table SELECT where required, avoiding MODIFY and ALL PRIVILEGES.
Question 543
An analyst group should read a production customer table but must not modify it. Which observation best proves the workload meets its requirement?
- A newly tagged eligible column is masked for intended users without hand-editing its table definition.
- 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.
- Two distinct tenant users each see only their own rows through the same query.
Explanation
Correct Answer
B:An analyst can SELECT but cannot UPDATE or DELETE the protected table.
Incorrect Answers
A:Hundreds of sensitive tables share a governed sensitivity tag and need the same centrally controlled mask. In those circumstances, “A newly tagged eligible column is masked for intended users without hand-editing its table definition” fits. An analyst can SELECT but cannot UPDATE or DELETE the protected table.
C:If a regulated table needs both redaction of tax IDs and exclusion of unauthorized region rows, “A restricted principal sees permitted rows with masked tax IDs, while an authorized principal sees the intended broader view” may be the appropriate response. An analyst can SELECT but cannot UPDATE or DELETE the protected table.
D: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. An analyst can SELECT but cannot UPDATE or DELETE the protected table.
Question 544
An analyst group should read a production customer table but must not modify it. The team observes: The group can change customer balances although it only needs reports. Which underlying cause most directly explains this failure?
- Overbroad MODIFY or ownership privileges were granted instead of least privilege.
- The dataset had been migrated to managed storage without considering external file ownership.
- The table was created with an external location rather than as a managed table.
- The auditor inspected only direct table-level policies and missed inherited scope policies.
Explanation
Correct Answer
A:Overbroad MODIFY or ownership privileges were granted instead of least privilege. Configure catalog and schema USE plus table SELECT where required, avoiding MODIFY and ALL PRIVILEGES.
Incorrect Answers
B:If 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” may be the appropriate response. Overbroad MODIFY or ownership privileges were granted instead of least privilege.
C:A governed table stores regulated transaction records and the organization wants Databricks to manage data-file lifecycle on deletion. In those circumstances, “The table was created with an external location rather than as a managed table” fits. Overbroad MODIFY or ownership privileges were granted instead of least privilege.
D:When an auditor needs to understand which inherited ABAC policies actually apply to a newly tagged table, “The auditor inspected only direct table-level policies and missed inherited scope policies” could be relevant. Overbroad MODIFY or ownership privileges were granted instead of least privilege.
Question 545
A departed contractor still has an inherited query privilege on a restricted data table. 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.
- Use Unity Catalog ABAC governed-tag policies rather than maintaining hundreds of independent table edits.
- Apply an explicit supported ALTER TABLE schema change on the governed table.
- Revoke the no-longer-authorized privilege from the relevant principal or group membership.
Explanation
Correct Answer
D:Revoke the no-longer-authorized privilege from the relevant principal or group membership. The contractor's access test fails while current authorized roles still succeed.
Incorrect Answers
A:If 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” may be the appropriate response. Revoke the no-longer-authorized privilege from the relevant principal or group membership.
B:Hundreds of sensitive tables share a governed sensitivity tag and need the same centrally controlled mask. In those circumstances, “Use Unity Catalog ABAC governed-tag policies rather than maintaining hundreds of independent table edits” fits. Revoke the no-longer-authorized privilege from the relevant principal or group membership.
C:When a managed table needs a schema change to add an optional reporting column while retaining existing rows, “Apply an explicit supported ALTER TABLE schema change on the governed table” could be relevant. Revoke the no-longer-authorized privilege from the relevant principal or group membership.
Question 546
A departed contractor still has an inherited query privilege on a restricted data table. Which setup step most directly realizes the proposed design?
- Create the supported tag-driven column mask policy at an eligible catalog or schema scope.
- Run authorized positive/negative test queries and inspect actual masked and filtered output.
- Use the supported REVOKE operation and review effective permissions through the hierarchy.
- Review compatibility and apply the supported conversion operation for the external Delta table.
Explanation
Correct Answer
C:Use the supported REVOKE operation and review effective permissions through the hierarchy. The contractor's access test fails while current authorized roles still succeed.
Incorrect Answers
A:Hundreds of sensitive tables share a governed sensitivity tag and need the same centrally controlled mask. In those circumstances, “Create the supported tag-driven column mask policy at an eligible catalog or schema scope” fits. Use the supported REVOKE operation and review effective permissions through the hierarchy.
B:When a new group is admitted to a masked analytics view and controls must still enforce least privilege, “Run authorized positive/negative test queries and inspect actual masked and filtered output” could be relevant. Use the supported REVOKE operation and review effective permissions through the hierarchy.
D:A data team must move a qualifying UC external Delta table into Databricks-managed storage. In those circumstances, “Review compatibility and apply the supported conversion operation for the external Delta table” fits. Use the supported REVOKE operation and review effective permissions through the hierarchy.
Question 547
A departed contractor still has an inherited query privilege on a restricted data table. What is the most relevant verification evidence for this case?
- Authorized users can query table metadata and transactional updates through Unity Catalog.
- The contractor's access test fails while current authorized roles still succeed.
- New-group users receive the intended redaction while exempt principals are unaffected per policy.
- A tagged table enforces the region filter and untagged out-of-scope tables retain their intended behavior.
Explanation
Correct Answer
B:The contractor's access test fails while current authorized roles still succeed.
Incorrect Answers
A:When 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” could be relevant. The contractor's access test fails while current authorized roles still succeed.
C: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 contractor's access test fails while current authorized roles still succeed.
D:When a security policy should restrict rows according to a governed region tag across multiple catalogs where supported, “A tagged table enforces the region filter and untagged out-of-scope tables retain their intended behavior” could be relevant. The contractor's access test fails while current authorized roles still succeed.
Question 548
A departed contractor still has an inherited query privilege on a restricted data table. The team observes: The former contractor still queries sensitive records after account changes. What is the most likely mechanism behind the observed defect?
- The auditor inspected only direct table-level policies and missed inherited scope policies.
- A stale group or object-level grant remains effective.
- The operator used destructive replacement rather than a supported schema alteration.
- The deployment applied column masking but omitted row filtering.
Explanation
Correct Answer
B:A stale group or object-level grant remains effective. Use the supported REVOKE operation and review effective permissions through the hierarchy.
Incorrect Answers
A:If an auditor needs to understand which inherited ABAC policies actually apply to a newly tagged table, “The auditor inspected only direct table-level policies and missed inherited scope policies” may be the appropriate response. A stale group or object-level grant remains effective.
C:When 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” could be relevant. A stale group or object-level grant remains effective.
D:If a regulated table needs both redaction of tax IDs and exclusion of unauthorized region rows, “The deployment applied column masking but omitted row filtering” may be the appropriate response. A stale group or object-level grant remains effective.
Question 549
A production integration needs machine-to-machine access without using a personal engineer login. Which approach most directly satisfies the requirement?
- Apply a supported row filter that uses the querying identity's authorized tenant mapping.
- Use a Unity Catalog managed Delta table when platform-managed storage lifecycle is required.
- Use a least-privileged service principal for the integration identity.
- Use effective-policy inspection rather than listing only policies directly attached to the table.
Explanation
Correct Answer
C:Use a least-privileged service principal for the integration identity. The job authenticates as the service principal and fails to access unrelated catalogs.
Incorrect Answers
A:A multi-tenant orders table stores tenant_id and each customer team may read only its tenant rows. In those circumstances, “Apply a supported row filter that uses the querying identity's authorized tenant mapping” fits. Use a least-privileged service principal for the integration identity.
B: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. Use a least-privileged service principal for the integration identity.
D: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 least-privileged service principal for the integration identity.
Question 550
A production integration needs machine-to-machine access without using a personal engineer login. Which configuration or engineering action would most directly implement the requirement?
- Create disposable examples of both types and inspect data persistence after supported drop operations.
- Create an external UC table pointing at the authorized external Delta path with approved permissions.
- Configure service-principal access and scope the UC grants required for its job.
- Configure supported masking and filtering functions or policies with proper privileges and execution support.
Explanation
Correct Answer
C:Configure service-principal access and scope the UC grants required for its job. The job authenticates as the service principal and fails to access unrelated catalogs.
Incorrect Answers
A:When a security reviewer wants to distinguish the consequences of dropping an external table from dropping a managed one, “Create disposable examples of both types and inspect data persistence after supported drop operations” could be relevant. Configure service-principal access and scope the UC grants required for its job.
B: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. Configure service-principal access and scope the UC grants required for its job.
D:When a regulated table needs both redaction of tax IDs and exclusion of unauthorized region rows, “Configure supported masking and filtering functions or policies with proper privileges and execution support” could be relevant. Configure service-principal access and scope the UC grants required for its job.
Certified Data Engineer Associate Practice Tests