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

Demo Question 1.

You are a data warehouse analyst for a retail company. You are working on the performance and scalability requirements for a new data warehouse that will replace an existing data warehouse. The marketing department needs the data warehouse to be loaded on a daily basis. The sales department also wants a daily load process, but that department's basic business requirements are met with a weekly load process. The CPU capacity of the current data warehouse server can support a weekly load process. The current data warehouse shares a server computer with the corporate financial databases. This server computer has the maximum CPU capacity, memory, and disk space that is was designed to handle. During the week, the server runs nightly batch jobs in support of the financial database. Only the weekend currently has enough time available to load the current data warehouse. It is anticipated that the new data warehouse will run on the existing server. With the existing server, you will not be able to meet the requirement of a daily load process for the new data warehouse. The directors of the marketing department and the sales department agree that if daily loads of the new data warehouse can be achieved, budget for additional resources can be made available. What can you do? (Choose three.)

A. Recommend purchasing another server that will support the Enterprise Editions of SQL Server 7.0 and Microsoft Windows NT 4.0.
B. Recommend purchasing a departmental server for the sales department and deploying a sales data mart.
C. Upgrade the network to provide additional bandwith.
D. Reschedule the nightly batch jobs for the financial database to the weekend.
E. Move the data warehouse processing off the current server to a new server.
F. Use Data Transformation Services (DTS) to provide for daily loading of the data warehouse.


Display Answer

Answer: A, E; F

Explanation: A. We need a server the Enterprise Edition of SQL Server 7.0 to support full functionality of OLAP Services. E. We need to offload the current server. The data warehouse should be run on the new server. F. A DTS package can be created and scheduled to run once a day. Incorrect