CDW110 ACTUAL TEST QUESTIONS WITH
COMPLETE SOLUTION VERIFIED
RESOURCE
●● Caboodle Dictionary Editor
Answer: In depth view of Caboodle ETL packages and data lineage.
Shows Clarity tables data that extracted from when populating tables,
which ETL packages are used by Caboodle tables and dependencies
amongst the tables in Caboodle.
●● Caboodle Executions
Answer: Where Caboodle administrators can create, edit, run and
monitor executions. Can be used to schedule recurring executions.
●● Caboodle Workqueues
Answer: Logs the different types of issues that can occur during the ETL
process that require manual intervention to resolve.
●● Caboodle configurations
Answer: modify settings, perform customizations such as adding
attributes to the data model and view reports related to Caboodle
configuration and operation.
, ●● Caboodle BI Developers
Answer: write Caboodle reports and should have access to the Caboodle
Dictionary on the Console. Dictionary provides table descriptions, data
lineage for tables and columns and foreign key information. BI
Developers should be familiar with Caboodles dimensional data model
and at least one area of healthcare reportings such as revenue or clinical
reporting.
●● Caboodle Administrators
Answer: have access to all activities on the Caboodle Console.
Administrators monitor executions, troubleshoot work queue errors and
establish system level configurations.
●● Caboodle ETL Developers
Answer: create custom EPIC and n on Epic content for extraction into
the data warehouse, document their work in the dictionary editor and test
their work using the ETL tools available in the console. Custom
development notes and documentation relevant to report writers will be
visible in the dictionary.
●● Why use Caboodle
Answer: Accessibility, Efficiency and fewer tables and simpler joins.
●● SSIS package
COMPLETE SOLUTION VERIFIED
RESOURCE
●● Caboodle Dictionary Editor
Answer: In depth view of Caboodle ETL packages and data lineage.
Shows Clarity tables data that extracted from when populating tables,
which ETL packages are used by Caboodle tables and dependencies
amongst the tables in Caboodle.
●● Caboodle Executions
Answer: Where Caboodle administrators can create, edit, run and
monitor executions. Can be used to schedule recurring executions.
●● Caboodle Workqueues
Answer: Logs the different types of issues that can occur during the ETL
process that require manual intervention to resolve.
●● Caboodle configurations
Answer: modify settings, perform customizations such as adding
attributes to the data model and view reports related to Caboodle
configuration and operation.
, ●● Caboodle BI Developers
Answer: write Caboodle reports and should have access to the Caboodle
Dictionary on the Console. Dictionary provides table descriptions, data
lineage for tables and columns and foreign key information. BI
Developers should be familiar with Caboodles dimensional data model
and at least one area of healthcare reportings such as revenue or clinical
reporting.
●● Caboodle Administrators
Answer: have access to all activities on the Caboodle Console.
Administrators monitor executions, troubleshoot work queue errors and
establish system level configurations.
●● Caboodle ETL Developers
Answer: create custom EPIC and n on Epic content for extraction into
the data warehouse, document their work in the dictionary editor and test
their work using the ETL tools available in the console. Custom
development notes and documentation relevant to report writers will be
visible in the dictionary.
●● Why use Caboodle
Answer: Accessibility, Efficiency and fewer tables and simpler joins.
●● SSIS package
