Answer-first summary for fast verification
Answer: End users are unable to see the view definition, and internal optimizations differ with a secure view.
The correct answer is B because secure views in Snowflake prevent users from seeing the view definition and disable certain internal optimizations that could potentially expose underlying data. This security measure ensures that sensitive data in base tables remains protected from indirect exposure through query optimizations. Option A is incorrect because secure views don't require a SECURE_ACCESS property for end users. Option C is wrong as secure views don't replicate data to separate storage. Option D is incorrect because both standard and secure views can support column masking and row-level security policies - the key difference lies in the security of the view definition itself and optimization behavior.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
What is the primary reason a Snowflake user would create a secure view instead of a standard view?
A
The secure view is only available to end users with the corresponding SECURE_ACCESS property.
B
End users are unable to see the view definition, and internal optimizations differ with a secure view.
C
With a secure view, the underlying data is replicated to a separate storage layer with enhanced encryption.
D
Secure views support additional functionality that is not supported for standard views, such as column masking and row level access policies.