Noos
PT EN
RAN-DBDEA-00112
Ranvier · DBDEA

Exam DBDEA Topics: governance Difficulty: medium

The table main.crm.customers contains the column email (STRING). Only the group pii_viewers should see real email addresses; every other user with SELECT should see ***@***.*** instead. A SQL UDF implements the logic: ```sql CREATE FUNCTION main.sec.mask_email(email STRING) RETURN CASE WHEN is_account_group_member('pii_viewers') THEN email ELSE '***@***.***' END; ``` Which statement correctly applies this function as a column mask on that column?

Options (Reading Mode) Click to filter discussion →
  1. A. ALTER TABLE main.crm.customers SET MASK main.sec.mask_email ON (email);
  2. B. ALTER TABLE main.crm.customers ALTER COLUMN email SET MASK main.sec.mask_email;
  3. C. ALTER TABLE main.crm.customers SET ROW FILTER main.sec.mask_email ON (email);
  4. D. ALTER TABLE main.crm.customers ALTER COLUMN email SET ROW FILTER main.sec.mask_email;
Reveal answer

Correct answer: ALTER TABLE main.crm.customers ALTER COLUMN email SET MASK main.sec.mask_email;

Reference: https://docs.databricks.com/aws/en/data-governance/unity-catalog/filters-and-masks/

Train this exam on Ranvier →

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 (B): ALTER TABLE main.crm.customers ALTER COLUMN email SET MASK main.sec.mask_email;

Ranvier · DBDEA

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.