TEMPORAL DATA MODELLING — Learn free

Self-check

Questions 1–10 of 10

1. What is Temporal Data Modelling?
Question 1A. Structuring data so that changes over time are explicitly captured and preservedB. Structuring data around measurable facts and descriptive dimensionsC. Structuring data as nodes and edges for traversalD. Structuring data for single-key lookupE. Structuring data as message contracts between services
2. What does Valid Time refer to in temporal modelling?
Question 2A. When the fact was recorded in the systemB. When a fact is true in the real worldC. When the database was last backed upD. When a query was executedE. When a record was archived
3. What does Transaction Time refer to in temporal modelling?
Question 3A. When the loan was originatedB. When the fact is true in the business worldC. When the fact was recorded in the systemD. When the repayment was dueE. When the customer applied
4. What is a model called when it captures both Valid Time and Transaction Time?
Question 4A. Uni-temporalB. SnapshotC. Slowly changingD. Bi-temporalE. Event-sourced
5. What is the key principle governing updates in a temporal model?
Question 5A. Rows are updated in place and the old value discardedB. Rows are deleted and reinserted with new valuesC. Only the latest value is kept in a cacheD. Changes are stored in a separate audit log onlyE. Data is never overwritten; new versions are inserted with time boundaries
6. In the temporal loan timeline for Loan L001, what happens on 1 February 2024?
Question 6A. The interest rate is corrected to 8.0%, stored as a new time sliceB. The loan is submitted with status PendingC. The loan is approved at 7.5%D. The loan is rejectedE. The earlier version is deleted
7. Which of the following is an example of an "as-of" query enabled by temporal modelling?
Question 7A. Total loan amount approved by branchB. Show the loan status as of 14 January 2024C. Count of loans per customer segmentD. List all officers in the Central branchE. Average repayment amount per product
8. With which normal-form principles do temporal tables frequently align when attributes change independently over time?
Question 8A. 1NF and 2NFB. BCNF onlyC. 5NF or 6NFD. DKNFE. UNF
9. Which of the following is NOT listed as a strength of Temporal Data Modelling?
Question 9A. Full audit trail of changesB. Accurate historical reconstructionC. Support for regulatory and compliance requirementsD. Reduced storage and simpler queriesE. Time-travel queries for analytics
10. Which industries are named as needing to show what data looked like at a specific point in time?
Question 10A. Retail, hospitality and entertainmentB. Manufacturing, logistics and agricultureC. Education, sport and mediaD. Advertising, gaming and travelE. Banking, insurance, healthcare and government