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 lo

第1题：

You are a database administrator for your company. The company uses a vendor company’s application that is based on a proprietary database. You query data from the application database and import the data into a SQL Server 2005 database. The application vendor provides you with a new OLE DB driver to be used when querying the application database. Company policy prohibits connections between the SQL Server database and the application database， except when querying this data. You need to provide a way to query data from the application database. What should you？（）

• A、Configure a Linked Server connection to the application database.
• B、Write a query that uses an OPENDATASOURCE command.
• C、Write a query that uses an OPENQUERY command.
• D、Configure a Remote Server connection to the application database.

第2题：

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.

第3题：

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

第4题：

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.

第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. There is a database named Inventory on a SQL Server 2005 computer， and the computer is named SQL01. SQL01 is utilized to aggregate manufacturing part numbers from your company’s trading partners. And the company stores the manufacturing part numbers in the Product table in the Inventory database. The company requests the users to deliver data as text files from each trading partner to SQL1 every night. The data should be imported， and no duplicate manufacturing part numbers should exist in the data which is imported from the text files， and the text files are stored in the Inventory database on SQL01. You should cut the effect on your company’s trading partners and your IT department to the least.  Which action should you perform？（）

• A、First， you should import the data from each text file into a staging table. Second， you should write a query to have a HAVING clause contained so as to migrate replicate values before results are inserted into the Product table.
• B、First， you should make sure that each text file is stored in an Extensible Markup Language （XML） file. Second， you should utilize Extensible Stylesheet Language Transformations （XSLT） to automatically migrate replicates before data is imported into the Product table.
• C、First， you should make sure that the unique key values for manufacturing part numbers are utilized by each of your company’s trading partners utilizes. Second， you should import the text files into the Product table.
• D、You should place a unique index on the PartNum column.

第6题：

You are the administrator of a SQL Server 2005 computer named SQL1. SQL1 contains a database that utilizes SQL Server log shipping. Log shipping occurs every 30 minutes. Each night， a full backup is made of the database， and all database indexes are rebuilt. The company’s network administrator reports that SQL1s network utilization becomes excessive after the nightly maintenance tasks are complete. You need to reduce the network bandwidth utilization for SQL1. What should you do？（）

• A、Configure the database to use the bulk-logged recovery model.
• B、Each night， rebuild only those indexes that require it.
• C、Disable log shipping before the nightly maintenance. Re-enable log shipping after nightly maintenance completes.
• D、Increase the time between transaction log backups.

第7题：

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. Now you get an order from your company CIO， you have to identify whether a database integrity check （DBCC CHECKDB） was run for a particular database.  Which log file should you examine？（）

• A、log.trc 
• B、default.trc 
• C、ERRORLOG 
• D、SQLAGENT

第8题：

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.

第9题：

第10题：

第11题：

第12题：

第13题：

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. VIP customer data of the company are stored in DB1. The customers access their profile data by using a Web application. You must ensure the security of the customer data， that is to say， even if the backup media is lost， you must guarantee that data files， log files and subsequent backups and so on are as safe as possible.  So what action should you perform to achieve this goal？（）

• A、For both the CustomerDB database and the master database, enable Transparent Database Encryption 
• B、You should use the built-in encryption functions to encrypt the sensitive data at the cell Ievel 
• C、You should make the CustomerDB database accessible only through stored procedures and functions. 
• D、For the CustomerDB database, enable Transparent Database Encryption and back up the transaction log. 

第14题：

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; 

第15题：

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;

第16题：

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.

第17题：

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.

第18题：

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. You have to perform the backup of the default trace according to the requirement of your failure recovery plan. The default trace is contained in the subdirectory.You have to backup the subdirectory.  Which SQL Server database engine subdirectory should be backed up？（）

• A、DATA
• B、INSTALL 
• C、LOG 
• D、BINN

第19题：

You are a database administrator for your company. You are configuring a new SQL Server 2005 computer named SQL1. SQL1 will run Reporting Services. It will also be configured to automatically perform database backups and other maintenance tasks. There are no other SQL Server computers in the network environment. All access to SQL1 will be made by using SQL1s DNS name. You need to disable any unnecessary services on SQL1. Which service or services should you disable？（）

• A、Internet Information Services
• B、SQL Server Browser
• C、SQL Server Agent
• D、Microsoft Distributed Transaction Coordinator

第20题：

第21题：

第22题：

第23题：