1. Which of the followings is correct about grainularity of fact table and dimension table?

a. choose as low granularity as possible for the fact table
b. granularity of a dimension could be lower than granularity of fact table
c. granularity of dimension could be higher than granularity of fact table
d. a and b
e. a and c

2. Which statement is NOT true about aggregates?

a. aggregates are summary tables along one or more dimensions
b. aggregated data are stored in the same table as the fact table
c. aggregate is one of the reasons to have multiple fact table
d. aggregates are helpful for query performance

3. When a company offers different nature of services/products, and the management wants to have information about the whole business and details of each line-of-business, what kind of dimensional modeling fits the requirement best?

a. A multi-star schema
b. A snow-flake schema
c. A schema with transaction and snapshot fact tables
d. A schema with a core fact table and a series of custom fact tables
e. None of the above

4. Which statement is true about Factless Fact table?

a. It is used when nothing happens, thus called "factless"
b. It is used sometimes at event capturing situation
c. It is used sometimes as coverage table
d. It may not contain measure field, thus called "factless"
e. b, c and d

5. Why do we need multiple fact tables in a dimensional schema?

a. There are many processes in a business; each process spawns one or more fact tables
b. Business may have heterogeneous products
c. Transaction and snapshot information are required
d. Aggregates are needed for query performance
e. All of the above