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

question 35

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 data in the three source tables,how many records will the dimension CUSTOMER in the populated star schema for ALSETMAX COMPANY have?

• A)4
• B)5
• C)8
• D)13

---

Definitions:

Web Protocols

Rules and standards that define how data is transmitted and received over the internet, including HTTP and FTP.

HTTPS

Hypertext Transfer Protocol Secure is an internet communication protocol that protects the integrity and confidentiality of data between the user's computer and the site.

128-bit Addressing

A system that uses 128 bits to denote a memory address, enabling a vast amount of unique addresses, often used in IPv6.

E-commerce Servers

Dedicated servers that host websites and applications for online marketing and sales transactions.