WHAT IS A FACT Table? — Learn free

Self-check

Questions 1–10 of 10

1. What does a fact table store in dimensional data modelling?
Question 1A. The measurable outcomes of a business processB. Descriptive attributes such as names and categoriesC. Hierarchies for roll-up and drill-downD. Slowly changing attribute historyE. Business keys and their load metadata
2. Which question do facts answer?
Question 2A. Who was involved?B. What happened?C. Where did it happen?D. Why did it happen?E. When is it valid?
3. Which three kinds of content does a fact table typically contain?
Question 3A. Text descriptions, hierarchies and validity datesB. Nested objects, arrays and methodsC. Numeric measures, foreign keys to dimension tables and minimal descriptive attributes of its ownD. Hubs, links and satellitesE. Nodes, edges and properties
4. What is the grain of a fact table?
Question 4A. The number of foreign keys it containsB. The total number of rowsC. The unit of currency used for measuresD. The level of detail that one row represents, such as one row per loan approval eventE. The hierarchy used for drill-down
5. What can happen if the grain of a fact table is not clearly defined?
Question 5A. The dimensions cannot be joinedB. The table cannot store numeric measuresC. The table becomes normalisedD. The foreign keys become primary keysE. Reports may produce incorrect totals or duplicate counts
6. Which measure is given as an example of an additive fact?
Question 6A. LoanAmountB. Interest RateC. Loan BalanceD. Customer SegmentE. Approval Date
7. Why is Loan Balance described as a semi-additive fact?
Question 7A. Because it cannot be summed at allB. Because it can be summed across customers but not across timeC. Because it is stored as textD. Because it is a foreign keyE. Because it is always an average
8. How should a non-additive fact such as Interest Rate be handled in analysis?
Question 8A. Summed across all dimensionsB. Summed across time onlyC. Not summed, though averages or ratios may be calculatedD. Moved into a dimension tableE. Stored as a foreign key
9. Why can a fact table not stand alone?
Question 9A. Because it has no primary keyB. Because it cannot be indexedC. Because it is always normalisedD. Because without dimensions providing context, numeric measures have little meaningE. Because it cannot be aggregated
10. Which of the following is NOT a listed characteristic of fact tables?
Question 10A. They belong to the Dimensional Modelling family including Star, Snowflake and Unified Star SchemaB. They are intentionally denormalised for analytical performanceC. They contain many foreign keys to dimensionsD. They are optimised for OLAP workloadsE. They contain many intrinsic descriptive attributes beyond numeric measures