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

question 43

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

---

Definitions:

Team Performance

The collective efficiency and productivity of a group of individuals working together towards common objectives.

Relevant Examples

Instances or scenarios that are directly related and meaningful to the topic or context being discussed.

Styles of Team Players

Different attitudes and behaviors individuals display while working in a team, ranging from leadership to supportive roles.

Top Management

The highest level of executives and senior administrators responsible for steering the overall direction of a company or organization.