Home / DE Associate practice test / Governance and Security / Question

Databricks Data Engineer Associate · free practice question

A table contains a `ssn` column that must be visible in full only to the `pii_admins` group; everyone else should see it masked. The requirement is to control…

Exam-style question on Governance and Security from the free DE Associate practice test, with the answer and a full explanation below.

Updated November 10, 2026

Governance and Security

A table contains a ssn column that must be visible in full only to the pii_admins group; everyone else should see it masked. The requirement is to control visibility of a single column based on the querying user's group, without maintaining separate copies of the table. Which Unity Catalog feature applies?

  1. AApply a row filter, which is the correct Unity Catalog tool for hiding specific columns such as ssn from certain groups while still returning exactly the same set of rows to every user of the table.
  2. BCreate two physical copies of the table, one fully masked and one unmasked, then grant the unmasked copy to pii_admins and grant the masked copy to everyone else who needs to query the data.
  3. CEncrypt the whole table at rest, which automatically masks the ssn column for non-admin users while leaving it fully readable for members of the privileged pii_admins group who query it.
  4. DApply a column mask, a dynamic masking UDF set on ssn that returns the real value for members of pii_admins and a redacted value for everyone else, all enforced on one single shared table.
  5. EDrop the ssn column from the table, because Unity Catalog does not support column-level access control and there is no supported way to vary a single column's visibility by the querying group.
Answer & explanation

Correct answer: D

WHY D: A column mask applies a UDF that returns the real or redacted value based on the caller's group membership, controlling per-column visibility on a single shared table. WHY NOT A: Row filters restrict which rows are returned, not which columns are masked. WHY NOT B: Maintaining two physical tables is the duplication the requirement forbids. WHY NOT C: At-rest encryption protects storage; it does not conditionally mask a column per user. WHY NOT E: Unity Catalog supports column-level controls, so dropping the column is unnecessary and wrong.

Take the full DE Associate practice test free →

Would you pass today?

This question is one of 45 in the free, timed Databricks Data Engineer Associate practice test. Take it and get a section-by-section score.

Start the free test →