You are managing a SQL Server 2008 instance which includes a database called Products
for Home.com. You should not modify the database frequently everyday. You should make
sure that you develop a read-only copy of the database for reporting purposes at the
beginning of every day .Which is the correct answer?
A.
You should utilize database snapshots.
B.
You should utilize Transactions Log.
C.
You should utilize store procedure
D.
You should utilize schema-bound views and XML schema