
Answer-first summary for fast verification
Answer: Secure view, Materialized view
The question asks for two valid view types in Snowflake. Based on Snowflake documentation and the community consensus (100% agreement on BE with upvoted comments), Secure views and Materialized views are the correct answers. Secure views provide enhanced security by not exposing underlying query definitions, while Materialized views store pre-computed results for improved performance. The other options (Layered, External, and Embedded views) are not standard Snowflake view types - they don't appear in Snowflake's official documentation or common database terminology.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.