70-431 Microsoft SQL Server 2005 - Implementation and Maintenance Practice Exam

Demo Question 1.

You are employed as a database administrator at EliteCertify.com. The EliteCertify.com network consists of a single Active Directory domain named EliteCertify.com. Your duties at EliteCertify.com include the administration of a SQL Server 2005 database named EliteCertify -DB02. EliteCertify -DB02 provides the clients with their banking information. The CIO wants the clients see the investment reports that combine the information retrieved from EliteCertify -DB02 with real-time investment information that comes from a Web service provided which is provided by a third party. You need to ensure that the investment information is current when the reports are executed. You need to create the appropriate objects that support the reports. What should you do?

A. You should create a table to store the banking information for every client. Then you should create a trigger that fires when information is inserted into the table that joins with the data coming from the Web service.
B. You should publish the data in the database as an XML Web service by using the FOR XML AUTO clause.
C. A developer in EliteCertify.com needs to create an assembly that calls the remote Web service. Then you should create a CLR function by using the assembly. Thereafter he can call the CLR function and combine the results with banking information in the database.
D. You should create a Transact-SQL stored procedure that uses a temporary table to store the banking information for each customer. Thereafter he should update the table with the values from the Web service.


Display Answer

Answer: C

Explanation: