Answer-first summary for fast verification
Answer: Secure views execute slowly compared to non-secure views.
The correct answer is A because Snowflake's official documentation explicitly states that secure views can execute more slowly than non-secure views. This performance difference occurs because secure views undergo additional security checks and optimizations are limited to prevent potential data exposure. Option B is incorrect because secure views are actually preferred for data sharing scenarios as they provide better security. Option C is incorrect because secure views are not similar to materialized views in performance - materialized views precompute and store results for faster access, while secure views have performance overhead. Option D is incorrect because there are indeed performance differences between secure and non-secure views, as confirmed by the documentation and community consensus with 100% agreement on answer A.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
What are the differences between secure views and standard views in Snowflake?
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.
No comments yet.