SOL-C01 · Question #270
SOL-C01 Question #270: Real Exam Question with Answer & Explanation
The correct answer is C: Dynamic Data Masking and Column-Level Security.. Dynamic Data Masking is the primary feature for masking sensitive data. Combining it with Column- Level Security (granted via roles) allows you to selectively mask the ` EMAIL' column based on the user's role. Row-Level Security filters rows, not columns. External Tables, Secure
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.
Explanation
Dynamic Data Masking is the primary feature for masking sensitive data. Combining it with Column- Level Security (granted via roles) allows you to selectively mask the ` EMAIL' column based on the user's role. Row-Level Security filters rows, not columns. External Tables, Secure Views, Data Encryption, Network Policies, Transient Tables, and UDFs are not directly relevant to this specific masking requirement.
Topics
Community Discussion
No community discussion yet for this question.