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

question 100

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



-Based on the data shown in the CUSTOM SPA DAILY VISITS DATABASE,the dimension VISIT in the CUSTOM SPA star schema has ________ records.

• A)0 (the dimension VISIT does not exist)
• B)3
• C)5

---

Definitions:

Labour Productivity

a measure of economic performance that calculates the amount of goods and services produced per hour worked by employees.

Multifactor Productivity

An indicator of economic efficiency that assesses the ratio of total goods and services output to the sum of inputs employed in their production.

Productivity Evaluation

The assessment of the efficiency of a worker or group of workers, generally measured by the amount of output produced relative to input used.