CDW 110V CABOODLE DATA MODEL
FUNDAMENTALS|110 QUESTIONS|ACE THE TEST: A
JOURNEY TO EXCELLENCE
What is the "Caboodle Setup and Support Guide"? - ✔ ✔ step-by-
step information about installing and upgrading Caboodle.
What is the "Caboodle Maintenance and Monitoring Guide"? - ✔ ✔
configuration, troubleshooting, and performance tuning for ETL
administrators, including upgrade steps.
What is the "Caboodle Changelog"? - ✔ ✔ required follow-up
actions and automatic changes for each new version of caboodle.
What is the "Caboodle Developer's Guide"? - ✔ ✔ Step-by-step
documentation on how to create custom DMC's and packages
What is the "Reporting with Caboodle"? - ✔ ✔ describes the DMC's
associated with common reporting topics with example SQL queries.
What is the relationship between SlicerDicer and Caboodle? - ✔ ✔
SlicerDicer is Epic's self service reporting tool in Hyperspace that
dynamically queries Caboodle data.
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
What is the "Dictionary" in Caboodle Console? - ✔ ✔ the
dictionary contains the basic metadata for Caboodle. Business
Intelligence developers can use the Dictionary to find out how data
is stored in each DMC.
What is the "Dictionary Editor" in Caboodle Console? - ✔ ✔ it offers
a more in-depth view of packages and data lineage for advanced
business intelligence developers, administrators, and developers. it
contains information about packages, procedures, dependencies,
indexes, and data source preferences, as well as tools for
customizing the data model. list of DMC's
What is the "Executions" activity in Caboodle Console? - ✔ ✔
activity is where administrators can create and monitor executions
and errors. move data from source to Caboodle.
, What is the "Work Queue" activity in Caboodle Console? - ✔ ✔
logs the different types of issues or changes that can occur during
the ETL process that require manual intervention. For example, you
may be notified that potential records matches have been
identified.
What is the "Confiruration" activity in Caboodle Console? - ✔ ✔
activity includes a variety of pages to manage and view important
information like system settings, user administration, component
configuration and more.
What is the button labeled "+Notes" for in each DMC and column,
and also on some configuration items? - ✔ ✔ it is a convenient
way for you to add your own documentation and will be visible to
other users.notes are searchable
What are some additional resources for Caboodle? - ✔ ✔
"Caboodle Setup and Support Guide"
"Caboodle Maintenance and Monitoring Guide"
"Caboodle Changelog"
"Caboodle Developer's Guide"
"Reporting with Caboodle"
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.
FUNDAMENTALS|110 QUESTIONS|ACE THE TEST: A
JOURNEY TO EXCELLENCE
What is the "Caboodle Setup and Support Guide"? - ✔ ✔ step-by-
step information about installing and upgrading Caboodle.
What is the "Caboodle Maintenance and Monitoring Guide"? - ✔ ✔
configuration, troubleshooting, and performance tuning for ETL
administrators, including upgrade steps.
What is the "Caboodle Changelog"? - ✔ ✔ required follow-up
actions and automatic changes for each new version of caboodle.
What is the "Caboodle Developer's Guide"? - ✔ ✔ Step-by-step
documentation on how to create custom DMC's and packages
What is the "Reporting with Caboodle"? - ✔ ✔ describes the DMC's
associated with common reporting topics with example SQL queries.
What is the relationship between SlicerDicer and Caboodle? - ✔ ✔
SlicerDicer is Epic's self service reporting tool in Hyperspace that
dynamically queries Caboodle data.
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
What is the "Dictionary" in Caboodle Console? - ✔ ✔ the
dictionary contains the basic metadata for Caboodle. Business
Intelligence developers can use the Dictionary to find out how data
is stored in each DMC.
What is the "Dictionary Editor" in Caboodle Console? - ✔ ✔ it offers
a more in-depth view of packages and data lineage for advanced
business intelligence developers, administrators, and developers. it
contains information about packages, procedures, dependencies,
indexes, and data source preferences, as well as tools for
customizing the data model. list of DMC's
What is the "Executions" activity in Caboodle Console? - ✔ ✔
activity is where administrators can create and monitor executions
and errors. move data from source to Caboodle.
, What is the "Work Queue" activity in Caboodle Console? - ✔ ✔
logs the different types of issues or changes that can occur during
the ETL process that require manual intervention. For example, you
may be notified that potential records matches have been
identified.
What is the "Confiruration" activity in Caboodle Console? - ✔ ✔
activity includes a variety of pages to manage and view important
information like system settings, user administration, component
configuration and more.
What is the button labeled "+Notes" for in each DMC and column,
and also on some configuration items? - ✔ ✔ it is a convenient
way for you to add your own documentation and will be visible to
other users.notes are searchable
What are some additional resources for Caboodle? - ✔ ✔
"Caboodle Setup and Support Guide"
"Caboodle Maintenance and Monitoring Guide"
"Caboodle Changelog"
"Caboodle Developer's Guide"
"Reporting with Caboodle"
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.
