This quiz will test your understanding of the concepts discussed in unit 2.
1. In a star schema which of the following are true?
a. all tables are in third normal form b. dimensions tend to have many more attibutes and relatively fewer tuples than fact tables c. the primary key of the fact table is usually the concatenation of foreign keys from dimension tables d. b and c e. all of the above
2. A snowflake schema is called such because?
a. dimensions are normalized into third normal form b. it contains a degenerated dimension c. it uses conformed dimensions d. all of the above
3. The following are all characteristics of multistar schemas?
a. not all concatenated foreign keys can provide a primary key for the fact table b. they contain one or more degenerate dimensions c. are typically found in businesses with multiple line items on an order form d. all of the above
4. Conformed dimensions are?
a. different across data marts b. very important for implementing the data warehouse c. support drill across data marts d. are found in multifact tables e. b, c & d
5. In the schema below if customer refers to an individual not to a company then what is the primary key of the fact table?
a. time_key, customer_key, product_key, channel_key, discount_key, order_number b. time_key c. time_key, customer_key, product_key, channel_key, discount_key d. time_key, customer_key, order_number
