CDW 110v Caboodle Data Model
Fundamentals
Leave the first rating
Save
Students also studied
Flashcard sets Study guides
Operating Systems Exam 2 PSTAT 10 FINAL WGU C175/D426 DATA MANAGEME... EECS 18
Teacher 201 terms Teacher 112 terms Teacher 348 terms Teacher
ewatuka0 Preview Ramonamaia25 Preview Nicholas_Muriithi Preview Kith
Terms in this set (170) Hide definitions
True or False: A caboodle report may contain at most 1 False. A Caboodle report can contain multiple conformed dimensions.
conformed dimension?
Which of the following can be populated by more than A single table and a single row in a table.
one package?
When would a foreign key column in Caboodle contain a When the foreign key in the source data was null and a value was expected.
-1?
Which tool(s) in the Caboodle console would be used Dictionary and the Dictionary editor.
most often by Caboodle report writers?
True or False: Caboodle and Clarity can be used False. Caboodle and Clarity cannot be used interchangeably.
interchangeably?
Which of the following types of columns would you find Surrogate key, foreign key, and a combo key.
in a type 1 table?
, Where does Epic data in Caboodle come from? From Clarity, which gets its data from Chronicles.
True or false: Only Epic can define SSIS packages to False. Caboodle developers can also SSIS packages to move data from Clarity to
move data from Clarity to Caboodle? Caboodle.
Caboodle is designed to... Store Epic data, store non-Epic data, make reporting easy, interoperate with
SlicerDicer.
Caboodle is considered a normalized database. False
Name three documentation resources for Caboodle Caboodle dictionary, Reporting with Caboodle document, Caboodle ER diagram.
resources.
When writing reports, why is it better to use your Because the console can be highly customized for your organization.
organization's Caboodle console rather than the console
used in training?
What are the differences between a normalized and In a normalized data model, the focus is on not repeating data. Ina dimensional
dimensional data model? data model, the focus us on ease of reporting, and uses the star schema which
focuses on a central fact table.
True or False: A new version of Caboodle is released False, released every four to six months.
every month.
Explain the role of the Caboodle report writer. Queries data that already exists in the database.
Explain the role of the Caboodle administrator. Uses the Caboodle console to mange and monitor the ETL process.
Explain the Caboodle developer role. Designs custom Data Model Components and SSIS packages to bring additional
data into the data warehouse.
True or False: Naming conventions are enforced in True. Naming conventions are enforced in Caboodle.
Caboodle.
What is the relationship between SlicerDicer and SlicerDicer is Epic's self service reporting tool in Hyperspace that dynamically
Caboodle? 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.
Fundamentals
Leave the first rating
Save
Students also studied
Flashcard sets Study guides
Operating Systems Exam 2 PSTAT 10 FINAL WGU C175/D426 DATA MANAGEME... EECS 18
Teacher 201 terms Teacher 112 terms Teacher 348 terms Teacher
ewatuka0 Preview Ramonamaia25 Preview Nicholas_Muriithi Preview Kith
Terms in this set (170) Hide definitions
True or False: A caboodle report may contain at most 1 False. A Caboodle report can contain multiple conformed dimensions.
conformed dimension?
Which of the following can be populated by more than A single table and a single row in a table.
one package?
When would a foreign key column in Caboodle contain a When the foreign key in the source data was null and a value was expected.
-1?
Which tool(s) in the Caboodle console would be used Dictionary and the Dictionary editor.
most often by Caboodle report writers?
True or False: Caboodle and Clarity can be used False. Caboodle and Clarity cannot be used interchangeably.
interchangeably?
Which of the following types of columns would you find Surrogate key, foreign key, and a combo key.
in a type 1 table?
, Where does Epic data in Caboodle come from? From Clarity, which gets its data from Chronicles.
True or false: Only Epic can define SSIS packages to False. Caboodle developers can also SSIS packages to move data from Clarity to
move data from Clarity to Caboodle? Caboodle.
Caboodle is designed to... Store Epic data, store non-Epic data, make reporting easy, interoperate with
SlicerDicer.
Caboodle is considered a normalized database. False
Name three documentation resources for Caboodle Caboodle dictionary, Reporting with Caboodle document, Caboodle ER diagram.
resources.
When writing reports, why is it better to use your Because the console can be highly customized for your organization.
organization's Caboodle console rather than the console
used in training?
What are the differences between a normalized and In a normalized data model, the focus is on not repeating data. Ina dimensional
dimensional data model? data model, the focus us on ease of reporting, and uses the star schema which
focuses on a central fact table.
True or False: A new version of Caboodle is released False, released every four to six months.
every month.
Explain the role of the Caboodle report writer. Queries data that already exists in the database.
Explain the role of the Caboodle administrator. Uses the Caboodle console to mange and monitor the ETL process.
Explain the Caboodle developer role. Designs custom Data Model Components and SSIS packages to bring additional
data into the data warehouse.
True or False: Naming conventions are enforced in True. Naming conventions are enforced in Caboodle.
Caboodle.
What is the relationship between SlicerDicer and SlicerDicer is Epic's self service reporting tool in Hyperspace that dynamically
Caboodle? 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.
