Noos
PT EN
RAN-DBDEA-00294
Ranvier · DBDEA

Exam DBDEA Topics: governance Difficulty: medium

A contractor's engagement ends today, and the offboarding checklist requires that all access to Unity Catalog data be cut off before the end of the day. An access review confirms that the contractor's privileges on dozens of tables all arrive through membership in three groups; the contractor holds no direct grants. Which action cuts off the contractor's data access completely and verifiably?

Options (Reading Mode) Click to filter discussion →
  1. A. Revoke SELECT from each of the three groups on every table they can currently read, working through the dozens of objects one by one before the end of the day.
  2. B. Wait for the contractor's personal access tokens to expire, which automatically disables the account's data access.
  3. C. Rename the contractor's user account so that sign-in fails, and leave the group memberships and all grants exactly as they are.
  4. D. Remove the contractor from the three groups: every privilege arrived through membership, so this single change cuts off all table access and is auditable.
Reveal answer

Correct answer: Remove the contractor from the three groups: every privilege arrived through membership, so this single change cuts off all table access and is auditable.

Reference: https://docs.databricks.com/aws/en/data-governance/unity-catalog/manage-privileges/

02 — The Myelin Layer · Canonical Discussion

Where the exam tries to trick you — and how those who passed solved it.

0 Passed

contributed to this question

Answer Distractor Matrix Click an option to filter or open its dissection.
✦ Consolidated Synthesis (Wiki) rev. #1 (baseline) · CC BY-SA 4.0
Start synthesis for this question →

No community synthesis consolidated for this question yet. Below is the verifiable official starting point — if you passed the exam, open the option dissection.

Official Answer (D): Remove the contractor from the three groups: every privilege arrived through membership, so this single change cuts off all table access and is auditable.

Contribute to this Question

Your contribution builds your Orbital Sheath

Peer contributions

No public contribution yet. Be the first who passed to explain why the distractors trick candidates — your contribution builds your Orbital Sheath.