Microsoft
70-432 · Question #85
You are the administrator of a SQL Server 2008 instance with a database named DB1. At the database a small percentage of data is modified everyday. Ever day in the morning, you have to create a…
The correct answer is A. You should use database snapshots. See the full explanation below for the reasoning.
Question
You are the administrator of a SQL Server 2008 instance with a database named DB1. At the database a small percentage of data is modified everyday. Ever day in the morning, you have to create a read-only copy of the database for reporting purposes and make sure that you use as little disk space as possible. In the options below, which strategy should you use?
Options
- AYou should use database snapshots
- BYou should use database backup and restore
- CYou should use database backup and restore along with compression
- DYou should use schema-bound views in a read-only database.
How the community answered
(41 responses)- A78% (32)
- B2% (1)
- C5% (2)
- D15% (6)
Community Discussion
No community discussion yet for this question.