Your company uses a SQL Server 2005 database. This database 

第1题：

You are planning the deployment of a SQL Azure database.  Your company has a Volume Licensing Agreement for Microsoft SQL Server 2008. The SQL Azure database must maintain a monthly availability of 99.9%.   You need to recommend an approach for minimizing the monthly expenses associated with the SQL Azure database.  What should you recommend？（）

• A、 Add a processor license to the existing SQL Server licensing agreement.
• B、 Purchase a Windows Azure consumption platform subscription.
• C、 Purchase a SQL Server Services Provider Licensing Agreement （SPLA）.
• D、 Purchase a SQL Server Web license to extend the existing SQL Server licensing agreement.

第2题：

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 DB01 in the instance. The company CIO wants all the application developers can capture traces to troubleshoot the application that uses the database DB1， and they can perform this by using SQL Server Profiler. But they have to be given as little permission as possible. The company CIO assigns this task to you.  So what action should you perform to achieve this goal？（）  

• A、All the SQL Server logins of the application developers have to be added to a fixed server role. 
• B、All the database users of the application developers have to be added to a fixed database role 
• C、All SQL Server logins of the application developers should be given the appropriate server-level permissions. 
• D、All database users of the application developers should be given the appropriate database-level permissions. 

第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 which contains a database. According to the company requirement， you have to move the application from Microsoft SQL Server 2000 to Microsoft SQL Server 2008. You have to monitor the SQL Server instance to record the use of features.  These features will be discontinued. What should you do？ （）

• A、The SQL Server 2008 Upgrade Advisor should be used. 
• B、The SQL Server Profiler which captures the SQL:BatchCompleted and Exception event classes should be used. 
• C、A SQL server-side trace that captures the Deprecation Announcement and Deprecation Final Support event classes should be used 
• D、A SQL server-side trace that captures the SQL:BatchCompleted and Exception event classes should be used.

第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 contains a database. Now your company CIO assigns a task to you. You have to check the performance of the SQL Server 2008 instance. You have to find out which common language runtime (CLR) queries takes the longest-running time.  So in the options below, which dynamic management view should you choose to use?（）  

• A、sys.dm_os_wait_stats 
• B、sys.dm_exec_requests 
• C、sys.dm_exec_sessions 
• D、sys.dm_exec_query_stats

第5题：

ou 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. According to the company requirement, you intend to perform an installation of an instance of SQL Server Reporting Services (SSRS) to the same machine. Now your company CIO wants version histories of all deployed reports can be kept. As a technical support, what should you do to ensure this?（）

• A、You should use the http.sys listener to install the SSRS instance. 
• B、You should configure the SSRS database, make it use Native mode 
• C、You should configure the SSRS database, make it use SharePoint integrated mode 
• D、You should use the Internet Information Services default Web site to install the SSRS instance 

第6题：

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.

第7题：

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 Dworks in the instance. You are log shipping the Adventureworks database to a remote SQL Server 2008 instance. The primary SQL Server instance required a restart during the weekend. But you notice that log shipping has stopped working after the weekend. You have to check log shipping of the Adventureworks database and find out the problem. What should you do? （） 

• A、You should use the EXTENDED_LOGICAL_CHECKS option to execute a DBCC CHECKDB statement on the AdventureWorks database by. 
• B、You should identify whether the SQL Server Agent is started on the primary server. 
• C、You should identify whether the AdventureWorks database uses the Simple recovery model. 
• D、You should identify whether the SQL Server Volume Shadow Copy Service (VSS) Writer is started on the primary server

第8题：

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.

第9题：

Your company uses a SQL Server 2005 database. Customer data from your trading partners is imported into the Customers table every night. You need to ensure that the customer record is updated if it already exists in the Customers table. If the record does not exist, the data needs to be inserted into the Customers table. What should you do?（）

• A、 Create a FOR trigger. 
• B、 Create an INSTEAD OF trigger. 
• C、 Create an AFTER trigger. 
• D、 Create a DDL trigger.

第10题：

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