CMS专题
单选题You need to back up the existing data on a computer before you install a new application. You also need to ensure that you are able to recover individual user files that are replaced or deleted during the installation. What should you do？（）A Create a
题目
Create a System Restore point.
Perform an Automated System Recovery （ASR） backup and restore.
In the Backup and Restore Center window， click the Back up files button.
In the Backup and Restore Center window， click the Back up computer button.
相似问题和答案
第1题：
You install a custom application on a computer that runs Microsoft Windows XP. The application stores each user’s data in the %programfiles%\app1\data folder on the computer. You install the custom application on a computer that runs Windows Vista.On the Windows Vista computer, you back up the %programfiles%\app1\data folder and notice that the backup contains no data.You need to back up the application’s user data on the Windows Vista computer.What should you do?（）
A.A
B.B
C.C
D.D
第2题：
A data file became corrupted in your database due to bad sectors on the disk. Because of corruption， you lost all the important tables in that data file. Which method would you use for recovery？（）
- A、flash back all the tables in the data file， one by one
- B、restore the data file to a new location and perform a media recovery
- C、flash back the database; there is no need to restore the data file
- D、restore the data file from the most recent backup and flash back the database
正确答案:B
第3题：
You are the administrator of a SQL Server 2000 computer. The server contains your company's order processing database. Two-hundred operators take orders by telephone 24 hours a day. Threehundred data entry personnel enter data from orders received by mail.
To ensure that order data will not be lost, your company's disaster recovery policy requires that backups be written to tape. Copies of these tapes must be stored at an off-site company location. Orders must be entered into the database before they can be filled. If the server fails, you must be able to recover the order data as quickly as possible.
You need to create a backup strategy that meets the company requirements and minimizes server workload. Which two actions should you take? (Each correct answer represents part of the solution. Choose two.)
A．Perform. a combination of full database and filegroup backups.
B．Perform. a combination of full database and file backups.
C．Perform. a combination of full database, differential, and transaction log backups.
D．Back up the data to a local tape drive.
E．Back up the data to a network share, and then use enterprise backup software to write the disk backups to tape.
解析：Explanation:
C: Most OLTP backup schemes include a full database, differential, and transaction log backups
E: In order to recover the data as quickly as possibly we backup the data to network share, and then backup that share to tape. This minimizes the impact of the backup process on the SQL Server computer.
Note 1: SQL Server 2000 provides three database recovery models. These are the Simple recovery model, the Full Recovery Model and the Bulk-Logged Recovery model. Simple Recovery requires the least administration. In the Simple Recovery model, data is recoverable only to the last full database or differential backup. Transaction log backups are not used, and consequently, minimal transaction log space is required.
This Recovery Model is not an appropriate choice for production systems where loss of recent changes is unacceptable. Full Recovery and Bulk-Logged Recovery models provide the greatest protection for data. These models rely on the transaction log to provide full recoverability and to prevent work loss in the broadest range of failure scenarios.
The Full Recovery model provides the most flexibility for recovering databases to an earlier point in time. The Bulk-Logged model provides higher performance and lower log space consumption for certain large-scale operations. It does this at the expense of some flexibility of pointin- time recovery. In this scenario we would want to implement the Full Recovery model as this Recovery model provides complete protection against media failure and provides the ability to recover the database to the point of failure or to a specific point in time.
To guarantee this degree of recoverability, all operations are fully logged. The backup strategy for full recovery consists of database backups, differential backups, which are optional, and transaction log backups. The differential backups are optional but have less of an effect on the system while they run, as they are smaller than full database backups.
This is because a differential backup creates a copy of all the pages in a database modified after the last database backup. A transaction log backup makes a copy only of the log file and backs up the changes made to the database after the last full or differential database backup. A log file backup cannot be used by itself to restore a database. A log file is used after a database restore to recover the database to the point of the original failure. The full database, differential, and transaction log backups can be written to a hard disk or other disk storage media such as a tape drive.
Disk backup devices can be defined on a local disk of a server or on a remote disk on a shared network resource. Tape backup devices are used in the same way as disk devices, with the exception that the tape device must be connected physically to the computer running an instance of SQL Server. SQL Server 2000 thus does not support backing up to remote tape devices.
Note 2, file backup, filegroup backup: SQL Server 2000 supports backing up or restoring individual files or filegroups within a database. This is a complex backup and the restore process that is usually reserved for large databases with high availability requirements. If the time available for backups is not long enough to support backing up the full database, subsets of the database can be backed up at different times. If a disk holding database files or filegroups fails, the site can restore just the lost files or filegroups. This allows for a quicker recovery because only the damaged files or filegroups are restored in the first step, not the entire database.
Incorrect Answers:
A: An OLTP server requires transaction log backups in order to be able to recover up to the point of failure.
B: An OLTP server requires transaction log backups in order to be able to recover up to the point of failure.
D: Backing up to a local tape device would minimize cost but it would compared to a backup to a network it would decrease performance of the server more, and it would take more time to recover.
第4题：
You have a computer that runs Windows XP professional. The computer contains one partition and a floppy disk drive. You connect a new USB drive. You need to back up the computer to meet the following requirements: Enable a complete recovery if the hard disk fails. Enable an automatic restore of the operating systems. Automatically recreate the partitions during a restore process. What should you do?（）
- A、From System Restore, create a system restore point.
- B、From the System Tools menu, run the Files and Settings Transfer Wizard.
- C、From Windows Backup, run the Automated System Recovery (ASR) Wizard.
- D、From Windows Backup, run the Backup Wizard, and then select Only backup the System State data.
正确答案:C
第5题：
You want to use Windows 2000 backup to perform a weekly backup of the user data on a Windows 2000 Professional computer. You want to ensure that the registry， boot files and COM plus objects are also backed up. What should you do？（）
- A、Configure the Windows backup to backup the system partition.
- B、Configure the Windows backup to backup the System State Data.
- C、Create a script written in MS Visual Basic scripting addition language to run rdisk.exe/s before the back up starts.
- D、Create a batch file to run rdisk.exe/s before the backup starts.
正确答案:B
第6题：
You are the network administrator for Active Directory.Another system administrator installs Software Update Services (SUS) on a production Windows Server 2003 computer. You are assigned to manage the SUS computer. You need to ensure that you can recover SUS if the server fails.You need to back up all components that are required to restore SUS to its current configuration. Because of limited space, you must not back up unnecessary data.What action or actions should you perform? Select all that apply.（）
A. Back up the SUS folder that contains synchronized content.
B. Back up the folder in which the SYSAdmin site was created.
C. Back up the System State data fro the Windows Server 2003 computer.
D. Back up the IIS metabase
第7题：
You are the network administrator for Active Directory. Another system administrator installs Software Update Services (SUS) on a production Windows Server 2003 computer. You are assigned to manage the SUS computer. You need to ensure that you can recover SUS if the server fails. You need to back up all components that are required to restore SUS to its current configuration. Because of limited space, you must not back up unnecessary data. What action or actions should you perform? Select all that apply.（）
- A、Back up the SUS folder that contains synchronized content.
- B、Back up the folder in which the SYSAdmin site was created.
- C、Back up the System State data fro the Windows Server 2003 computer.
- D、Back up the IIS metabase
正确答案:A,B,D
第8题：
You need to back up the existing data on a computer before you install a new application. You also need to ensure that you are able to recover individual user files that are replaced or deleted during the installation.What should you do?（）
A.A
B.B
C.C
D.D
第9题：
You have a computer that runs Windows XP Professional. You use Microsoft Outlook Express to download e-mail messages. You need to copy the e-mail messages, Outlook Express settings, and Internet Explorer settings to a new computer that runs Windows XP Professional. What should you do?（）
- A、Copy all *.dbx files from the old computer to the new computer.
- B、Establish a Remote Assistance session from the old computer to the new computer.
- C、Back up the system state on the old computer. Restore the system state on the new computer.
- D、Run the File and Settings Transfer Wizard on the old computer. Run the File and Settings Transfer Wizard on the new computer.
正确答案:D
第10题：
You have a Windows Server 2008 R2 Hyper-V server. Virtual machines （VMs） store data on pass- through disks. You need to design a backup solution that allows you to restore VMs. What should you do？（）
- A、Back up the VMs by using Windows Server Backup within the VMs
- B、Create checkpoints of the VMs by using Microsoft System Center Virtual Machine Manager （VMM） 2008 R2
- C、Back up the system state on the VMs by using Windows Server Backup within the VMs
- D、Back up the Hyper-V server by using Microsoft System Center Data Protection Manager （DPM） 2007 with SP1
正确答案:A