• 搜标题
  • 搜题干
  • 搜选项
0 / 200字
单项选择题

YouworkwithaSQLServer2005databasethatprovidesbankinginformationforcustomers.Youwantcustomerstoseebankingreportsthatcombinedatathatisretrievedfromthedatabasewithreal-timeinvestmentinformationthatcomesfromaWebserviceprovidedbyathirdparty.Theinvestmentinformationmustbecurrentwhenthereportsareexecuted.Youneedtocreatetheappropriateobjectsthatsupportthereports.Whatshouldyoudo?（）
A.PublishthedatainthedatabaseasanXMLWebservicebyusingtheFORXMLAUTOclause.
B.Createatabletostorethebankinginformationforeachcustomer.CreateatriggerthatfireswhendataisinsertedintothetablethatjoinswiththedatacomingfromtheWebservice.
C.CreateaTransact-SQLstoredprocedurethatusesatemporarytabletostorethebankinginformationforeachcustomer.UpdatethetablewiththevaluesfromtheWebservice.
D.HaveadeveloperinyourcompanycreateanassemblythatcallstheremoteWebservice.CreateaCLRfunctionbyusingtheassembly.CalltheCLRfunctionandcombinetheresultswithbankinginformationinthedatabase.

A.Youwantcustomerstoseebankingreportsthatcombinedatathatisretrievedfromthedatabasewithreal-timeinvestmentinformationthatcomesfromaWebserviceprovidedbyathirdparty.Theinvestmentinformationmustbecurrentwhenthereportsareexecuted.Youneedtocreatetheappropriateobjectsthatsupportthereports.Whatshouldyoudo?（）
A.PublishthedatainthedatabaseasanXMLWebservicebyusingtheFORXMLAUTOclause.
B.Createatabletostorethebankinginformationforeachcustomer.CreateatriggerthatfireswhendataisinsertedintothetablethatjoinswiththedatacomingfromtheWebservice.
C.CreateaTransact-SQLstoredprocedurethatusesatemporarytabletostorethebankinginformationforeachcustomer.UpdatethetablewiththevaluesfromtheWebservice.
D.HaveadeveloperinyourcompanycreateanassemblythatcallstheremoteWebservice.CreateaCLRfunctionbyusingtheassembly.CalltheCLRfunctionandcombinetheresultswithbankinginformationinthedatabase.
题目列表

你可能感兴趣的试题

单项选择题

YouneedtoensurethattheCust_CalcDatacolumnisimplementedappropriately.Whatshouldyoudo?（）

A.SpecifythattheCust_CalcDatacolumnmustbeimplementedasacomputedcolumnofthetable.
B.SpecifythattheCust_CalcDatacolumnmustbeindexedusinganon-clusteredindex.
C.SpecifythattheCust_CalcDatacolumnmustbeimplementedasacolumnthatusesauser-defineddatatype.
D.SpecifythattheCust_CalcDatacolumnmustbeupdatedbyaSQLServerAgentjobthatrunsnightly.
单项选择题

YourcompanyconsistsofasingleActiveDirectorydomainthatisconfiguredinWindows2000nativemode.AllserversrunWindowsServer2003ServicePack2(SP2).YoudeployaRoutingandRemoteAccessservertoprovideVPNaccesstothenetwork.YouneedtoensurethatonlymembersofagroupnamedSalescanaccessthenetworkthroughtheVPN.Thesolutionmustminimizetheadministrativeeffortrequiredtomanageremoteaccess.Whatshouldyoudo?（）
A.Allowdial-inaccessfortheuseraccountsofallSalesgroupmembers.
B.Denydial-inaccessfortheuseraccountsofallusersexcepttheSalesgroupmembers.
C.CreatearemoteaccesspolicyandassigntheAllow-RemoteAccesspermission.AddtheWindows-GroupsconditionandspecifytheSalesgroup.
D.CreatearemoteaccesspolicyandassigntheDeny-RemoteAccesspermission.AddtheWindows-GroupsconditionandspecifyallActiveDirectorygroupsexceptforSales.

A.AllserversrunWindowsServer2003ServicePack2(SP2).YoudeployaRoutingandRemoteAccessservertoprovideVPNaccesstothenetwork.YouneedtoensurethatonlymembersofagroupnamedSalescanaccessthenetworkthroughtheVPN.Thesolutionmustminimizetheadministrativeeffortrequiredtomanageremoteaccess.Whatshouldyoudo?（）
A.Allowdial-inaccessfortheuseraccountsofallSalesgroupmembers.
B.Denydial-inaccessfortheuseraccountsofallusersexcepttheSalesgroupmembers.
C.CreatearemoteaccesspolicyandassigntheAllow-RemoteAccesspermission.AddtheWindows-GroupsconditionandspecifytheSalesgroup.
D.CreatearemoteaccesspolicyandassigntheDeny-RemoteAccesspermission.AddtheWindows-GroupsconditionandspecifyallActiveDirectorygroupsexceptforSales.
微信扫码免费搜题