Review

The following questions are designed to reinforce key information presented in the chapter. If you are unable to answer a question, review the appropriate lesson and then try the question again. Answers to the questions can be found in Appendix A: Questions and Answers.

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. 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?
3. Why would you want to migrate the OLAP Services Repository database to SQL Server?

Answers