Typically,in a star schema all ________ are given a simple,non-composite system-generated key,also called a surrogate key.
A)Fact tables
B)Dimension tables
C)Time columns
D)Transaction identifiers

Question

Quizplus · Accepted Answer

Surrogate keys are generated by the system and are used as a primary key in dimension tables. Fact tables often reference these keys as foreign keys. Time columns are part of the dimension table and do not require surrogate keys. Transaction identifiers may be used as surrogate keys in some cases but it is not a common practice.

Typically,in a Star Schema All ________ Are Given a Simple,non-Composite