CDW110 EXAM/CDW110 EXAM PREPARATION/CDW110 PRACTICE
EXAM ACTUAL EXAM 200 QUESTIONS AND CORRECT DETAILED
ANSWERS
| A+ GRADE ASSURED
Question 1
Which of the following best describes Caboodle?
A) A transactional database for real-time patient care.
B) A web application for clinical documentation.
C) A data warehouse designed to store Epic and non-Epic data in a unified
model for reporting.
D) A tool for direct data entry into source systems like Clarity.
E) A platform primarily for creating custom Epic reports using Chronicles.
Correct Answer: C) A data warehouse designed to store Epic and non-
Epic data in a unified model for reporting.
Rationale: Caboodle is specifically designed as a data warehouse to
integrate data from various sources, including Epic and external
systems, into a single model optimized for reporting and analysis.
Question 2
The Caboodle Console is a web application housed on the Caboodle server.
Which of the following components is NOT typically included in the Caboodle
Console?
A) Dictionary
B) Dictionary Editor
C) Executions
D) Work Queue
E) Chronicles Report Writer
Correct Answer: E) Chronicles Report Writer
Rationale: The Caboodle Console includes the Dictionary, Dictionary
Editor, Executions, Work Queue, and Configuration. Chronicles
Report Writer is a separate Epic reporting tool, not part of the Cab
Caboodle Console.
Question 3
In a data warehouse like Caboodle, what is a key characteristic regarding
data loading for a single entity?
A) Only one source system can load data for a given entity.
B) Multiple packages may populate a given row in a Caboodle table.
C) Data is always loaded directly from the source to the reporting database.
D) Business key values are always unique across all source systems.
E) Data is only refreshed once a week to ensure data integrity.
Correct Answer: B) Multiple packages may populate a given row in a
Caboodle table.
,Rationale: A characteristic of a data warehouse is that multiple
sources may load data pertaining to a single entity, meaning more
than one package may populate a given row in a Caboodle table.
This can result in multiple business key values associated with a
single entity.
Question 4
What does the acronym ETL stand for in the context of data warehousing?
A) Extract, Test, Load
B) Enter, Transform, Link
C) Extract, Transform, Load
D) Encode, Transmit, Learn
E) Evaluate, Test, Load
Correct Answer: C) Extract, Transform, Load
Rationale: ETL stands for Extract, Transform, Load. This process
involves extracting data from source systems, transforming it into a
format suitable for the data warehouse, and then loading it into the
data warehouse tables.
Question 5
Data movement within Caboodle, from source systems to the staging and
then to the reporting database, is primarily realized via a set of what?
A) SQL Server Reporting Services (SSRS) reports
B) SQL Server Integration Services (SSIS) packages
C) SQL Server Analysis Services (SSAS) cubes
D) Epic Chronicles export utilities
E) Custom SQL scripts run manually
Correct Answer: B) SQL Server Integration Services (SSIS) packages
Rationale: The architecture of Caboodle includes a staging database
and a reporting database. Data movement between these stages,
and from source systems, is primarily managed through SQL Server
Integration Services (SSIS) packages.
Question 6
How is data lineage generally defined in Caboodle?
A) At the individual column level.
B) At the table level.
C) At the SSIS package level.
D) At the database schema level.
E) At the individual row level.
Correct Answer: C) At the SSIS package level.
,Rationale: In Caboodle, data lineage, which identifies the source of a
specific piece of information, is defined at the package level.
Question 7
The Caboodle data model structure is based on which standard schema for a
dimensional data model?
A) Snowflake schema
B) Star schema
C) Relational schema
D) Hierarchical schema
E) Network schema
Correct Answer: B) Star schema
Rationale: The Caboodle data model structure is based on a "star
schema," which features a central fact table surrounded by many
linked dimension tables. This structure is designed for ease of
reporting.
Question 8
Which of the following is a key characteristic of a dimensional data model, as
used in Caboodle?
A) Highly normalized tables with complex joins.
B) Focus on real-time transactional processing.
C) Simpler and more intuitive for report writers.
D) Primarily uses surrogate keys that are meaningful to end-users.
E) Designed for frequent data updates rather than historical analysis.
Correct Answer: C) Simpler and more intuitive for report writers.
Rationale: Dimensional data models, like the star schema used in
Caboodle, are characterized by being simpler and more intuitive,
making them "MADE for report writers" by providing a more user-
friendly structure for querying.
Question 9
What is the purpose of the dbo schema on the Caboodle staging database?
A) It stores the final reporting data for end-users.
B) It houses views that simplify reporting.
C) Import tables and Mapping tables primarily reside here.
D) It is the default schema recommended for report writers.
E) It contains only historical, non-current data.
Correct Answer: C) Import tables and Mapping tables primarily reside
here.
Rationale: On the Caboodle staging database, the dbo schema is
, where import tables and mapping tables typically reside. The
reporting data for end-users is in the dbo schema of the reporting
database.
Question 10
Which schema is recommended as the default schema for report writing in
Caboodle because it houses views that simplify reporting?
A) dbo schema on the staging database.
B) FullAccess schema on the reporting database.
C) Epic schema on either database.
D) dbo schema on the reporting database.
E) Staging schema.
Correct Answer: B) FullAccess schema on the reporting database.
Rationale: The FullAccess schema on the reporting database is
explicitly recommended as the default schema for report writing
because it contains views that are designed to simplify reporting by
abstracting complexities.
Question 11
What is a surrogate key in Caboodle?
A) A unique identifier from the source system.
B) A system-generated identifier that serves as the primary key for fact and
dimension tables.
C) A business key that is inherently meaningful to report consumers.
D) A key that changes frequently to track historical data.
E) A natural key derived directly from operational data.
Correct Answer: B) A system-generated identifier that serves as the
primary key for fact and dimension tables.
Rationale: A surrogate key is a system-generated identifier in
Caboodle, used as the primary key for all fact and dimension tables.
It is not inherently meaningful to report consumers and is created
during the ETL process.[4]
Question 12
What is another name for a source identifier in Caboodle, which consists of
two columns (IdType and Id)?
A) Surrogate key
B) Foreign key
C) Durable key
D) Business key
E) Primary key
EXAM ACTUAL EXAM 200 QUESTIONS AND CORRECT DETAILED
ANSWERS
| A+ GRADE ASSURED
Question 1
Which of the following best describes Caboodle?
A) A transactional database for real-time patient care.
B) A web application for clinical documentation.
C) A data warehouse designed to store Epic and non-Epic data in a unified
model for reporting.
D) A tool for direct data entry into source systems like Clarity.
E) A platform primarily for creating custom Epic reports using Chronicles.
Correct Answer: C) A data warehouse designed to store Epic and non-
Epic data in a unified model for reporting.
Rationale: Caboodle is specifically designed as a data warehouse to
integrate data from various sources, including Epic and external
systems, into a single model optimized for reporting and analysis.
Question 2
The Caboodle Console is a web application housed on the Caboodle server.
Which of the following components is NOT typically included in the Caboodle
Console?
A) Dictionary
B) Dictionary Editor
C) Executions
D) Work Queue
E) Chronicles Report Writer
Correct Answer: E) Chronicles Report Writer
Rationale: The Caboodle Console includes the Dictionary, Dictionary
Editor, Executions, Work Queue, and Configuration. Chronicles
Report Writer is a separate Epic reporting tool, not part of the Cab
Caboodle Console.
Question 3
In a data warehouse like Caboodle, what is a key characteristic regarding
data loading for a single entity?
A) Only one source system can load data for a given entity.
B) Multiple packages may populate a given row in a Caboodle table.
C) Data is always loaded directly from the source to the reporting database.
D) Business key values are always unique across all source systems.
E) Data is only refreshed once a week to ensure data integrity.
Correct Answer: B) Multiple packages may populate a given row in a
Caboodle table.
,Rationale: A characteristic of a data warehouse is that multiple
sources may load data pertaining to a single entity, meaning more
than one package may populate a given row in a Caboodle table.
This can result in multiple business key values associated with a
single entity.
Question 4
What does the acronym ETL stand for in the context of data warehousing?
A) Extract, Test, Load
B) Enter, Transform, Link
C) Extract, Transform, Load
D) Encode, Transmit, Learn
E) Evaluate, Test, Load
Correct Answer: C) Extract, Transform, Load
Rationale: ETL stands for Extract, Transform, Load. This process
involves extracting data from source systems, transforming it into a
format suitable for the data warehouse, and then loading it into the
data warehouse tables.
Question 5
Data movement within Caboodle, from source systems to the staging and
then to the reporting database, is primarily realized via a set of what?
A) SQL Server Reporting Services (SSRS) reports
B) SQL Server Integration Services (SSIS) packages
C) SQL Server Analysis Services (SSAS) cubes
D) Epic Chronicles export utilities
E) Custom SQL scripts run manually
Correct Answer: B) SQL Server Integration Services (SSIS) packages
Rationale: The architecture of Caboodle includes a staging database
and a reporting database. Data movement between these stages,
and from source systems, is primarily managed through SQL Server
Integration Services (SSIS) packages.
Question 6
How is data lineage generally defined in Caboodle?
A) At the individual column level.
B) At the table level.
C) At the SSIS package level.
D) At the database schema level.
E) At the individual row level.
Correct Answer: C) At the SSIS package level.
,Rationale: In Caboodle, data lineage, which identifies the source of a
specific piece of information, is defined at the package level.
Question 7
The Caboodle data model structure is based on which standard schema for a
dimensional data model?
A) Snowflake schema
B) Star schema
C) Relational schema
D) Hierarchical schema
E) Network schema
Correct Answer: B) Star schema
Rationale: The Caboodle data model structure is based on a "star
schema," which features a central fact table surrounded by many
linked dimension tables. This structure is designed for ease of
reporting.
Question 8
Which of the following is a key characteristic of a dimensional data model, as
used in Caboodle?
A) Highly normalized tables with complex joins.
B) Focus on real-time transactional processing.
C) Simpler and more intuitive for report writers.
D) Primarily uses surrogate keys that are meaningful to end-users.
E) Designed for frequent data updates rather than historical analysis.
Correct Answer: C) Simpler and more intuitive for report writers.
Rationale: Dimensional data models, like the star schema used in
Caboodle, are characterized by being simpler and more intuitive,
making them "MADE for report writers" by providing a more user-
friendly structure for querying.
Question 9
What is the purpose of the dbo schema on the Caboodle staging database?
A) It stores the final reporting data for end-users.
B) It houses views that simplify reporting.
C) Import tables and Mapping tables primarily reside here.
D) It is the default schema recommended for report writers.
E) It contains only historical, non-current data.
Correct Answer: C) Import tables and Mapping tables primarily reside
here.
Rationale: On the Caboodle staging database, the dbo schema is
, where import tables and mapping tables typically reside. The
reporting data for end-users is in the dbo schema of the reporting
database.
Question 10
Which schema is recommended as the default schema for report writing in
Caboodle because it houses views that simplify reporting?
A) dbo schema on the staging database.
B) FullAccess schema on the reporting database.
C) Epic schema on either database.
D) dbo schema on the reporting database.
E) Staging schema.
Correct Answer: B) FullAccess schema on the reporting database.
Rationale: The FullAccess schema on the reporting database is
explicitly recommended as the default schema for report writing
because it contains views that are designed to simplify reporting by
abstracting complexities.
Question 11
What is a surrogate key in Caboodle?
A) A unique identifier from the source system.
B) A system-generated identifier that serves as the primary key for fact and
dimension tables.
C) A business key that is inherently meaningful to report consumers.
D) A key that changes frequently to track historical data.
E) A natural key derived directly from operational data.
Correct Answer: B) A system-generated identifier that serves as the
primary key for fact and dimension tables.
Rationale: A surrogate key is a system-generated identifier in
Caboodle, used as the primary key for all fact and dimension tables.
It is not inherently meaningful to report consumers and is created
during the ETL process.[4]
Question 12
What is another name for a source identifier in Caboodle, which consists of
two columns (IdType and Id)?
A) Surrogate key
B) Foreign key
C) Durable key
D) Business key
E) Primary key
