SOL-C01 · Question #246
You have a Snowflake table named CUSTOMER DATA' with columns CUSTOMER ID', NAME, 'CITY, and 'TRANSACTION DATE. You need to implement a data masking policy that masks the 'NAME column for all users exc
Sign in or unlock SOL-C01 to reveal the answer and full explanation for question #246. The question stem and answer options stay visible for context.
Question
You have a Snowflake table named CUSTOMER DATA' with columns CUSTOMER ID', NAME, 'CITY, and 'TRANSACTION DATE. You need to implement a data masking policy that masks the 'NAME column for all users except those with the 'ACCOUNTADMIN' role. Additionally, you want to implement a row-level security policy that filters the data based on the CITY column, allowing users with the 'CITY MANAGER role to only see data for their assigned city. How would you implement these policies?
Options
- ACreate a masking policy for the `NAME' column using a CASE statement that checks the
- BCreate a view on top of the 'CUSTOMER_DATA' table and implement the masking and row-level
- CCreate a masking policy using regular expressions to filter the data. Create a stored procedure to
- DCreate masking policy using the 'TRANSFORM' function to mask the 'NAME' column, and create a
- ECreate a stored procedure with 'EXECUTE AS OWNER to filter the data based on the 'CITY
Unlock SOL-C01 to see the answer
You've previewed enough free SOL-C01 questions. Unlock SOL-C01 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.