[单选题]

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.

参考答案与解析:

相关试题

You work as the ente

[单选题]You work as the enterprise exchange administrator at TestKing.com. TestKing.com makes use ofMicrosoft Exchange Server messaging solution. The TestKing.com 

  • 查看答案
  • You have a server th

    [单选题]You have a server that runs Windows Server 2008. The server has the Windows Server virtualization roleservice installed and has one virtual 

  • 查看答案
  • You are the network 

    [单选题]You are the network administrator for Contoso, Ltd. The network consists of a single Active Directory forest that contains a single domain n

  • 查看答案
  • You are managing an 

    [多选题] You are managing an Oracle Database 11g database with ASM storage. The ASM disk group has the COMPATIBLE.ASM attribute set to 11.1. Which&e

  • 查看答案
  • You are the DNS admi

    [单选题]You are the DNS administrator for Adventure Works. Adventure Works is an Internet service provider (ISP) that hosts Web sites for many compa

  • 查看答案
  • You need to create a

    [单选题]You need to create a web share on your Windows 2000 Professional computer named Admin01. You create a folder named reports. Then you co

  • 查看答案
  • A System p administrator&

    [单选题]A System p administrator needs to run the annualreval.sh script, directing standard error to /var/log/reval.err, and appending standard out to /var/lo

  • 查看答案
  • View the Exhibit and&ensp

    [单选题]View the Exhibit and examine the properties of the TT tablespace. Using Database Control, you have scheduled a job to shrink the TRANS 

  • 查看答案
  • Your company has an 

    [单选题]Your company has an Active Directory domain. A server named Server1 runs Windows Server 2008. The Terminal Services role and the Terminal Se

  • 查看答案
  • class Computation extends&ensp

    [单选题]class Computation extends Thread { private int num; private boolean isComplete; private int result; public Computation(int num) { this.num = num;&ensp

  • 查看答案
  • You work in a compan