多选题A startup company recently lost their critical database due to hardware failure on a Windows 2003 4-way processor server running 32-bit applications and an out-dated backup due to a narrow backup window.  To prevent this situation from happening again，

第1题：

You are evaluating the use of pass-through disks for the database servers. You need to recommend a backup solution for the database servers that meets the following requirements： - Minimizes costs. - Provides for the recovery of the databases if a hardware failure occurs. What should you include in the recommendation？（）

• A、Create full backups of the Hyper-V host by using Windows Server Backup
• B、Create snapshots of the VMs from Hyper-V Manager
• C、Create full backups of the Hyper-V host by using Microsoft System Center Data Protection Manager
• D、Create full backups of the VMs by using Windows Server Backup from within the VMs

第2题：

A customer has a large amount of data stored on three database servers and is concerned that at present there is no disaster recovery plan in place.  They have an existing tape backup solution that meets their backup window.  In order to analyze potential disaster recovery plans， which of the following questions is the most important？（）

• A、What is the minimum critical backup window？
• B、Which server is handling the most critical data？
• C、How much data is stored on each server？
• D、What is the throughput of the hard drives？

第3题：

In your database， online redo log files are multiplexed and one of the members in a group is lost due to media failure？ How would you recover the lost redo log member？（）

• A、 import the database from the last export
• B、 restore all the members in the group from the last backup
• C、 drop the lost member from the database and then add a new member to the group
• D、 restore all the database files from the backup and then perform a complete recovery
• E、 restore all the database files from the backup and then perform an incomplete recovery

第4题：

Your test database is configured to run in NOARCHIVELOG mode. One of the data files in the USERStablespace is lost due to a media failure. You notice that all the online redo logs have been overwritten since the last backup.  What would you do to recover the data file（）

• A、Take the USERS tablespace offline and re-create the lost data file.
• B、Shut down the instance， restore the data file from the last consistent backup， and restart the databaseinstance.
• C、Shut down the instance， restore all the database files from the last consistent backup， and restart thedatabase instance.
• D、Take the USERS tablespace offline， restore all the data files of the USERS tablespace from the lastconsistent backup， and make the tablespace online.

第5题：

Adam is working as a Database Administrator （DBA） for TeleSoft Corporation. His database is running in the ARCHIVELOG mode. During database startup， he discovers that one of the disks crashed， resulting in the permanent loss of a read-write USERS tablespace. The USERS01.dbf datafile belongs to the USERS tablespace and is 500 MB in size. He needs to recover the USERS tablespace from the backup. While reviewing the backup details， he discovers that the most recent available backup is five days old. This backup was taken when the USERS tablespace was read-only. After correcting the hardware problem that caused the failure， what should Adam do to recover the USERS tablespace？（）

• A、 Restore the USERS01.dbf file from the backup， and open the database using the STARTUP command.
• B、 Restore the USERS01.dbf file using the RECOVER TABLESPACE command， and open the database using the ALTER DATABASE OPEN statement.
• C、 Restore the USERS01.dbf file from the backup， recover the USERS tablespace using the RECOVER TABLESPACE command， and open the database using the ALTER DATABASE OPEN statement.
• D、 Restore the USERS01.dbf file from the backup and change the status of the USERS tablespace from read-only to read-write using the ALTER TABLESPACE USERS READ WRITE statement. Then， recover the USERS tablespace using the RECOVER TABLESPACE command， and open the database using the ALTER DATABASE OPEN statement.

第6题：

You have a server that runs Windows Server 2003 Service Pack 2 (SP2). An incremental backup runs every weekday at 01:00. On Friday, you examine the Windows Backup log and discover that the last entry in the log is one week old. You need to identify the problem that prevents the backup from running. What should you do? （）

• A、From Scheduled Tasks, examine the log.
• B、From Event Viewer, examine the system log.
• C、From Windows Backup, enable detailed logging and then perform a manual backup.
• D、From Windows Explorer, examine the files in the %systemroot%/system32/LogFiles folder.

第7题：

You are the administrator of the TestKing company network. The network consists of a single Active Directory domain named The network includes 20 member servers running Windows Server 2003 and 4 domain controllers running Windows Server 2003. All client computers run Windows XP Professional. A member server named TestKingSrvA functions as a file server. TestKingSrvA has a locally attached tape device. You need to create a backup schedule for TestKingSrvA. All data on TestKingSrvA must be backed up once a week. Every day, you need to back up only the data that was changed after the last weekly backup. You need to minimize the amount of time taken to restore the data in the event of a hardware failure. What should you do? （）(Choose two)（）

• A、Perform a normal backup every week.
• B、Perform a copy backup every week.
• C、Perform a differential backup every week.
• D、Perform an incremental backup every week
• E、Perform a normal backup every day.
• F、Perform a copy backup every day.
• G、Perform a differential backup every day.
• H、Perform an incremental backup every day.

第8题：

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. You configure the SQL Server instance to use the -T1222 and -T1204 trace flags during startup. You must make sure that your failure recovery plan performs backup of the use of the trace flags. So what action should you perform to achieve this goal? （） 

• A、You should backup the master database
• B、You should backup the default.trc file
• C、You should backup the SQL Server registry hive.
• D、You should backup the resource database 

第9题：

第10题：

第11题：

第12题：

第13题：

A startup company recently lost their critical database due to hardware failure on a Windows 2003 4-way processor server running 32-bit applications and an out-dated backup due to a narrow backup window.  To prevent this situation from happening again， the solution proposed must be cost effective， scale to 16-way and allow for future storage expansion.  Which TWO of the following options should the consultant recommend？（）

• A、Implement Snapshot feature of Storage Manager.
• B、Implement Flashcopy feature of Storage Manager.
• C、Provide remote volume mirroring （RVM） feature of Storage Manager.
• D、Implement MSCS clustering on an x455 attached to a shared Fibre DS4000 SAN fabric.
• E、Implement MSCS clustering on an x445 attached to a shared Fibre DS4000 SAN fabric.

第14题：

Your database is configured in NOARCHIVELOG mode. All the control files have been lost due to a hard disk failure but the data files are not lost. You have the closed whole database backup available to you.  Which two statements are true in this scenario？（）

• A、The instance aborts.
• B、The database cannot be recovered.
• C、The database can be recovered by restoring the control files from the backup.
• D、The database remains opened and you have to shut it down with the ABORT option.
• E、The database can be restored till the point of the last closed whole database backup.

第15题：

You have recovered your Oracle Database 10g by using the control file backup because all copies of the current control file have been lost due to a media failure. You open your database by using the following statement：       SQL>ALTER DATABASE OPEN RESETLOGS；   Which of the following options is true about using the RESETLOGS option？（）

• A、 The log sequence is reset to 0.
• B、 All the online redo logs are deleted.
• C、 All the archived redo logs from a previous incarnation become useless.
• D、 The full database backup taken from a previous incarnation can be used in future.
• E、 Only the control file and online redo log files are updated with a new RESETLOGS SCN and time stamp.

第16题：

You have lost all your RMAN backup set pieces due to a disk failure. Unfortunately， you have an automated cross-check script that also does a delete expired backupset command. You have restored all the backup set pieces from tape.  What command would you use to get those backup set pieces registered in the recovery catalog and the control file of the database again？（）  

• A、 register database
• B、 recover catalog
• C、 load backupset
• D、 synch metadata
• E、 catalog start with

第17题：

In which of the following scenarios is a tablespace recovery required？（）

• A、 when recovering a lost read-only tablespace from a read-only tablespace backup
• B、 when recovering a lost read-only tablespace from a read-write tablespace backup when the database is running in  ARCHIVELOG mode
• C、 when recovering a lost read-only tablespace from a read-write tablespace backup when the database is running in  NOARCHIVELOG mode and the changes in the online redo log files have been overwritten
• D、 when recovering a lost read-only tablespace from a read-only tablespace backup using the backup of the control file， the control file was created using the ALTER DATABASE BACKUP CONTROLFILE TO TRACE statement， and this statement was issued when the tablespace was read-only

第18题：

Your network contains a server named Server1 that runs Windows Server 2008 R2. Server1 has Microsoft Exchange Server 2010 deployed. You schedule a backup of the server. You discover that the Exchange Server 2010 transaction log files are purged during the backup. You need to prevent the Exchange Server 2010 transaction log files from being purged. What should you do? （）

• A、From the properties of the backup, add an exclusion.
• B、From the properties of the backup, modify the VSS settings.
• C、From Windows PowerShell, run the New-WBFileSpec cmdlet.
• D、From Windows PowerShell, run the New-WBBackupTarget cmdlet.

第19题：

You are the network administrator for All network servers run Windows Server 2003. A member server named TestKingA contains two volumes. You need to perform a complete backup of the data on TestKingA. You must ensure that TestKingA can be completely restored in case of hardware failure. Which two actions should you perform? （）(Each correct answer presents part of the solution. Choose two)

• A、Create an Automated System Recovery (ASR) backup.
• B、Create a backup of user data.
• C、Create a Windows Server 2003 bootable floppy disk.
• D、Create a DOS bootable floppy disk.
• E、Copy all Windows Server 2003 boot files to the Windows Server 2003 bootable floppy disk.
• F、Copy only Boot.ini to the Windows Server 2003 bootable floppy disk

第20题：

第21题：

第22题：

第23题：

第24题：