Answer: To limit access to sensitive data, To hide view definition and details from unauthorized users

Secure views in Snowflake are specifically designed for data privacy and security purposes. Option C ('To limit access to sensitive data') is correct because secure views restrict data visibility based on user privileges, preventing unauthorized access to sensitive information. Option E ('To hide view definition and details from unauthorized users') is also correct because secure views conceal the underlying SQL definition from users who don't have the necessary privileges, protecting the logic and structure of the view. The community discussion shows 100% consensus on CE, with references to Snowflake documentation confirming these as the primary purposes of secure views. Options A, B, and D are incorrect because secure views are not primarily for storing unstructured data, improving query performance, or optimizing concurrency - these are addressed by other Snowflake features like stages, clustering, and resource management.

Author: LeetQuiz Editorial Team