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?

Your company has two SQL Server 2005 computers named SQL1 and SQL2. Both servers take part in replication. SQL1 is both the Publisher and its own Distributor of a publication named Pub1. Pub1 is the only publication on SQL1, and SQL2 is the only Subscriber. Your supervisor requests a status report about the replication latencies. Using Replication Monitor on SQL1, you need to find out the current latencies between the Publisher and Distributor as well as between the Distributor and Subscriber. What should you do?

Your company has two SQL Server 2005 computers named SQL1 and SQL2. Transaction log shipping occurs from SQL1 to SQL2 by using default SQL Server Agent schedule settings. You need to reconfigure transaction log shipping to provide minimum latency on SQL2. What should you do?

Your company uses a mission-critical database named DB1, which is located on a server named SOL1.
You want to mirror DB1 on a second server named SQL2. Before you can establish database mirroring, you need to prepare DB1 and the servers for mirroring. Which three actions should you perform? (Each correct answer presents part of the solution. Choose three.)

PassGuide.com-Make You Succeed To Pass IT Exams
PassGuide 70-431

Your company uses a SQL Server 2005 database. CusMikeer data from your trading partners is imported into the CusMikeers table every night. You need to ensure that the cusMikeer record is updated if it already exists in the CusMikeers table. If the record does not exist, the data needs to be inserted into the CusMikeers table. What should you do?

You are creating a view to join the CusMikeers and Orders tables in a SQL Server 2005 database. You need to ensure that the view cannot be affected by modifications to underlying table schemas. You want to accomplish this goal by using the least possible amount of overhead. What should you do?

Your company uses SQL Server 2005. You are implementing a series or views that are used in ad hoc queries. The views are used to enrorce your companys security policy or abstracting data. Some or these views perform slowly. You create indexes on those views to increase performance, while still maintaining the companys security policy. One or the views returns the current date as one or the columns. The view returns the current date by using the GETDATE() function. This view does not allow you to create an index. You need to create an index on the view. Which two actions should you perform? (Each correct answer presents part of the solution.
Choose two.)

You work with a SQL Server 2005 database that provides banking information for cusMikeers. You want cusMikeers to see banking reports that combine data that is retrieved from the database with real-time investment information that comes from a Web service provided by a third party. The investment information must be current when the reports are executed.
You need to create the appropriate objects that support the reports. What should you do?