YouworkwithaSQLServer2005databasethatprovidesbankinginformationforcustomers.Youwantcustomerstoseebankingreportsthatcombinedatathatisretrievedfromthedatabasewithreal-timeinvestmentinformationthatcomesfromaWebserviceprovidedbyathirdparty.Theinvestmentinformationmustbecurrentwhenthereportsareexecuted.Youneedtocreatetheappropriateobjectsthatsupportthereports.Whatshouldyoudo?()
A.PublishthedatainthedatabaseasanXMLWebservicebyusingtheFORXMLAUTOclause.
B.Createatabletostorethebankinginformationforeachcustomer.CreateatriggerthatfireswhendataisinsertedintothetablethatjoinswiththedatacomingfromtheWebservice.
C.CreateaTransact-SQLstoredprocedurethatusesatemporarytabletostorethebankinginformationforeachcustomer.UpdatethetablewiththevaluesfromtheWebservice.
D.HaveadeveloperinTestKing.comcreateanassemblythatcallstheremoteWebservice.CreateaCLRfunctionbyusingtheassembly.CalltheCLRfunctionandcombinetheresultswithbankinginformationinthedatabase.