Exam SOL-C01 Topic 1 Question 137 Discussion

Actual exam question for Snowflake's SOL-C01 exam
Question #: 137
Topic #: 1
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?

Suggested Answer: C,E Vote an answer

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.

by Fitch at Jan 09, 2026, 04:42 AM

Limited Time Offer

15%

Off

Get Premium SOL-C01 Questions as Interactive Self Test Engine or PDF

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
Nick name: Submit Cancel
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
0
0
0
10