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.
A)2
B)3
C)4

Question

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.
A)2 
B)3 
C)4

Quizplus · Accepted Answer

The aggregated fact table would be connected to 3 dimensions: medication, patient, and time (daily basis).

The Following Questions Citing STATEWIDE HEALTH Assume That a Single-Source