试题详情
- 单项选择题 You work with a SQL Server 2005 database that provides banking information for customers. You want customers to see banking reports that combine data that is retrieved from the database with real-time investment information that comes from a Web service provided by a third party. The investment information must be current when the reports are executed. You need to create the appropriate objects that support the reports. What should you do?（）
A、 Publish the data in the database as an XML Web service by using the FOR XML AUTO clause.
B、 Create a table to store the banking information for each customer. Create a trigger that fires when data is inserted into the table that joins with the data coming from the Web service.
C、 Create a Transact-SQL stored procedure that uses a temporary table to store the banking information for each customer. Update the table with the values from the Web service.
D、 Have a developer in your company create an assembly that calls the remote Web service. Create aCLR function by using the assembly. Call the CLR function and combine the results with banking information in the database.
- D
关注下方微信公众号，在线模考后查看
热门试题
- Your network&e
- All client computer
- You are a network ad
- You are t
- 您有一台运行 Windows
- You are em
- You are c
- You work
- 为应用程序开发人员上班 Certkil
- You create&ensp
- 你是TestKing网站的电脑管理员，公
- You are u
- Your network contain
- Certkiller.com&ensp
- 您最近在计算机上安装了某个应用程序。该应
- Your company runs R
- 您公司计划将所有客户端计算机升级为Win
- You create&ens
- 您有一台运行Windows 7
- You create a Web For