CDW110 Exam Questions and Answers
100% Pass
(General Reporting Tips) If a query refers to more than one table, all
columns should be prefixed by a descriptor (table name or alias) -
[ANSWER]: Using descriptors ensures you have unambiguous column
references, preventing issues that can occur when two tables contain
columns with the same name.
QUESTION: Chapter 1. (Study Checklist) Caboodle Console -
[ANSWER]: The Caboodle Console is a web application housed on the
Caboodle server. It includes the following:
Dictionary
Dictionary Editor
Executions
Work Queue
,Configuration
QUESTION: Chapter 1. (Study Checklist) Data Warehouse -
[ANSWER]: In a data warehouse, multiple sources may load data
pertaining to a single entity. This means that more than one package may
populate a given row in a Caboodle table. As a result, there may be
multiple business key values associated with a single entity in a Caboodle
table.
QUESTION: Chapter 1. (Study Checklist) ETL -
[ANSWER]: Extract, Transform, Load
QUESTION: Chapter 1. (Study Checklist) SSIS Package -
[ANSWER]: The architecture of Caboodle includes a staging database
and a reporting database. Data is extracted from source systems (like
Clarity), transformed in the staging database, and presented for users in
,the reporting database. This movement of data is realized via a set of
SQL Server Integration Services (SSIS) packages.
QUESTION: Chapter 1. (Study Checklist) Data Lineage -
[ANSWER]: Generally, data lineage refers to the process of identifying
the source of a specific piece of information. In Caboodle, data lineage
is defined at the package level.
QUESTION: Chapter 1. (Study Checklist) Star Schema -
[ANSWER]: The standard schema for a dimensional data model. The
name refers to the image of a fact table surrounded by many linked
dimension tables, which loosely resembles a star.
The Caboodle data model structure is based on a "star schema" ‐ where
one central fact table will join to many associated lookup or dimension
tables. This structure provides the foundation of the Caboodle data
model.
, QUESTION: Chapter 1. (Study Checklist) DMC -
[ANSWER]: DATA MODEL COMPONENT
No table in Caboodle "stands alone." Each is considered part of a Data
Model Component, which refers to the collection of metadata tables
that support the ETL process and reporting views stored in the
FullAccess schema.
Each DMC gets a type. Strict table naming conventions are followed in
Caboodle, so that a table's suffix provides information about its
structure and purpose.
These suffixes are:
· Dim for dimensions (e.g. PatientDim)
· Fact for facts (e.g. EncounterFact)
· Bridge for bridges (e.g. DiagnosisBridge)
· DataMart for data marts (e.g. HospitalReadmissionDataMart)
· AttributeValueDim for EAV tables (e.g. PatientAttributeValueDim)
· X for custom tables (e.g. CustomFactX)
100% Pass
(General Reporting Tips) If a query refers to more than one table, all
columns should be prefixed by a descriptor (table name or alias) -
[ANSWER]: Using descriptors ensures you have unambiguous column
references, preventing issues that can occur when two tables contain
columns with the same name.
QUESTION: Chapter 1. (Study Checklist) Caboodle Console -
[ANSWER]: The Caboodle Console is a web application housed on the
Caboodle server. It includes the following:
Dictionary
Dictionary Editor
Executions
Work Queue
,Configuration
QUESTION: Chapter 1. (Study Checklist) Data Warehouse -
[ANSWER]: In a data warehouse, multiple sources may load data
pertaining to a single entity. This means that more than one package may
populate a given row in a Caboodle table. As a result, there may be
multiple business key values associated with a single entity in a Caboodle
table.
QUESTION: Chapter 1. (Study Checklist) ETL -
[ANSWER]: Extract, Transform, Load
QUESTION: Chapter 1. (Study Checklist) SSIS Package -
[ANSWER]: The architecture of Caboodle includes a staging database
and a reporting database. Data is extracted from source systems (like
Clarity), transformed in the staging database, and presented for users in
,the reporting database. This movement of data is realized via a set of
SQL Server Integration Services (SSIS) packages.
QUESTION: Chapter 1. (Study Checklist) Data Lineage -
[ANSWER]: Generally, data lineage refers to the process of identifying
the source of a specific piece of information. In Caboodle, data lineage
is defined at the package level.
QUESTION: Chapter 1. (Study Checklist) Star Schema -
[ANSWER]: The standard schema for a dimensional data model. The
name refers to the image of a fact table surrounded by many linked
dimension tables, which loosely resembles a star.
The Caboodle data model structure is based on a "star schema" ‐ where
one central fact table will join to many associated lookup or dimension
tables. This structure provides the foundation of the Caboodle data
model.
, QUESTION: Chapter 1. (Study Checklist) DMC -
[ANSWER]: DATA MODEL COMPONENT
No table in Caboodle "stands alone." Each is considered part of a Data
Model Component, which refers to the collection of metadata tables
that support the ETL process and reporting views stored in the
FullAccess schema.
Each DMC gets a type. Strict table naming conventions are followed in
Caboodle, so that a table's suffix provides information about its
structure and purpose.
These suffixes are:
· Dim for dimensions (e.g. PatientDim)
· Fact for facts (e.g. EncounterFact)
· Bridge for bridges (e.g. DiagnosisBridge)
· DataMart for data marts (e.g. HospitalReadmissionDataMart)
· AttributeValueDim for EAV tables (e.g. PatientAttributeValueDim)
· X for custom tables (e.g. CustomFactX)
