CDW110 Exam Questions and Answers 100% Pass

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)