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. How are OLAP and OLTP different?
2. True or false: An OLAP system is the best place to query the status of a particular order (explain your answer).
3. In the following table, evaluate which attributes are characteristic of each different type of data.

Attribute	OLAP	OLTP
Consolidate
Consistent
Read write
Subject oriented
Historical
Read only
Detailed
Granular

4. What are the disadvantages of using an OLTP system to conduct analytical processing?

Answers