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?
A.
Implement parameterized Transact-SQL queries in the application.
B.
Implement Transact-SQL stored procedures in the database.
C.
Implement CLR stored procedures in the database.
D.
Implement distributed Web services.