O'Reilly logo

DATA WAREHOUSING FUNDAMENTALS: A Comprehensive Guide for IT Professionals by Paulraj Ponniah

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

19.8. EXERCISES

  1. Indicate if true or false:

    1. It is a good practice to drop the indexes before the initial load.

    2. The key of the fact table is independent of the keys of the dimension tables.

    3. Remote deployment of desktop tools is usually faster.

    4. A pilot data mart is necessary when the users are already very familiar with data warehousing.

    5. Backing up the data warehouse is not necessary under any conditions because you can recover data from the source systems.

    6. Passwords must be cryptic and arbitrary.

    7. Always checkpoint the load jobs.

    8. It is a good practice to load the fact tables before loading the dimension tables.

    9. Initial training of the users must include basic database and data storage concepts.

    10. Role-based security provision is not suitable for the data warehouse.

  2. Prepare a plan for getting the user desktops ready for the initial deployment of your data warehouse. The potential users are spread across the country in thirty major centers. Overseas users from four centers will also be tapping into the data warehouse. Analysts at five major regional offices will be using the OLAP system. Your data warehouse is Web-enabled. Make suitable assumptions, considering all aspects, and work out a plan.

  3. What are the considerations for deploying the data warehouse in stages? Under what circumstances is staged deployment recommended? Describe how you will plan to determine the stages.

  4. What are the characteristics of the type of pilot system described as a broad business pilot? What are its advantages and disadvantages? ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required