COF-C02 · Question #390
COF-C02 Question #390: Real Exam Question with Answer & Explanation
The correct answer is D: There are no performance differences between secure and non-secure views.. Secure views and non-secure views in Snowflake are differentiated primarily by their handling of data access and security rather than performance characteristics. A secure view enforces row- level security and ensures that the view definition is hidden from the users. However, in
Question
How do secure views compare to non-secure views in Snowflake?
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.
Explanation
Secure views and non-secure views in Snowflake are differentiated primarily by their handling of data access and security rather than performance characteristics. A secure view enforces row- level security and ensures that the view definition is hidden from the users. However, in terms of performance, secure views do not inherently execute slower or faster than non-secure views. The performance of both types of views depends more on other factors such as underlying table design, query complexity, and system workload rather than the security features embedded in the views themselves.
Topics
Community Discussion
No community discussion yet for this question.