DIMENSIONAL DATA MODELLING — Learn free

Self-check

Questions 1–10 of 10

1. Into what two kinds of structure does Dimensional Data Modelling organise data?
Question 1A. Facts (quantitative measures) and dimensions (descriptive attributes)B. Hubs and satellitesC. Anchors and tiesD. Nodes and edgesE. Keys and values
2. What is the primary goal of dimensional modelling?
Question 2A. Eliminating redundancy at all costsB. Delivering a business-friendly, performance-optimised structure for fast and intuitive access to informationC. Enforcing referential integrity across the enterpriseD. Supporting fine-grained operational updatesE. Capturing every attribute change on its own timeline
3. Which two questions do facts and dimensions answer together?
Question 3A. How is the data stored, and who owns it?B. When was it recorded, and when was it valid?C. What happened, and under what circumstances did it happen?D. Which node connects to which, and how many hops?E. What is the key, and what is the value?
4. What distinguishes a star schema?
Question 4A. Dimensions are partially normalised into sub-dimensionsB. Facts are stored as eventsC. Every dimension references a geography tableD. The fact table connects directly to denormalised dimension tables with minimal joinsE. Every table is in 6NF
5. In a snowflake schema, what might a Customer dimension reference?
Question 5A. An event streamB. A fact tableC. A hub tableD. A JSON documentE. A separate Geography table
6. How does dimensional modelling relate to normalisation?
Question 6A. It intentionally denormalises data to optimise usability and query performanceB. It requires full compliance with 3NFC. It targets 6NF for temporal accuracyD. It applies DKNF constraints to dimensionsE. It is identical to Inmon's 3NF approach
7. Which measures does the example Fact_LoanApproval table contain?
Question 7A. CustomerID, Name and SegmentB. LoanAmount, InterestRate, ApprovalFlag and ApprovalCountC. Day, Month, Quarter and YearD. Branch and ExperienceLevelE. LoanType and Secured/Unsecured
8. Which question is given as an example that business users can easily answer with a dimensional loan model?
Question 8A. Which officers are connected to high-risk customers?B. What was the interest rate as of 14 January?C. Total Approved Loan Amount by Customer Segment and QuarterD. Which loan documents embed the same customer?E. Which events must be replayed to rebuild the loan?
9. Which of the following is NOT listed as a strength of dimensional modelling?
Question 9A. Intuitive structureB. Fast aggregation performanceC. Strong alignment with reporting needsD. Suitability for transaction processing and fine-grained operational updatesE. Natural scaling by adding new fact tables or dimensions
10. To which modelling family does dimensional modelling belong?
Question 10A. The ensemble family alongside Data Vault and AnchorB. The pre-relational family alongside hierarchical and network modelsC. The semantic family alongside ontologiesD. The NoSQL family alongside document storesE. An OLAP-oriented approach rooted in denormalisation, separate from the ensemble family