You are employed as a database administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. Your duties at Domain.com include the administration of a SQL Server 2005 database named Certkiller -DB02.
Certkiller -DB02 provides the clients with their banking information. The CIO wants the clients see the investment reports that combine the information retrieved from Certkiller -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 Domain.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.