Valid SOL-C01 Dumps shared by ExamDiscuss.com for Helping Passing SOL-C01 Exam! ExamDiscuss.com now offer the newest SOL-C01 exam dumps, the ExamDiscuss.com SOL-C01 exam questions have been updated and answers have been corrected get the newest ExamDiscuss.com SOL-C01 dumps with Test Engine here:
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?
Correct Answer: A,D
Options A and D correctly implements masking and row-level security. Option A utilizes masking policy for the 'NAME column that considers the `ACCOUNTADMIN' role. And utilizes a row-level security policy (row access policy) that consider 'CITY_MANAGER and 'CITY' for filtering. Option D utilizes `TRANSFORM' to transform and mask the 'NAME' column and implements row access policy which includes Mapping table between CITY and CITY_MANAGER. Option B,C, and E are incorrect as they either create a view, stored procedure and/or regular expressions, which are not the best practices of implementing masking and row-level security in Snowflake.