Exam 8: Data Warehouse and Data Mart Modeling

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 CUSTOM SPA DAILY VISITS DATABASE column AmountCharged provides the data for a dimension in the STATEWIDE HEALTH star schema.

What do timestamps indicate in slowly changing dimensions?

________ contain descriptions of the business,organization,or enterprise to which the subject of analysis belongs.

________ contain measures related to the subject of analysis.

STATEWIDE HEALTH The following questions citing STATEWIDE HEALTH assume that a single-source star schema is created. The purpose of this star schema is to analyze quantities of prescribed medications by all dimensions provided by its source: the STATEWIDE HEALTH PRESCRIPTIONS DATABASE shown below. In this database, each prescription is prescribed for one patient by one doctor, and it contains one medication. STATEWIDE HEALTH PRESCRIPTIONS DATABASE -The detailed fact table in the STATEWIDE HEALTH star schema is a line-item detailed fact table.

The ________ slowly changing dimension approach changes the old value in the dimension's record with the new value.

________ contain analytically useful information.

The following questions citing STATEWIDE HEALTH assume that a single-source star schema is created. The purpose of this star schema is to analyze quantities of prescribed medications by all dimensions provided by its source: the STATEWIDE HEALTH PRESCRIPTIONS DATABASE shown below. In this database, each prescription is prescribed for one patient by one doctor, and it contains one medication. STATEWIDE HEALTH PRESCRIPTIONS DATABASE -Based on the data shown in the STATEWIDE HEALTH PRESCRIPTIONS database,if we created an aggregated fact table that contains data about daily prescribed quantities of each medication,such an aggregated table would have ________ records in the fact table.

Observe the REAL ESTATE PROPERTY DIMENSION: This dimension will be used for the following questions citing REAL ESTATE PROPERTY DIMENSION. -Show how the Type 3 approach would implement the following change: the size of property whose ID is 111 is increased to 7000 sq ft (do not add timestamps).

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

What is the role of the row indicator column?

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.

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 CUSTOM SPA DAILY VISITS DATABASE column SEYearOfHire provides the data for a dimension in the STATEWIDE HEALTH star schema.

Observe the REAL ESTATE PROPERTY DIMENSION: This dimension will be used for the following questions citing REAL ESTATE PROPERTY DIMENSION. -Show how the Type 2 approach would implement the following change: the size of property whose ID is 111 is increased to 7000 sq ft on 1/1/2013.Assume that the dimension was originally created and populated with all brand-new properties on 1/1/2000,and add appropriate timestamps and a row indicator.

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 CUSTOM SPA DAILY VISITS DATABASE column VisitID provides the data for a dimension in the STATEWIDE HEALTH star schema.

The following questions citing STATEWIDE HEALTH assume that a single-source star schema is created. The purpose of this star schema is to analyze quantities of prescribed medications by all dimensions provided by its source: the STATEWIDE HEALTH PRESCRIPTIONS DATABASE shown below. In this database, each prescription is prescribed for one patient by one doctor, and it contains one medication. STATEWIDE HEALTH PRESCRIPTIONS DATABASE -Based on the data shown in the STATEWIDE HEALTH PRESCRIPTIONS database,if we created an aggregated fact table that contains data about daily prescribed quantities of each medication per each patient,such an aggregated table would be connected to ________ dimensions.

Analytical queries on the dimensionally modeled database can be significantly simpler to create than on the equivalent nondimensional database.

STATEWIDE HEALTH The following questions citing STATEWIDE HEALTH assume that a single-source star schema is created. The purpose of this star schema is to analyze quantities of prescribed medications by all dimensions provided by its source: the STATEWIDE HEALTH PRESCRIPTIONS DATABASE shown below. In this database, each prescription is prescribed for one patient by one doctor, and it contains one medication. STATEWIDE HEALTH PRESCRIPTIONS DATABASE -The STATEWIDE HEALTH PRESCRIPTIONS database column PrescID provides the data for a dimension in the STATEWIDE HEALTH star schema.

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 Claire from the CUSTOM SPA DAILY VISITS DATABASE appears altogether ________ time(s)in CUSTOM SPA star schema.

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.