Application developers in your company create an assembly that contains a CLR function. This CLR function reads data from a spreadsheet, performs some calculations, and returns the data to a SQL Server 2005 computer. You need to register the assembly with SQL Server 2005 by using the CREATE ASSEMBLY statement and the least privileged security’ permission set.

Which permission set should you use?

You are preparing for a new installation of SQL Server 2005. You need to select the protocols that client computers might use to connect to the server. Which two protocols can you use to achieve this goal?

(Each correct answer presents a complete solution. Choose two.)

Your SQL Server 2005 database contains a table that has 500?million rows of data. Some of the data is

historical and some is current.

You need to partition the data on a single server to increase performance and optimize maintenance.

What should you do?

Your company Web site includes a page that customers 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.)

You are responsible for managing the database schema for an order entry application in a SQL Server 2005

database.

After a design review, a member of the development staff asks you to add a new column named CommissionRate

to the Product table. Because the actual commission rates for all products are not known at this time, each

product has a default commission rate of 12 percent. The rate can be modified as necessary. You add the new

column.

You need to configure the table to assign the default value as efficiently as possible.

What should you do?

You are modifying a table named Product in a SQL Server 2005 database. You want to add a new column

named FriendlyName to the Product table. A friendly name for each product will be stored in this column. The

table currently contains data. The sales department has not yet created a friendly name for each product.

FriendlyName is a required value for each product.

You want to add this new column by using the least amount of effort.

What should you do?

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 has a SQL Server 2005 computer. You have been assigned the task of retrieving information

about a user who is currently logged in.

You need to create a function that returns scalar information about the activity time for a particular user.

What are two possible ways to achieve this goal? (Each correct answer presents a complete solution. Choose two.)

Your company uses SQL Server 2005. You are implementing a series of views that are used in ad hoc queries.

The views are used to enforce your companys security policy of abstracting data.

Some of these views perform slowly. You create indexes on those views to increase performance, while still

maintaining the companys 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.

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

You want customers 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?