Every Key Used to Join the Fact Table with a Dimension

question 133

Multiple Choice

Every key used to join the fact table with a dimension table should be a ________ key.

• A) primary
• B) surrogate
• C) foreign
• D) secondary

---

Definitions:

Psychographic

Relating to the study and classification of people according to their attitudes, aspirations, and other psychological criteria, often used in market research.

Demographic

Statistical data relating to the population and particular groups within it, often used in market analysis to segment audiences.

Lifestyle

A person’s typical way of life as expressed by his or her activities, interests, and opinions.

Targeting

The process of identifying and focusing marketing efforts on a specific demographic or niche market that is most likely to buy a product or service.