Noos
PT EN
RAN-DBDEA-00107
Ranvier · DBDEA

Exam DBDEA Topics: governance Difficulty: easy

A governance engineer is onboarding a new analytics team to the lakehouse. The team's group, finance_analysts, must be allowed to read rows from the table analytics.finance.invoices, and the engineer wants to apply the grant with SQL in a notebook rather than through Catalog Explorer. Which statement uses the correct Databricks SQL syntax?

Options (Reading Mode) Click to filter discussion →
  1. A. GRANT SELECT TO finance_analysts ON TABLE analytics.finance.invoices;
  2. B. GRANT READ ON TABLE analytics.finance.invoices TO finance_analysts;
  3. C. GRANT SELECT ON TABLE analytics.finance.invoices FROM finance_analysts;
  4. D. GRANT SELECT ON TABLE analytics.finance.invoices TO finance_analysts;
Reveal answer

Correct answer: GRANT SELECT ON TABLE analytics.finance.invoices TO finance_analysts;

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): GRANT SELECT ON TABLE analytics.finance.invoices TO finance_analysts;

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.