CDW110V COMPREHENSIVE UPDATED EXAM QUESTIONS
AND ANSWERS GUARANTEE A+
✔✔Identify the Caboodle table and column for the following data point: The date the
order was placed - ✔✔DateDim.DisplayString
✔✔Identify the Caboodle table and column for the following data point: The name of the
department - ✔✔DepartmentDim.Name
✔✔Identify the Caboodle table and column for the following data point: The PatientKey
for the inferred rows - ✔✔PatientDim.PatientKey
✔✔Identify the Caboodle table and column for the following data point: The medication's
generic name - ✔✔MedicationDim.GenericName
✔✔Identify the Caboodle table and column for the following data point: The medication's
Epic ID - ✔✔MedicationDim.MedicationEpicID
✔✔Identify the Caboodle table and column for the following data point: Column to
identify inferred patients - ✔✔PatientDim._IsInferred
✔✔Identify the Caboodle table and column for the following data point: Column in the -
Fact table to remove deleted data - ✔✔MedicationOrderFact._IsDeleted = 0
✔✔Identify the Caboodle table and column for the following data point: The Patient's
Epic ID - ✔✔PatientDim.PatientEpicId
✔✔Identify the Caboodle table and column for the following data point: The patient's
name - ✔✔PatientDim.Name
✔✔Identify the Caboodle table and column for the following data point: The patient's zip
code - ✔✔PatientDim.PostalCode
✔✔Identify the Caboodle table and column for the following data point: The patient's
phone number - ✔✔PatientDim.HomePhoneNumber
✔✔Identify the Caboodle table and column for the following data point: The patient's
MyChart Status - ✔✔PatientDim.MyChartStatus
✔✔Identify the Caboodle table and column for the following data point: Column to
identify deleted primary care providers - ✔✔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? - ✔✔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? -
✔✔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? - ✔✔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? - ✔✔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 - ✔✔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. - ✔✔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 date the
patient arrived at the ED - ✔✔
AND ANSWERS GUARANTEE A+
✔✔Identify the Caboodle table and column for the following data point: The date the
order was placed - ✔✔DateDim.DisplayString
✔✔Identify the Caboodle table and column for the following data point: The name of the
department - ✔✔DepartmentDim.Name
✔✔Identify the Caboodle table and column for the following data point: The PatientKey
for the inferred rows - ✔✔PatientDim.PatientKey
✔✔Identify the Caboodle table and column for the following data point: The medication's
generic name - ✔✔MedicationDim.GenericName
✔✔Identify the Caboodle table and column for the following data point: The medication's
Epic ID - ✔✔MedicationDim.MedicationEpicID
✔✔Identify the Caboodle table and column for the following data point: Column to
identify inferred patients - ✔✔PatientDim._IsInferred
✔✔Identify the Caboodle table and column for the following data point: Column in the -
Fact table to remove deleted data - ✔✔MedicationOrderFact._IsDeleted = 0
✔✔Identify the Caboodle table and column for the following data point: The Patient's
Epic ID - ✔✔PatientDim.PatientEpicId
✔✔Identify the Caboodle table and column for the following data point: The patient's
name - ✔✔PatientDim.Name
✔✔Identify the Caboodle table and column for the following data point: The patient's zip
code - ✔✔PatientDim.PostalCode
✔✔Identify the Caboodle table and column for the following data point: The patient's
phone number - ✔✔PatientDim.HomePhoneNumber
✔✔Identify the Caboodle table and column for the following data point: The patient's
MyChart Status - ✔✔PatientDim.MyChartStatus
✔✔Identify the Caboodle table and column for the following data point: Column to
identify deleted primary care providers - ✔✔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? - ✔✔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? -
✔✔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? - ✔✔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? - ✔✔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 - ✔✔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. - ✔✔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 date the
patient arrived at the ED - ✔✔
