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

question 21

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

• A)2
• B)3
• C)4

---

Definitions:

Wilshire 5000

A metric assessing the performance of all equity securities based in the U.S. for which price information is easily accessible.

DJIA

Stands for Dow Jones Industrial Average, which is a stock market index that measures the stock performance of 30 large companies listed on stock exchanges in the United States.

DAX

The Deutscher Aktienindex, a major stock market index consisting of the 30 major German blue chip companies trading on the Frankfurt Stock Exchange.

Bankers' Acceptances

Short-term debt instruments issued by a company that is guaranteed by a commercial bank.