exam questions

Exam SnowPro Core All Questions

View all questions & answers for the SnowPro Core exam

Exam SnowPro Core topic 1 question 907 discussion

Actual exam question from Snowflake's SnowPro Core
Question #: 907
Topic #: 1
[All SnowPro Core Questions]

What does a masking policy consist of in Snowflake?

  • A. A single data type, with one or more conditions, and one or more masking functions
  • B. A single data type, with only one condition, and only one masking function
  • C. Multiple data types, with only one condition, and one or more masking functions
  • D. Multiple data types, with one or more conditions, and one or more masking functions
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
ASK_123
Highly Voted 1 year, 1 month ago
Selected Answer: A
A "A masking policy consists of a single data type, one or more conditions, and one or more masking functions." https://docs.snowflake.com/en/user-guide/security-column-intro
upvoted 9 times
...
gizzamo
Most Recent 11 months ago
Selected Answer: A
A masking policy consists of a single data type, one or more conditions, and one or more masking functions. -You can apply the masking policy to one or more table/view columns with the matching data type. For example, you can define a policy for an email address once and apply it to 1000s of email columns across databases and schemas. -Masking policy conditions can be expressed using Conditional Expression Functions and Context Functions or by querying a custom entitlement table. You can use the context functions INVOKER_ROLE and INVOKER_SHARE for use with views and shares, respectively. -Masking functions can be any of the built-in functions (e.g. REGEXP_REPLACE, SHA2 , SHA2_HEX), User-Defined Functions Overview, or Writing External Functions (for de-tokenization using an external tokenization provider).
upvoted 3 times
...
junaid2107
12 months ago
Selected Answer: A
A masking policy consists of a single data type, one or more conditions, and one or more masking functions
upvoted 2 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...