Explain What Are The Options Available To Refresh Snapshots?

1.	Explain What Are The Options Available To Refresh Snapshots?
Answer» COMPLETE - Tables are completely regenerated using the snapshot's query and the MASTER tables every TIME the snapshot REFERENCED. FAST - If SIMPLE snapshot used then a snapshot log can be used to send the changes to the snapshot tables. FORCE - Default value. If possible it performs a FAST refresh; Otherwise it will perform a complete refresh.

Answer»

COMPLETE - Tables are completely regenerated using the snapshot's query and the MASTER tables every TIME the snapshot REFERENCED.
FAST - If SIMPLE snapshot used then a snapshot log can be used to send the changes to the snapshot tables.
FORCE - Default value. If possible it performs a FAST refresh; Otherwise it will perform a complete refresh.

Discussion