Wednesday, November 18, 2009

Data warehouse questions

1. List the types of statistics collected for monitoring the functioning of the data


warehouse.

2. Describe any six different types of action for growth planning prompted by the

collected statistics.

3. How do the statistics help in fine-tuning the data warehouse?

4. Do you think publishing the statistics and similar data for the users is helpful? If

so, why?

5. What are the three main subjects in user training content? Why are these essential?

6. Describe any four major tasks needed to prepare a training program.

7. What are the responsibilities of the training administrator?

8. Do you think a multitier user support structure is suitable for the data warehouse

environment? What are the alternatives?

9. What role can the company’s intranet play in training and user support?

10. List any five factors to be part of ETL management.