CDW110 EXAM 2023-2024 EXAM| GRADE A QUESTIONS AND VERIFIED ANSWERS | 100% Correct
QUESTION
-A foreign key column in Caboodle contains the value ‐3.
... [Show More] 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.
QUESTION
-TRUE or FALSE: All inferred rows in Caboodle have a primary key of ‐1.
Answer:
False
Inferred rows in Caboodle have non‐negative primary key values because they represent an entity that Caboodle has inferred the existence of. The foreign key columns for such rows will be set to ‐1 until the Caboodle ETL process updates the data.
QUESTION
-Referential Integrity
Answer:
Referential integrity is enforced in Caboodle, meaning that lookup columns will never contain null values. Furthermore, every value in a lookup column has a match in the destination table.
Caboodle enforces referential integrity by:
• Placing "extra" rows in every table
• These rows have surrogate key values of -1, -2, and -3
• Applying default foreign key values (-1, -2, -3)
• Creating inferred rows
QUESTION
-Inferred Row
Answer:
When a foreign key value is loaded into Caboodle, the ETL process uses its Id and idtype to determine the correct surrogate key value to store. If the referenced row does not exist yet, the ETL process creates a new row in the target table and assigns a new surrogate key value as its primary key. Such a row is called an inferred row.
Inferred rows are created when one table has more up-to-date information than another.
Two common scenarios:
A. Unmatched references in the source
B. Testing or development
Every table in Caboodle has three "extra" rows.
These rows provide a place for foreign keys to point.
QUESTION
-The -1 Row
Answer:
AS PART OF REFERENTIAL INTEGRITY
When a foreign key value is NULL in the source system, the foreign key is said to be UNSPECIFIED.
(Unspecified Foreign Key)
In this case, the corresponding foreign key in Caboodle is set to ‐1.
Since many date columns in Caboodle are
Foreign keys to the datedim table, NULL dates from Clarity are often represented with a ‐1 value datekey
Columns in Caboodle.
QUESTION
-The -2 Row
Answer:
AS PART OF REFERENTIAL INTEGRITY
When a foreign key is not applicable (N/A) as defined by the SSIS package, Caboodle sets the value to -2. This is handled by the ETL process.
QUESTION
-The -3 Row
Answer:
AS PART OF REFERENTIAL INTEGRITY
If an account was deleted in the source, all foreign key values are set to ‐3.
When a record is hard‐deleted in the source system or no longer passes the filters required for extraction,
Caboodle tracks the deletion in one of two ways. [Show Less]