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?
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?
To save quarter-end financial results for the previous six years, the architect can use Materialized Views in Snowflake. Materialized views store the result set of a query and can be updated periodically, making them well-suited to maintaining historical financial data efficiently. Time Travel and Zero-copy Cloning are not appropriate for this use case since Time Travel is generally used for short-term data recovery and Zero-copy Cloning is more for duplicating entire databases or tables without additional storage costs. Secure views are designed to limit data access, while the Search Optimization Service is intended to enhance query performance, neither of which directly addresses the need for maintaining historical financial records.
Answer is D. Clone table and afterwards delete data older than the previous 6 years.
Answer is D and is validated
I think its D
Changing my answer to C time travel