多做题,通过考试没问题!

微软认证考试

睦霖题库>其他计算机考试>微软认证考试

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
答案解析:
进入题库查看解析

微信扫一扫手机做题