Microsoft Azure Data Fundamentals — Question 168

In an analytical data model, which type of table contains entities that are used to aggregate numeric values, where each entity is represented by a row with a unique key value?

Answer options

Correct answer: C

Explanation

The correct answer is C, as fact tables are specifically designed to store quantitative data for analysis, with each row representing a unique entity associated with a particular measure. Options A and B are incorrect because bridge tables are used to manage many-to-many relationships and dimension tables are used to describe the context of the data, not aggregate it.