Why would a Snowflake user create a secure view instead of a standard view?
Why would a Snowflake user create a secure view instead of a standard view?
End users are unable to see the view definition, and internal optimizations differ with a secure view. This ensures that sensitive internal details and potential exposure of the underlying data are prevented, providing an additional layer of security.
Answer should be B Why Should I Use Secure Views? For a non-secure view, internal optimizations can indirectly expose data. 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.
B is the correct answer
https://docs.snowflake.com/en/user-guide/views-secure
B is correct
B is correct answer. https://docs.snowflake.com/en/user-guide/views-secure