This quiz will test your understanding of the concepts discussed in unit 1.
1. Which model is used to develop DW?
a. relational model b. entity relationship diagram c. dimensional model d. all of the above
2. Which of the following is an example of an OLAP query?
a. How many shoes did we sell last month? b. Do repeat purchasers make similar product purchases? c. Is there a correlation among the purchase milk and film? d. a & b e. b & c
3. Which of the following are all characteristics of DW and OLAP?
a. DB design model is ERD b. user is a data entry clerk c. usage is ad hoc d. data structures are denormalized and simple e. a & d f. c & d
4. All of the following are strengths of Dimensional Modeling except?
a. can be changed gracefully b. provides a predictable, standard framework c. availability of common modeling situations d. none of the above
5. Which of the following are characteristics of a dimension table?
a. it is the center of the star schema b. typically includes facts c. is usually larger than fact tables d. supports grouping, browsing, constraining e. a & c f. b & d
