Chapter 1

Benefits of Data Warehousing

Review Questions

  1. What is a data warehouse?
  2. A data warehouse is a historical, consistent data store, including the tools used to query and analyze that data.

  3. What is a data mart?
  4. A data mart is a subset of a warehouse that is usually for just a particular department or business process.

  5. What are some benefits provided by data warehousing?
  6. The ability to access enterprisewide data

    The ability to have consistent data

    The ability to perform analysis quickly

    Recognition of redundancy of effort

    Discovery of gaps in business knowledge or business processes

    Decreased administration costs

    Empowerment of all members of an enterprise provided with information necessary to perform effectively

  7. True or false: Implementing a data warehouse with SQL Server 7.0 requires additional tools purchased from third-party vendors.
  8. False



Microsoft Corporation - Microsoft SQL Server 7 Data Warehousing Technical Support Training Kit
Microsoft SQL Server 7 Data Warehousing Technical Support Training Kit
ISBN: 0735606706
EAN: 2147483647
Year: 1999
Pages: 114

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net