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 the database administrator for your company. You receive report from users saying that a SQL Server 2005 application makes no response for several seconds at a time during the day. This problem happens at random throughout the day and many users are affected at once. You check at the time that the problem happens. You find that both CPU utilization and disk utilization on the SQL Server 2005 computer are low, but that the network is operating normally. Therefore, you have to examine additional information that is related to the problem. What action should you perform?

• A. You have to check the output of the DBCC SHOWCONTIG command.
• B. You have to check the sys.dm_tran_locks dynamic management view (DMV).
• C. You have to check the total number of lock requests on the SQL Server 2005 computer.
• D. You have to check the output of the DBCC SQLPERF(IOSTATS) command.
• E. You have to check the total number of index and table scans on the SQL Server 2005 computer.

The DeliveryVans, AirlinePreferences, and SeasonalContractors databases should be removed into the data center. Which action should be performed?

• A. A SQL Server database should be created for each of the databases in a single instance of SQL Server 2005.
• B. A separate instance of SQL Server 2005 should be installed for each of the databases on a single server.
• C. A default instance of SQL Server 2005 should be installed on three separate servers. And then, one server should be utilized for each of the databases.
• D. The data should be imported from each of the databases into a single database in an instance of SQL Server 2005.

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 the database administrator for your company. There is a SQL Server 2005 computer in the company. A single user database named DB01 is contained in this computer. All company employees connect to DB1. According to the requirement of the company policy, the database should be fault-tolerant and that failovers require no administrative effort. Therefore, you are asked to provide fault tolerance for the database.
Your solution must guarantee that even if a complete hardware failure occurs on the SQL Server 2005 computer, client computers are able to connect to the database, including a failure of all disks. What action should you perform to achieve your goal?

• A. Log shipping needs to be implemented to another SQL Server 2005 computer.
• B. Transactional replication needs to be implemented to another SQL Server 2005 computer.
• C. A two-node server cluster that contains the database needs to be implemented.
• D. Database mirroring to another SQL Server 2005 computer needs to be implemented.

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 2005 Package Migration Wizard should be run. And when the upgrade fails, a Transfer SQL Server Objects task should be run.
• 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) package should be wrapped in an Execute DTS 2000 Package task.
• D. 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.

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 query execution plan, you should look for queries with missing or out-of-date statistics.
• B. In a query execution plan, you should look for queries with a large number of table scans.
• C. In a SQL Trace log file, you should look for queries with low duration values and high read and write values.
• D. In a SQL Trace log file, you should look for queries with high duration values and low read and write values.