Why should a Snowflake user configure a secure view? (Choose two.)
Why should a Snowflake user configure a secure view? (Choose two.)
A Snowflake user should configure a secure view to protect hidden data from other users and to hide the view definition from other users. This ensures that sensitive information is not exposed through the view and maintains the confidentiality of the view's structure and underlying data.
CE Some of the internal optimizations for views require access to the underlying data in the base tables for the view. This access might allow data that is hidden from users of the view to be exposed through user code, such as user-defined functions, or other programmatic methods. Secure views do not utilize these optimizations, ensuring that users have no access to the underlying data. For security or privacy reasons, you might not wish to expose the underlying tables or internal structural details for a view. With secure views, the view definition and details are visible only to authorized users (i.e. users who are granted the role that owns the view).
CE correct