100% Latest & Updated Databricks Certified Data Engineer Associate Practice Test Questions, Exam Dumps & Verified Answers!
30 Days Free Updates, Instant Download!
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.
Question 561
A new data steward needs authority to delegate access to a governed table while other analysts remain read-only. Which design choice best addresses the stated business and technical requirement?
- Use a documented supported conversion-to-managed workflow after checking prerequisites.
- Design a supported ABAC row-filter policy with managed governed tags and identity conditions.
- Register the dataset as an external table backed by its controlled location.
- Assign object ownership or a narrowly appropriate MANAGE privilege rather than general content-edit rights.
Explanation
Correct Answer
D:Assign object ownership or a narrowly appropriate MANAGE privilege rather than general content-edit rights. The steward manages authorized access while ordinary analysts cannot grant themselves privileges.
Incorrect Answers
A:A data team must move a qualifying UC external Delta table into Databricks-managed storage. In those circumstances, “Use a documented supported conversion-to-managed workflow after checking prerequisites” fits. Assign object ownership or a narrowly appropriate MANAGE privilege rather than general content-edit rights.
B:When 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” could be relevant. Assign object ownership or a narrowly appropriate MANAGE privilege rather than general content-edit rights.
C: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. Assign object ownership or a narrowly appropriate MANAGE privilege rather than general content-edit rights.
Question 562
A new data steward needs authority to delegate access to a governed table while other analysts remain read-only. Which setup step most directly realizes the proposed design?
- Configure the delegated management permission and verify the steward can administer grants.
- Perform an approved change of external table location under supported constraints and verify object access.
- Create an external UC table pointing at the authorized external Delta path with approved permissions.
- Use eligible serverless or supported Databricks Runtime and fine-grained access settings as required.
Explanation
Correct Answer
A:Configure the delegated management permission and verify the steward can administer grants. The steward manages authorized access while ordinary analysts cannot grant themselves privileges.
Incorrect Answers
B: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. Configure the delegated management permission and verify the steward can administer grants.
C: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 delegated management permission and verify the steward can administer grants.
D:When 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” could be relevant. Configure the delegated management permission and verify the steward can administer grants.
Question 563
A new data steward needs authority to delegate access to a governed table while other analysts remain read-only. What is the most relevant verification evidence for this case?
- The table is catalog-governed and dropping it follows the supported managed data lifecycle.
- The audit reveals applicable inherited masking and row-filter policies and their origins.
- The steward manages authorized access while ordinary analysts cannot grant themselves privileges.
- A restricted principal sees permitted rows with masked tax IDs, while an authorized principal sees the intended broader view.
Explanation
Correct Answer
C:The steward manages authorized access while ordinary analysts cannot grant themselves privileges.
Incorrect Answers
A:If a governed table stores regulated transaction records and the organization wants Databricks to manage data-file lifecycle on deletion, “The table is catalog-governed and dropping it follows the supported managed data lifecycle” may be the appropriate response. The steward manages authorized access while ordinary analysts cannot grant themselves privileges.
B:An auditor needs to understand which inherited ABAC policies actually apply to a newly tagged table. In those circumstances, “The audit reveals applicable inherited masking and row-filter policies and their origins” fits. The steward manages authorized access while ordinary analysts cannot grant themselves privileges.
D: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 steward manages authorized access while ordinary analysts cannot grant themselves privileges.
Question 564
A new data steward needs authority to delegate access to a governed table while other analysts remain read-only. The team observes: Every analyst can alter permission grants after onboarding. What is the most likely mechanism behind the observed defect?
- The ABAC predicate relied on tags that were not governed or not matched by the policy.
- Management privileges were granted to the general reader group.
- Managed and external lifecycle ownership were conflated.
- The policy condition or principal scope no longer matches the intended sensitive data.
Explanation
Correct Answer
B:Management privileges were granted to the general reader group. Configure the delegated management permission and verify the steward can administer grants.
Incorrect Answers
A:A security policy should restrict rows according to a governed region tag across multiple catalogs where supported. In those circumstances, “The ABAC predicate relied on tags that were not governed or not matched by the policy” fits. Management privileges were granted to the general reader group.
C: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. Management privileges were granted to the general reader group.
D:A tag-driven ABAC mask was changed, and the security team needs to confirm its effect on analysts and exempt staff. In those circumstances, “The policy condition or principal scope no longer matches the intended sensitive data” fits. Management privileges were granted to the general reader group.
Question 565
A clinical data table contains patient identifiers but analysts should see masked values while retaining aggregate use. Which approach most directly satisfies the requirement?
- Use column masking based on analyst identity or governed policy rather than copying plaintext to every report.
- Register the dataset as an external table backed by its controlled location.
- Validate the external LOCATION and all storage credentials before modifying table metadata.
- Grant only required usage and SELECT privileges to the group on the intended securables.
Explanation
Correct Answer
A:Use column masking based on analyst identity or governed policy rather than copying plaintext to every report. A regular analyst sees masked identifiers while an approved clinical role sees authorized values.
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. Use column masking based on analyst identity or governed policy rather than copying plaintext to every report.
C:An external table moved to a new permitted storage directory and the registration must refer to correct data. In those circumstances, “Validate the external LOCATION and all storage credentials before modifying table metadata” fits. Use column masking based on analyst identity or governed policy rather than copying plaintext to every report.
D:When 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” could be relevant. Use column masking based on analyst identity or governed policy rather than copying plaintext to every report.
Question 566
A clinical data table contains patient identifiers but analysts should see masked values while retaining aggregate use. Which configuration or engineering action would most directly implement the requirement?
- Create the table as managed under the approved catalog and schema without a separate LOCATION path.
- Configure catalog and schema USE plus table SELECT where required, avoiding MODIFY and ALL PRIVILEGES.
- Create the three-level named table with the supported Delta format and managed/external choice.
- Define the supported masking function/policy for the sensitive column and authorized principals.
Explanation
Correct Answer
D:Define the supported masking function/policy for the sensitive column and authorized principals. A regular analyst sees masked identifiers while an approved clinical role sees authorized values.
Incorrect Answers
A:If 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” may be the appropriate response. Define the supported masking function/policy for the sensitive column and authorized principals.
B:An analyst group should read a production customer table but must not modify it. In those circumstances, “Configure catalog and schema USE plus table SELECT where required, avoiding MODIFY and ALL PRIVILEGES” fits. Define the supported masking function/policy for the sensitive column and authorized principals.
C:When a finance team wants to create a Delta table and retain queryable schema history across routine updates, “Create the three-level named table with the supported Delta format and managed/external choice” could be relevant. Define the supported masking function/policy for the sensitive column and authorized principals.
Question 567
A clinical data table contains patient identifiers but analysts should see masked values while retaining aggregate use. Which test would establish that the change worked as intended?
- A regular analyst sees masked identifiers while an approved clinical role sees authorized values.
- Access tests show that the restricted principal is denied while intended groups retain access.
- Existing records remain accessible and the new column is visible with nulls where expected.
- The catalog records a managed table, the data remains queryable and ownership semantics are verified.
Explanation
Correct Answer
A:A regular analyst sees masked identifiers while an approved clinical role sees authorized values.
Incorrect Answers
B:When 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” could be relevant. A regular analyst sees masked identifiers while an approved clinical role sees authorized values.
C: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 regular analyst sees masked identifiers while an approved clinical role sees authorized values.
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. A regular analyst sees masked identifiers while an approved clinical role sees authorized values.
Question 568
A clinical data table contains patient identifiers but analysts should see masked values while retaining aggregate use. The team observes: An ordinary analyst receives unmasked patient identifiers. Which configuration or design gap best explains the symptom?
- The job depended on personal credentials and grants.
- The table was created with an external location rather than as a managed table.
- The sensitive column lacks an effective mask for that principal.
- The intended explicit restriction was not applied through a supported enforcement path.
Explanation
Correct Answer
C:The sensitive column lacks an effective mask for that principal. Define the supported masking function/policy for the sensitive column and authorized principals.
Incorrect Answers
A:When a production integration needs machine-to-machine access without using a personal engineer login, “The job depended on personal credentials and grants” could be relevant. The sensitive column lacks an effective mask for that principal.
B: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 sensitive column lacks an effective mask for that principal.
D: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 sensitive column lacks an effective mask for that principal.
Question 569
A multi-tenant orders table stores tenant_id and each customer team may read only its tenant rows. Which architecture or engineering decision best fits this scenario?
- Use a documented supported conversion-to-managed workflow after checking prerequisites.
- Apply an explicit supported ALTER TABLE schema change on the governed table.
- Document and test the different metadata and data-lifecycle semantics on a disposable dataset.
- Apply a supported row filter that uses the querying identity's authorized tenant mapping.
Explanation
Correct Answer
D:Apply a supported row filter that uses the querying identity's authorized tenant mapping. Two distinct tenant users each see only their own rows through the same query.
Incorrect Answers
A:If 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” may be the appropriate response. Apply a supported row filter that uses the querying identity's authorized tenant mapping.
B: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. Apply a supported row filter that uses the querying identity's authorized tenant mapping.
C: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. Apply a supported row filter that uses the querying identity's authorized tenant mapping.
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.
Certified Data Engineer Associate Practice Tests