CDW 300v Caboodle Fundamentals

Question 1

How does Caboodle differ from Clarity?

Answer 1

Caboodle is a dimensional data model, while Clarity is a normalized data model.

Caboodle ETL is generally more complex than Clarity ETL, but Caboodle queries are generally
simpler than Clarity queries.

Caboodle is a data warehouse and stores data from non‐Epic sources, Clarity can only get data from
Chronicles

Question 2

You create a new DMC called ItsAFactX in the Caboodle Console and add several columns to it, but do not click Apply Changes and Generate Script. Which of the following database objects have been affected by your actions? ﴾Circle all that apply.﴿
A. dbo.ItsAFactXImport
B. Config.TableEtls
C. Config.TableEtlColumns
D. Epic.ItsAFactX_IdLookup

Answer 2

B, C. Documenting a DMC in the Console updates the information about it in metadata tables, but
the DMC is not physically created until you click Apply Changes.

Question 2

What is the difference between the IdLookup table and the BusinessKeyLookup table?

Answer 2

Both the IdLookup table and the BusinessKeyLookup table show the surrogate key and the businesskey on a single row. The difference is that the IdLookup shows the IdType as a string, while the BusinessKeyLookup table shows the IdTypeId as a numeric representation of the IdType.

Question 3

Which of the following are valid ways to add a new column to an existing Caboodle DMC? ﴾Circle
all that apply.﴿
A.Click the +Column button in the Dictionary Editor.
B. Run an ALTER TABLE command in SQL.
C.EXECUTE the dbo.AddColumnToDmc stored procedure in SQL.
D.You can’t add columns to existing DMCs, only to new ones at the time of creation

Answer 3

A, C. In addition to adding columns in the Console, there is an API you can use to add columns. You
should never manually modify SQL tables.

Question 4

How does Caboodle protect your data when you delete columns from a DMC and when you
modify the data types of columns in a DMC?

Answer 4

Whenever a change is made to a column, such as deleting or modifying it, Caboodle stores the
original data in an _OLD column. The _OLD columns will persist on the database until someone manually removes them.

Question 5

Your organization might have more than one of these environments, which one:
A. Development
B. Test
C. Release
D. Production

Answer 5

Your organization might want multiple DEV environments; it would not make sense to have
multiples of any other type.

Question 6

True or False: All columns in Caboodle are updated at the time of ETL?

Answer 6

False, Post ETL columns are populated with stored procedures and are populated after ETL runs.

Question 7

You wish to modify a Caboodle‐generated script to rename a column without also generating an
_Old column that would then need to be dropped. Where should you add this code in the script?

A. At the very beginning of the script
B. At the very end of the script
C. In place of the PRE‐CONVERSION comment block
D. In place of the POST‐CONVERSION comment block
E. Nowhere, since you aren’t supposed to modify Caboodle‐generated scripts

Answer 7

C. If you simply renamed a column, you can rename it in a pre‐conversion to prevent the previous
column name from receiving the ‘_Old’ suffix.

Question 8

True or False: Each time you generate an install script it is automatically saved as a plain‐text file on the Caboodle server.

Answer 8

False. If you use Bulk Script Generation, files will be saved, but if you generate scripts individually,
you need to save them yourself if you wish to retain them.