CompTIA Data+ DA0-002 (V2) Practice Question

The team is capturing point-in-time, read-only copies of the table on a fixed schedule; this is the hallmark of a snapshot. A snapshot freezes the dataset at a specific moment so it can be queried or restored later, even though the source continues to change. Setting a refresh interval governs how often a live object such as a materialized view is updated, but it does not preserve older states. Change data capture stores row-level deltas in logs rather than a full frozen view, and geo-redundant replication focuses on high availability rather than historical versions. Therefore, snapshotting is the correct data versioning mechanism in this scenario.