Microsoft DP-900 topic 1 question 285

Correct Option C: Fact tables contains all foreign keys from Dimensions. That is to make sure of data integrity in star schema.

C - Fact Table

Coined another way: What type of table contains entities used to aggregate numeric values, where each entity is represented by a row with a unique key value, in an Analytic Data Model?

ChatGPT:
In an Analytic Data Model, the type of table that contains entities used to aggregate numeric values, with each entity represented by a row with a unique key value, is typically referred to as a "fact table."

A fact table is a central component of a multidimensional data model such as a star schema or snowflake schema. It contains quantitative data (facts) about a business process or activity and serves as the primary source for aggregating and analyzing numerical measures. Each row in the fact table represents a specific event or transaction, and the fact table usually includes foreign keys that reference dimension tables, which provide context and additional descriptive attributes for the facts.

Fact tables play a crucial role in supporting analytical queries and reporting in data warehousing and business intelligence environments by enabling the aggregation of data across different dimensions, such as time, geography, product, or customer.

Dimension

The question says, "...used to aggregate numeric values,"
Dimension Table contains all kinds of data elements, not only numeric values. Only a FACT table is composed as containing numeric values (the aggregation of all Dim Table Primary Keys).

Just copied and posted exact same question to ChatGPT, and here is the response:

In an analytical data model, the type of table that contains entities used to aggregate numeric values, with each entity represented by a row with a unique key value, is typically referred to as a "fact table."

A fact table contains quantitative data (facts) about a business process or activity, and it often includes foreign keys that reference the dimension tables. These foreign keys allow the fact table to be joined with the dimension tables, which contain descriptive attributes related to the facts being measured.

Fact tables are central to multidimensional modeling techniques such as star schemas and snowflake schemas, which are commonly used in data warehousing and business intelligence environments for analyzing and reporting on large volumes of data.