A user needs to implement a Slowly Changing Dimension Type 2 to track historical changes.
Which action will accomplish this?
Correct Answer: D
A Type 2 Slowly Changing Dimension preserves history by expiring the currently active dimension record and inserting a new version whenever tracked attributes change. Snowflake recommends streams and tasks for this requirement because a stream records DML changes from the source or staging table, and a scheduled or triggered task can process those changes with a MERGE statement.
The MERGE can update the old row's end date or current-row flag and insert a replacement row with new effective dates. Dynamic tables represent a maintained current result and are not the preferred solution for Type 2 historical tracking. Time Travel and clones are recovery and historical-query features, while Snowpipe and materialized views do not implement the required record-versioning workflow.