Snowflake
ADA-C01 · Question #62
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…
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
How the community answered
(25 responses)- A16% (4)
- B72% (18)
- C4% (1)
- D8% (2)
Community Discussion
No community discussion yet for this question.