Noos
PT EN
RAN-DBDEA-00175
Ranvier · DBDEA

Exam DBDEA Topics: governance Difficulty: medium

A nightly Lakeflow Job runs under the service principal loader-sp and writes report files into the Unity Catalog volume main.ops.drop_zone. The job's identity already has USE CATALOG on main and USE SCHEMA on ops. Which grant should an administrator apply so that the pipeline can write its files into the volume?

Options (Reading Mode) Click to filter discussion →
  1. A. GRANT SELECT ON VOLUME main.ops.drop_zone TO `loader-sp`, since SELECT is the privilege that controls reads and writes on volumes.
  2. B. GRANT ALL PRIVILEGES ON CATALOG main TO `loader-sp`, which is the least-privilege grant that still enables the file writes.
  3. C. GRANT WRITE VOLUME ON VOLUME main.ops.drop_zone TO `loader-sp`, the Unity Catalog privilege that authorizes writing files in a volume.
  4. D. GRANT nothing at all, because volumes automatically inherit their access rules from the storage credential backing them.
Reveal answer

Correct answer: GRANT WRITE VOLUME ON VOLUME main.ops.drop_zone TO `loader-sp`, the Unity Catalog privilege that authorizes writing files in a volume.

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 (C): GRANT WRITE VOLUME ON VOLUME main.ops.drop_zone TO `loader-sp`, the Unity Catalog privilege that authorizes writing files in a volume.

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.