PrepAway - Latest Free Exam Questions & Answers

Which is the correct answer?

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?

PrepAway - Latest Free Exam Questions & Answers

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


Leave a Reply