Multiple Choice
CUSTOM SPA
The following questions citing CUSTOM SPA assume that a single-source star schema is created. The purpose of this star schema is to analyze procedure revenue by all dimensions provided by its source: the CUSTOM SPA DAILY VISITS DATABASE, shown below. In this database, each visit includes one patron, one spa employee, and one or more procedures. The price for each procedure varies from visit to visit.
CUSTOM SPA DAILY VISITS DATABASE
-The fact table in the CUSTOM SPA star schema is a ________ fact table.
A) constellation
B) degenerate
C) transaction-level detailed
D) line-item detailed
Correct Answer:
Verified
Correct Answer:
Verified
Q34: The following questions citing STATEWIDE HEALTH assume
Q35: The following questions citing STATEWIDE HEALTH assume
Q36: Dimensionally modeled data warehouse approach can be
Q37: Which of the following allows reusing (instead
Q38: Aggregated fact tables have a finer level
Q40: The following questions citing STATEWIDE HEALTH assume
Q41: CUSTOM SPA<br>The following questions citing CUSTOM SPA
Q42: The dimensional schema is often referred to
Q43: Including a transaction identifier in the fact
Q44: Dimensional modeling can be employed as a