What is a common approach to test row filters for different user groups?

Using the SET USER statement to simulate different users

Disabling the filter temporarily

A retail company has a table 'sales' with a column 'customer_email'. You have created a masking policy 'mask_email'. You need to apply this policy to the 'customer_email' column so that only the sales team sees the full email. Which SQL statement should you use?

APPLY MASKING POLICY mask_email TO TABLE sales COLUMN customer_email;

ALTER TABLE sales SET MASKING POLICY mask_email ON customer_email;

ALTER TABLE sales ALTER COLUMN customer_email SET MASKING POLICY mask_email;

CREATE MASKING POLICY mask_email ON sales(customer_email);

In a masking policy definition, what does the function typically use to decide whether to mask a value?

The user's group membership or other user attributes

Which use case is best suited for column-level masking?

Hiding specific sensitive columns, such as email addresses, from certain user groups

Preventing users from seeing entire rows of a table

Limiting the number of rows returned in a query

Encrypting the entire table to meet compliance requirements

DatabricksCertified Data Engineer Associate

Domain 7Objective 3

Understand Column-Level Masking and Row-Level Security to Restrict Data Visibility Based on User Groups. DATA-ENGINEER-ASSOCIATE Practice Questions (Page 3)

Part of the Governance and Security domain, which accounts for 15% of the DATA-ENGINEER-ASSOCIATE exam. Databricks does not publish an official question count, but from its 90-minute exam (~35–60 total, ~5–9 in this domain), expect 1–2 from this objective — we provide 20 practice questions to prepare you well beyond it. (estimate)

20questions here

4free pages

10concepts

15%of the exam

Questions 11–15

11foundation · easy
What is a common approach to test row filters for different user groups?
Select an answer first
12application · medium
A retail company has a table 'sales' with a column 'customer_email'. You have created a masking policy 'mask_email'. You need to apply this policy to the 'customer_email' column so that only the sales team sees the full email. Which SQL statement should you use?
Select an answer first
13foundation · easy
In a masking policy definition, what does the function typically use to decide whether to mask a value?
Select an answer first
14foundation · easy
What does a row filter function typically return to indicate whether a row is visible?
Select an answer first
15foundation · easy
Which use case is best suited for column-level masking?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to DATA-ENGINEER-ASSOCIATE

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Databricks. “DATA-ENGINEER-ASSOCIATE” is a trademark of its owner, used for identification only.