SOL-C01 Question #26: Real Exam Question with Answer & Explanation

Question

A Snowflake administrator is tasked with managing storage costs. They notice that several large tables are rarely queried. Which of the following strategies are MOST effective for reducing storage costs for these tables, while still allowing for future access?

Options

• ADropping the tables and recreating them when needed from source data.
• BCloning the tables to a cheaper storage solution outside of Snowflake.
• CSetting a data retention period for the tables using Time Travel and Fail-safe.
• DPurging the tables completely to reclaim storage space.
• EUsing Snowflake's data compression, which is automatically enabled and optimizes storage

Explanation

Snowflake automatically compresses data, optimizing storage utilization (E). Setting a shorter data retention period reduces the amount of historical data stored, directly impacting storage costs (C). Dropping and recreating tables (A) is inefficient and time-consuming. Cloning to extemal storage (B) isn't a direct Snowflake cost-reduction strategy. Purging the tables (D) eliminates access to the data, which contradicts the requirement of allowing for future access. Fail-safe is for disaster recovery and is not configurable, while Time Travel allows restoring data within defined retention period. Data retention period reduces the amount of data retained.

No community discussion yet for this question.