Snowpro Core · Free Practice Question Medium
Question 32
Which of the following statements about column-level security features in Snowflake is correct?
-
A
Column-level security requires manual masking of data before inserting it into the table.
-
B
Dynamic Data Masking is available starting from the Standard Edition.
-
C
Dynamic Data Masking applies only at query runtime based on the role of the user executing the query.
-
D
External Tokenization replaces the original data values with hashed equivalents that cannot be decrypted.
Reveal correct answer
Correct answer: C
A.
Dynamic Data Masking does not require manual masking of data; it is applied dynamically based on user roles.
B.
Dynamic Data Masking is available starting from the Enterprise Edition, not the Standard Edition.
C.
Dynamic Data Masking in Snowflake occurs at query runtime and depends on the role of the user running the query, ensuring that only authorized users can view sensitive data.
D.
External Tokenization replaces data values with tokens that preserve analytic functionality, but it does not necessarily use irreversible hashing.
Discussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
