多选题What are three facts about backups with mysqldump?（）ACan back up a remote database serverBAllow a consistent backup to be takenCAre always faster to restore than binary backupsDAre able to back up specific items within a databaseECreate automatically c

第1题：

You are working on a database that must be functioning 24 hours a day， 7 days a week. The databaseis configured in ARCHIVELOG mode.  Which two options do you have for performing user-managed backups（）

• A、You can perform consistent backups only.
• B、You can perform a complete database backup without shutting down the database instance.
• C、You can back up data files only when all data files have the same SCN recorded in the control file.
• D、You can back up only those data files whose headers are frozen by using ALTER TABLESPACE BEGINBACKUP or ALTER DATABASE BEGIN BACKUP commands.

第2题：

You issue the following command：   RMAN>CONFIGURE BACKUP OPTIMIZATION ON；   What is the result of this command on your backups？（）

• A、 An incremental backup strategy will be used automatically.
• B、 Read-only datafiles will not be backed up as long as backups of those files already exist and those backups meet established retention criteria.
• C、 RMAN will configure itself for maximum performance at the cost of CPU.
• D、 RMAN will configure itself for minimal OS/CPU impact at the cost of time to back up the database.
• E、 RMAN will automatically compress backups.

第3题：

What are three facts about backups with mysqldump?（）

• A、Can back up a remote database server
• B、Allow a consistent backup to be taken
• C、Are always faster to restore than binary backups
• D、Are able to back up specific items within a database
• E、Create automatically compressed backups
• F、Will lock all storage engines for duration of backup

第4题：

You are a database administrator for your company. A database on one of the company’s SQL Server 2005 computers stores transaction information for the company’s Web-based order system. The database is configured to use the full recovery model. Your company receives very few orders between the hours of 19：00 and 04：00. Your maximum acceptable risk for data loss is one hour. Database backups must be performed as quickly as possible. You need to develop a maintenance plan to manage this risk. What should you do？（）

• A、Configure a Back Up Database task to do a full backup of the database every hour.Configure a Check Database Integrity task to run every hour.
• B、Configure a Back Up Database task to do a full backup of the database every day at 19：00.Configure a second Back Up Database task to do differential backups at 09：00 and 14：00.Configure a third Back Up Database task to do transaction log backups every hour.
• C、Configure a Back Up Database task to do a full backup of the database every day at 19：00.Configure a second Back Up Database task to do differential backups at 09：00 and 14：00.Configure a Check Database Integrity task to run every hour.
• D、Configure a Back Up Database task to do a full backup at 09：00 and 14：00.Configure a second Back Up Database task to do transaction log backups every hour.

第5题：

Your data recovery strategy must meet the following requirements： Back up all data files and folders in C:///Data.  Restore individual files and folders in C:///Data.  Ensure that data is backed up to and restored from external media.  What should you do？（）

• A、Use the Previous Versions feature to restore the files and folders.
• B、Use the System Restore feature to perform backup and restore operations.
• C、Use the NTBackup utility to back up and restore individual files and folders.
• D、Use the Backup and Restore Center to back up and restore files.

第6题：

A support engineer reports that inserting new sales transactions in a SQL Server 2005 database results in an error. You investigate the error. You discover that in one of the databases， a developer has accidentally deleted some data in a table that is critical for transaction processing. The database uses the full recovery model. You need to restore the table. You need to achieve this goal without affecting the availability of other data in the database. What should you do？（）

• A、Back up the current transaction log. Restore the database with a different name and stop at the point just before the data loss. Copy the table back into the original database.
• B、Back up the current transaction log. Restore the database to the point just before the data loss.
• C、Restore the database from the existing backup files to a time just before the data loss.
• D、Restore the database to the point of the last full backup.

第7题：

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

Your database is in NOARCHIVELOG mode. You start to do a backup， but your users complain that they dont want you to shut down the database to perform the backup. What options are available to you？（）  

• A、 Put the database in hot backup mode and perform an online backup，including backing up the  archived redo logs.
• B、 Just back up the database datafiles without shutting down the database.
• C、 You will have to wait until you can shut down the database to perform the backup.
• D、 Mark each datafile as backup in progress， back them up individually，and then mark them as backup not in progress. No archived redo logs will need to be backed up.
• E、 Only back up the datafiles that the user will not be touching. Once the user has finished what they were doing，you can shut down the database and back up the datafiles the user changed during the  course of the remaining backup

第14题：

Which is the correct command to back up the database， back up the archived redo logs， and then remove the backed-up archived redo logs？（）  

• A、 backup database
• B、 backup database and archivelogs
• C、 backup database plus archivelogs
• D、 backup database plus archivelog delete input
• E、 backup database and archivelog delete input

第15题：

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、Back up the system state on the VMs by using Windows Server Backup within the VMs
• C、Back up the Hyper-V server by using Microsoft System Center Data Protection Manager （DPM） 2007 with SP1
• D、Create checkpoints of the VMs by using Microsoft System Center Virtual Machine Manager （VMM） 2008 R2

第16题：

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

第17题：

You need to back up your Encrypting File System (EFS) certificate. You must achieve this goal in theminimum amount of time.  What should you do?（）

• A、Run Cipher.exe /x.
• B、Run Ntbackup.exe /p.
• C、From Backup and Restore，click Back up now.
• D、From Backup and Restore，click Create a system image.

第18题：

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 System Restore point.
• B、Perform an Automated System Recovery （ASR） backup and restore.
• C、In the Backup and Restore Center window， click the Back up files button.
• D、In the Backup and Restore Center window， click the Back up computer button.

第19题：

第20题：

第21题：

第22题：

第23题：