nerdexam
Microsoft

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.

Design a data warehousing solution

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)
  • A
    8% (3)
  • B
    74% (28)
  • C
    3% (1)
  • D
    16% (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.

AA fact table with a non-additive measure

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.

BA factless fact tableCorrect

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.

CA periodic snapshot fact table

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.

DA fact table with an additive measure

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

#factless fact table#fact table types#non-additive measures#dimension design

Community Discussion

No community discussion yet for this question.

Full 70-467 Practice