70-019 Designing and Implementing Data Warehouse with Microsoft SQL server 7.0 Online Class

Microsoft ™

70-019 Designing and Implementing Data Warehouse with Microsoft SQL server 7.0

Note 1: 70-019 Exhibit and all related diagrams are not shown in demo questions.
Note 2: 70-019 Answers are not shown in demo questions.
Exhibits and Answers are only provided in the Full Version.

Demo Question 10.

You are a technology consultant for West Coast Sales. West Coast Sales wants to develop an application for its salespersons. The salespersons are typically traveling 75 to 90 percent of the time and do no have permanent offices. The salespersons use a modem to connect to the company's network. The company wants the new application to perform reporting of actual sales results, reporting of sales projections, and analysis of "what if" scenarios. This application will require data from the company's data warehouse that is specifically relevant to a particular salesperson and that salesperson's product line. You need to design this new application. Which two technologies can you use? (Choose two.)

A. SQL Server replication
B. PivotTable Service
C. Microsoft Briefcase
D. Microsoft Excel

Display Answer

Purchase Full Version:

70-019 Printable PDF Prep Guide $59.95 BUY NOW!

70-019 Test Simulation Engine $69.95 BUY NOW!

70-019 PDF & Test Simulation Engine $99.95 BUY NOW!

Answer: B, D

Explanation: B. The PivotTable Service enables analysis on the client machine. Cube subsets can be stored on the client machine, so analysis is faster and the client does not have to go back to the server for data. The client machine can even be disconnected from the network so that the cube can be taken off line for analysis. D. Microsoft Excel can be used to report actual sales results, sales projection, and what if scenarios. Microsoft Excel can use the cubes provided by the PivotTable Service as the data source. Reference: SQL Server 7.0 Data Warehousing Training Kit (), PivotTable Service Incorrect