Multiple Choice
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 DOCTOR in the STATEWIDE HEALTH star schema has ________ records.
A) 0 (the dimension DOCTOR does not exist)
B) 3
C) 4
D) 5
Correct Answer:
Verified
Correct Answer:
Verified
Q1: What is represented by each row in
Q3: A dimensional model cannot be based on
Q4: STATEWIDE HEALTH<br><br>The following questions citing STATEWIDE HEALTH
Q5: The following questions citing STATEWIDE HEALTH assume
Q6: CUSTOM SPA<br>The following questions citing CUSTOM SPA
Q7: STATEWIDE HEALTH<br><br>The following questions citing STATEWIDE HEALTH
Q8: What is the difference between detailed fact
Q9: List the two questions that have to
Q10: A dimensional model can contain more than
Q11: What is represented by each row in