CDW110v Caboodle Data Model Fundamentals 2024
Exam Questions and Marking Scheme
A column in Caboodle does not contain the data you expect to see. To determine
if the issue is within the source data or the ETL process, you want to investigate
the Clarity data. How can you determine which Clarity column is used to populate
the Caboodle column? Ans✓✓✓ Investigate the data lineage for the column
using the Cogito Dictionary.
A lookup column in Caboodle contains the value -3. What could this mean?
Ans✓✓✓ There are two possibilities: Either the data that once populated this
row in Caboodle has been deleted from the source or this is the row with -3 as its
primary key, for which all lookup columns are also -3. To know which is true,
check the primary key value for the given row: a non-negative value indicates that
this row represents deleted data in the source.
A row in a Caboodle table has a primary key value of -2. What value will be stored
in columns with a data type of "Date" for this row that are not lookup columns?
A. -2
B. NULL
C. 12/31/1840
D. *Not Applicable Ans✓✓✓ b. NULL, For the row with a primary key of -2,
lookup columns will store a value of -2, string columns will store '*Not Applicable',
and all other data type columns will store NULL.
Consider the following query:
SELECT DurableKey FROM <TableName>
, Which of the following statements are true?
A. This query will only run if <TableName> is a snapshot table
B. This query will run regardless of whether <TableName> has change tracking
C. The value in the DurableKey column could repeat in multiple rows of the results
D. There is no table in Caboodle for which this query will run Ans✓✓✓ A. This
query will only run if <TableName> is a snapshot table, and C. The value in the
DurableKey column could repeat in multiple rows of the results
Explain the relationship between the dbo and FullAccess schemas. Ans✓✓✓ The
Cogito Dictionary reflects the dbo schema. The FullAccess schema contains almost
everything in the dbo schema (minus a few metadata columns) plus additional
columns in some tables. Since FullAccess has more data, report writers should use
it when writing queries. However, report writers should also be familiar with dbo
due to its relationship with the Cogito Dictionary.
How does data get into Caboodle? Ans✓✓✓ Data gets into Caboodle through
SSIS packages from Clarity or a 3rd party database.
How many SSIS packages can populate a single table in Caboodle.
A. A single SSIS package
B. Multiple SSIS packages all from Clarity
C. Multiple SSIS packages from multiple sources Ans✓✓✓ A, B, and C
Identify the Caboodle table and column for the following data point, INI, and Item
#: Administration Date, I LPL 4010 Ans✓✓✓
ImmunizationEventFact.AdministrationDateKey
Exam Questions and Marking Scheme
A column in Caboodle does not contain the data you expect to see. To determine
if the issue is within the source data or the ETL process, you want to investigate
the Clarity data. How can you determine which Clarity column is used to populate
the Caboodle column? Ans✓✓✓ Investigate the data lineage for the column
using the Cogito Dictionary.
A lookup column in Caboodle contains the value -3. What could this mean?
Ans✓✓✓ There are two possibilities: Either the data that once populated this
row in Caboodle has been deleted from the source or this is the row with -3 as its
primary key, for which all lookup columns are also -3. To know which is true,
check the primary key value for the given row: a non-negative value indicates that
this row represents deleted data in the source.
A row in a Caboodle table has a primary key value of -2. What value will be stored
in columns with a data type of "Date" for this row that are not lookup columns?
A. -2
B. NULL
C. 12/31/1840
D. *Not Applicable Ans✓✓✓ b. NULL, For the row with a primary key of -2,
lookup columns will store a value of -2, string columns will store '*Not Applicable',
and all other data type columns will store NULL.
Consider the following query:
SELECT DurableKey FROM <TableName>
, Which of the following statements are true?
A. This query will only run if <TableName> is a snapshot table
B. This query will run regardless of whether <TableName> has change tracking
C. The value in the DurableKey column could repeat in multiple rows of the results
D. There is no table in Caboodle for which this query will run Ans✓✓✓ A. This
query will only run if <TableName> is a snapshot table, and C. The value in the
DurableKey column could repeat in multiple rows of the results
Explain the relationship between the dbo and FullAccess schemas. Ans✓✓✓ The
Cogito Dictionary reflects the dbo schema. The FullAccess schema contains almost
everything in the dbo schema (minus a few metadata columns) plus additional
columns in some tables. Since FullAccess has more data, report writers should use
it when writing queries. However, report writers should also be familiar with dbo
due to its relationship with the Cogito Dictionary.
How does data get into Caboodle? Ans✓✓✓ Data gets into Caboodle through
SSIS packages from Clarity or a 3rd party database.
How many SSIS packages can populate a single table in Caboodle.
A. A single SSIS package
B. Multiple SSIS packages all from Clarity
C. Multiple SSIS packages from multiple sources Ans✓✓✓ A, B, and C
Identify the Caboodle table and column for the following data point, INI, and Item
#: Administration Date, I LPL 4010 Ans✓✓✓
ImmunizationEventFact.AdministrationDateKey
