1|Page
CDW110V CABOODLE DATA MODEL
FUNDAMENTALS EXAM WITH CORRECT
SOLUTIONS
Identify the Caboodle table and column for the following data point: The Patient's
Epic ID-correct-answer-PatientDim.PatientEpicId
Identify the Caboodle table and column for the following data point: The patient's
name-correct-answer-PatientDim.Name
Identify the Caboodle table and column for the following data point: The patient's
zip code-correct-answer-PatientDim.PostalCode
Identify the Caboodle table and column for the following data point: The patient's
phone number-correct-answer-PatientDim.HomePhoneNumber
Identify the Caboodle table and column for the following data point: The patient's
MyChart Status-correct-answer-PatientDim.MyChartStatus
,2|Page
Identify the Caboodle table and column for the following data point: Column to
identify deleted primary care providers-correct-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?-
correct-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?-
correct-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?-correct-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.
, 3|Page
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?-correct-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-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.
True or False: All inferred rows in Caboodle have a primary key of -1.-correct-
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.
CDW110V CABOODLE DATA MODEL
FUNDAMENTALS EXAM WITH CORRECT
SOLUTIONS
Identify the Caboodle table and column for the following data point: The Patient's
Epic ID-correct-answer-PatientDim.PatientEpicId
Identify the Caboodle table and column for the following data point: The patient's
name-correct-answer-PatientDim.Name
Identify the Caboodle table and column for the following data point: The patient's
zip code-correct-answer-PatientDim.PostalCode
Identify the Caboodle table and column for the following data point: The patient's
phone number-correct-answer-PatientDim.HomePhoneNumber
Identify the Caboodle table and column for the following data point: The patient's
MyChart Status-correct-answer-PatientDim.MyChartStatus
,2|Page
Identify the Caboodle table and column for the following data point: Column to
identify deleted primary care providers-correct-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?-
correct-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?-
correct-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?-correct-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.
, 3|Page
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?-correct-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-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.
True or False: All inferred rows in Caboodle have a primary key of -1.-correct-
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.
