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

question 57

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

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

---

Definitions:

Interest Tax Savings

The reduction in income tax that results from the deductibility of interest payments on certain types of loans, such as mortgages.

Discount Rate

The interest rate used to discount future cash flows of a project or investment to determine its present value.

Defensive Merger

A strategy where a company merges with or acquires another company to protect itself against potential competitors or hostile takeovers.

Hostile Takeover

An acquisition attempt by a company or individual against the target company's wishes.