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 value 60611 from the CUSTOM SPA DAILY VISITS DATABASE appears altogether ________ time(s)in CUSTOM SPA star schema.
A)1
B)2
C)5

Question

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 value 60611 from the CUSTOM SPA DAILY VISITS DATABASE appears altogether ________ time(s)in CUSTOM SPA star schema.
A)1 
B)2 
C)5

Quizplus · Accepted Answer

The value 60611 appears twice in the CUSTOM SPA star schema. It appears once in the fact table for each visit and once in the dimension table for the patron's zip code.

CUSTOM SPA The Following Questions Citing CUSTOM SPA Assume That a Single-Source