You work as the database administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. All servers on the Domain.com network run Windows Server 2003 and all client computers run Windows XP Professional. The Domain.com network contains two SQL Server 2000 database servers named Certkiller -DB01 and Certkiller -DB02 that are configured fro log shipping. Certkiller -DB01 is the primary server and hosts a database named CK_Trading. Both Certkiller -DB01 and Certkiller -DB02 have Service Pack 3 for SQL Server 2000 installed. Domain.com wants to upgrade Certkiller -DB01 and Certkiller -DB02 to SQL Server 2005 Enterprise Edition but the CK_Trading database must remain available during the upgrade process. You verify that both Certkiller -DB01 and Certkiller -DB02 exceed the recommended hardware requirements for SQL Server 2005 Enterprise Edition. You then install Service Pack 1 for Windows Server 2003 on Certkiller -DB01 and Certkiller -DB02.
What should you do next?

You work as the database administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. All servers on the Domain.com network run Windows 2000 Server. The Domain.com network contains a SQL Server 7.0 database server named Certkiller -DB01 that runs on Windows 2000 Server. Service Pack 4 for Windows 2000 Server id installed on Certkiller -DB01.
Domain.com wants to migrate Certkiller -DB01 to SQL Server 2005. You decide to perform an in-place upgrade to SQL Server 2005. You verify that Certkiller -DB01 exceeds the recommended hardware requirements for SQL Server 2005.
What should you do next?

You work as the database administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. All servers on the Domain.com network run Windows 2000 Server. The Domain.com network contains a SQL Server 2000 database server named Certkiller -DB01 that runs on Windows 2000 Server Service Pack 4. Certkiller -DB01 contains a database named CK_Trading.
Domain.com wants to migrate Certkiller -DB01 to SQL Server 2005 but wants to retain the CK_Trading database with the same instance name. You decide to perform an in-place upgrade to SQL Server 2005. You verify that Certkiller -DB01 exceeds the minimum recommended hardware requirements for SQL Server 2005.
What should you do next?

You are employed as a database administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. You have received instruction from the CIO to prepare a new installation of SQL Server 2005. The new SQL Server 2005 database server is named Certkiller -DB01. A Domain.com user named Mia Hamm is a member of the Marketing department. You instruct her to identify the protocols that the client computers might use to connect to the server. Mia Hamm needs to identify the protocols that are needed to accomplish this goal.
What should she identify? (Choose all that apply)

You work as the database administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. All servers on the Domain.com network run Windows 2000 Server. The Domain.com network contains a SQL Server 2000 database server named Certkiller -DB01 that runs on Windows 2000 Server. Certkiller -DB01 contains a database named CK_Sales.
Domain.com intends migrating Certkiller -DB01 to SQL Server 2005 in the near future. To prepare for the migration, you decide to install SQL Server 2005 Express on a server named Certkiller -SR23. Certkiller -SR31 was used for previously used by application developer and contains Microsoft Visual Studio 2003, .NET Framework 1.2 and Internet Explorer 5.5. You verify that Certkiller -SR23 exceeds the minimum recommended hardware requirements for SQL Server 2005. What should you do next? (Each correct answer provides part of the solution. Choose THREE.)

You work as a database administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. All servers on the Domain.com network run Windows Server 2003 with the latest Service Packs and Hotfixes, while the client computers run Windows XP Professional, Windows 98 Second Edition, and Novell NetWare 6.5.
You have received instruction to prepare for a new installation of SQL Server 2005 on a member server named Certkiller -SR21. Certkiller -SR21 will host a database named CK_Sales. All Domain.com users must be able to connect to Certkiller -SR21 by computer name. A Domain.com network administrator named Rory Allen must ensure that the client computers will be able to connect to Certkiller -DB01.
Which protocols can Domain.com users use to Certkiller -SR21?

Your company uses SQL Server 2005. A user reports that an order processing application stopped responding in the middle of an order transaction. The users SQL Server session ID is 54. You need to find out if session 54 is blocked by another connection. If it is, you need to identity the blocking session ID. What are two possible ways to achieve this goal? (Each correct answer presents a complete solution. Choose two.)

Your company has a server named SQL1 that runs SQL Server 2005 Enterpilse Edition. SQL1 has 2 GB of RAM, 1.6 GB of which are used by the default SQL Server database engine instance. The average data growth of all databases combined is 100 MB a month. Users state that report execution times are increasing. You want to assess whether more RAM is needed. You need to use System Monitor to create a counter log that will help you decide whether to add RAM. Which performance object should you add to the counter log?

The sales department and the finance department are located in different buildings. The two departments are connected by a 2 megabit network. Both departments use SQL Server 2005. The sales department records all sales activities in a database named DB1. DB1 contains 380 tables and has a size of 10 GB. The finance department has read-only access to four tables in DB1 for reporting purposes. The finance department runs queries throughout the day and needs the data to be as up to date as possible. Users in the finance department tell you that report execution is slow. To optimize network capacity, your department decides to provide copies of these four tables to the finance department. You need to provide copies of these tables. You want to achieve this goal by using the copy method that uses the least amount of network bandwidth. What should you do?

You are creating an HTTP endpoint that will be used to provide customer data to external applications. Your SQL Server 2005 computer is named SQL1 . You create a stored procedure named dbo.usp_GetPersonData to retrieve the data in the AdventureWorks database. You create the endpoint by using the following code.

CREATE ENDPOINT SQLEP_AWPersons
AS HTTP
(PATH = ‘/AWpersons’,
AUTHENTICATION = (INTEGRATED),
PORTS = (CLEAR),
SITE = ‘SQL1’)
FOR SOAP
(WEBMETHOD ‘PersonData’
(NAME=’AdventureWorks .dbo .usp_GetPersonData’),
BATCHES = DISABLED,
WSDL = DEFAULT,
DATABASE = ‘AdventureWorks’,
NAMESPACE = ‘http://Adventure-Works/Persons’)

The first users to connect to the endpoint tell you that they do not get any data. You connect to the endpoint and discover that it is not responding.

You need to modify the endpoint so that data is returned as expected. What should you do?