Focal Point Data Modelling — Learn free

Self-check

Questions 1–10 of 10

1. To which modelling family does Focal Point Data Modelling belong?
Question 1A. Ensemble Data Modelling, like Data VaultB. Dimensional Modelling, like the star schemaC. Pre-relational modelling, like the network modelD. NoSQL modellingE. Semantic modelling
2. How many stages, called Focal Forms, make up the Focal modelling process?
Question 2A. ThreeB. FiveC. SixD. TenE. Two
3. What is done in Focal Form One?
Question 3A. Group attributes into Descriptor ConceptsB. Determine atomic contextC. Identify and define the primary business concept entitiesD. Identify natural business relationships between conceptsE. Identify attributes of the core concepts
4. What makes Focal Form Four unique to the Focal methodology?
Question 4A. It defines the business keys of each entityB. It creates the link tables between entitiesC. It historises every attribute by defaultD. It categorises attributes into one of ten predefined Descriptor Concepts, each with a specific definitionE. It builds the semantic layer
5. In Focal Point modelling, which example is given of a Condition descriptor in a Loan Focal?
Question 5A. The customer's nameB. The officer's branchC. The loan identifierD. The payment dateE. The interest rate, as a financial Condition
6. What does Focal Form Five, Atomic Context, determine?
Question 6A. Which attributes group together at the most granular level to answer a specific atomic question, usually no more than five related attributesB. Which entities are the primary business conceptsC. Which ten Descriptor Concepts applyD. Which relationships are historicalE. Which fact tables share conformed dimensions
7. How does the stability of a Focal Point physical model compare with Data Vault?
Question 7A. Focal models evolve more frequently than Data Vault modelsB. Focal physical models typically remain stable with minimal changes, whereas Data Vault physical models tend to evolve more frequentlyC. Both change at the same rateD. Neither model can change after implementationE. Focal models are regenerated for every load
8. How does historisation in Focal Point modelling differ from Anchor modelling?
Question 8A. Focal historises every Descriptor by default; Anchor does notB. Focal uses LoadDate only; Anchor uses ValidFrom onlyC. In Focal, historisation is not enforced on every Descriptor, whereas Anchor enforces itD. Focal has no temporal capability at allE. They are identical
9. In the comparison of dimensional, ensemble and temporal modelling, how is temporal modelling characterised?
Question 9A. As a competing family alongside Kimball and ensembleB. As a replacement for Data VaultC. As a type of snowflake schemaD. As a cross-cutting principle that elevates time to a first-class citizen and must be applied within relational, dimensional or ensemble structuresE. As a NoSQL technique
10. Why is temporal handling in dimensional modelling described as "bolted on"?
Question 10A. Because dimensional models cannot store datesB. Because fact tables never record timeC. Because Slowly Changing Dimensions are forbiddenD. Because dimensional models store history in satellitesE. Because history is handled partially at attribute level through Slowly Changing Dimensions rather than systemically across every entity and relationship