A data engineer creates a column mask for the salary column on an HR table. The mask should return NULL for all users who are NOT members of the hr_analysts account-level group. Which SQL function should be used inside the masking function body to check account group membership?
is_member('hr_analysts')has_privilege('hr_analysts', 'SELECT')is_account_group_member('hr_analysts')array_contains(current_user_groups(), 'hr_analysts')More Ensuring Data Security and Compliance Questions
20 questions
Full Databricks Certified Data Engineer Professional Practice Test
All topics covered
All Databricks Certified Data Engineer Professional Questions
Browse by topic
Related Questions
What is the correct three-level namespace for referencing a table in Unity Catalog?...
A data team needs to ensure that users outside the `finance_admin` group see only the last 4 digits ...
A company has a single large orders table in Unity Catalog shared across regional business units. Ea...
Why are service principals preferred over personal access tokens (PATs) from a user account for auto...
In Unity Catalog, what is the difference between a managed table and an external table with respect ...
Educational Content — CertQnA practice questions are written against official exam objectives, covering the same domains tested on the real exam. All content is original and independent — not actual exam questions, not affiliated with any certification vendor. Learn more about our content policy
Discussion
Be the first to share your understanding of this concept
Sign in to join the discussion