This quiz will test your understanding of the concepts discussed in unit 3.
1. Some common dimensional model design techniques are?
a. typically include over 20 tables b. snowflaking should be avoided c. dimensional attributes should be abbreviated d. hierarchies within dimensions must always roll up e. b & d
2. If you must snowflake which ideas below would be a good to follow?
a. normalize all tables b. use bitmap indexing for low cardinality attributes c. use when needed for browsing within a secondary dimension d. b & c
3. Hierarchies with dimensions generally support drill up and drill down operations. Why?
a. because detail such as state can be summed to sales area for analysis purposes b. because data kept at multiple levels of detail support very detailed analysis by drilling down through a dimension c. because not all hierarchical attributes can be summed or disagregated d. all of the above
4. Facts differ from attributes because?
a. they are well known in advance b. they are typically numeric in nature c. they are typically text fields d. none of the above
5. A recommended time dimension should?
a. support multinational needs b. be at the monthly grain c. support calculation of important aggregated periods like quarter through hard-coded logic d. include an attribute for important dates time periods such as seasons and holidays e. a & d
