nerdexam
Snowflake

COF-R02 · Question #221

A Snowflake Administrator needs to ensure that sensitive corporate data in Snowflake tables is not visible to end users, but is partially visible to functional managers. How can this requirement be…

The correct answer is B. Use dynamic data masking. See the full explanation below for the reasoning.

Question

A Snowflake Administrator needs to ensure that sensitive corporate data in Snowflake tables is not visible to end users, but is partially visible to functional managers. How can this requirement be met?

Options

  • AUse data encryption.
  • BUse dynamic data masking.
  • CUse secure materialized views.
  • DRevoke all roles for functional managers and end users.

How the community answered

(20 responses)
  • A
    5% (1)
  • B
    75% (15)
  • C
    5% (1)
  • D
    15% (3)

Community Discussion

No community discussion yet for this question.

Full COF-R02 Practice