UNIFIED STAR SCHEMA (USS) — Learn free

Self-check

Questions 1–10 of 10

1. What central structure does the Unified Star Schema (USS) introduce?
Question 1A. The Puppini BridgeB. The Hub tableC. The Anchor tableD. The Descriptor tableE. The Satellite table
2. What is the primary goal of the Unified Star Schema?
Question 2A. Normalising dimensions to 3NFB. Providing a unified query entry point that eliminates ambiguity when working with multiple fact tablesC. Storing every attribute on its own timelineD. Replacing dimensions with knotsE. Reducing the fact table to a single row per customer
3. What is a fan trap?
Question 3A. A missing foreign key in a dimensionB. A relationship between facts and dimensions that is ambiguous or missingC. A join that multiplies rows incorrectlyD. A bridge with too many sparse keysE. A dimension that changes too slowly
4. What does the Puppini Bridge essentially consist of?
Question 4A. A pre-aggregated summary of all measuresB. A normalised copy of every dimensionC. A list of slowly changing attribute versionsD. A union of keys from all relevant facts and dimensionsE. A hierarchy of parent–child pointers
5. How do analysts query a Unified Star Schema?
Question 5A. They start from each fact table and inner-join to the bridgeB. They start from the largest dimensionC. They query the fact tables directly and union the resultsD. They traverse edges from a customer nodeE. They begin at the bridge and left-join to any required fact or dimension
6. Which combined report is given as an example that a Puppini Bridge makes safe in a loan approval environment?
Question 6A. Approval-to-Repayment Conversion by Customer SegmentB. Which customers share the same contact detailsC. What rate was valid as of 20 January 2024D. Which loan documents embed officer O11E. Which events rebuild loan L001
7. Why does the Unified Star Schema support self-service BI well?
Question 7A. Because it removes all dimensionsB. Because queries always originate from a unified structure, so business users can explore multiple processes without deep warehouse knowledgeC. Because it stores data as JSOND. Because it requires no joins at allE. Because it pre-computes every possible report
8. Which of the following is NOT listed as a trade-off of the Unified Star Schema?
Question 8A. The bridge can become wide and sparse with many unpopulated keysB. Careful storage and indexing strategies are requiredC. New fact tables cannot be added without breaking existing reportsD. Strong governance over conformed dimensions and keys is essentialE. Some measures may need restructuring, which can feel counterintuitive to fact-centric modellers
9. To which modelling family does the Unified Star Schema belong?
Question 9A. The ensemble familyB. The pre-relational familyC. The NoSQL familyD. Primarily the Dimensional Modelling domain, as a dimensional–semantic hybridE. The temporal family
10. Why does the query logic built on the Bridge_Puppini remain valid when new facts such as Repayments or Collections are added later?
Question 10A. Because the facts are merged into one tableB. Because the dimensions are re-normalisedC. Because every fact is stored in the bridge as a measureD. Because the bridge is rebuilt from scratch each timeE. Because the bridge is the single entry point for all queries