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?

The correct answer is D. Zero-copy cloning. Zero-copy cloning allows you to create point-in-time snapshots of a database, schema, or table without physically duplicating the underlying data. The clone references the same micro-partitions as the source, consuming no additional storage initially. An Architect can create a cl

Architectural Principles and Best Practices

Question

Options

ASearch optimization service
BMaterialized view
CTime Travel
DZero-copy cloning
ESecure views

How the community answered

(40 responses)

A
13% (5)
B
5% (2)
C
3% (1)
D
78% (31)
E
3% (1)

Explanation

Zero-copy cloning allows you to create point-in-time snapshots of a database, schema, or table without physically duplicating the underlying data. The clone references the same micro-partitions as the source, consuming no additional storage initially. An Architect can create a clone at each quarter-end and retain those clones indefinitely-well beyond six years. Time Travel (C) is a distractor: it only retains historical data for up to 90 days (even in Snowflake Enterprise), making it unsuitable for a six-year retention requirement. Materialized views (B) cache query results for performance but do not serve as long-term historical snapshots. Search optimization (A) improves query speed, and Secure views (E) restrict data visibility-neither addresses long-term data preservation.

Topics

#Zero-copy cloning#Data snapshots#Historical data management#Data versioning

Community Discussion

No community discussion yet for this question.

Full ARA-C01 Practice