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 at Domain.com include the administration of a SQL Server 2005 database named Certkiller -DB02.
Certkiller -DB02 hosts a database named CK_Sales that stores sales transactions for the company. Domain.com wants to provide customers real-time delivery tracking information using data retrieved from Certkiller -DB02 and data from a parcel tracking Web service provided by a third party. You need to ensure that the real-time tracking information is current when queries are executed. You need to create the appropriate objects that support the queries.
What should you do?
A.
You should create a table to store the tracking information for every shipped item.
Then you should create a trigger that fires when information is inserted into the table that joins with the data coming from the parcel tracking Web service.
B.
You should publish the data in the database as an XML Web service by using the FOR XML AUTO clause.
C.
You should create an assembly that calls the parcel tracking Web service and a CLR function using the assembly.
Then you should call the CLR function and combine the results with customer information in the database.
D.
You should create a Transact-SQL stored procedure that uses a temporary table to store the tracking information for each customer.
Then you should update the table with the values from the parcel tracking Web service.