You are the administrator of a SQL server computer. The server is running SQL Server 6.5 and SQL Server 7.0.You install a named instance of SQL Server 2000, and then run the SQL server upgrade wizard. On the database selection screen, some of the SQL Serv

第1题：

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 text file which is named SQL01.log on the E: drive. A SQL Server Agent job executes every 2 minutes and logs information to the text file. You get a report from users saying that the sever doesn't make response. As the technical support, you check and find that the SQL Server Agent service does not run and the SQL Server Agent job no longer functions. You have to identify the reason why the SQL Server Agent service is unresponsive. In the options below, which log should you check?（）  

• A、You should check SQL1.log
• B、You should check SQLAGENT.OUT
• C、You should check log_xx.trc
• D、You should check ERRORLOG

第2题：

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 computer which hosts several applications in your company. The instance runs on the computer. A job named DiliveryList is created by you. This job requires a file to be written to a file server. But because the job cannot access the file server, it fails to run. You intend to configure the SQL Server Agent service so that only the SQL Server Agent service has read and write access to the file server. Which account type should you use? （） 

• A、You should use local Service account
• B、You should use network Service account
• C、You should use domain account
• D、You should use local System account

第3题：

You are designing a plan for migrating an existing Microsoft SQL Server 2008 database to SQL Azure.The database includes a SQL Server Agent job that cleans the application log table.   You need to recommend an approach for ensuring that the SQL Server Agent job continues to run without modification.  What should you recommend？（）

• A、 Use the SQL Azure Data Sync service.
• B、 Run the SQL Server Agent in SQL Azure.
• C、 Use SQL Server Integration Services （SSIS） to connect to SQL Azure.
• D、 Connect the existing on-premise SQL Server Agent jobs to SQL Azure.

第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 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

第5题：

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. According to the company requirement, you migrate an application from Microsoft SQL Server 2000 to Microsoft SQL Server 2008. You have to monitor the SQL Server instance, and record the use of features which will be discontinued. What should you do? （） 

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

第6题：

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

第7题：

You work in a company which uses SQL Server 2008. You are the administrator of the company database. In your company there is a server which contains a default SQL Server 2005 instance. For a new application, you have to install a SQL Server 2008 instance on the server. Your company CIO assigns a task to you. You must make sure that the respective certified third-party applications have access to both database instances. You have to achieve this goal without changing the existing application environments. So what should you do to achieve this by using as little database administrative effort as possible?（）

• A、You should install SQL Server 2008 as a named instance, and make the new application to use the new instance. 
• B、You should install SQL Server 2008 as the default instance, and make the new application to use the default instance. 
• C、You should upgrade the SQL Server 2005 application to use SQL Server 2008. 
• D、You should upgrade the SQL Server 2005 instance to a SQL Server 2008 instance. 

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

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. Now you get a report from users saying that DB1 meets deadlock problems. As the technical support, you have to capture the deadlock information to the SQL Server error log. What should you do?（）  

• A、For the AdventureWorks database, enable Server Auditing 
• B、First you should set the appropriate trace flags as a startup parameter, and then restart the SQL Server instance 
• C、You should configure the data collector and make it capture the deadlock graphs
• D、You should configure a SQL Profiler trace, and make it capture the deadlock graphs

第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 SQL Server 7.0 database. You upgrade the database to the SQL Server instance. According to the company requirement, you must make sure that suspect pages can be detected in the database. So what action should you perform to achieve this goal?（）

• A、For the database, you should turn on the TRUSTWORTHY database option
• B、For the database, the PAGE_VERIFY database option should be set to CHECKSUM
• C、For the database, the database compatibility level option should be set to 10
• D、For the model database, the PAGE_VERIFY database option should be set to TORN_PAGE_DETECTION. 

第15题：

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 a database administrator for your company. There is a Data Transformation Services （DTS） package， and the DTS package is stored in SQL Server 2000. And you plans to have the SQL Server 2000 migrated into SQL Server 2005. The DTS package dynamically configures precedence constraints by utilizing complex Microsoft Visual Basic Scripting Edition （VBScript）. The SQL Server 2005 Package Migration Wizard is run by you， but the wizard cannot convert the package from SQL Server 2000 to SQL Server 2005. You are required to make sure that the DTS package runs in SQL Server 2005. And the package should be run in the shortest time.  Which action should be utilized？（）

• A、The SQL Server 2000 Data Transformation Services （DTS） package should be wrapped in an Execute DTS 2000 Package task.
• B、The SQL Server 2000 Data Transformation Services （DTS） package should be manually recreated as a SQL Server Integration Services （SSIS） package.
• C、The SQL Server 2000 Data Transformation Services （DTS） task should be configured to not utilize precedence constraints. Then， the SQL Server 2005 Package Migration Wizard should be run again.
• D、The SQL Server 2005 Package Migration Wizard should be run. And when the upgrade fails， a Transfer SQL Server Objects task should be run.

第16题：

ou work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now for a new application, a SQL Server 2008 instance has to be installed on an existing server. The server contains a default SQL Server 2005 instance. Your company CIO wants their corresponding certified third-party applications can access to both database instances. The company assigns this task to you. You must achieve this by using as little database administrative effort as possible, and never change the existing application environments. What should you do? （） 

• A、You should install SQL Server 2008 as the default instance, and configure the new application to use the default instance 
• B、You should upgrade the SQL Server 2005 application to use SQL Server 2008 
• C、You should upgrade the SQL Server 2005 instance to a SQL Server 2008 instance 
• D、You should install SQL Server 2008 as a named instance, and make the new application use the new instance. 

第17题：

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 must make sure that all SQL Server instances are consistently configured for naming conventions, security settings, force index creation and avoidance of data fragmentation. So what action should you perform to achieve this goal?（）  

• A、You should use the Database Engine Tuning Advisor. 
• B、In Microsoft SQL Server Management Studio, you should create a maintenance plan 
• C、You should use the SQL Server Configuration Manager 
• D、In Microsoft SQL Server Management Studio, you should create a policy

第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 on the same physical computer. Now users report that they are unable to connect to the named instances. You check and verify that they can only connect to the default instance. You also ensure that all SQL Server instances run normally. You have to start the service which is required to connect to the named instances.  Which service should you start?（）  

• A、Server 
• B、SQL Server Agent 
• C、SQL Server Browser 
• D、SQL Active Directory Helper

第19题：

第20题：

第21题：

第22题：

第23题：