CDW110V LATEST 2026 STUDY GUIDE QUESTIONS AND
ANSWERS GUARANTEE A+
✔✔What is the surrogate key for MedicationOrderFact? - ✔✔MedicationOrderKey
✔✔How are foreign keys documented in the Dictionary? - ✔✔Table that link to or from a
given table are listed under properties, and hyperlinks to the destination table are
provided next to foreign key column descriptions.
✔✔True or False: A maximum of one foreign key can exist between two tables in
Caboodle. - ✔✔False. Multiple foreign keys can exist between two tables in Caboodle.
✔✔How can MedicationOrderFact join to PatientDim? -
✔✔MedicationOrderFact.PatientKey = PatientDim.PatientKey or
MedicationOrderFact.PatientDurableKey = PatientDim.PatientDurableKey
✔✔In Caboodle, can Fact tables be joined to other fact tables? - ✔✔Yes, example
MedicationOrderFact can join to EncounterFact.
✔✔Which of the following would you expect to be stored in a dimension table? -
✔✔Users and Diagnosis Definitions
✔✔Which of the following are possible to do in Caboodle? - ✔✔Joining a fact table to
another fact table, Fact table to dimension table, dimension table to dimension table, 2
different EAV dim table to an attribute dim table
✔✔True or False: Any change to Patient data in Clarity will generate a new row in
PatientDim after the next extract. - ✔✔False, only changes in type 2 data would result in
a new row being generated.
✔✔True of false: The _Current view tables in the FullAccess schema contains a subset
of the rows contained in their corresponding type 2 tables. - ✔✔True. _Current view
tables in the Fullaccess schema contain a subset of the rows contained in their
corresponding type 2 tables.
✔✔What is a durable key? - ✔✔Type 2 tables have a durable key column which stores
the same value for all rows that correspond to the same entity. This allows for grouping
or summarizing data by the entity.
✔✔If a patient has a PCP assigned, but that providers' data hasn't been extracted to
ProviderDim, what value would appear in ProviderDim.name for this patient? -
✔✔*unknown (an inferred row)
, ✔✔A foreign key column in Caboodle contains the value -3. What could this mean? -
✔✔Either the data that once populated this row was deleted from the source, or this is
the -3 row, for which all foreign key columns are also -3.
✔✔If a foreign key is null in Clarity, what will appear in the corresponding column in
Caboodle? - ✔✔If the foreign key was expected to have data, then a -1 will appear in
Caboodle to represent an unspecified value. If the foreign key was not expected to
contain data, then a -2 will appear in the row to represent a value that is not applicable.
✔✔What is the difference between a MappingFact table and a Bridge table? - ✔✔Both
are used to map many-to-many relationships, however, Bridge table always link to a
Dimension table while MappingFact tables link to Fact tables.
✔✔What two columns do all Bridge tables have? - ✔✔Every Bridge table has a Combo
key to which other tables join, and a foreign key to join to its associated Dim table.
✔✔What Chronicles Data structure underlies many of the EAV tables in Caboodle? -
✔✔SmartData Element data stored in the HLV master file in Chronicles.
✔✔True or false: AttributeValueDim tables are more granular than their associated Fact
table? - ✔✔True. EAV tables are more granular than their associated Fact table.
✔✔What is the granularity of MedicationOrderFact? - ✔✔An order.
✔✔What Clarity table acts as the primary source for data in EpisodeFact? - ✔✔Episode.
✔✔True or False: Every row in DepartmentDim represents a department. - ✔✔False.
Rows in DeptartmentDim represent many different data types, ex: bed, room, room
group, etc.
✔✔What is the granularity of DepartmentDim? - ✔✔Granularity: A bed, room, room
group, care area, submitter, department, location, service area, or business segment
✔✔True or False: A load package must populate all fields in a table? - ✔✔False. A load
package does not have to populate all fields in a table.
✔✔DBO (Reporting Tables reside in this Schema) - ✔✔DBO are a way to organize
tables. Import tables used by developers to store data.
✔✔Full Access (Reporting Views Reside in this Schema) - ✔✔FullAccess refer are -
Views Designed to simplify reporting (should be default for BI Developers writing
reports).
ANSWERS GUARANTEE A+
✔✔What is the surrogate key for MedicationOrderFact? - ✔✔MedicationOrderKey
✔✔How are foreign keys documented in the Dictionary? - ✔✔Table that link to or from a
given table are listed under properties, and hyperlinks to the destination table are
provided next to foreign key column descriptions.
✔✔True or False: A maximum of one foreign key can exist between two tables in
Caboodle. - ✔✔False. Multiple foreign keys can exist between two tables in Caboodle.
✔✔How can MedicationOrderFact join to PatientDim? -
✔✔MedicationOrderFact.PatientKey = PatientDim.PatientKey or
MedicationOrderFact.PatientDurableKey = PatientDim.PatientDurableKey
✔✔In Caboodle, can Fact tables be joined to other fact tables? - ✔✔Yes, example
MedicationOrderFact can join to EncounterFact.
✔✔Which of the following would you expect to be stored in a dimension table? -
✔✔Users and Diagnosis Definitions
✔✔Which of the following are possible to do in Caboodle? - ✔✔Joining a fact table to
another fact table, Fact table to dimension table, dimension table to dimension table, 2
different EAV dim table to an attribute dim table
✔✔True or False: Any change to Patient data in Clarity will generate a new row in
PatientDim after the next extract. - ✔✔False, only changes in type 2 data would result in
a new row being generated.
✔✔True of false: The _Current view tables in the FullAccess schema contains a subset
of the rows contained in their corresponding type 2 tables. - ✔✔True. _Current view
tables in the Fullaccess schema contain a subset of the rows contained in their
corresponding type 2 tables.
✔✔What is a durable key? - ✔✔Type 2 tables have a durable key column which stores
the same value for all rows that correspond to the same entity. This allows for grouping
or summarizing data by the entity.
✔✔If a patient has a PCP assigned, but that providers' data hasn't been extracted to
ProviderDim, what value would appear in ProviderDim.name for this patient? -
✔✔*unknown (an inferred row)
, ✔✔A foreign key column in Caboodle contains the value -3. What could this mean? -
✔✔Either the data that once populated this row was deleted from the source, or this is
the -3 row, for which all foreign key columns are also -3.
✔✔If a foreign key is null in Clarity, what will appear in the corresponding column in
Caboodle? - ✔✔If the foreign key was expected to have data, then a -1 will appear in
Caboodle to represent an unspecified value. If the foreign key was not expected to
contain data, then a -2 will appear in the row to represent a value that is not applicable.
✔✔What is the difference between a MappingFact table and a Bridge table? - ✔✔Both
are used to map many-to-many relationships, however, Bridge table always link to a
Dimension table while MappingFact tables link to Fact tables.
✔✔What two columns do all Bridge tables have? - ✔✔Every Bridge table has a Combo
key to which other tables join, and a foreign key to join to its associated Dim table.
✔✔What Chronicles Data structure underlies many of the EAV tables in Caboodle? -
✔✔SmartData Element data stored in the HLV master file in Chronicles.
✔✔True or false: AttributeValueDim tables are more granular than their associated Fact
table? - ✔✔True. EAV tables are more granular than their associated Fact table.
✔✔What is the granularity of MedicationOrderFact? - ✔✔An order.
✔✔What Clarity table acts as the primary source for data in EpisodeFact? - ✔✔Episode.
✔✔True or False: Every row in DepartmentDim represents a department. - ✔✔False.
Rows in DeptartmentDim represent many different data types, ex: bed, room, room
group, etc.
✔✔What is the granularity of DepartmentDim? - ✔✔Granularity: A bed, room, room
group, care area, submitter, department, location, service area, or business segment
✔✔True or False: A load package must populate all fields in a table? - ✔✔False. A load
package does not have to populate all fields in a table.
✔✔DBO (Reporting Tables reside in this Schema) - ✔✔DBO are a way to organize
tables. Import tables used by developers to store data.
✔✔Full Access (Reporting Views Reside in this Schema) - ✔✔FullAccess refer are -
Views Designed to simplify reporting (should be default for BI Developers writing
reports).
