CDW110 UPDATED ACTUAL Questions
and CORRECT Answers
What is Caboodle? - CORRECT ANSWER A data warehouse, designed to store Epic and
non-Epic data in a unified data model for efficient reporting
Caboodle staging database - CORRECT ANSWER Data is transformed, checked for
referential integrity, and cleaned
Caboodle reporting database - CORRECT ANSWER Comes from the staging database and
is used by caboodle report writers to write reports
SSIS Packages - CORRECT ANSWER 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 - CORRECT ANSWER True
Schema - CORRECT ANSWER A collection of database objects
dbo schema - CORRECT ANSWER Stores reporting data and acts as the data source for
SlicerDicer
FullAccess Schema - CORRECT ANSWER Everything for report writers from the dbo
schema and more
FilteredAccess Schema - CORRECT ANSWER Similar to FullAccess, but results are
filtered based on user security
, Which schema should be the default schema for reporting? - CORRECT
ANSWER FullAccess
How to see what schema is being used for reports? - CORRECT ANSWER SELECT
SCHEMA_NAME()
Which Cogito tools query from Caboodle? - CORRECT ANSWER Mainly SlicerDicer,
but also certain custom Radar metrics and Workbench templates
True or false: all tables and columns in Caboodle are written in PascalCase - CORRECT
ANSWER True
True or false: all key columns in Caboodle are surrogate keys - CORRECT
ANSWER True
Surrogate key - CORRECT ANSWER The column's value does not exist in the source
database and is created during the ETL process. This is necessary because Caboodle contains
both Epic and non-Epic data
Lookup column - CORRECT ANSWER A column in one table whose value identifies at
least one row in another table. Most tables in Caboodle have at least one
Compared to Fact tables, Dimension tables usually contain.. - CORRECT ANSWER More
data and fewer lookup columns
True or false: lookup columns end in -Key - CORRECT ANSWER True
Where to look for identifying information for validation in Caboodle? - CORRECT
ANSWER EpicId or EpicCsn columns
and CORRECT Answers
What is Caboodle? - CORRECT ANSWER A data warehouse, designed to store Epic and
non-Epic data in a unified data model for efficient reporting
Caboodle staging database - CORRECT ANSWER Data is transformed, checked for
referential integrity, and cleaned
Caboodle reporting database - CORRECT ANSWER Comes from the staging database and
is used by caboodle report writers to write reports
SSIS Packages - CORRECT ANSWER 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 - CORRECT ANSWER True
Schema - CORRECT ANSWER A collection of database objects
dbo schema - CORRECT ANSWER Stores reporting data and acts as the data source for
SlicerDicer
FullAccess Schema - CORRECT ANSWER Everything for report writers from the dbo
schema and more
FilteredAccess Schema - CORRECT ANSWER Similar to FullAccess, but results are
filtered based on user security
, Which schema should be the default schema for reporting? - CORRECT
ANSWER FullAccess
How to see what schema is being used for reports? - CORRECT ANSWER SELECT
SCHEMA_NAME()
Which Cogito tools query from Caboodle? - CORRECT ANSWER Mainly SlicerDicer,
but also certain custom Radar metrics and Workbench templates
True or false: all tables and columns in Caboodle are written in PascalCase - CORRECT
ANSWER True
True or false: all key columns in Caboodle are surrogate keys - CORRECT
ANSWER True
Surrogate key - CORRECT ANSWER The column's value does not exist in the source
database and is created during the ETL process. This is necessary because Caboodle contains
both Epic and non-Epic data
Lookup column - CORRECT ANSWER A column in one table whose value identifies at
least one row in another table. Most tables in Caboodle have at least one
Compared to Fact tables, Dimension tables usually contain.. - CORRECT ANSWER More
data and fewer lookup columns
True or false: lookup columns end in -Key - CORRECT ANSWER True
Where to look for identifying information for validation in Caboodle? - CORRECT
ANSWER EpicId or EpicCsn columns
