CDW 110V CABOODLE DATA MODEL
FUNDAMENTALS EXAM LATEST
UPDATED
, True or False: A caboodle report may contain at most 1 conformed dimension? -
ANSWERFalse. A Caboodle report can contain multiple conformed dimensions.
Which of the following can be populated by more than one package? - ANSWERA
single table and a single row in a table.
When would a foreign key column in Caboodle contain a -1? - ANSWERWhen the
foreign key in the source data was null and a value was expected.
Which tool(s) in the Caboodle console would be used most often by Caboodle report
writers? - ANSWERDictionary and the Dictionary editor.
True or False: Caboodle and Clarity can be used interchangeably? - ANSWERFalse.
Caboodle and Clarity cannot be used interchangeably.
Which of the following types of columns would you find in a type 1 table? -
ANSWERSurrogate key, foreign key, and a combo key.
Where does Epic data in Caboodle come from? - ANSWERFrom Clarity, which gets its
data from Chronicles.
True or false: Only Epic can define SSIS packages to move data from Clarity to
Caboodle? - ANSWERFalse. Caboodle developers can also SSIS packages to move
data from Clarity to Caboodle.
Caboodle is designed to... - ANSWERStore Epic data, store non-Epic data, make
reporting easy, interoperate with SlicerDicer.
Caboodle is considered a normalized database. - ANSWERFalse
Name three documentation resources for Caboodle resources. - ANSWERCaboodle
dictionary, Reporting with Caboodle document, Caboodle ER diagram.
When writing reports, why is it better to use your organization's Caboodle console rather
than the console used in training? - ANSWERBecause the console can be highly
customized for your organization.
What are the differences between a normalized and dimensional data model? -
ANSWERIn a normalized data model, the focus is on not repeating data. Ina
dimensional data model, the focus us on ease of reporting, and uses the star schema
which focuses on a central fact table.
FUNDAMENTALS EXAM LATEST
UPDATED
, True or False: A caboodle report may contain at most 1 conformed dimension? -
ANSWERFalse. A Caboodle report can contain multiple conformed dimensions.
Which of the following can be populated by more than one package? - ANSWERA
single table and a single row in a table.
When would a foreign key column in Caboodle contain a -1? - ANSWERWhen the
foreign key in the source data was null and a value was expected.
Which tool(s) in the Caboodle console would be used most often by Caboodle report
writers? - ANSWERDictionary and the Dictionary editor.
True or False: Caboodle and Clarity can be used interchangeably? - ANSWERFalse.
Caboodle and Clarity cannot be used interchangeably.
Which of the following types of columns would you find in a type 1 table? -
ANSWERSurrogate key, foreign key, and a combo key.
Where does Epic data in Caboodle come from? - ANSWERFrom Clarity, which gets its
data from Chronicles.
True or false: Only Epic can define SSIS packages to move data from Clarity to
Caboodle? - ANSWERFalse. Caboodle developers can also SSIS packages to move
data from Clarity to Caboodle.
Caboodle is designed to... - ANSWERStore Epic data, store non-Epic data, make
reporting easy, interoperate with SlicerDicer.
Caboodle is considered a normalized database. - ANSWERFalse
Name three documentation resources for Caboodle resources. - ANSWERCaboodle
dictionary, Reporting with Caboodle document, Caboodle ER diagram.
When writing reports, why is it better to use your organization's Caboodle console rather
than the console used in training? - ANSWERBecause the console can be highly
customized for your organization.
What are the differences between a normalized and dimensional data model? -
ANSWERIn a normalized data model, the focus is on not repeating data. Ina
dimensional data model, the focus us on ease of reporting, and uses the star schema
which focuses on a central fact table.
