SnowPro Core Certification — Question 540

What does Snowflake recommend as a best practice for using secure views?

Answer options

• A. Use sequence-generated values.
• B. Programmatically reveal the identifiers.
• C. Use secure views solely for query convenience.
• D. Do not expose the sequence-generated column(s).

Correct answer: D

Explanation

The best practice recommended by Snowflake is to not expose the sequence-generated columns, which helps maintain data security and integrity. Options A, B, and C do not align with security principles and could potentially compromise the confidentiality of the data managed by secure views.