Anchor Data Modelling — Learn free

Self-check

Questions 1–10 of 10

1. What are the four main elements of Anchor Data Modelling?
Question 1A. Anchor, Knot, Attribute and TieB. Hub, Link, Satellite and ReferenceC. Fact, Dimension, Bridge and HierarchyD. Focal, Relation, Descriptor and ConditionE. Node, Edge, Property and Label
2. What does an Anchor represent in Anchor Data Modelling?
Question 2A. A set of reference values such as status codesB. A core business entity that exists over time, associated with a business keyC. A relationship between two entitiesD. A changing metric such as a credit scoreE. A pre-aggregated reporting view
3. What is a Knot used for in Anchor Data Modelling?
Question 3A. Linking two anchorsB. Storing the business key of an entityC. Representing a value set or reference data, such as Customer_Status with values Active, Inactive and PendingD. Recording a fluctuating measureE. Defining the grain of a fact
4. Which example is given of a Static Attribute of a Customer Anchor?
Question 4A. Customer_ScoreB. Sales_RegionC. Customer_StatusD. Email_Address or Phone_NumberE. Loan interest rate
5. What is a Horizontal Attribute in Anchor Data Modelling?
Question 5A. An attribute shared across several anchorsB. An attribute stored in the anchor table itselfC. An attribute that links two anchorsD. An attribute whose value never changesE. An attribute whose value may change over time, such as a customer's credit score
6. What is the purpose of a Tie in Anchor Data Modelling?
Question 6A. To define relationships between Anchors and track how entities are connectedB. To store domain valuesC. To hold descriptive attributesD. To identify the business keyE. To aggregate measures
7. What distinguishes a Historical Tie from a Static Tie?
Question 7A. A Historical Tie links an anchor to an attribute; a Static Tie links two anchorsB. A Historical Tie represents a relationship that changes over time, whereas a Static Tie remains constantC. A Historical Tie has no time attributesD. A Static Tie is used only for reference dataE. They are the same
8. Which of the following is NOT listed as a key benefit of Anchor Data Modelling?
Question 8A. FlexibilityB. SimplicityC. Minimal number of tables and joinsD. Historical accuracyE. Scalability
9. In the Anchor Modelling loan example, what does Attr_Status reference?
Question 9A. Tie_LoanOfficerB. Anchor_CustomerC. Attr_InterestRateD. Knot_Status, which holds values such as Pending, Approved and RejectedE. Sat_LoanDetails
10. In the Anchor loan example, what happens in Attr_InterestRate when the rate changes from 7.5% to 8.0%?
Question 10A. The existing row is overwritten with 8.0%B. The row is deleted and Anchor_Loan is updatedC. The rate is moved to Knot_StatusD. A new Tie is createdE. The old value stays with its validity range and a new row is added, preserving full history