You are employed as a database administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. Domain.com makes use of a database named CK_DATA. CK_DATA is located on a server named Certkiller -DB01.
You have been informed by the CIO that a table scan on the Products table in CK_DATA causes a slow query. This is a large table that is used regularly. You investigate and discover that the query contains the following statement:
SELECT PrName, PrDesc FROM Products WHERE PrID = <value> However, the Products table should at all times remain available to users.
What should you do?

You are employed as a database administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. A full backup of your database named CK_Data is created automatically at midnight every day. You have been informed by the CIO that differential backups of CK_Data occur twice a day at 10:00 and at 16:00. A database snapshot is thus created daily at noon. A Domain.com user named Dean Austin is appointed as the technician in the Research and Development department. The CIO informs you that a developer accidentally dropped the NewProjects table in CK_Data at 12:30. You check and notice that the NewProjects was last updated one week ago. You instruct Dean Austin to recover the NewProjects table. He needs to accomplish this by using the minimum amount of administrative effort. It is important that he reduces the amount of information that is lost.
What should he do?

You work as the 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 implementing transaction log shipping for a database named CK_Data from a server named Certkiller -DB01 to a server named Certkiller -DB02. A Domain.com user named Rory Allen is appointed as a junior technician in the Research and Development department. You inform Rory Allen that CK_Data is 100 GB in size. It is therefore too big to transfer over the network in a reasonable amount of time. You instruct Rory Allen to minimize the impact on the network. Rory Allen needs to accomplish this by initializing the secondary database.
What actions should Rory Allen perform? (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 -SR31. You verify that Certkiller -SR31 exceeds the minimum recommended hardware requirements for SQL Server 2005.
What should you do next?

You manage a SQL Server 2005 computer that was installed using default settings. After a power failure, the SQL Server (MSSQLSERVER) service on your database server does not start. You need to find out the cause of the problem. Which three actions should you perform? (Each correct answer presents part of the solution. Choose three.)

You use Service Broker manage data requests between SQL Server 2005 databases. You need to make changes to objects for an existing service. You want to ensure that no messages can be received by the service until the changes are complete. What should you do?

You work in San Francisco at the main office of your company. You are responsible for managing a SQL Server 2005 database. The sales department wants a report that compares cusMikeer activity in the previous quarter between the main office in San Francisco and the branch office in Paris. They want the data sorted by surname and first name.
You restore a recent backup of the Paris database onto your server. You write queries to build the report, ordering the data by the Surname and FirstName columns.
You review the data and notice that the cusMikeer list from the Paris database is sorted differently.
The sales department needs the revised data within 15 minutes for a presentation. You need to implement the fastest possible solution that ensures that the data from both databases is sorted identically. 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?

You are a database developer for a company that manufactures bicycles. You are creating a Web application

that will retrieve data from a database named AdventureWorks. The application connects to a database server

that is running SQL Server 2005. One of the functions of your application will allow shift supervisors to see how

many bicycles were manufactured during the current shift.

A user named Tom creates a stored procedure named usp_GetPersonData in the dbo schema. You are creating

an HTTP endpoint that exposes a Web method named PersonData. This Web method allows client applications

to access the stored procedure. You use the following statement to create the endpoint.

CREATE ENDPOINT SQLEP_AWPersons

AS HTTP

(PATH = ‘/AWpersons’,

AUTHENTICATION = (INTEGRATED),

PORTS = (CLEAR),

SITE = ‘SQL1’)

FOR SOAP

(WEBMETHOD ”

(NAME=”),

BATCHES = DISABLED,

WSDL = DEFAULT,

DATABASE = ‘AdventureWorks’,

NAMESPACE = ‘http://Adventure-Works/Persons’)

You need to specify the correct WEBMETHOD and NAME to create the endpoint.

Which command should you use?

You are writing a query that returns data from tables in a SQL Server 2005 database. Some of the data is stored

in relational columns, and some of the data is stored in XML data type columns.

Your query needs to return a relational result set that contains data from relational fields and attribute values from

XML data type columns.

Which two methods of the XML data type should you use? (Each correct answer presents part of the solution.

Choose two.)