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:

Simple Interest

Interest assessed only on the original investment, without consideration for compounding.

Annual Rate

The amount of interest, return, or other financial change represented annually, often as a percentage.

Treasury Bill

A short-term government security issued at a discount from the face value and maturing at full face value, offering investors a secure, short-term investment option.

Simple Rate of Return

A measure of the gain or loss on an investment over a specific period, expressed as a percentage of the investment's initial cost.