CDW 110V CABOODLE DATA MODEL
ACTUAL TEST PAPER COMPLETE
QUESTIONS AND SOLUTIONS TESTED
ANSWERS
◉ Identify the Caboodle table and column for the following data
point: Column used to identify office visits that have been completed
(I EPT 87318)
Answer: EncounterFact.DerivedEncounterStatus = 'Complete'
◉ Identify the Caboodle table and column for the following data
point: The patient's MRN
Answer: PatientDim.PrimaryMrn
◉ Identify the Caboodle table and column for the following data
point: The patient's name
Answer: PatientDim.Name
◉ Identify the Caboodle table and column for the following data
point: Medications that are considered opioids
Answer: MedicationDim.Opioid
,◉ True or False: Any change to patient data in Clarity will generate a
new row in PatientDim after the next extract.
Answer: False. Assuming the data is extracted to Caboodle, only
changes to snapshot columns would generate a new row in
PatientDim.
◉ What is a durable key?
Answer: Snapshot tables have a durable key column which stores
the same value for all rows that correspond to the same entity. This
allows for accurate grouping and summarizing.
◉ Log into Hyperspace as the Cogito Tools Administrator, open the
Patients data model in SlicerDicer, and click Troubleshoot. What
table and column is used to generate a count of patients in
SlicerDicer? Why would this column be preferable to the primary
key?
Answer: PatientDim.DurableKey. This column stores exactly one
value per patient in PatientDim. Since PatientDim is a snapshot
table, the DurableKey provides a more accurate count of patients
than PatientKey since there may be more than one PatientKey value
per patient.
◉ Consider the following query:
SELECT DurableKey FROM <TableName>
, Which of the following statements are true?
A. This query will only run if <TableName> is a snapshot table
B. This query will run regardless of whether <TableName> has
change tracking
C. The value in the DurableKey column could repeat in multiple rows
of the results
D. There is no table in Caboodle for which this query will run
Answer: A. This query will only run if <TableName> is a snapshot
table, and C. The value in the DurableKey column could repeat in
multiple rows of the results
◉ Identify the Caboodle table and column for the following data
point: The Epic ID for the medication order
Answer: MedicationOrderFact.MedicationOrderEpicId
◉ Identify the Caboodle table and column for the following data
point: The date the order was placed
Answer: DateDim.DisplayString
◉ Identify the Caboodle table and column for the following data
point: The name of the department
Answer: DepartmentDim.Name
ACTUAL TEST PAPER COMPLETE
QUESTIONS AND SOLUTIONS TESTED
ANSWERS
◉ Identify the Caboodle table and column for the following data
point: Column used to identify office visits that have been completed
(I EPT 87318)
Answer: EncounterFact.DerivedEncounterStatus = 'Complete'
◉ Identify the Caboodle table and column for the following data
point: The patient's MRN
Answer: PatientDim.PrimaryMrn
◉ Identify the Caboodle table and column for the following data
point: The patient's name
Answer: PatientDim.Name
◉ Identify the Caboodle table and column for the following data
point: Medications that are considered opioids
Answer: MedicationDim.Opioid
,◉ True or False: Any change to patient data in Clarity will generate a
new row in PatientDim after the next extract.
Answer: False. Assuming the data is extracted to Caboodle, only
changes to snapshot columns would generate a new row in
PatientDim.
◉ What is a durable key?
Answer: Snapshot tables have a durable key column which stores
the same value for all rows that correspond to the same entity. This
allows for accurate grouping and summarizing.
◉ Log into Hyperspace as the Cogito Tools Administrator, open the
Patients data model in SlicerDicer, and click Troubleshoot. What
table and column is used to generate a count of patients in
SlicerDicer? Why would this column be preferable to the primary
key?
Answer: PatientDim.DurableKey. This column stores exactly one
value per patient in PatientDim. Since PatientDim is a snapshot
table, the DurableKey provides a more accurate count of patients
than PatientKey since there may be more than one PatientKey value
per patient.
◉ Consider the following query:
SELECT DurableKey FROM <TableName>
, Which of the following statements are true?
A. This query will only run if <TableName> is a snapshot table
B. This query will run regardless of whether <TableName> has
change tracking
C. The value in the DurableKey column could repeat in multiple rows
of the results
D. There is no table in Caboodle for which this query will run
Answer: A. This query will only run if <TableName> is a snapshot
table, and C. The value in the DurableKey column could repeat in
multiple rows of the results
◉ Identify the Caboodle table and column for the following data
point: The Epic ID for the medication order
Answer: MedicationOrderFact.MedicationOrderEpicId
◉ Identify the Caboodle table and column for the following data
point: The date the order was placed
Answer: DateDim.DisplayString
◉ Identify the Caboodle table and column for the following data
point: The name of the department
Answer: DepartmentDim.Name
