A full backup of your database named DB1 is created auMikeatically at midnight every day. Differential backups of DB1 occur twice each day at 10:00 and at 16:00. A database snapshot is created every day at noon.
A developer reports that he accidentally dropped the Pricelist table in DB1 at 12:30. The last update to Pricelist occurred one week ago. You need to recover the Pricelist table.
You want to achieve this goal by using the minimum amount of administrative effort. You must also minimize the amount of data that is lost. What should you do?

You are implementing transaction log shipping for a database named DB1 from a server named SOL1 to a server named SQL2. Because DB1 is 100 GB in size, it is too big to transfer over the network in a reasonable amount of time.
You need to minimize the impact on the network while you initialize the secondary database. Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)

Your company has a network that consists of two domains named DOM1 and DOM2. There is no trust relationship between DOM1 and DOM2. DOM1 contains a server named SQL1. DOM2 contains a server named SQL2.

Both servers run SQL Server 2005. The SQL Server instance on SQL1 uses the DOM1 SQLService1 service account.
The SQL Server instance on SQL2 uses the DOM2SQLService2 service account. There are no mirroring endpoints on either server. SQL1 contains a database named DB1 .
You want to mirror DB1 to SQL2 by using high-protection mode without a witness. You need to create the database mirroring endpoints and configure security on all participating server instances. What should you do?

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.)

You use a SQL Server 2005 computer that was installed with the default settings. A database named DB1 is located on the server. Due to the recent failure of a hard disk controller, you decide to check the integrity of DB1.
You create a maintenance task named CheckDB1 that uses default settings. Because this check must not interfere with user transactions, you schedule it to run over the weekend.
The following Monday, you need to retrieve the outcome details of the CheckDB1 maintenance plan.
What are two possible ways to achieve this goal? (Each correct answer presents a complete solution. Choose two.)

You are responsible for managing a SQL Server 2005 database. This database is updated with data that is exported from another site. On a monthly basis, data is loaded into the database from a flat file by using the bcp utility.
This operation should be minimally logged. However, users report that they receive error messages indicating that the transaction log is full.
You investigate and discover that the errors occur when the data is being imported.
You need to prevent this problem from occurring. What should you do?

You are creating a Web-based application to manage data aggregation for reports. The application connects to a SQL Server 2005 database named DataManager.
One page in the application has controls that execute stored procedures in a database named ReportingDatabase. There is an existing Service Broker connection between the DataManager database and ReportingDatabase.
You want to add two new message types to the existing service. In each database, you create message types named ProcessReport and SendResult. You need to add the two new message types to the existing service.
What should you do first?

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 cusMikeer 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?