Caboodle Data Model Exam 2023/2024 Graded A+

What is a primary reason that snapshot data should not be used for audit reporting? - ANSWER-Snapshot data is tracked by the Caboodle ETL process and does not track when a specific change took place. Snapshot columns retain... - ANSWER-Previous 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? - ANSWER-Check 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? - ANSWER-Iscurrent, StartDate, EndDate, DurableKey DurableKey - ANSWER-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. The StartDate and EndDate columns refer to: - ANSWER-Store 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: - ANSWER-Whether that table uses change tracking. When joining to a snapshot table do these two things: - ANSWER-Use 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... - ANSWER-Was 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 - ANSWER-False. There will always be. When comparing durable key values, be sure to remove what? - ANSWER-The negative values: ‐1, ‐2, ‐3. Neglecting to do so may result in false positives.