How do secure views compare to non-secure views in Snowflake?

Question

Options

• ASecure views execute slowly compared to non-secure views.
• BNon-secure views are preferred over secure views when sharing data.
• CSecure views are similar to materialized views in that they are the most performant.
• DThere are no performance differences between secure and non-secure views.

• B
  3% (1)
• C
  3% (1)
• D
  93% (27)

Explanation

NOTE: The marked answer (D) conflicts with official Snowflake documentation, and this question likely contains an error. According to Snowflake's documentation, secure views intentionally bypass certain query optimizer optimizations to prevent data leakage through execution plan details-which means secure views can execute more slowly than equivalent non-secure views. This makes option A ('Secure views execute slowly compared to non-secure views') the factually accurate statement per Snowflake docs. Option B is incorrect because secure views are required (not discouraged) when sharing sensitive data. Option C is incorrect because secure views are unrelated to materialized views and are not the most performant. If this question appears on an exam with D as the answer, treat it with caution, as A aligns with the actual Snowflake documentation behavior.

No community discussion yet for this question.