ALSETMAX COMPANY
Observe the Three Different Tables That Exist in the ALSETMAX

Multiple Choice

ALSETMAX COMPANY
Observe the three different tables that exist in the ALSETMAX COMPANY and contains the information about customers.Assume all the values in all tables are correct.All three tables will be used as the source tables for the dimension CUSTOMER in the ALSETMAX COMPANY dimensionally modeled data warehouse.
ALSE TMAX CUSTOMERS
$\begin{array} { c l l c } \text { SSN } & \text { Name } & \text { Gemder } & \text { CustBirthYear } \\ 111 - 11 - 1111 & \text { Ned } & \text { Male } & 1980 \\ 222 - 22 - 2222 & \text { Nelly } & \text { Female } & 1990 \\ 333 - 33 - 3333 & \text { Anna } & \text { Female } & 1989 \\ 444-44 - 4444 & \text { Ned } & \text { Male } & 1970 \end{array}$ \\
A-MAX CUSTOMER TABLE
$\begin{array} { c c c c } \text { GSN } & \text { Nane } & \text { Sex } & \text { YearOfBirth } \\ 111 - 11 - 1111 & \text { Ned } & \text { M } & 1980 \\ 222 - 22 - 2212 & \text { Nelly } & F & 1990 \\ 333 - 33 - 3333 & \text { Anna } & F & 1989 \\ 555 - 55 - 5555 & \text { Anna } & F & 1970 \end{array}$ \\
AM CUSTOMER ZIPCODE INFO
$\begin{array} { c c } \text { SSN } & \text { ZipCode } \\ 111 - 11 - 1111 & 60611 \\ 222 - 22 - 2122 & 60655 \\ 333 - 33 - 3333 & 60601 \\ 444 - 44 - 4444 & 60611 \\ 555 - 55 - 5555 & 60655 \end{array}$

This scenario will be used for the following questions citing ALSETMAX COMPANY.
-Based on the three source tables,how many columns will the dimension CUSTOMER in the populated star schema for ALSETMAX COMPANY have? (Assume that the dimension uses a surrogate key,but no time stamps or row indicators. )

A) 6
B) 7
C) 8
D) 10