CDW 110V 2024 UPDATE
COMPREHENSIVE QUESTIONS AND VERIFIED
ANSWERS [MOST TESTED QUESTIONS] CERTIFIED
STUDY RESOURCES/COMPLETE GUIDE
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)
,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)
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.
Type 1 Data - (correct answer)
Type 2 Data - (correct answer)
"_Current" View - (correct answer)
COMPREHENSIVE QUESTIONS AND VERIFIED
ANSWERS [MOST TESTED QUESTIONS] CERTIFIED
STUDY RESOURCES/COMPLETE GUIDE
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)
,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)
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.
Type 1 Data - (correct answer)
Type 2 Data - (correct answer)
"_Current" View - (correct answer)
