CDW110V CABOODLE DATA
MODEL FUNDAMENTALS
PRACTICE EXAM QUESTIONS
WITH CORRECT DETAILED
ANSWERS | ALREADY GRADED
A+<RECENT VERSION>
1. True or False: A caboodle report may contain at most 1 conformed
dimension? - ANSWER False. A Caboodle report can contain multiple
conformed dimensions.
2. Which of the following can be populated by more than one package? -
ANSWER A single table and a single row in a table.
3. When would a foreign key column in Caboodle contain a -1? -
ANSWER When the foreign key in the source data was null and a
value was expected.
4. Which tool(s) in the Caboodle console would be used most often by
Caboodle report writers? - ANSWER Dictionary and the Dictionary
editor.
,5. True or False: Caboodle and Clarity can be used interchangeably? -
ANSWER False. Caboodle and Clarity cannot be used
interchangeably.
6. Which of the following types of columns would you find in a type 1
table? - ANSWER Surrogate key, foreign key, and a combo key.
7. Where does Epic data in Caboodle come from? - ANSWER From
Clarity, which gets its data from Chronicles.
8. True or false: Only Epic can define SSIS packages to move data from
Clarity to Caboodle? - ANSWER False. Caboodle developers can also
SSIS packages to move data from Clarity to Caboodle.
9. Caboodle is designed to... - ANSWER Store Epic data, store non-Epic
data, make reporting easy, interoperate with slicerdicer.
10.Caboodle is considered a normalized database. - ANSWER False
11.Name three documentation resources for Caboodle resources. -
ANSWER Caboodle dictionary, Reporting with Caboodle document,
Caboodle ER diagram.
12.When writing reports, why is it better to use your organization's Caboodle
console rather than the console used in training? - ANSWER Because
the console can be highly customized for your organization.
13.What are the differences between a normalized and dimensional data
model? - ANSWER In a normalized data model, the focus is on not
repeating data. Ina dimensional data model, the focus us on ease of
reporting, and uses the star schema which focuses on a central fact table.
,14.True or False: A new version of Caboodle is released every month. -
ANSWER False, released every four to six months.
15.Explain the role of the Caboodle report writer. - ANSWER Queries
data that already exists in the database.
16.Explain the role of the Caboodle administrator. - ANSWER Uses the
Caboodle console to mange and monitor the ETL process.
17.Explain the Caboodle developer role. - ANSWER Designs custom
Data Model Components and SSIS packages to bring additional data into
the data warehouse.
18.True or False: Naming conventions are enforced in Caboodle. -
ANSWER True. Naming conventions are enforced in Caboodle.
19.What is the relationship between slicerdicer and Caboodle? -
ANSWER slicerdicer is Epic's self service reporting tool in
Hyperspace that dynamically queries Caboodle data.
20.What is the surrogate key for medicationorderfact? - ANSWER
medicationorderkey
21.How are foreign keys documented in the Dictionary? - ANSWER
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.
, 22.True or False: A maximum of one foreign key can exist between two
tables in Caboodle. - ANSWER False. Multiple foreign keys can exist
between two tables in Caboodle.
23.How can medicationorderfact join to patientdim? - ANSWER
medicationorderfact.patientkey = patientdim.patientkey or
medicationorderfact.patientdurablekey = patientdim.patientdurablekey
24.In Caboodle, can Fact tables be joined to other fact tables? -
ANSWER Yes, example medicationorderfact can join to
encounterfact.
25.Which of the following would you expect to be stored in a dimension
table? - ANSWER Users and Diagnosis Definitions
26.Which of the following are possible to do in Caboodle? - ANSWER
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
27.True or False: Any change to Patient data in Clarity will generate a new
row in patientdim after the next extract. - ANSWER False, only
changes in type 2 data would result in a new row being generated.
28.True of false: The _Current view tables in the fullaccess schema contains
a subset of the rows contained in their corresponding type 2 tables. -
ANSWER True. _Current view tables in the Fullaccess schema
contain a subset of the rows contained in their corresponding type 2
tables.
MODEL FUNDAMENTALS
PRACTICE EXAM QUESTIONS
WITH CORRECT DETAILED
ANSWERS | ALREADY GRADED
A+<RECENT VERSION>
1. True or False: A caboodle report may contain at most 1 conformed
dimension? - ANSWER False. A Caboodle report can contain multiple
conformed dimensions.
2. Which of the following can be populated by more than one package? -
ANSWER A single table and a single row in a table.
3. When would a foreign key column in Caboodle contain a -1? -
ANSWER When the foreign key in the source data was null and a
value was expected.
4. Which tool(s) in the Caboodle console would be used most often by
Caboodle report writers? - ANSWER Dictionary and the Dictionary
editor.
,5. True or False: Caboodle and Clarity can be used interchangeably? -
ANSWER False. Caboodle and Clarity cannot be used
interchangeably.
6. Which of the following types of columns would you find in a type 1
table? - ANSWER Surrogate key, foreign key, and a combo key.
7. Where does Epic data in Caboodle come from? - ANSWER From
Clarity, which gets its data from Chronicles.
8. True or false: Only Epic can define SSIS packages to move data from
Clarity to Caboodle? - ANSWER False. Caboodle developers can also
SSIS packages to move data from Clarity to Caboodle.
9. Caboodle is designed to... - ANSWER Store Epic data, store non-Epic
data, make reporting easy, interoperate with slicerdicer.
10.Caboodle is considered a normalized database. - ANSWER False
11.Name three documentation resources for Caboodle resources. -
ANSWER Caboodle dictionary, Reporting with Caboodle document,
Caboodle ER diagram.
12.When writing reports, why is it better to use your organization's Caboodle
console rather than the console used in training? - ANSWER Because
the console can be highly customized for your organization.
13.What are the differences between a normalized and dimensional data
model? - ANSWER In a normalized data model, the focus is on not
repeating data. Ina dimensional data model, the focus us on ease of
reporting, and uses the star schema which focuses on a central fact table.
,14.True or False: A new version of Caboodle is released every month. -
ANSWER False, released every four to six months.
15.Explain the role of the Caboodle report writer. - ANSWER Queries
data that already exists in the database.
16.Explain the role of the Caboodle administrator. - ANSWER Uses the
Caboodle console to mange and monitor the ETL process.
17.Explain the Caboodle developer role. - ANSWER Designs custom
Data Model Components and SSIS packages to bring additional data into
the data warehouse.
18.True or False: Naming conventions are enforced in Caboodle. -
ANSWER True. Naming conventions are enforced in Caboodle.
19.What is the relationship between slicerdicer and Caboodle? -
ANSWER slicerdicer is Epic's self service reporting tool in
Hyperspace that dynamically queries Caboodle data.
20.What is the surrogate key for medicationorderfact? - ANSWER
medicationorderkey
21.How are foreign keys documented in the Dictionary? - ANSWER
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.
, 22.True or False: A maximum of one foreign key can exist between two
tables in Caboodle. - ANSWER False. Multiple foreign keys can exist
between two tables in Caboodle.
23.How can medicationorderfact join to patientdim? - ANSWER
medicationorderfact.patientkey = patientdim.patientkey or
medicationorderfact.patientdurablekey = patientdim.patientdurablekey
24.In Caboodle, can Fact tables be joined to other fact tables? -
ANSWER Yes, example medicationorderfact can join to
encounterfact.
25.Which of the following would you expect to be stored in a dimension
table? - ANSWER Users and Diagnosis Definitions
26.Which of the following are possible to do in Caboodle? - ANSWER
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
27.True or False: Any change to Patient data in Clarity will generate a new
row in patientdim after the next extract. - ANSWER False, only
changes in type 2 data would result in a new row being generated.
28.True of false: The _Current view tables in the fullaccess schema contains
a subset of the rows contained in their corresponding type 2 tables. -
ANSWER True. _Current view tables in the Fullaccess schema
contain a subset of the rows contained in their corresponding type 2
tables.
