Caboodle: CDW110v Data Model
Fundamentals Questions And Answers
100% Verified.
Caboodle Console - correct answer.
Data Warehouse - correct answer.
ETL - correct answer.
Package - correct answer.
SSIS - correct answer.
Staging Database - correct answer.
Star Schema - correct answer.
Surrogate Key - correct answer.
How do you Identify key characteristics of the dimensional data model? - correct
answer.
How do you Identify the benefits of the dimensional data model? - correct answer.
How do you Identify reporting needs that best fit Caboodle? - correct answer.
Differentiate between Clarity and Caboodle. - correct answer.
Explain how data flows into Caboodle. - correct answer.
Explain the benefits of the dimensional data model. - correct answer.
, Explain the difference between a normalized data model and a dimensional data model.
- correct answer.
Explain where Caboodle fits among Epic's reporting tools. - correct answer.
Define Business Key - correct answer.
Define Data Lineage - correct answer.
Define Dictionary - correct answer.
Define Dimension Table - correct answer.
Define Durable Key - correct answer.
Define Fact Table - correct answer.
Define ID - correct answer.
Define IdType - correct answer.
How do you Navigate the Caboodle Console? - correct answer.
How do you look up the data lineage of a table? - correct answer.
How do you look up the data lineage of a column? - correct answer.
How do you identify Epic data in Caboodle? - correct answer.
How do you identify non-Epic data in Caboodle? - correct answer.
Explain who uses the Caboodle Console. - correct answer.
Explain how data is loaded into Caboodle. - correct answer.
T/F: All changes to the data extracted to PatientDim generate new rows. - correct
answer. False
Although PatientDim is a type 2, only certain columns in it are type 2. Changes to the
data stored in type 1 columns do not create new rows. Rather, the existing value is
overwritten across existing rows for a given entity.
T/F: In the FullAccess schema, joining to a type 2 table always returns the current
values for the entities in the views. - correct answer. False
The FullAccess views contain the historical information, just like the dbo tables do,
unless you join to the _Current views.
Fundamentals Questions And Answers
100% Verified.
Caboodle Console - correct answer.
Data Warehouse - correct answer.
ETL - correct answer.
Package - correct answer.
SSIS - correct answer.
Staging Database - correct answer.
Star Schema - correct answer.
Surrogate Key - correct answer.
How do you Identify key characteristics of the dimensional data model? - correct
answer.
How do you Identify the benefits of the dimensional data model? - correct answer.
How do you Identify reporting needs that best fit Caboodle? - correct answer.
Differentiate between Clarity and Caboodle. - correct answer.
Explain how data flows into Caboodle. - correct answer.
Explain the benefits of the dimensional data model. - correct answer.
, Explain the difference between a normalized data model and a dimensional data model.
- correct answer.
Explain where Caboodle fits among Epic's reporting tools. - correct answer.
Define Business Key - correct answer.
Define Data Lineage - correct answer.
Define Dictionary - correct answer.
Define Dimension Table - correct answer.
Define Durable Key - correct answer.
Define Fact Table - correct answer.
Define ID - correct answer.
Define IdType - correct answer.
How do you Navigate the Caboodle Console? - correct answer.
How do you look up the data lineage of a table? - correct answer.
How do you look up the data lineage of a column? - correct answer.
How do you identify Epic data in Caboodle? - correct answer.
How do you identify non-Epic data in Caboodle? - correct answer.
Explain who uses the Caboodle Console. - correct answer.
Explain how data is loaded into Caboodle. - correct answer.
T/F: All changes to the data extracted to PatientDim generate new rows. - correct
answer. False
Although PatientDim is a type 2, only certain columns in it are type 2. Changes to the
data stored in type 1 columns do not create new rows. Rather, the existing value is
overwritten across existing rows for a given entity.
T/F: In the FullAccess schema, joining to a type 2 table always returns the current
values for the entities in the views. - correct answer. False
The FullAccess views contain the historical information, just like the dbo tables do,
unless you join to the _Current views.
