CDW110 FINAL STUDY GUIDE 2026 SOLVED
QUESTIONS FULLY CORRECT
⫸ What is ETL? Answer: Extract, transform, & Load. Used for moving
data into a data warehouse.
⫸ What is Chronicles? Answer: Epic's production hierarchical database
which excels at operationalizing data but not reporting.
⫸ How many databases in Caboodle? Answer: (2) Staging & Reporting
⫸ Is moving data from Chronicles to Clarity more intense than Clarity
to Caboodle? Answer: The ETL process to Caboodle from Clarity is
more intense than the ETL process from Chronicles to Clarity.
⫸ Is all data in Clarity extracted to Caboodle Answer: No, not all data is
extracted.
⫸ What is dbo schema? Answer: data source for SlicerDicer and is
limited by the access rights of the user. To determine what schema use
SELECT SCHEMA_NAME() command in SQL.
⫸ What does the Data Dictionary content type filter do? Answer: When
you apply the Data Dictionary content type filter, only Clarity and
Caboodle database objects will display with Caboodle appearing first.
QUESTIONS FULLY CORRECT
⫸ What is ETL? Answer: Extract, transform, & Load. Used for moving
data into a data warehouse.
⫸ What is Chronicles? Answer: Epic's production hierarchical database
which excels at operationalizing data but not reporting.
⫸ How many databases in Caboodle? Answer: (2) Staging & Reporting
⫸ Is moving data from Chronicles to Clarity more intense than Clarity
to Caboodle? Answer: The ETL process to Caboodle from Clarity is
more intense than the ETL process from Chronicles to Clarity.
⫸ Is all data in Clarity extracted to Caboodle Answer: No, not all data is
extracted.
⫸ What is dbo schema? Answer: data source for SlicerDicer and is
limited by the access rights of the user. To determine what schema use
SELECT SCHEMA_NAME() command in SQL.
⫸ What does the Data Dictionary content type filter do? Answer: When
you apply the Data Dictionary content type filter, only Clarity and
Caboodle database objects will display with Caboodle appearing first.