CDW 110 EXAM REVIEW 2025/2026
COMPREHENSIVE TEST BANK WITH 100%
CORRECT SOLUTIONS
◉Caboodle staging database Answer: Data is transformed, checked for
referential integrity, and cleaned
◉Caboodle reporting database Answer: Comes from the staging
database and is used by caboodle report writers to write reports
◉SSIS Packages 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 Answer: True
◉Schema Answer: A collection of database objects
◉dbo schema Answer: Stores reporting data and acts as the data source
for SlicerDicer
, ◉FullAccess Schema Answer: Everything for report writers from the
dbo schema and more
◉FilteredAccess Schema Answer: Similar to FullAccess, but results are
filtered based on user security
◉Which schema should be the default schema for reporting? Answer:
FullAccess
◉How to see what schema is being used for reports? Answer: SELECT
SCHEMA_NAME()
◉Which Cogito tools query from Caboodle? 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 Answer: True
◉True or false: all key columns in Caboodle are surrogate keys Answer:
True
◉Surrogate key 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
COMPREHENSIVE TEST BANK WITH 100%
CORRECT SOLUTIONS
◉Caboodle staging database Answer: Data is transformed, checked for
referential integrity, and cleaned
◉Caboodle reporting database Answer: Comes from the staging
database and is used by caboodle report writers to write reports
◉SSIS Packages 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 Answer: True
◉Schema Answer: A collection of database objects
◉dbo schema Answer: Stores reporting data and acts as the data source
for SlicerDicer
, ◉FullAccess Schema Answer: Everything for report writers from the
dbo schema and more
◉FilteredAccess Schema Answer: Similar to FullAccess, but results are
filtered based on user security
◉Which schema should be the default schema for reporting? Answer:
FullAccess
◉How to see what schema is being used for reports? Answer: SELECT
SCHEMA_NAME()
◉Which Cogito tools query from Caboodle? 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 Answer: True
◉True or false: all key columns in Caboodle are surrogate keys Answer:
True
◉Surrogate key 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
