CABOODLE DATA MODEL EXAM 100%
SOLVED
, What is a primary reason that snapshot data should not be used for audit reporting? -
ANSWERSnapshot data is tracked by the Caboodle ETL process and does not track
when a specific change took place.
Snapshot columns retain... - ANSWERPrevious values which been extracted to
Caboodle and have since changed in the source.
How might you be able to determine the date when a change took place? -
ANSWERCheck the data lineage to determine the Chronicles item and/or Clarity table
and column that store this information. For non‐Epic data, work with your Caboodle
developers to determine relevant data lineage.
What 4 columns do snapshot tables include? - ANSWERIscurrent, StartDate, EndDate,
DurableKey
DurableKey - ANSWERWhile 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.
The StartDate and EndDate columns refer to: - ANSWERStore the date range for the
snapshot data in the table. 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.
Lookup columns will join to either the surrogate key or DurableKey depending upon: -
ANSWERWhether that table uses change tracking.
When joining to a snapshot table do these two things: - ANSWERUse the durable key
lookup column in the starting table to join to the durable key of the target table. Then,
filter to the current row of the snapshot table
Foreign keys that join to the surrogate key of a snapshot table point to the row that... -
ANSWERWas current at the time the data was loaded. Therefore, such foreign keys
could point to stale data in snapshot tables.
True or False: There will rarely be a lookup column to the durable key of a snapshot
table - ANSWERFalse. There will always be.
When comparing durable key values, be sure to remove what? - ANSWERThe negative
values: ‐1, ‐2, ‐3. Neglecting to do so may result in false positives.
SOLVED
, What is a primary reason that snapshot data should not be used for audit reporting? -
ANSWERSnapshot data is tracked by the Caboodle ETL process and does not track
when a specific change took place.
Snapshot columns retain... - ANSWERPrevious values which been extracted to
Caboodle and have since changed in the source.
How might you be able to determine the date when a change took place? -
ANSWERCheck the data lineage to determine the Chronicles item and/or Clarity table
and column that store this information. For non‐Epic data, work with your Caboodle
developers to determine relevant data lineage.
What 4 columns do snapshot tables include? - ANSWERIscurrent, StartDate, EndDate,
DurableKey
DurableKey - ANSWERWhile 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.
The StartDate and EndDate columns refer to: - ANSWERStore the date range for the
snapshot data in the table. 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.
Lookup columns will join to either the surrogate key or DurableKey depending upon: -
ANSWERWhether that table uses change tracking.
When joining to a snapshot table do these two things: - ANSWERUse the durable key
lookup column in the starting table to join to the durable key of the target table. Then,
filter to the current row of the snapshot table
Foreign keys that join to the surrogate key of a snapshot table point to the row that... -
ANSWERWas current at the time the data was loaded. Therefore, such foreign keys
could point to stale data in snapshot tables.
True or False: There will rarely be a lookup column to the durable key of a snapshot
table - ANSWERFalse. There will always be.
When comparing durable key values, be sure to remove what? - ANSWERThe negative
values: ‐1, ‐2, ‐3. Neglecting to do so may result in false positives.
