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?
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.