Data Vault MOdelling — Learn free

Self-check

Questions 1–10 of 10

1. To which modelling family does Data Vault belong?
Question 1A. Ensemble Data ModellingB. Dimensional ModellingC. Pre-relational modellingD. Semantic modellingE. NoSQL modelling
2. How should terms such as "Business Vault" and "Raw Vault" be understood?
Question 2A. As two competing methodologiesB. As extensions within the single core Data Vault model, not distinct systemsC. As Kimball's names for data martsD. As Inmon's layers of the EDWE. As deprecated names for star schemas
3. What do Hub tables store in Data Vault?
Question 3A. Descriptive attributes with historyB. Relationships between entitiesC. Business keys that uniquely identify entities, without descriptive informationD. Stable domain values such as status codesE. Pre-aggregated measures
4. What is the role of Link tables in Data Vault?
Question 4A. To store measures for reportingB. To hold time-variant descriptive attributesC. To store reference domain valuesD. To manage relationships between entities by linking hub tables through foreign keysE. To cache the latest state of each hub
5. What do Satellite tables contain in Data Vault?
Question 5A. Only business keysB. Only foreign keys between hubsC. Pre-joined dimensional viewsD. The Puppini Bridge keysE. Descriptive attributes related to hub entities, separated from the core keys
6. Which Data Vault table type stores stable domain values such as loan status codes and is optional but recommended?
Question 6A. Reference tablesB. Hub tablesC. Link tablesD. Satellite tablesE. Bridge tables
7. In the layered data architecture described with Data Vault, which layer does Data Vault replace?
Question 7A. The Landing ZoneB. 3NF modelling in the Transform Zone's Warehousing LayerC. Dimensional modelling in the Semantic LayerD. The Staging ZoneE. The BI reporting layer
8. Which of the following is NOT one of the options named for adding a Semantic Layer on top of Data Vault?
Question 8A. A virtual semantic layer with on-the-fly joins across hubs, links and satellitesB. Physical tables that pre-aggregate frequently accessed dataC. A hierarchical tree of parent–child pointersD. A dimensional model that simplifies reporting for end usersE. Leaving the Data Vault structure intact in the Warehousing Layer while serving dimensional views
9. Which fields make a Data Vault satellite bi-temporal by default?
Question 9A. Hash keys and record sourceB. Primary key and foreign keyC. ValidFrom and hub keyD. ValidFrom, ValidTo and LoadDate togetherE. LoadDate alone
10. In the Data Vault loan example, what happens when a loan's interest rate changes from 7.5% to 8.0%?
Question 10A. The Hub_Loan row is updated with the new rateB. The Link_LoanCustomer row is replacedC. The old rate is deleted from Sat_LoanDetailsD. A new hub is created for the new rateE. The old value stays in Sat_LoanDetails with its validity range and a new row is added, preserving full history