DA0-002 · Question #30
Which of the following tables holds relational keys and numeric values?
The correct answer is A. Fact. A fact table, central to a star schema in data warehousing, primarily holds foreign keys that relate to dimension tables and numeric measures (facts) that are subject to analysis. It stores the quantitative data for reporting.
Question
Which of the following tables holds relational keys and numeric values?
Options
- AFact
- BGraph
- CDimensional
- DTransactional
How the community answered
(27 responses)- A85% (23)
- B4% (1)
- C7% (2)
- D4% (1)
Why each option
A fact table, central to a star schema in data warehousing, primarily holds foreign keys that relate to dimension tables and numeric measures (facts) that are subject to analysis. It stores the quantitative data for reporting.
In a data warehouse star schema, a fact table stores quantitative measures (numeric values) and foreign keys that link to various dimension tables. These foreign keys are relational keys that establish the relationships between the facts and their descriptive attributes in dimensions.
A graph table is used in graph databases to store nodes and edges, which is a different data model from relational tables storing keys and numeric values in the context of data warehousing.
A dimensional table (or dimension table) holds descriptive attributes (e.g., product names, customer demographics) and a primary key, but it typically does not store the numeric measures or 'facts' of a business process.
A transactional table is typically found in an Online Transaction Processing (OLTP) system and records individual transactions, often containing a mix of keys, descriptive data, and numeric values, but the term 'fact table' specifically refers to the analytical context of storing measures and relational keys for data warehousing.
Concept tested: Fact tables in data warehousing
Source: https://learn.microsoft.com/en-us/power-bi/guidance/star-schema
Topics
Community Discussion
No community discussion yet for this question.