SnowPro Core Certification — Question 484

Why would a Snowflake user create a secure view instead of a standard view?

Answer options

• 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.

Correct answer: B

Explanation

The correct answer is B because secure views hide their definitions from end users, adding a layer of security, and they have different internal optimizations compared to standard views. Options A and C are incorrect as they misrepresent the functionality of secure views; A incorrectly implies access is solely based on SECURE_ACCESS and C incorrectly states that data is replicated. Option D, while true regarding additional functionality, does not address the primary reason for choosing secure views over standard views.