70-467 · Question #91
You need to create the factCustomerContact table. Which type of table should you create?
The correct answer is B. A factless fact table. A factless fact table records the occurrence of events or coverage relationships without any associated numeric measures, which fits a customer contact tracking table.
Question
You need to create the factCustomerContact table. Which type of table should you create?
Options
- AA fact table with a non-additive measure
- BA factless fact table
- CA periodic snapshot fact table
- DA fact table with an additive measure
How the community answered
(38 responses)- A8% (3)
- B74% (28)
- C3% (1)
- D16% (6)
Why each option
A factless fact table records the occurrence of events or coverage relationships without any associated numeric measures, which fits a customer contact tracking table.
A fact table with a non-additive measure still contains a measure column (such as a ratio or balance) that cannot be summed across all dimensions, which is not applicable when no measure exists at all.
A factless fact table captures the many-to-many relationships between dimension keys to record that an event happened, such as a customer being contacted, without storing any numeric facts to aggregate. The factCustomerContact table only needs to record the association between a customer and a contact event, with no meaningful measure to sum or average. This design pattern is standard in dimensional modeling for event-tracking and coverage scenarios.
A periodic snapshot fact table records the state of a process at regular time intervals with cumulative or balance measures, which is not the purpose of a contact-tracking table.
A fact table with an additive measure contains numeric measures like quantities or amounts that can be summed across all dimensions, which requires measurable data that a contact event table does not have.
Concept tested: Factless fact table design for event tracking
Source: https://learn.microsoft.com/en-us/analysis-services/multidimensional-models/define-a-fact-relationship-and-fact-relationship-properties
Topics
Community Discussion
No community discussion yet for this question.