CDW110v Caboodle Data Model Fundamentals Exam || Most
Recent Exam 2026-2027 Actual Complete Real Exam Questions
And Correct Answers (Verified Answers) Already Graded A+ |
Guaranteed Success!! | Newest Exam | Just Released!!
What is the relationship between SlicerDicer and Caboodle? -
ANSWER SlicerDicer is Epic's self-service reporting tool in
Hyperspace that dynamically queries Caboodle data.
Identify the Caboodle table and column for the following
data point: The
patient's MyChart Status - ANSWER -
PatientDim.MyChartStatus
Identify the Caboodle table and column for the following data
point: Column to identify deleted primary care providers -
ANSWER -ProviderDim._IsDeleted = 1
Suppose you're creating a report using EncounterFact and
ProviderDim that displays the name of each provider for each
encounter. If an encounter's data loads into EncounterFact, but
that provider's data hasn't been extracted to ProviderDim, what
value would appear in ProviderDim.Name for this encounter? -
ANSWER -There would be an inferred row in ProviderDim,
therefore ProviderDim.Name would show "*Unknown" for the
encounter.
,A lookup column in Caboodle contains the value -3. What could
this mean? - ANSWER -There are two possibilities: Either the
data that once populated this row in Caboodle has been deleted
from the source or this is the row with -3 as its primary key, for
which all lookup columns are also -3. To know which is true,
check the primary key value for the given row: a non-negative
value indicates that this row represents deleted data in the
source.
If a lookup column is null in Clarity, what will appear in the
corresponding column in Caboodle? - ANSWER -If the lookup
column was null in the source and the SSIS package defines
the data lineage, then a -1 will appear in Caboodle to represent
an unspecified value. If the look up columns's data lineage was
not defined by the SSIS package that loaded data for a
particular row, then a -2 will appear in Caboodle to represent a
value that is not applicable.
Log into Hyperspace as the Cogito Tools Administrator, open
the Patients data model in SlicerDicer, and click Troubleshoot.
What is the purpose of the
WHERE clause in this data model? - ANSWER -The WHERE
clause (WHERE subq.DurableKey > 0) filters out the rows with
negative durable key values from PatientDim. Since these rows
do not represent actual patients, they should not be included in
the total count of patients in the Patients data model.
, 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 - 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.
True or False: All inferred rows in Caboodle have a primary key
of -1. - ANSWER -False. Inferred rows in Caboodle have non-
negative primary key values because they represent an entity
that Caboodle has inferred the existence of. The lookup
columns for such rows will be set to -1 until the Caboodle ETL
process updates the data.
Identify the Caboodle table and column for the following data
point: The chief
complaints Epic ID - ANSWER -
ChiefComplaintBridge.ChiefComplaintEpicId
Identify the Caboodle table and column for the following
data point: The
patient's name - ANSWER -
PatientDim.Name
Recent Exam 2026-2027 Actual Complete Real Exam Questions
And Correct Answers (Verified Answers) Already Graded A+ |
Guaranteed Success!! | Newest Exam | Just Released!!
What is the relationship between SlicerDicer and Caboodle? -
ANSWER SlicerDicer is Epic's self-service reporting tool in
Hyperspace that dynamically queries Caboodle data.
Identify the Caboodle table and column for the following
data point: The
patient's MyChart Status - ANSWER -
PatientDim.MyChartStatus
Identify the Caboodle table and column for the following data
point: Column to identify deleted primary care providers -
ANSWER -ProviderDim._IsDeleted = 1
Suppose you're creating a report using EncounterFact and
ProviderDim that displays the name of each provider for each
encounter. If an encounter's data loads into EncounterFact, but
that provider's data hasn't been extracted to ProviderDim, what
value would appear in ProviderDim.Name for this encounter? -
ANSWER -There would be an inferred row in ProviderDim,
therefore ProviderDim.Name would show "*Unknown" for the
encounter.
,A lookup column in Caboodle contains the value -3. What could
this mean? - ANSWER -There are two possibilities: Either the
data that once populated this row in Caboodle has been deleted
from the source or this is the row with -3 as its primary key, for
which all lookup columns are also -3. To know which is true,
check the primary key value for the given row: a non-negative
value indicates that this row represents deleted data in the
source.
If a lookup column is null in Clarity, what will appear in the
corresponding column in Caboodle? - ANSWER -If the lookup
column was null in the source and the SSIS package defines
the data lineage, then a -1 will appear in Caboodle to represent
an unspecified value. If the look up columns's data lineage was
not defined by the SSIS package that loaded data for a
particular row, then a -2 will appear in Caboodle to represent a
value that is not applicable.
Log into Hyperspace as the Cogito Tools Administrator, open
the Patients data model in SlicerDicer, and click Troubleshoot.
What is the purpose of the
WHERE clause in this data model? - ANSWER -The WHERE
clause (WHERE subq.DurableKey > 0) filters out the rows with
negative durable key values from PatientDim. Since these rows
do not represent actual patients, they should not be included in
the total count of patients in the Patients data model.
, 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 - 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.
True or False: All inferred rows in Caboodle have a primary key
of -1. - ANSWER -False. Inferred rows in Caboodle have non-
negative primary key values because they represent an entity
that Caboodle has inferred the existence of. The lookup
columns for such rows will be set to -1 until the Caboodle ETL
process updates the data.
Identify the Caboodle table and column for the following data
point: The chief
complaints Epic ID - ANSWER -
ChiefComplaintBridge.ChiefComplaintEpicId
Identify the Caboodle table and column for the following
data point: The
patient's name - ANSWER -
PatientDim.Name
