You are a database administrator for AIOTestKing.com. A company vendor provides product inventory data by using a Web service. Your company needs to create several reports based on this data. You need to ensure that the reports have access to the necessary data.
Your solution must provide the best reporting performance. What should you do?
A.
Create a SQL Server Integration Services (SSIS) package that uses a Web service task to retrieve the data and store it in the database. Create reports that utilize the data in the database.
B.
Create Reporting Services reports that retrieve data directly from the vendor Web service.
C.
Create Reporting Services reports that retrieve data by using XPath queries.
D.
Create a SQL Server Integration Services (SSIS) package that uses an FTP task to retrieve the data and store it in the database. Create reports that utilize the data in the database.
Explanation:
The Power of Knowing. The Web Service task executes a Web service method. You can use the Web Service task to for example writing to a variable the values that a Web service method returns. For example, you could obtain the highest temperature of the day from a Web service method, and then use that value to update a variable that is used in an expression that sets a column value.