试题详情
单项选择题 You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named DB1 in the instance. In 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?（）  

A、You should use database snapshots 

B、You should use database backup and restore 

C、You should use database backup and restore along with compression 

D、You should use schema-bound views in a read-only database. The database resides on the same instance.

  • A

  • 关注下方微信公众号，在线模考后查看

热门试题