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?

Your company uses a SQL Server 2005 database. This database contains a trigger named trg_lnsertOrders, which fires when order data is inserted into the Orders table.
The trigger is responsible for ensuring that a cusMikeer exists in the CusMikeers table before data is inserted into the Orders table. You need to configure the trigger to prevent it from firing during the data import process.
You must accomplish this goal while using the least amount of administrative effort. Which two Transact-SQL statements can you use to achieve this goal? (Each correct answer presents a complete solution. Choose two.)

You are creating a SQL Server 2005 database for a mortgage company. The database will support a new Web-based application that will handle up to 1,000 simultaneous users.
This application must quickly display the results of calculation-intensive operations, such as calculating mortgage payments and amortization schedules. You need to ensure that the database processes calculations as quickly and efficiently as possible. What should you do?

Your company Web site includes a page that cusMikeers use to send feedback about the company and its products. You use a SQL Server 2005 database to store the comments in the Comments column of a table named Feedback.
You need to implement full-text searching so that you can run reports on the comments. Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)