CDW 110 EXAM TEST PAPER QUESTIONS SOLUTIONS GRADED A PLUS
CDW 110 Actual EXAM Paper 2026/2027 Questions
and Answers Verified Solutions Latest Update
Question:
Caboodle staging database.
Answer:
Data is transformed, checked for referential integrity, and cleaned
Question:
Caboodle reporting database.
Answer:
Comes from the staging database and is used by caboodle report writers to write reports
Question:
SSIS Packages.
Answer:
SQL Server Integration Services. The mechanism used to move data during the caboodle ETL
process
Question:
True or false: your organization can create custom SSIS packages to extract Clarity data or
additional data sets.
Answer:
True
Question:
,Schema.
Answer:
A collection of database objects
Question:
dbo schema.
Answer:
Stores reporting data and acts as the data source for SlicerDicer
Question:
FullAccess Schema.
Answer:
Everything for report writers from the dbo schema and more
Question:
FilteredAccess Schema.
Answer:
Similar to FullAccess, but results are filtered based on user security
Question:
Which schema should be the default schema for reporting.
Answer:
FullAccess
Question:
How to see what schema is being used for reports.
, Answer:
SELECT SCHEMA_NAME()
Question:
Which Cogito tools query from Caboodle.
Answer:
Mainly SlicerDicer, but also certain custom Radar metrics and Workbench templates
Question:
True or false: all tables and columns in Caboodle are written in PascalCase.
Answer:
True
Question:
True or false: all key columns in Caboodle are surrogate keys.
Answer:
True
Question:
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
Question:
Lookup column.
Answer:
CDW 110 Actual EXAM Paper 2026/2027 Questions
and Answers Verified Solutions Latest Update
Question:
Caboodle staging database.
Answer:
Data is transformed, checked for referential integrity, and cleaned
Question:
Caboodle reporting database.
Answer:
Comes from the staging database and is used by caboodle report writers to write reports
Question:
SSIS Packages.
Answer:
SQL Server Integration Services. The mechanism used to move data during the caboodle ETL
process
Question:
True or false: your organization can create custom SSIS packages to extract Clarity data or
additional data sets.
Answer:
True
Question:
,Schema.
Answer:
A collection of database objects
Question:
dbo schema.
Answer:
Stores reporting data and acts as the data source for SlicerDicer
Question:
FullAccess Schema.
Answer:
Everything for report writers from the dbo schema and more
Question:
FilteredAccess Schema.
Answer:
Similar to FullAccess, but results are filtered based on user security
Question:
Which schema should be the default schema for reporting.
Answer:
FullAccess
Question:
How to see what schema is being used for reports.
, Answer:
SELECT SCHEMA_NAME()
Question:
Which Cogito tools query from Caboodle.
Answer:
Mainly SlicerDicer, but also certain custom Radar metrics and Workbench templates
Question:
True or false: all tables and columns in Caboodle are written in PascalCase.
Answer:
True
Question:
True or false: all key columns in Caboodle are surrogate keys.
Answer:
True
Question:
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
Question:
Lookup column.
Answer:
