In a Dimensional Database with a Star Structure

question 17

Multiple Choice

In a dimensional database with a star structure

• A)The dimension database tables are all related only to the central fact table
• B)There is one inner circle of dimension tables and additional dimension tables are related to the inner dimension tables
• C)Queries traverse at least three tables
• D)A and C

---

Definitions:

Prescriptive

Pertaining to the detailed specification of a set of recommendations or rules designed to solve a problem or improve a situation.

Restrictive

Describing policies, practices, or measures that limit or control the actions and freedoms of individuals or groups.

Internal Control

Processes adopted by organizations to ensure the integrity of financial and accounting information, promote accountability, and prevent fraud.

Data Integrity

The accuracy, consistency, and reliability of data throughout its lifecycle, ensuring it remains intact and unaltered from its original state.