When Determining the Size of a Fact Table, Estimating the Number

question 104

Multiple Choice

When determining the size of a fact table, estimating the number of possible values for each dimension associated with the fact table is equivalent to:

• A) determining the number of DDL statements made to create a table.
• B) determining the number of possible values for each foreign key in the fact table.
• C) determining the number of DML statements made to create a table.
• D) determining the number of TRIGGERS used in the database.

---

Definitions:

Required Units

The quantity of products or services that must be produced or sold to meet a specific target or fulfill a certain demand.

Variable Expenses

Costs that change in proportion to the activity or volume of operations in a business.

Net Income

The profit of a company after all expenses and taxes have been deducted from total revenue.

Sales

The total amount earned from selling goods or services over a particular period, usually before any expenses are deducted.