
Answer-first summary for fast verification
Answer: Secure view
Secure views in Snowflake do not consume storage costs because they are logical objects that store only the view definition (metadata), not the actual data. The view dynamically queries the underlying tables when accessed. In contrast, materialized views store pre-computed results and consume storage. Temporary tables and transient tables both consume storage costs during their existence - temporary tables for the session duration and transient tables until explicitly dropped. The community discussion shows 100% consensus on answer A with upvoted comments confirming this is correct.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.