CDW110v Caboodle Data Model Fundamentals Exam Questions & Answers.

CDW110v Caboodle Data Model
Fundamentals Exam Questions & Answers


Caboodle Dictionary - (CORRECT ANSWER)-Basic metadata for tables. Find Descriptions
b b b b b b b b b




b of tables and columns available in data model. Identify tables that can be linked together.
b b b b b b b b b b b b b b




Caboodle Dictionary Editor - (CORRECT ANSWER)-In depth view of Caboodle ETL
b b b b b b b b b b




b packages and data lineage. Shows Clarity tables data that extracted from when populating
b b b b b b b b b b b b




b tables, which ETL packages are used by Caboodle tables and dependencies amongst the
b b b b b b b b b b b b




b tables in Caboodle.
b b




Caboodle Executions - (CORRECT ANSWER)-Where Caboodle administrators can create,
b b b b b b b b




b edit, run and monitor executions. Can be used to schedule recurring executions.
b b b b b b b b b b b




Caboodle Workqueues - (CORRECT ANSWER)-Logs the different types of issues that can
b b b b b b b b b b b




b occur during the ETL process that require manual intervention to resolve.
b b b b b b b b b b




Caboodle configurations - (CORRECT ANSWER)-modify settings, perform customizations
b b b b b b b




b such as adding attributes to the data model and view reports related to Caboodle
b b b b b b b b b b b b b




b configuration and operation. b b




Caboodle BI Developers - (CORRECT ANSWER)-write Caboodle reports and should have
b b b b b b b b b b




b access to the Caboodle Dictionary on the Console. Dictionary provides table descriptions,
b b b b b b b b b b b




b data lineage for tables and columns and foreign key information. BI Developers should be
b b b b b b b b b b b b b

, b familiar with Caboodles dimensional data model and at least one area of healthcare
b b b b b b b b b b b b




b reportings such as revenue or clinical reporting.
b b b b b b




Caboodle Administrators - (CORRECT ANSWER)-have access to all activities on the
b b b b b b b b b b




b Caboodle Console. Administrators monitor executions, troubleshoot work queue errors
b b b b b b b b




b and establish system level configurations.
b b b b




Caboodle ETL Developers - (CORRECT ANSWER)-create custom EPIC and n on Epic
b b b b b b b b b b b




b content for extraction into the data warehouse, document their work in the dictionary
b b b b b b b b b b b b




b editor and test their work using the ETL tools available in the console. Custom
b b b b b b b b b b b b b




b development notes and documentation relevant to report writers will be visible in the
b b b b b b b b b b b b




b dictionary.


Why use Caboodle - (CORRECT ANSWER)-Accessibility, Efficiency and fewer tables and
b b b b b b b b b b




b simpler joins. b




SSIS package - (CORRECT ANSWER)-SQL Server Integration packages : Data is extracted
b b b b b b b b b b b




b from source systems (Clarity) transformed in the staging database and presented for
b b b b b b b b b b b




b users in the reporting database.
b b b b




DMCs - (CORRECT ANSWER)-Data Model Components
b b b b b




Data Model Compenents - (CORRECT ANSWER)-collection of metadata tables that support
b b b b b b b b b b




b the ETL process and reporting views stored in the FullAccess schema.
b b b b b b b b b b




DMC type and suffixes - (CORRECT ANSWER)-Each DMC gets a type and suffix. Dim for
b b b b b b b b b b b b b b




b dimensions, Fact for facts, Bridge for bridges, Datamart for data marts, AttributeValueDim
b b b b b b b b b b b




b for EAV tables, X for custom tables
b b b b b b




Caboodle Star Schema - (CORRECT ANSWER)-where one central fact table will join to
b b b b b b b b b b b b




b many associated lookup or dimension tables.
b b b b b