PrepAway - Latest Free Exam Questions & Answers

Which strategy should you use?

You maintain a SQL Server 2008 instance that contains a database named Finance. A small
percentage of data in the database is modified daily.
You need to create a read-only copy of the database for reporting purposes at the beginning
of each day by ensuring that minimal disk space is used.
Which strategy should you use?

PrepAway - Latest Free Exam Questions & Answers

A.
Use database snapshots.

B.
Use database backup and restore.

C.
Use database backup and restore along with compression.

D.
Use schema-bound views in a read-only database that resides on the same instance.


Leave a Reply