Interview Questions

1. How does a snapshot work?

High level tasks of snapshot involves

  •  When you create a snapshot a sparse file is created for each data file
  •  When data is modified in the source database for the first time, the old value of the modified data is copied to the sparse file
  •  If the same data is the subsequently changed again, those changes will be ignored and not copied to the snapshot
  •  When you query the snapshot, it first checks if the data is available in the snapshot. If it’s there it reads if from the snapshot. If it’s not there, I reads through to the source database and gets the data from there instead, because that means the data has not yet changed since the time the snapshot was taken 
By Hena Parveen 2 0
Is this helpful? Yes No

Submit an interview question

Submitted questions and answers are subject to review and editing, and may or may not be selected for posting, at the sole discretion of w3Sniff.

Get Started

Comments

Leave a Comment


Check out more interview questions

Based on your skills

MS SQL Server

2567550 1720 50 859

Angular

67721 92 0 46

Wordpress

57027 72 1 36