Home » Microsoft » MB6-886 » What should you recommend?
You have a server that runs SQL Server 2008 Enterprise. The server contains a 300-GB database.
At the end of every month, several reports are generated from the database.
Users report that it takes a long time to access data from the database while the reports are being generated.
You need to recommend a solution to improve the data access time while the reports are being generated from the database. The solution must use a minimum amount of administrative effort.
What should you recommend?
A. database snapshots
B. a failover cluster
C. database mirroring
D. linked servers
Correct Answer: A
Explanation/Reference:
A database snapshot is a read-only, static view of a database (called the source database). Each database snapshot is transactionally consistent with the source database at the moment of the snapshot’s creation. When you create a database snapshot, the source database will typically have open transactions. Before the snapshot becomes available, the open transactions are rolled back to make the database snapshot transactionally consistent.
One of the reasons to take database snapshots is to extend access to data from a particular point in time. In the current scenario, you can create a database snapshot at the end of every month for later reporting. You can then run end-of-period reports on the snapshot. If disk space permits, you can also maintain end-ofperiod snapshots indefinitely, allowing queries against the results from these periods; for example, to investigate organizational performance.