CDW 110 Exam Set 2 Questions and Answers

CDW110 Exam Set 2 Questions and Answers with 100%
Correct Answers
Question 1.
(General Reporting Tips) If a query refers to more than one table, all columns should be
prefixed by a descriptor (table name or alias)
Correct Answer: Using descriptors ensures you have unambiguous column
references, preventing issues that can occur when two tables contain columns with
the same name.

Question 2.
Chapter 1. (Study Checklist) Caboodle Console
Correct Answer: The Caboodle Console is a web appli- cation housed on the
Caboodle server. It includes the following: Dictionary Dictionary Editor Executions
Work Queue Configuration

Question 3.
Chapter 1. (Study Checklist) Data Warehouse
Correct 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 asso-
ciated with a single entity in a Caboo- dle table.

Question 4.
Chapter 1. (Study Checklist) ETL
Correct Answer: Extract, Transform, Load

Question 5.
Chapter 1. (Study Checklist) SSIS Package
Correct Answer: The architecture of Caboodle includes a staging database and a
report- ing database. Data is extracted from source systems (like Clarity), trans-
formed in the staging database, and presented for users in the reporting database.
This movement of data is re- alized via a set of SQL Server Integra- tion Services
(SSIS) packages.

Question 6.
Chapter 1. (Study Checklist) Data Lineage
Correct Answer: Generally, data lineage refers to the process of identifying the
source of a specific piece of information. In Ca- boodle, data lineage is defined at
the package level.

,Question 7.
Chapter 1. (Study Checklist) Star Schema
Correct Answer: The standard schema for a dimension- al 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 as- sociated lookup
or dimension tables. This structure provides the foundation of the Caboodle data
model.

Question 8.
Chapter 1. (Study Checklist) DMC
Correct Answer: DATA MODEL COMPONENT No table in Caboodle "stands alone."
Each is considered part of a Data Mod- el Component, which refers to the col-
lection 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 pro- vides information about its
structure and purpose. These suffixes are: · Dim for dimensions (e.g. Patient- Dim) ·
Fact for facts (e.g. EncounterFact) · Bridge for bridges (e.g. Diagnosis- Bridge) ·
DataMart for data marts (e.g. Hospi- talReadmissionDataMart) · AttributeValueDim
for EAV tables (e.g. PatientAttributeValueDim) · X for custom tables (e.g.
CustomFac- tX)

Question 9.
Chapter 1. (Study Checklist) Staging Database
Correct Answer: The Caboodle database into which records are loaded by SSIS
packages and stored procedures.

Question 10.
Chapter 1. (Study Checklist) Reporting Data- base
Correct Answer: The architecture of Caboodle includes a staging database and a
report- ing database. Data is extracted from source systems (like Clarity), trans-
formed in the staging database, and presented for users in the reporting database.
This movement of data is re- alized via a set of SQL Server Integra- tion Services
(SSIS) packages.

Question 11.
Chapter 1. (Study Checklist) Dbo Schema
Correct Answer: STAGING DATABASE Import tables and Mapping tables live here.
This is primarily used by administrators for moving data into Caboodle.
REPORTING DATABASE The dbo schema stores reporting data and acts as the
data source for SlicerDicer. The Caboo- dle Dictionary reflects the contents of the
dbo schema.

, Question 12.
Chapter 1. (Study Checklist) FullAccess Schema
Correct Answer: STAGING DATABASE The FullAccess schema does not exist on
the Staging database. REPORTING DATABASE The FullAccess schema houses
views that simplify reporting. FullAccess should be your default schema when
reporting.

Question 13.
(ETL Terms) Execution
Correct Answer: An execution is the process that ex- tracts data from a source
system using packages, transforms the data in the staging database, and loads it to
Ca- boodle for reporting. You create and run executions in the Caboodle Con- sole.

Question 14.
(ETL Terms) Extract
Correct Answer: Extracts to Caboodle from Clarity can be either backfill or
incremental. Back- fill extracts load or reload every row in a table from Clarity,
whereas incremen- tal extracts load only changed rows. Existing data is available
while extracts are in progress.

Question 15.
(ETL Terms)package
Correct Answer: A package is a definition of an extract of data from one specific
source to a specific import table. For example, a fact might have packages for Epic
in- patient data, Epic outpatient data, and several non-Epic data sources. Pack-
ages are defined in SSIS .dtsx files.

Question 16.
Chapter 1. (Study Checklist) Identify key char- acteristics of the dimensional data model.
Correct Answer: MADE for report writers. · Simpler and more intuitive. · Easily
extensible. · More performant..

Question 17.
Chapter 1. (Study Checklist) Identify docu- mentation resources for reporting out of Ca-
boodle
Correct Answer: Caboodle Dictionary Reporting with Caboodle document Caboodle
ER diagram

Question 18.
Chapter 1. (Study Checklist) Identify reporting needs that best fit Caboodle
Correct Answer: Custom data packages can be writ- ten by Caboodle developers to
accom- modate your organization's reporting needs.