SOL-C01 · Question #270
A Snowflake table 'CUSTOMER DATA' contains Personally Identifiable Information (PII). You need to mask the 'EMAIL' column for users with the 'ANALYST' role, while allowing users with the 'DATA SCIENTI
Sign in or unlock SOL-C01 to reveal the answer and full explanation for question #270. The question stem and answer options stay visible for context.
Question
A Snowflake table 'CUSTOMER DATA' contains Personally Identifiable Information (PII). You need to mask the 'EMAIL' column for users with the 'ANALYST' role, while allowing users with the 'DATA SCIENTIST role to view the unmasked data. Assuming both roles already exist, which of the following Snowflake features, in combination, would BEST accomplish this?
Options
- ADynamic Data Masking and Row-Level Security.
- BExternal Tables and Secure Views.
- CDynamic Data Masking and Column-Level Security.
- DData Encryption and Network Policies.
- ETransient Tables and User-Defined Functions.
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.