CDW110 EXAM ACTUAL EXAM QUESTIONS AND CORRECT
CDW110
DETAILED ANSWERS/ GET IT RIGHT | 100% SOLUTIONS
Study online at https://quizlet.com/_hbuujc
1. What is Caboodle? A data warehouse, designed to store Epic and non-Epic data in
a unified data model for efficient reporting
2. Caboodle staging database Data is transformed, checked for referential integrity, and
cleaned
3. Caboodle reporting database Comes from the staging database and is used by caboodle
report writers to write reports
4. SSIS Packages SQL Server Integration Services. The mechanism used to move
data during the caboodle ETL process
5. True or false: your organiza- True
tion can create custom SSIS
packages to extract Clarity
data or additional data sets
6. Schema A collection of database objects
7. dbo schema Stores reporting data and acts as the data source for SlicerDicer
8. FullAccess Schema Everything for report writers from the dbo schema and more
9. FilteredAccess Schema Similar to FullAccess, but results are filtered based on user
security
10. Which schema should be the FullAccess
default schema for reporting?
11. How to see what schema is be- SELECT SCHEMA_NAME()
ing used for reports?
12. Which Cogito tools query Mainly SlicerDicer, but also certain custom Radar metrics and
from Caboodle? Workbench templates
1/9
, CDW110
Study online at https://quizlet.com/_hbuujc
13. True or false: all tables and True
columns in Caboodle are writ-
ten in PascalCase
14. True or false: all key columns True
in Caboodle are surrogate
keys
15. Surrogate key 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
16. Lookup column A column in one table whose value identifies at least one row in
another table. Most tables in Caboodle have at least one
17. Compared to Fact tables, Di- More data and fewer lookup columns
mension tables usually con-
tain..
18. True or false: lookup columns True
end in -Key
19. Where to look for identifying EpicId or EpicCsn columns
information for validation in
Caboodle?
20. DMC Data Model Component. Consists of the table, the packages
used to populate the table, and underlying metadata tables that
assist with ETL
21. Dimension tables One row for each entity within the set. Examples are
ProviderDim, PatientDim
22. Fact tables
2/9
CDW110
DETAILED ANSWERS/ GET IT RIGHT | 100% SOLUTIONS
Study online at https://quizlet.com/_hbuujc
1. What is Caboodle? A data warehouse, designed to store Epic and non-Epic data in
a unified data model for efficient reporting
2. Caboodle staging database Data is transformed, checked for referential integrity, and
cleaned
3. Caboodle reporting database Comes from the staging database and is used by caboodle
report writers to write reports
4. SSIS Packages SQL Server Integration Services. The mechanism used to move
data during the caboodle ETL process
5. True or false: your organiza- True
tion can create custom SSIS
packages to extract Clarity
data or additional data sets
6. Schema A collection of database objects
7. dbo schema Stores reporting data and acts as the data source for SlicerDicer
8. FullAccess Schema Everything for report writers from the dbo schema and more
9. FilteredAccess Schema Similar to FullAccess, but results are filtered based on user
security
10. Which schema should be the FullAccess
default schema for reporting?
11. How to see what schema is be- SELECT SCHEMA_NAME()
ing used for reports?
12. Which Cogito tools query Mainly SlicerDicer, but also certain custom Radar metrics and
from Caboodle? Workbench templates
1/9
, CDW110
Study online at https://quizlet.com/_hbuujc
13. True or false: all tables and True
columns in Caboodle are writ-
ten in PascalCase
14. True or false: all key columns True
in Caboodle are surrogate
keys
15. Surrogate key 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
16. Lookup column A column in one table whose value identifies at least one row in
another table. Most tables in Caboodle have at least one
17. Compared to Fact tables, Di- More data and fewer lookup columns
mension tables usually con-
tain..
18. True or false: lookup columns True
end in -Key
19. Where to look for identifying EpicId or EpicCsn columns
information for validation in
Caboodle?
20. DMC Data Model Component. Consists of the table, the packages
used to populate the table, and underlying metadata tables that
assist with ETL
21. Dimension tables One row for each entity within the set. Examples are
ProviderDim, PatientDim
22. Fact tables
2/9
