
Answer-first summary for fast verification
Answer: Do not expose the sequence-generated column(s).
The correct answer is D based on Snowflake's official documentation and community consensus. Snowflake explicitly recommends not exposing sequence-generated columns in secure views because sequential identifiers can reveal information about data volume, growth patterns, and potentially sensitive business metrics. The community discussion shows unanimous support for option D with multiple upvoted comments referencing Snowflake's documentation. Option A (using sequence-generated values) is explicitly discouraged. Option B (programmatically revealing identifiers) contradicts the security principle. Option C (using secure views solely for query convenience) misses the primary security purpose of secure views. The documentation link provided in the discussion confirms that Snowflake recommends using randomized identifiers like UUID_STRING instead of sequence-generated values and programmatically obfuscating identifiers when necessary.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.