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.
a failover cluster
B.
database mirroring
C.
database snapshots
D.
linked servers