CDW 110V CABOODLE DATA MODEL
COMPREHENSIVE EXAM SCRIPT VERIFIED
QUESTIONS COMPLETE ANSWERS
GRADED APLUS
◉ Type 1 Data
Answer:
◉ Type 2 Data
Answer:
◉ "_Current" View
Answer:
◉ StartDate Column
Answer:
◉ EndDate Column
Answer:
◉ Durable Key
, Answer:
◉ How do you identify whether changing data will trigger an update
to an existing row or create a new row?
Answer:
◉ How do you successfully report with current and/or historical
data?
Answer:
◉ How do you use durable keys to find the information about an
entity and understand its history?
Answer:
◉ How do you identify from looking at the data in a table whether
the table is type 1 or type 2?
Answer:
◉ Explain foreign key references from Type 2 tables.
Answer:
◉ Explain the difference between Type 1 and Type 2 data.
Answer:
COMPREHENSIVE EXAM SCRIPT VERIFIED
QUESTIONS COMPLETE ANSWERS
GRADED APLUS
◉ Type 1 Data
Answer:
◉ Type 2 Data
Answer:
◉ "_Current" View
Answer:
◉ StartDate Column
Answer:
◉ EndDate Column
Answer:
◉ Durable Key
, Answer:
◉ How do you identify whether changing data will trigger an update
to an existing row or create a new row?
Answer:
◉ How do you successfully report with current and/or historical
data?
Answer:
◉ How do you use durable keys to find the information about an
entity and understand its history?
Answer:
◉ How do you identify from looking at the data in a table whether
the table is type 1 or type 2?
Answer:
◉ Explain foreign key references from Type 2 tables.
Answer:
◉ Explain the difference between Type 1 and Type 2 data.
Answer:
