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

question 64

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 VISITPROCEDURE in the CUSTOM SPA star schema has ________ records.

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

---

Definitions:

Total Magnification

The overall enlargement of an image seen with a microscope, calculated by multiplying the objective lens magnification by the ocular lens magnification.

Depth of Field

In photography and optics, the distance between the nearest and the furthest objects that are in acceptably sharp focus.

Total Magnification

The enlargement level of an image as seen through a microscope, calculated by multiplying the objective lens magnification by the eyepiece lens magnification.

Cross-Sectional Area

The total area within the boundary of a three-dimensional object when it is cut through perpendicularly to its longest axis.