Databricks-GenAI-Assoc Governance Practice Question
A generative AI team stores prompt/response logs in a Unity Catalog Delta table named `main.genai.interaction_logs`. Compliance requires that the raw `prompt_text` column be readable only by members of the `ai_compliance` group, while all other users querying the table must see the literal string `REDACTED`. Which Unity Catalog feature should be implemented directly on the table to satisfy this requirement without creating a separate view?
⚠ Common exam trap
Many exam-takers confuse row-level filtering, which removes rows, with column-level masking, which rewrites values for the same rows.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Column mask
Column masks are the Unity Catalog mechanism designed to transform individual column values based on the caller's group membership while leaving the table itself queryable by everyone. Binding a mask function to prompt_text that checks is_account_group_member('ai_compliance') gives compliance staff the raw text and returns REDACTED to all other users, meeting the requirement on the existing table.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Row filter
Why it's wrong here
A row filter controls which rows are returned based on a predicate, not which column values are shown. If applied here, non-compliance users would either see full prompt_text on the rows they can access or lose rows entirely, which does not meet the requirement that all users still query the table and see a redacted placeholder in that column.
- ✗
Dynamic view with a CASE expression
Why it's wrong here
A dynamic view can implement conditional redaction, but the scenario explicitly asks for the behavior to be applied directly on the table without creating a separate view. Requiring consumers to switch to a new view name also breaks existing queries, so this does not satisfy the stated constraint even though it is a valid masking pattern.
- ✓
Column mask
Why this is correct
A column mask is a Unity Catalog function bound to a column that evaluates the invoking user's identity and returns either the real value or a substituted value. Applying it to prompt_text with a CASE on is_account_group_member('ai_compliance') makes compliance users see raw text and everyone else see REDACTED, exactly as required, while keeping a single table.
- ✗
Attribute-based access control tag
Why it's wrong here
Tags in Unity Catalog are metadata labels used for classification, discovery, and for driving policies in some engines, but a tag alone does not rewrite column values at query time. Tagging prompt_text as sensitive would not cause non-compliance users to receive REDACTED, so the literal masking behavior demanded by the scenario would not occur.
About these practice questions
This Databricks-GenAI-Assoc question is part of Courseiva's 330-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam dumps. Learn why practice questions differ from exam dumps →
JA
Written and reviewed by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
Last reviewed September 2026 · checked against the official Databricks exam blueprint
This Databricks-GenAI-Assoc practice question is part of Courseiva's free Databricks certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the Databricks-GenAI-Assoc exam.