What should you do?

You work as a database administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. Your duties include administrating a SQL Server 2005 database named Certkiller -DB04. You have received instruction from the CIO that Certkiller -DB04 will support a new Web-based application. This Web-based application will handle approximately 1,500 users simultaneously. The application must display the results of calculation-intensive operations like calculating the instalment and amortization schedules as quick as possible.
What should you do?

You work as a database administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. Your duties include administrating a SQL Server 2005 database named Certkiller -DB04. You have received instruction from the CIO that Certkiller -DB04 will support a new Web-based application. This Web-based application will handle approximately 1,500 users simultaneously. The application must display the results of calculation-intensive operations like calculating the instalment and amortization schedules as quick as possible.
What should you do?

A.
You should implement the USE Master Transact-SQL statement.

B.
You should implement CLR stored procedures in the database.

C.
You should implement parameterized Transact-SQL queries in the application.

D.
You should implement Transact-SQL stored procedures in the database.

E.
You should implement Distributed Web services.

Explanation:
A Common Language Runtime (CLR) will generally perform better than T-SQL and CRUD (Create, Read, Update, Delete) operations for complex math, string manipulation and other tasks that go beyond data access.



Leave a Reply 0

Your email address will not be published. Required fields are marked *