CDW110 EXAM LATEST ACTUAL EXAM WITH UPDATED QUESTIONS AND ANSWERS (ALREADY GRADED A+)
4 views 0 purchase
Course
CDW110
Institution
CDW110
CDW110 EXAM LATEST ACTUAL EXAM WITH
UPDATED QUESTIONS AND ANSWERS (ALREADY GRADED
A+)
Change tracking - ANSWER-A property of a table that informs us
how Caboodle will be updated when changes are made to the
source databases
Change tracking types - ANSWER-1) None, 2) Snapshot Change
T...
How to tell if a table is using snapshot change tracking? -
ANSWER-Chip in the overview section of the table
Non snapshot table - ANSWER-Reflect the current content of the
source data at the time of the most recent extract
Non Snapchat table granularity - ANSWER-One row per entity
extracted to the table
,2|Page
Snapshot table - ANSWER-Use change tracking which allows to
store but current and historical data
Snapshot table granularity - ANSWER-One row per entity for a
date range
When using snapshot tables, additional filtered is needed to
ensure that... - ANSWER-Only current data is returned
True or false: snapshot data tracks when a specific change took
place - ANSWER-False
What is the granularity of PatientDim? - ANSWER-A patient
record for a date range
What does the DurableKey identify in a table? - ANSWER-Unique
entities
Which columns show the date range for a Snapchat column? -
ANSWER-StartDate and EndDate
, 3|Page
What are the default start and end dates? - ANSWER-1/1/1979,
12/31/2099
True or false: for a given DurableKey value, there is exactly one
row where IsCurrent = 1 - ANSWER-True
What is the correct way to join a snapshot table? - ANSWER-Join
on DurableKey and filter IsCurrent = 1
True or false: DurableKey only exist in snapshot tables -
ANSWER-True
Referential Integrity - ANSWER-Lookup columns will always have
a value and that value will find a match in the destination table
True or false: due to referential integrity, there are no nulls in
Caboodle tables - ANSWER-False. Nulls can exist in non-lookup
columns
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller edwinnyamoita. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $19.99. You're not tied to anything after your purchase.
