PRACTICE EXAM-A ComboKey is used as a foregin key to which of the following
types of DMCs?
CHOOSE ONLY ONE ANSWER
Fact
Dimension
SetDim
DataMart
AttributeValueDim
Bridge
Give this one a try later!
, Bridge
Although it is the destination of the join, the combo key column of a bridge
table is not the primary key. Rather, multiple rows may have the same
combo key value.
PRACTICE EXAM-Table A has a foreign key to Table B. An execution runs, which
includes a package that loads data to Table A, but does not contain any packages
which will populate Table B. Which of the following tables could have an inferred row
added to it as a result of this execution?
CHOOSE ONLY ONE ANSWER
A. Only Table A
B. Only Table B
C. Both Table A and Table B
D. Neither Table A nor Table B
Give this one a try later!
B. Only Table B
Inferred rows are created in the table that is referenced by a foreign key's
value. When data is loaded into table A, it's foreign key is populated. If
Table B does not yet have that foreign key value, and inferred row is
created.
CHAPTER 1-What are the differences between a normalized and dimensional data
model?
Give this one a try later!
In a normalized data model, the focus is on not repeating data, which
reduces the size of the
database. In a dimensional data model, the focus is on ease of reporting
and uses the star schema, which focuses on a central fact table pertaining
to a reportable event and surrounding dimension tables providing context
, for the event.
CONTEXT...It gives CONTEXT
CHAPTER 1-How does Non-Epic data flow into Caboodle
Give this one a try later!
The Caboodle developer designs custom DMCs (Data Model
Components) and writes SSIS
packages to bring additional data into the warehouse. This may be
additional Epic data from Clarity or non‐Epic data from 3rd party sources.
OVERALL-Primary Key
Give this one a try later!
The Primary Key is the column(s) that can uniquely ID a row in a table.
OVERALL-NAME COVENTIONS IN CABOODLE
Give this one a try later!
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
CHAPTER 1-How does Epic data flow into Caboodle
Give this one a try later!
Epic data moves between several databases before it gets to Caboodle.
CHRONICLES flows into CLARITY via ETL. After transformation, the data is
stored in a relational database on a separate server. Even though the
structure of the Chronicles and Clarity databases differ significantly, the ETL
process preserves the relationships mapped in Chronicles.
CLARITY flows into Caboodle data is extracted
from 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.
CHAPTER 4-If a foreign key is null in Clarity, what will appear in the corresponding
column in Caboodle?
Give this one a try later!
If the foreign key was null in the source, then a ‐1 will appear in Caboodle
to represent an unspecified value. If the foreign key's data lineage was not
defined by the source package that loaded data for a particular row, then a
‐2 will appear in Caboodle to represent a value that is not applicable.
CHAPTER 1-ETL
Give this one a try later!
types of DMCs?
CHOOSE ONLY ONE ANSWER
Fact
Dimension
SetDim
DataMart
AttributeValueDim
Bridge
Give this one a try later!
, Bridge
Although it is the destination of the join, the combo key column of a bridge
table is not the primary key. Rather, multiple rows may have the same
combo key value.
PRACTICE EXAM-Table A has a foreign key to Table B. An execution runs, which
includes a package that loads data to Table A, but does not contain any packages
which will populate Table B. Which of the following tables could have an inferred row
added to it as a result of this execution?
CHOOSE ONLY ONE ANSWER
A. Only Table A
B. Only Table B
C. Both Table A and Table B
D. Neither Table A nor Table B
Give this one a try later!
B. Only Table B
Inferred rows are created in the table that is referenced by a foreign key's
value. When data is loaded into table A, it's foreign key is populated. If
Table B does not yet have that foreign key value, and inferred row is
created.
CHAPTER 1-What are the differences between a normalized and dimensional data
model?
Give this one a try later!
In a normalized data model, the focus is on not repeating data, which
reduces the size of the
database. In a dimensional data model, the focus is on ease of reporting
and uses the star schema, which focuses on a central fact table pertaining
to a reportable event and surrounding dimension tables providing context
, for the event.
CONTEXT...It gives CONTEXT
CHAPTER 1-How does Non-Epic data flow into Caboodle
Give this one a try later!
The Caboodle developer designs custom DMCs (Data Model
Components) and writes SSIS
packages to bring additional data into the warehouse. This may be
additional Epic data from Clarity or non‐Epic data from 3rd party sources.
OVERALL-Primary Key
Give this one a try later!
The Primary Key is the column(s) that can uniquely ID a row in a table.
OVERALL-NAME COVENTIONS IN CABOODLE
Give this one a try later!
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
CHAPTER 1-How does Epic data flow into Caboodle
Give this one a try later!
Epic data moves between several databases before it gets to Caboodle.
CHRONICLES flows into CLARITY via ETL. After transformation, the data is
stored in a relational database on a separate server. Even though the
structure of the Chronicles and Clarity databases differ significantly, the ETL
process preserves the relationships mapped in Chronicles.
CLARITY flows into Caboodle data is extracted
from 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.
CHAPTER 4-If a foreign key is null in Clarity, what will appear in the corresponding
column in Caboodle?
Give this one a try later!
If the foreign key was null in the source, then a ‐1 will appear in Caboodle
to represent an unspecified value. If the foreign key's data lineage was not
defined by the source package that loaded data for a particular row, then a
‐2 will appear in Caboodle to represent a value that is not applicable.
CHAPTER 1-ETL
Give this one a try later!
