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.

Question

Quizplus · Accepted Answer

Estimating the number of possible values for each dimension is equivalent to determining the number of possible values for each foreign key in the fact table, as each dimension corresponds to a foreign key in the fact table.

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