微软认证考试
You are a database administrator for your company. Each night， you perform full backups of your SQL Server 2005 computer. During business hours， you perform hourly transaction log backups. You rebuild database indexes each night. You need to modify your b
题目
You are a database administrator for your company. Each night， you perform full backups of your SQL Server 2005 computer. During business hours， you perform hourly transaction log backups. You rebuild database indexes each night. You need to modify your backup strategy. You must ensure that the database recovers to a new server as quickly as possible. What should you do？（）
- A、Schedule the full backups to run after the nightly index is rebuilt.
- B、Schedule the full backup to run before the nightly index is rebuilt. Schedule a differential backup to run after the nightly index is rebuilt.
- C、Schedule an additional transaction log backup to run after the nightly index is rebuilt.
- D、Schedule a marker to be added to the transaction log before the nightly index is rebuilt.
相似问题和答案
第1题：
Your database runs in NOARCHIVELOG mode， and is backed up every night using RMAN scripts. However， last night your assistant DBA performed a manual operating system backup， instead of running the scripts. Today your database crashed and you now want to use the backups from last night. What do you need todo？（）
- A、You need to perform the restore and recover operations manually, because the backup was made manually.
- B、First you need to resynchronize the catalog with the control file, and then you can use RMAN to recover the database.
- C、First you need to add the backup to the catalog using the CATALOG command, and then you can use RMAN to recover the database.
- D、You can just use RMAN and recover the database, because RMAN automatically updates the catalog with the backup information.
正确答案:C
第2题：
You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions， monitoring the database server， and design deployment. In the company， you major job is the deployment， maintenance and support of Microsoft SQL Server 2005. You work as a database administrator for your company. The users report the slow performance of a SQL Server 2005 application. You are required to identify the queries which perform slowly because of blocking. Which action should you perform？（）
- A、In a SQL Trace log file， you should look for queries with low duration values and high read and write values.
- B、In a query execution plan， you should look for queries with missing or out-of-date statistics.
- C、In a SQL Trace log file， you should look for queries with high duration values and low read and write values.
- D、In a query execution plan， you should look for queries with a large number of table scans.
正确答案:C
第3题：
You are the database administrator of a SQL Server 2000 computer. The server contains your company's Accounts database. Hundreds of users access the database each day.
Because you have had power interruptions in the past, you want to perfect the physical integrity of the Accounts database. You do not want to slow down server operations.
What should you do?
A．Enable the torn page detection database option for each database.
B．Disable write caching on all disk controllers.
C．Ensure that write caching disk controllers have battery backups.
D．Create a database maintenance plan to check database integrity and make repairs each night.
解析：Explanation:Thescenariostatesthatpowerinterruptionshaveoccurredinthepast.Bybuyingabatterybackupsolutionforthediskcontrollersthepowerinterruptionproblemwouldbeprevented.IncorrectAnswers:A:Tornpagedetectionisareactivesolutionwhichwouldslowdownperformancesincerestoreswouldhavetobemade.Itwouldbettertouseapreventivesolution.Note:Tornpagedetection:Ifatornpageisdetected,thedatabasemustberestoredfrombackupbecauseitwillbephysicallyinconsistent.B:Cachingisveryimportforperformance.Disablingwrite-cachingwouldbeabadidea.D:Repairingthedatabaseeverynightisnotagoodsolution.Databaseerrorscannotbeaccepted.Itisbettertopreventtheprobleminsteadoftryingtofixitafterithashappened.
第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. 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.
正确答案:C
第5题：
You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions， monitoring the database server， and design deployment. In the company， you major job is the deployment， maintenance and support of Microsoft SQL Server 2005. You work as a database administrator for your company. A user database named Products is included by your SQL Server 2005 computer. SQL Server Integration Services （SSIS） packages are utilized to export data from the Products database to a text file. You deliver the text file to your company’s trading partners by utilizing FTP. You are required to make sure that your SSIS packages can be recovered from the occurrence of a disaster. Which action should be performed to finish the task？（）
- A、To finish the task，the Products database should be backed up.
- B、To finish the task，your server should be set to utilize the full recovery model.
- C、To finish the task，your server should be set to utilize the bulk-logged recovery model.
- D、To finish the task， the msdb database should be backed up.
正确答案:D
第6题：
Your test database is running in NOARCHIVELOG mode. What are the implications of this？ （）
- A、You can perform open database backups.
- B、You can perform closed database backups.
- C、You cannot perform schema-level logical backups.
- D、You can perform the backup of only the SYSTEM tablespace when the database is open.
正确答案:B
第7题：
You are a database administrator for your company. The company uses a SQL Server 2005 application. Each night， data is imported into a database， and the database is then set to be read-only. During business hours， users run predefined and ad hoc queries. You need to monitor the servers performance during the day. What are two possible ways to achieve this goal？（）
- A、Use the Lock Waits/sec performance counter.
- B、Use the Number of Deadlocks/sec performance counter.
- C、Use the Transactions/sec performance counter.
- D、Use the Full Scans/sec performance counter.
- E、Use the Batches/sec performance counter.
正确答案:D,E
第8题：
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.
第9题：
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 which is named Instance01. Instance01 contains a database which is named Dworks. The bulk-logged recovery mode is used by the Dworks database. You log ship the Dworks database through a WAN link. A scheduled job rebuilds the indexes of the Dworks database. You find that the size of the log backups for log shipping has been enlarged by the job. Now you have to reduce the size of the log backup. So what action should you perform to achieve this goal？（）
- A、You should recreate the indexes.
- B、You should compress the log file backups
- C、You should make the Dworks database use the Full recovery mode
- D、You should make the Dworks database use the Simple recovery mode.
正确答案:B
第10题：
You are a database administrator for your company. You are responsible for a SQL Server 2005 database that has several indexes. You need to write a stored procedure that checks the indexes for fragmentation. Which Transact-SQL statement should you use？（）
- A、DBCC DBREINDEX
- B、SELECT * FROM sys.dm_db_index_physical_stats
- C、DBCC INDEXDEFRAG
- D、SELECT * FROM sys.indexes
正确答案:B