CDW110 EXAM 2025-2026 EXAM| GRADE A QUESTIONS AND VERIFIED ANSWERS | 100% Correct

QUESTION
-A foreign key column in Caboodle contains the value ‐3. What could this mean?
Answer:
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 foreign key
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.
QUESTION
-If a foreign key is null in Clarity, what will appear in the corresponding column in Caboodle?
Answer:
If the foreign key was null in the source, then a ‐1 will appear in Caboodle to represent an
unspecified value. If the foreign key's data lineage was not defined by the source package that
loaded data for a particular row, then a ‐2 will appear in Caboodle to represent a value that is not
applicable.
QUESTION
-A row in a Caboodle table has a primary key value of ‐2. What value will be stored in non‐
foreign key columns with a data type of "Date" for this row?
A. ‐2
B. NULL
C. 12/31/1840
D. *Not Applicable
Answer:
B. NULL
For the row with a primary key of ‐2, foreign key columns will store a value of ‐2, string
columns will
Store '*Not Applicable', and all other data type columns will store NULL.