SnowPro Core Certification — Question 639

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

Answer options

• A. Secure views execute slowly compared to non-secure views.
• B. Non-secure views are preferred over secure views when sharing data.
• C. Secure views are similar to materialized views in that they are the most performant.
• D. There are no performance differences between secure and non-secure views.

Correct answer: A

Explanation

The correct answer is A because secure views have additional security measures that can introduce performance overhead, making them execute more slowly than non-secure views. Options B and C are incorrect as they misrepresent the use cases and performance characteristics of secure views, while D is also incorrect because there is a performance difference between the two types of views.