CDW110v Caboodle Data Model Fundamentals Exam Questions and Answers

CDW110v Caboodle Data Model Fundamentals Exam
Questions and Answers
Question 1
Identify the Caboodle table and column for the following data point: Column to identify deleted primary care providers
Correct Answer
ProviderDim._IsDeleted = 1



Question 2
What is the relationship between SlicerDicer and Caboodle?
Correct Answer
SlicerDicer is Epic's self-service reporting tool in Hyperspace that dynamically queries Caboodle data.




Page 1 of 27

,Question 3
A row in a Caboodle table has a primary key value of -2. What value will be stored in columns with a data type of "Date" for
this row that are not lookup columns?
A. -2
B. NULL
C. 12/31/1840
D. *Not Applicable
Correct Answer
b. NULL, For the row with a primary key of -2, lookup columns will store a value of -2, string columns will store '*Not
Applicable', and all other data type columns will store NULL.



Question 4
Identify the Caboodle table and column for the following data point: The patient's Epic ID
Correct Answer
PatientDim.PatientEpicId



Question 5
Identify the Caboodle table and column for the following data point: Type
Correct Answer
EncounterFact.Type




Page 2 of 27

, Question 6
Identify the Caboodle table and column for the following data point: The patient's zip code
Correct Answer
PatientDim.PostalCode



Question 7
Identify the Caboodle table and column for the following data point: The Primary Key of AllergyFact
Correct Answer
AllergyFact.AllergyKey



Question 8
True or False. Researching Caboodle should be completed in Hyperspace in the Cogito Dictionary portion of the Analytics
Catalog.
Correct Answer
True



Question 9
Identify the Caboodle table and column for the following data point: Medications that are considered opioids
Correct Answer
MedicationDim.Opioid




Page 3 of 27