SnowPro Advanced: Architect — Question 46

An Architect would like to save quarter-end financial results for the previous six years.
Which Snowflake feature can the Architect use to accomplish this?

Answer options

• A. Search optimization service
• B. Materialized view
• C. Time Travel
• D. Zero-copy cloning
• E. Secure views

Correct answer: D

Explanation

Zero-copy cloning allows for the creation of a clone of a database without physically duplicating the data, making it efficient for storing historical data. The other options do not provide the same functionality for long-term data retention; for instance, Time Travel is useful for accessing previous states, but not for long-term storage like cloning.