CDW 110v Caboodle Data Model
Fundamentals – Complete Q&A 2026
Section 1: Snapshot Tables & Change Tracking
(Questions 1-15)
Question 1
What is a primary reason that snapshot data should NOT be used for audit
reporting?
A. Snapshot data is too large to query efficiently
B. Snapshot data is tracked by the Caboodle ETL process and does not track
when a specific change took place
C. Snapshot data only contains current values
D. Snapshot data is not stored in the data warehouse
*Correct Answer: B. *
Rationale: Snapshot data is tracked by the Caboodle ETL process and does
not track when a specific change took place. For audit reporting, you need to
know exactly when a change occurred, which snapshot data does not provide.
Question 2
What four columns do snapshot tables include?
A. IsCurrent, StartDate, EndDate, DurableKey
B. IsCurrent, StartDate, EndDate, SurrogateKey
,C. IsCurrent, CreateDate, ModifiedDate, DurableKey
D. StartDate, EndDate, VersionNumber, BusinessKey
*Correct Answer: A. *
Rationale: Snapshot tables include four key columns: IsCurrent, StartDate,
EndDate, and DurableKey. These columns allow tracking of changes over
time while maintaining a durable identifier for each entity.
Question 3
What is the purpose of the DurableKey column in a snapshot table?
A. It serves as the primary key for the table
B. It stores the same value for all rows in the table that refer to the same
entity
C. It is a foreign key to the source system
D. It indicates the current version of the row
*Correct Answer: B. *
Rationale: While there may be multiple rows in a snapshot table for a given
entity, each with a unique primary key value, the DurableKey column stores
the same value for all rows in the table that refer to the same entity.
Question 4
What are the default StartDate and EndDate values for the earliest and
most recent rows in a snapshot table?
A. 1/1/1900 and 12/31/2099
B. 1/1/1970 and 1/1/2100
C. 1/1/1979 and 12/31/2099
D. NULL and NULL
,*Correct Answer: C. *
Rationale: For the rows that hold the earliest and most recent versions of the
data recorded in Caboodle, the StartDate and EndDate are set to a default
start and end date value of 1/1/1979 and 12/31/2099.
Question 5
When joining to a snapshot table, what two things should you do?
A. Use the surrogate key and filter to the current row
B. Use the durable key and filter to the current row
C. Use the business key and filter to the earliest row
D. Use the primary key only
*Correct Answer: B. *
Rationale: When joining to a snapshot table, you should use the durable key
lookup column in the starting table to join to the durable key of the target
table, and then filter to the current row of the snapshot table.
Question 6
Foreign keys that join to the surrogate key of a snapshot table point to the
row that:
A. Was current at the time the data was loaded
B. Is always the current row
C. Is the earliest version of the entity
D. Has the lowest DurableKey value
*Correct Answer: A. *
, Rationale: Foreign keys that join to the surrogate key of a snapshot table
point to the row that was current at the time the data was loaded.
Therefore, such foreign keys could point to stale data in snapshot tables.
Question 7
True or False: There will rarely be a lookup column to the durable key of a
snapshot table.
A. True
B. False
*Correct Answer: B. False. *
Rationale: False. There will always be a lookup column to the durable key of
a snapshot table. This ensures that you can join to the snapshot table using
the durable key to track entities across versions.
Question 8
When comparing durable key values, what should you remove?
A. Only -1 values
B. Only -2 values
C. The negative values: -1, -2, -3
D. All values less than zero
*Correct Answer: C. *
Rationale: When comparing durable key values, be sure to remove the
negative values: -1, -2, -3. Neglecting to do so may result in false positives.
Fundamentals – Complete Q&A 2026
Section 1: Snapshot Tables & Change Tracking
(Questions 1-15)
Question 1
What is a primary reason that snapshot data should NOT be used for audit
reporting?
A. Snapshot data is too large to query efficiently
B. Snapshot data is tracked by the Caboodle ETL process and does not track
when a specific change took place
C. Snapshot data only contains current values
D. Snapshot data is not stored in the data warehouse
*Correct Answer: B. *
Rationale: Snapshot data is tracked by the Caboodle ETL process and does
not track when a specific change took place. For audit reporting, you need to
know exactly when a change occurred, which snapshot data does not provide.
Question 2
What four columns do snapshot tables include?
A. IsCurrent, StartDate, EndDate, DurableKey
B. IsCurrent, StartDate, EndDate, SurrogateKey
,C. IsCurrent, CreateDate, ModifiedDate, DurableKey
D. StartDate, EndDate, VersionNumber, BusinessKey
*Correct Answer: A. *
Rationale: Snapshot tables include four key columns: IsCurrent, StartDate,
EndDate, and DurableKey. These columns allow tracking of changes over
time while maintaining a durable identifier for each entity.
Question 3
What is the purpose of the DurableKey column in a snapshot table?
A. It serves as the primary key for the table
B. It stores the same value for all rows in the table that refer to the same
entity
C. It is a foreign key to the source system
D. It indicates the current version of the row
*Correct Answer: B. *
Rationale: While there may be multiple rows in a snapshot table for a given
entity, each with a unique primary key value, the DurableKey column stores
the same value for all rows in the table that refer to the same entity.
Question 4
What are the default StartDate and EndDate values for the earliest and
most recent rows in a snapshot table?
A. 1/1/1900 and 12/31/2099
B. 1/1/1970 and 1/1/2100
C. 1/1/1979 and 12/31/2099
D. NULL and NULL
,*Correct Answer: C. *
Rationale: For the rows that hold the earliest and most recent versions of the
data recorded in Caboodle, the StartDate and EndDate are set to a default
start and end date value of 1/1/1979 and 12/31/2099.
Question 5
When joining to a snapshot table, what two things should you do?
A. Use the surrogate key and filter to the current row
B. Use the durable key and filter to the current row
C. Use the business key and filter to the earliest row
D. Use the primary key only
*Correct Answer: B. *
Rationale: When joining to a snapshot table, you should use the durable key
lookup column in the starting table to join to the durable key of the target
table, and then filter to the current row of the snapshot table.
Question 6
Foreign keys that join to the surrogate key of a snapshot table point to the
row that:
A. Was current at the time the data was loaded
B. Is always the current row
C. Is the earliest version of the entity
D. Has the lowest DurableKey value
*Correct Answer: A. *
, Rationale: Foreign keys that join to the surrogate key of a snapshot table
point to the row that was current at the time the data was loaded.
Therefore, such foreign keys could point to stale data in snapshot tables.
Question 7
True or False: There will rarely be a lookup column to the durable key of a
snapshot table.
A. True
B. False
*Correct Answer: B. False. *
Rationale: False. There will always be a lookup column to the durable key of
a snapshot table. This ensures that you can join to the snapshot table using
the durable key to track entities across versions.
Question 8
When comparing durable key values, what should you remove?
A. Only -1 values
B. Only -2 values
C. The negative values: -1, -2, -3
D. All values less than zero
*Correct Answer: C. *
Rationale: When comparing durable key values, be sure to remove the
negative values: -1, -2, -3. Neglecting to do so may result in false positives.
