Snowflake
ADA-C01 · Question #62
ADA-C01 Question #62: Real Exam Question with Answer & Explanation
The correct answer is B. The consumer account will only see asterisks in the cc_num column, regardless of which role is. See the full explanation below for the reasoning.
Question
A table has a dynamic data masking policy defined on its cc_num column. The masking policy allows the role SECURE_ROLE to view the credit card number; all other roles will see just a series of asterisks. What will happen if a Snowflake Administrator shares this table with another Snowflake account?
Options
- AIf the consumer account has a role named SECURE_ROLE, only that role will be able to see the
- BThe consumer account will only see asterisks in the cc_num column, regardless of which role is
- CThe Administrator cannot share a table that has a dynamic data masking policy applied to one of
- DAny queries against the table will completely omit the cc_num column from the result set that is
Community Discussion
No community discussion yet for this question.