SQL Server 2005 MCTS 70-431 - Part 2

Take This Test

Section 1

1) You are building a scientific application that will store data in a SQL Server 2005 database. The application does not store data until a final process is complete. One of the procedures you are currently working with performs many processor-intensive calculations. Which of the following would accommodate the situation?

(Select all that apply.)

2) Customer data from your trading partners is imported every night. You need to ensure that the customer record is updated if it already exists. If the record does not exist, the data for the customer needs to be inserted into the Customers table. What should you create?
3) You need to configure access to a second SQL server for an application that will be using the data for a single query. How would you implement the configuration and query?
4) You are implementing views that are used in ad hoc queries. The views are used to enforce application security policy. Some of these views perform slowly. You create indexes on those views to increase performance but still maintain the security policy. One of the views returns the current date as one of the columns. The view returns the current date by using the GEtdATE() function. This view does not allow you to create an index. Which two actions should you perform?
(Select two answers, as each correct answer presents part of the solution.)
5) Several users are complaining of problems with updating of data through their application. You suspect that locks placed by other users and applications are preventing updates from occurring. Which of the following will help locate current locks and blocking?
6) You are designing a query that must return related data from two tables. You must return only data that matches between the tables. One column of data allows null entries, and you are not to return data from either table in this case. Which of the following SQL items is needed?
7) Indexes of a table are heavily fragmented. What should you do to decrease the fragmentation of all indexes while keeping the table available to users?
8) How to prevent non-management individuals from accessing a Microsoft SQL Server 2005 Enterprise Edition instance on a server?
9) You are creating a backup job and want to ensure that a new header is placed on the tape you are using. What option do you use to perform this task?
10) You are preparing a table design for a complex business database application. After data entry, it is a requirement of one of these fields that a series of complex business logic procedures must be performed to obtain the value for the field. Which of the following would you implement?

Take This Test

Also check these SQL Server 2005 test papers, these are one of most attempted test paper in this category.