100% Latest & Updated Databricks Certified Data Engineer Associate Practice Test Questions, Exam Dumps & Verified Answers!
30 Days Free Updates, Instant Download!
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.
Question 551
A production integration needs machine-to-machine access without using a personal engineer login. Which test would establish that the change worked as intended?
- The catalog records a managed table, the data remains queryable and ownership semantics are verified.
- A regular analyst sees masked identifiers while an approved clinical role sees authorized values.
- A newly tagged eligible column is masked for intended users without hand-editing its table definition.
- The job authenticates as the service principal and fails to access unrelated catalogs.
Explanation
Correct Answer
D:The job authenticates as the service principal and fails to access unrelated catalogs.
Incorrect Answers
A:If 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” may be the appropriate response. The job authenticates as the service principal and fails to access unrelated catalogs.
B:A clinical data table contains patient identifiers but analysts should see masked values while retaining aggregate use. In those circumstances, “A regular analyst sees masked identifiers while an approved clinical role sees authorized values” fits. The job authenticates as the service principal and fails to access unrelated catalogs.
C:When hundreds of sensitive tables share a governed sensitivity tag and need the same centrally controlled mask, “A newly tagged eligible column is masked for intended users without hand-editing its table definition” could be relevant. The job authenticates as the service principal and fails to access unrelated catalogs.
Question 552
A production integration needs machine-to-machine access without using a personal engineer login. The team observes: A developer departure breaks the production ingestion authorization. Which configuration or design gap best explains the symptom?
- Only per-table controls were used instead of the required centrally scoped ABAC policy.
- The job depended on personal credentials and grants.
- The sensitive column lacks an effective mask for that principal.
- The cluster runtime or access mode does not meet ABAC policy requirements.
Explanation
Correct Answer
B:The job depended on personal credentials and grants. Configure service-principal access and scope the UC grants required for its job.
Incorrect Answers
A:Hundreds of sensitive tables share a governed sensitivity tag and need the same centrally controlled mask. In those circumstances, “Only per-table controls were used instead of the required centrally scoped ABAC policy” fits. The job depended on personal credentials and grants.
C: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 job depended on personal credentials and grants.
D:An ABAC policy appears configured, but a job running an old cluster runtime cannot query its protected table. In those circumstances, “The cluster runtime or access mode does not meet ABAC policy requirements” fits. The job depended on personal credentials and grants.
Question 553
A team grants SELECT on a table but receives a missing privilege error traversing its catalog. Which architecture or engineering decision best fits this scenario?
- Check parent USE CATALOG and USE SCHEMA authorization alongside table SELECT.
- Register the dataset as an external table backed by its controlled location.
- Use effective-policy inspection rather than listing only policies directly attached to the table.
- Use a documented supported conversion-to-managed workflow after checking prerequisites.
Explanation
Correct Answer
A:Check parent USE CATALOG and USE SCHEMA authorization alongside table SELECT. The authorized user can access the intended table without obtaining broader edit rights.
Incorrect Answers
B:If an organization has existing Delta files owned by an external data steward that Databricks must not delete, “Register the dataset as an external table backed by its controlled location” may be the appropriate response. Check parent USE CATALOG and USE SCHEMA authorization alongside table SELECT.
C: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. Check parent USE CATALOG and USE SCHEMA authorization alongside table SELECT.
D:When a data team must move a qualifying UC external Delta table into Databricks-managed storage, “Use a documented supported conversion-to-managed workflow after checking prerequisites” could be relevant. Check parent USE CATALOG and USE SCHEMA authorization alongside table SELECT.
Question 554
A team grants SELECT on a table but receives a missing privilege error traversing its catalog. Which implementation step is most appropriate before production use?
- Configure supported masking and filtering functions or policies with proper privileges and execution support.
- Add the nullable column through approved DDL and update downstream consumers.
- Review and add only the missing usage privilege at the correct parent level.
- Define the policy at eligible scopes with the required UDF or expression, tag condition and principals.
Explanation
Correct Answer
C:Review and add only the missing usage privilege at the correct parent level. The authorized user can access the intended table without obtaining broader edit rights.
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. Review and add only the missing usage privilege at the correct parent level.
B: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. Review and add only the missing usage privilege at the correct parent level.
D: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. Review and add only the missing usage privilege at the correct parent level.
Question 555
A team grants SELECT on a table but receives a missing privilege error traversing its catalog. Which acceptance test provides the strongest evidence that the intended outcome has been achieved?
- The catalog records a managed table, the data remains queryable and ownership semantics are verified.
- The authorized user can access the intended table without obtaining broader edit rights.
- A restricted principal sees permitted rows with masked tax IDs, while an authorized principal sees the intended broader view.
- New-group users receive the intended redaction while exempt principals are unaffected per policy.
Explanation
Correct Answer
B:The authorized user can access the intended table without obtaining broader edit rights.
Incorrect Answers
A: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. The authorized user can access the intended table without obtaining broader edit rights.
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. The authorized user can access the intended table without obtaining broader edit rights.
D: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 authorized user can access the intended table without obtaining broader edit rights.
Question 556
A team grants SELECT on a table but receives a missing privilege error traversing its catalog. The team observes: A user cannot resolve the table despite having SELECT on it. Which root cause should be addressed first given this evidence?
- The deployment applied column masking but omitted row filtering.
- A row-level authorization filter was absent or matched the wrong identity.
- One of the needed parent namespace usage permissions is absent.
- The ABAC predicate relied on tags that were not governed or not matched by the policy.
Explanation
Correct Answer
C:One of the needed parent namespace usage permissions is absent. Review and add only the missing usage privilege at the correct parent level.
Incorrect Answers
A: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. One of the needed parent namespace usage permissions is absent.
B: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. One of the needed parent namespace usage permissions is absent.
D:When a security policy should restrict rows according to a governed region tag across multiple catalogs where supported, “The ABAC predicate relied on tags that were not governed or not matched by the policy” could be relevant. One of the needed parent namespace usage permissions is absent.
Question 557
A highly restricted catalog must prevent a temporary group from seeing specified records despite broad organizational grants. Which technical design is most appropriate for the stated constraint?
- Test effective policy evaluation using representative identities and tagged columns.
- Evaluate an explicit supported DENY control and its current limitations before claiming an override.
- Verify policy behavior using identities from both the new group and an exempt approved role.
- Design a supported ABAC row-filter policy with managed governed tags and identity conditions.
Explanation
Correct Answer
B:Evaluate an explicit supported DENY control and its current limitations before claiming an override. Access tests show that the restricted principal is denied while intended groups retain access.
Incorrect Answers
A:If 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” may be the appropriate response. Evaluate an explicit supported DENY control and its current limitations before claiming an override.
C:When a new group is admitted to a masked analytics view and controls must still enforce least privilege, “Verify policy behavior using identities from both the new group and an exempt approved role” could be relevant. Evaluate an explicit supported DENY control and its current limitations before claiming an override.
D:If a security policy should restrict rows according to a governed region tag across multiple catalogs where supported, “Design a supported ABAC row-filter policy with managed governed tags and identity conditions” may be the appropriate response. Evaluate an explicit supported DENY control and its current limitations before claiming an override.
Question 558
A highly restricted catalog must prevent a temporary group from seeing specified records despite broad organizational grants. Which action should the engineer perform to establish the intended control?
- Create an external UC table pointing at the authorized external Delta path with approved permissions.
- Apply the permitted denial configuration where supported and test effective permissions for the target group.
- Use eligible serverless or supported Databricks Runtime and fine-grained access settings as required.
- Create the table as managed under the approved catalog and schema without a separate LOCATION path.
Explanation
Correct Answer
B:Apply the permitted denial configuration where supported and test effective permissions for the target group. Access tests show that the restricted principal is denied while intended groups retain access.
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. Apply the permitted denial configuration where supported and test effective permissions for the target group.
C:If an ABAC policy appears configured, but a job running an old cluster runtime cannot query its protected table, “Use eligible serverless or supported Databricks Runtime and fine-grained access settings as required” may be the appropriate response. Apply the permitted denial configuration where supported and test effective permissions for the target group.
D: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. Apply the permitted denial configuration where supported and test effective permissions for the target group.
Question 559
A highly restricted catalog must prevent a temporary group from seeing specified records despite broad organizational grants. Which observation best proves the workload meets its requirement?
- Access tests show that the restricted principal is denied while intended groups retain access.
- The audit reveals applicable inherited masking and row-filter policies and their origins.
- The external files persist after metadata removal and managed data follows its documented lifecycle.
- The same authorized principal can read governed data on eligible compute while the unsupported runtime is rejected.
Explanation
Correct Answer
A:Access tests show that the restricted principal is denied while intended groups retain access.
Incorrect Answers
B:If 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” may be the appropriate response. Access tests show that the restricted principal is denied while intended groups retain access.
C:A security reviewer wants to distinguish the consequences of dropping an external table from dropping a managed one. In those circumstances, “The external files persist after metadata removal and managed data follows its documented lifecycle” fits. Access tests show that the restricted principal is denied while intended groups retain access.
D:When an ABAC policy appears configured, but a job running an old cluster runtime cannot query its protected table, “The same authorized principal can read governed data on eligible compute while the unsupported runtime is rejected” could be relevant. Access tests show that the restricted principal is denied while intended groups retain access.
Question 560
A highly restricted catalog must prevent a temporary group from seeing specified records despite broad organizational grants. The team observes: A group continues reading sensitive data because a broad inherited grant remains. Which underlying cause most directly explains this failure?
- The intended explicit restriction was not applied through a supported enforcement path.
- The team changed the table name instead of running the supported conversion workflow.
- The table was created with an external location rather than as a managed table.
- Managed and external lifecycle ownership were conflated.
Explanation
Correct Answer
A:The intended explicit restriction was not applied through a supported enforcement path. Apply the permitted denial configuration where supported and test effective permissions for the target group.
Incorrect Answers
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. The intended explicit restriction was not applied through a supported enforcement path.
C:When 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” could be relevant. The intended explicit restriction was not applied through a supported enforcement path.
D:If 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” may be the appropriate response. The intended explicit restriction was not applied through a supported enforcement path.
Certified Data Engineer Associate Practice Tests