Exam 8: Data Warehouse and Data Mart Modeling

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 doctor,such an aggregated table would have ________ records in the fact table.

What are conformed dimensions?

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 star schema contains the dimension VISIT.

Observe the REAL ESTATE PROPERTY DIMENSION: This dimension will be used for the following questions citing REAL ESTATE PROPERTY DIMENSION. -Show how Type 3 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.

What is a snowflake model?

All sources for a dimensional model must be operational data sources from the company that is building the dimensional model.

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 value 10 from the STATEWIDE HEALTH PRESCRIPTIONS database appears all together ________ time(s)in the populated tables of the STATEWIDE HEALTH star schema.

Dimensionally modeled data warehouse approach results in multiple unrelated ETL infrastructures.

In a typical,properly designed star schema,the number of records (rows)in any of the dimension tables is:

What does granularity of a fact table describe?

What are the two options for designing analytical databases in organizations where the organizational,political,or budgetary structure of the organization forces parts of the organization to undertake isolated initiatives?

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 (do not add timestamps).

What is a constellation of stars?

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 value 2mg from the STATEWIDE HEALTH PRESCRIPTIONS database appears all together ________ time(s)in the populated tables of 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,the dimension MEDICATION in the STATEWIDE HEALTH star schema has ________ records.

Dimensionally modeled data warehouse approach can be used for designing an enterprise-wide analytical data warehouse.

Which of the following allows reusing (instead of duplication)of dimensions?

Aggregated fact tables have a finer level of granularity than detailed tables.

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.

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 doctor,such an aggregated table would be connected to ________ dimensions.