Chapter 13

Maintaining a SQL Server Data Warehouse

Review Questions

  1. You want to identify which database in your data warehouse is most critical to your operations the one you must back up regularly. Data in the enterprise database comes from multiple heterogeneous data sources and requires numerous data transformations. Data in your data marts comes from subsets of the data warehouse database. Which database is most critical? Why?
  2. The enterprise data warehouse database is the most critical. Recovering this database requires more work and data transformations than recovering data in the data marts. If you lose the enterprise database, the data marts cannot gather new data until the enterprise data warehouse is back online. You should also save any transformation scripts or DTS packages that can help you rebuild the database if the restore process fails.

  3. You plan to add new data to your data mart. What is the most efficient way to update any cubes that use the new data? Why?
  4. You should use the incremental update processing method to add new data. This method uses partitions and affects the cube minimally.

  5. Why would you want to migrate the OLAP Services Repository database to SQL Server?
  6. You should migrate the OLAP Services Repository database to SQL Server to maximum database integrity. Migrating this repository also minimizes administrative overhead by allowing you to administer the OLAP Services Repository with the same backup and restore methods that you use in SQL Server.



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