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

question 96

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,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

---

Definitions:

Mumbai

A populous city on India's west coast, known for its financial and entertainment (Bollywood) industry, as well as being one of the world's largest cities.

Farm Output

The total quantity of agricultural products produced by a farm or in a specific area within a given period.

Global South

A term often used to describe countries considered to be in a position of socio-economic and political disadvantage, primarily those in the Southern Hemisphere.

Farmer's Family

Refers to the household members related to and living with a farmer, often involved in agricultural activities and decisions.