CDW110 Questions With Complete Solutions
What is Caboodle? A data warehouse, designed to store Epic and non-Epic data in a
unified data model for efficient reporting
Caboodle staging database Data is transformed, checked for referential integrity, and
cleaned
Caboodle reporting database Comes from the staging database and is used by caboodle
report writers to write reports
SSIS Packages SQL Server Integration Services. The mechanism used to move data
during the caboodle ETL process
True or false: your organization can create custom SSIS packages to extract Clarity data or
additional data sets True
Schema A collection of database objects
dbo schema Stores reporting data and acts as the data source for SlicerDicer
, CDW110 Questions With Complete Solutions
FullAccess Schema Everything for report writers from the dbo schema and more
FilteredAccess Schema Similar to FullAccess, but results are filtered based on user
security
Which schema should be the default schema for reporting? FullAccess
How to see what schema is being used for reports? SELECT SCHEMA_NAME()
Which Cogito tools query from Caboodle? Mainly SlicerDicer, but also certain custom
Radar metrics and Workbench templates
True or false: all tables and columns in Caboodle are written in PascalCase True
True or false: all key columns in Caboodle are surrogate keys True
What is Caboodle? A data warehouse, designed to store Epic and non-Epic data in a
unified data model for efficient reporting
Caboodle staging database Data is transformed, checked for referential integrity, and
cleaned
Caboodle reporting database Comes from the staging database and is used by caboodle
report writers to write reports
SSIS Packages SQL Server Integration Services. The mechanism used to move data
during the caboodle ETL process
True or false: your organization can create custom SSIS packages to extract Clarity data or
additional data sets True
Schema A collection of database objects
dbo schema Stores reporting data and acts as the data source for SlicerDicer
, CDW110 Questions With Complete Solutions
FullAccess Schema Everything for report writers from the dbo schema and more
FilteredAccess Schema Similar to FullAccess, but results are filtered based on user
security
Which schema should be the default schema for reporting? FullAccess
How to see what schema is being used for reports? SELECT SCHEMA_NAME()
Which Cogito tools query from Caboodle? Mainly SlicerDicer, but also certain custom
Radar metrics and Workbench templates
True or false: all tables and columns in Caboodle are written in PascalCase True
True or false: all key columns in Caboodle are surrogate keys True
