WHAT IS A DIMENSION Table? — Learn free

Self-check

Questions 1–10 of 10

1. What role does a dimension table play in dimensional modelling?
Question 1A. It provides descriptive context to fact tablesB. It stores the numeric measures of a business processC. It records the grain of each business eventD. It holds the event log for replayE. It stores hashed business keys
2. Which questions do dimensions answer?
Question 2A. How much and how manyB. Who, what, when, where and sometimes howC. Only whenD. Only how muchE. Which key and which value
3. What does a dimension table typically contain?
Question 3A. Numeric measures and foreign keysB. Immutable events with timestampsC. A primary key, descriptive attributes and hierarchies for reportingD. Hubs, links and satellitesE. Request and response payloads
4. Which attributes are listed for Dim_Customer in the loan approval warehouse?
Question 4A. OfficerID, Name, Branch and ExperienceYearsB. BranchID, City and RegionC. DateID, Day, Month, Quarter and YearD. CustomerID, Name, AgeGroup, IncomeBand and SegmentE. LoanAmount, InterestRate and ApprovalFlag
5. What analytical capability do hierarchies within dimensions enable?
Question 5A. Event replayB. Multi-hop traversalC. Schema validationD. Idempotent consumptionE. Roll-up and drill-down analysis
6. Which technique is used to manage business attributes such as customer segment that change over time in a dimension?
Question 6A. Slowly Changing Dimensions (SCD Type 1, Type 2 or Type 3)B. Cartesian decompositionC. Partition keysD. Projection–join decompositionE. Owner–member sets
7. Why are dimensions described as the "face" of the data warehouse?
Question 7A. Because they hold the largest number of rowsB. Because business users primarily interact with dimension attributes when building reportsC. Because they are loaded firstD. Because they contain all the numeric measuresE. Because they define the grain
8. Which of the following is NOT listed as a trade-off of dimension tables?
Question 8A. Dimension tables in a star schema may contain redundant dataB. Managing slowly changing attributes requires careful governanceC. Poorly designed hierarchies can create inconsistent reporting resultsD. Dimensions cannot integrate with BI toolsE. Denormalisation increases redundancy
9. How do dimensions differ between a star schema and a snowflake schema?
Question 9A. Star dimensions are normalised to 6NF; snowflake dimensions are flatB. Star dimensions store measures; snowflake dimensions store keys onlyC. Star dimensions are denormalised for simplicity and performance; snowflake dimensions may be partially normalised to reduce redundancyD. Star dimensions have no primary key; snowflake dimensions doE. There is no difference
10. Which normal forms does dimensional modelling NOT aim to comply with?
Question 10A. 1NFB. 2NFC. 3NFD. None; it complies with all normal formsE. Higher forms such as 4NF, 5NF or 6NF