SOL-C01 · Question #236
A data analyst needs to query a table named 'ORDERS' which contains sensitive customer information, including email addresses. They only need to access order IDs and order dates for their analysis, bu
Sign in or unlock SOL-C01 to reveal the answer and full explanation for question #236. The question stem and answer options stay visible for context.
Question
A data analyst needs to query a table named 'ORDERS' which contains sensitive customer information, including email addresses. They only need to access order IDs and order dates for their analysis, but they are mistakenly seeing all columns. You, as the Snowflake administrator, need to restrict their access to only the necessary columns without creating a separate table or view. What is the MOST secure and efficient way to achieve this in Snowflake using Row Access Policies and Column Masking Policies? Assume the role 'ANALYST' is already defined.
Options
- ACreate a view on the 'ORDERS' table that selects only the 'ORDER_ID and 'ORDER_DATE
- BGrant the ANALYST role SELECT access to the 'ORDERS' table, and then use 'ALTER TABLE to
- CApply a Row Access Policy that allows only rows with a specific order date, and then grant the
- DApply a Column Masking Policy to the 'EMAIL' column to mask the data (e.g., replace it with
- ECreate a dynamic data masking policy for the `EMAIL' column and a row access policy that only
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.