A full backup of your database named DB1 is created automatically at midnight every day.Differential backups of DB1 occur twice each day at 10：00 and at 16：00. A database snapshot is created every day at noon. A developer reports that he accidentally dro

第1题：

You perform differential incremental level 1 backups of your database on each working day and level 0 backup on Sundays， to tape.  Which two statements are true about differential incremental backups（）

• A、The backup performed on Sundays contains all the blocks that have ever been used in the database.
• B、The backup performed on Sundays contains all the blocks that have changed since the last level 1backup. 
• C、The backup performed on each working day contains all the blocks that have changed since the lastlevel 0 backup.
• D、The backup performed on Monday contains all the blocks that have changed since the level 0 backup，and every other working day contains all the blocks that have changed since the level 1 backup.

第2题：

Every Sunday the Unix system administrator has a job that executes a full backup of the entire Unix system your database is on. Is this backup usable for backup and recovery of your database？（）  

• A、 Yes， if the database is in ARCHIVELOG mode
• B、 Yes， if the database is in NOARCHIVELOG mode
• C、 No， the backup is not usable in any way
• D、 Only if the ENABLE_ONLINE_BACKUP parameter is set to TRUE

第3题：

You are implementing transaction log shipping for a database named DB1 from a server named SQL1 to a server named SQL2. Because DB1 is 100 GB in size， it is too big to transfer over the network in a reasonable amount of time. You need to minimize the impact on the network while you initialize the secondary database. Which two actions should you perform？（）

• A、Specify the simple recovery model for DB1.
• B、Specify either the full or the bulk-logged recovery model for DB1.
• C、Perform a complete backup of DB1 to portable media. Restore the secondary database from that backup； specify the RECOVERY option.
• D、Perform a complete backup of DB1 to portable media. Restore the secondary database from that backup； specify the STANDBY option.
• E、Before you activate transaction log shipping to the secondary database， execute the following statement on the primary server.BACKUP LOG DB1 WITH TRUNCATE ONLY

第4题：

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. You have set the recovery model of DB1 to Full. At 2：00 There is a full database backup of all the user databases every day. Every quarter the transaction log backup is performed. Every 4 hours a differential backup is occurred. You are going to perform a full backup of DB1 at 11：00. When you perform this back up， you must make sure that the overall backup will not be affected. What'；s more， you have to restore procedures for DB1. You must make sure that the backup files are restored in proper sequence.  In the options below， which Transact-SQL statement should you use？（）

• A、BACKUP LOG DB1 TO DISK = 't:/backups/db1.trn'; 
• B、BACKUP DATABASE DB1 TO DISK = 't:/backups/db1.bak' WITH DIFFERENTIAL; 
• C、BACKUP DATABASE DB1 TO DISK = 't:/backups/db1.bak' WITH NOUNLOAD; 
• D、BACKUP DATABASE DB1 TO DISK = 't:/backups/db1.bak' WITH COPY_ONLY; 

第5题：

You work in a company which 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 inthe instance. You have set the recovery model of DB1 to Full. You deploy a new process. The process modifies 10,000 records from the Accounts table at 18:00 every day. Any modification made by the process to the data must be reverted and database keeps online. You must make sure of this. So which strategy should you implement?（）  

• A、You should implement Differential backup 
• B、You should implement Database snapshots
• C、You should implement Primary filegroup backup 
• D、You should implement Transaction log backup

第6题：

A full backup of your database named DB1 is created automatically at midnight every day. Differential backups of DB1 occur twice each day at 10:00 and at 16:00. A database snapshot is created every day at noon. A developer reports that he accidentally dropped the Pricelist table in DB1 at 12:30. The last update to Pricelist occurred one week ago. You need to recover the Pricelist table. You want to achieve this goal by using the minimum amount of administrative effort. You must also minimize the amount of data that is lost. What should you do?（）

• A、 Restore the most recent backup into a new database named DB1bak. Apply the most recent differential backup. Copy the Pricelist table from DB1bak to DB1. 
• B、 Delete all database snapshots except the most recent one. Restore DB1 from the most recent database snapshot. 
• C、 Recover DB1 from the most recent backup. Apply the most recent differential backup. 
• D、 Copy the Pricelist table from the most recent database snapshot into DB1.

第7题：

You are a database administrator for your company. The company uses a SQL Server 2005 database. A full backup of the database is made each night. Transaction log backups are made each morning and each afternoon. You notice that the database transaction log file grows very large throughout the day. You need to minimize the size of the transaction log file. You also need to minimize data loss in the event of a failure. What should you do？（）

• A、Decrease the amount of time between transaction log backups.
• B、Configure the database to use the simple recovery model.
• C、Configure the RECOVERY INTERVAL option to be a smaller value.
• D、Run DBCC SHRINKFILE on the transaction log file.

第8题：

Your network consists of a single Active Directory domain. You have a server named Server1. Server1 has only one hard disk drive. You run a full backup at 02:00 every Monday. You run an incremental backup at 02:00 every Tuesday to Sunday. You run an Automated System Recovery (ASR) backup every day at 13:00. Server1’s hard disk drive fails on Wednesday at 15:00. You need to recover Server1 to its latest configuration by using the minimum amount of administrative effort. What should you restore? （）

• A、Monday’s full backup, then Tuesday’s incremental backup, and then Wednesday’s incremental backup
• B、Monday’s full backup and then Wednesday’s ASR backup
• C、Monday’s full backup and then Wednesday’s incremental backup
• D、Wednesday’s ASR backup

第9题：

Your company uses a mission-critical database named DB1, which is located on a server named SQL1. You want to mirror DB1 on a second server named SQL2. Before you can establish database mirroring, you need to prepare DB1 and the servers for mirroring. Which three actions should you perform?（）

• A、 Set the recovery model of DB1 on SQL1 to bulk-logged recovery. 
• B、 Set the recovery model of DB1 on SQL1 to full recovery. 
• C、 Back up DB1 on SQL1. Restore the backup on SQL2; specify the NORECOVERY option. 
• D、 Back up DB1 on SQL1. Restore the backup on SQL2; specify the STANDBY option. 
• E、 Back up DB1 on SQL1. Restore the backup on SQL2; specify the RECOVERY option.
• F、 Create endpoints on all participating servers. 
• G、 Set the AutoShrink property of DB1 on SQL1 to false.

第10题：

You are the network administrator for TestKing. The network contains a Windows Server 2003 computer named Testking1. You back up the data folders on Testking1 by using the following schedule: 1. Normal backup every Monday. 2. Incremental backups every Tuesday, Wednesday, Thursday, and Friday. After the backup on Friday is completed, a user accidentally deletes a file from a data folder on Server1. The user reports that he modified the file in the past week, but he does not know which day he modified the file. You do not know when the file was last backed up. You need to restore the latest copy of the file as quickly as possible. What should you do?（）

• A、Open the backup log for each day. Begin by opening the log for Monday, and then work forward through the logs for each day of the week. In each log, search for a backup of the file. Restore the first backup that you find.
• B、Open the backup log for each day. Begin by opening the log for Tuesday, and then work forward through the logs for each day of the week. In each log, search for a backup of the file. Restore the first backup that you find.
• C、Open the backup log for each day. Begin by opening the log for Friday, and then work backward through the logs for each day of the week. In each log, search for a backup of the file. Restore the first backup that you find.
• D、Restore the file from the Monday, Tuesday, Wednesday, Thursday, and Friday backups, in that order.
• E、Restore the file from the Monday backup, and then from the Friday backup.

第11题：

第12题：

第13题：

You are working on a 24x7 （available 24 hours per day， 7 days per week） production database. An operating system （OS） user deletes the alert log file accidentally. Which statement in this scenario is true？（）

• A、The database crashes.
• B、The DBA needs to re-create the file.
• C、The file gets re-created automatically.
• D、The file gets restored automatically from the last backup.
• E、The DBA needs to perform a complete database recovery.
• F、The DBA needs to perform an incomplete database recovery.

第14题：

You perform differential incremental level 1 backups of your database on each working day and level 0 backupon Sundays， to tape. Which two statements are true about differential incremental backups（）

• A、The backup performed on Sundays contains all the blocks that have ever been used in the database.
• B、The backup performed on Sundays contains all the blocks that have changed since the last level 1 backup.
• C、The backup performed on each working day contains all the blocks that have changed since the last level 0 backup.
• D、The backup performed on Monday contains all the blocks that have changed since the level 0 backup， and every other working day contains all the blocks that have changed since the level 1 backup

第15题：

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.

第16题：

You have a file server named Server1 that runs Windows Server 2003 Service Pack 2 (SP2). You enable Shadow Copies on all drives by using the default options. You run a full backup every Monday at 02:00. You run an incremental backup every day at 02:00, except on Monday. On Thursday at 14:00, a user reports that he accidentally deleted a file named File1.doc in a shared folder named //Server1/Data/. The user reports that the file was last updated at 09:00 on Thursday. You need to restore the latest version of File1.doc. What should you restore? （）

• A、the file by using the Previous Versions Client
• B、the file from the full backup performed on Monday
• C、the file from the incremental backup performed on Thursday
• D、the user’s computer by using Automated System Recovery (ASR)

第17题：

You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 Enterprise Edition instance. There is a database named DB1 in the instance. A backup of DB1 is performed every day. You have to minimize the size of the full database backup files of DB1.  In the options below, which Transact-SQL statement should you use? （）  

• A、BACKUP DATABASE DB1 TO DISK = 't:/backups/db1.bak'; 
• B、BACKUP DATABASE DB1 TO DISK = 't:/backups/db1.bak' WITH COMPRESSION; 
• C、BACKUP DATABASE DB1 TO DISK = 't:/backups/db1.bak' WITH DIFFERENTIAL; 
• D、BACKUP DATABASE DB1 TO DISK = 't:/backups/db1.bak' WITH COMPRESSION,DIFFERENTIAL;

第18题：

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. At present about 90 GB of data is stored in DB1. You made some rough calculations that every day about 1 GB of data is modified or inserted. You set the recovery model of DB1 to Simple. According to the company requirements, during business hours, data loss of more than 120 minutes worth of transactions is unacceptable. You have to choose a backup strategy which must comply with the following two requirements: Using as little disk space as possible Complying with the company requirements. So what action should you perform to achieve this goal?（）  

• A、A full database backup should be performed once daily. During business hour, a transaction log backup should be performed every two hours. 
• B、A full database backup should be performed once daily 
• C、A full database backup should be performed once daily. During business hours, a differential backup should be performed every two hours 
• D、Perform a full database backup should be performed once every week. A differential backup should be performed once daily. During business hours a transaction log backup should be performed every two hours.

第19题：

You work in a company which 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. The latest differential backup is performed at 15:30, the full back up was performed at 13:30, and database snapshots were created at 16:30 and at 17:30. The backups and the database snapshots are stored on a different disk from the database files. At 17:05, the hard disk containing the database files fails at 17:02 hours. You must restore DB1 while reduce data loss to the least.  So what action should you perform to achieve this goal?（）  

• A、You should restore the full backup 
• B、You should restore the database snapshot from 16:30 hours. 
• C、You should restore the database snapshot from 17:30 hours 
• D、You should restore both the full backup and the differential backup. 

第20题：

You have a file server named Server1 that runs Windows Server 2003 Service Pack 2 (SP2). You enable Shadow Copies on all drives by using the default options. You run a full backup every Monday at 02:00. You run an incremental backup every day at 02:00, except on Monday. On Thursday at 14:00, a user reports that he accidentally deleted a file named File1.doc in a shared folder named //Server1/Data/. The user reports that the file was last updated at 09:00 on Thursday. You need to restore the latest version of File1.doc. What should you restore? （）

• A、the file by using the Previous Versions Client
• B、the file from the full backup performed on Monday
• C、the file from the incremental backup performed on Thursday
• D、the user’s computer by using Automated System Recovery (ASR)

第21题：

You are a database administrator for your company. The company uses a SQL Server 2005 computer that runs Reporting Services. Reporting Services is used to produce hundreds of reports each day. You discover that the ReportServerTempDB database is growing. You need to minimize the size of the ReportServerTempDB database. What should you do？（）

• A、Decrease the time between transaction log backups of the database.
• B、Delete report snapshot history each week.
• C、Minimize the use of session caching in the reports.
• D、Minimize the use of report snapshots in the reports.

第22题：

第23题：