A00-260.pdf - SASInstitute A00-260 SAS Data Integration...

A00-260
SASInstitute
SAS Data Integration Development

QUESTION: 62
In SAS Data Integration Studio, surrogate and retained key values are:
A. generated by the Lookup transformation
B. copied from source tables into dimension tables
C. generated by the SCD Type 2 Loader transformation
D. copied from dimension tables into source tables
Answer: C
QUESTION: 63
A fact table is populated by using which transformation in SAS Data Integration Studio?
A. SCD Type 2 Loader
B. Data Validation
C. Lookup
D. DataFlux IS Job
Answer: C
QUESTION: 64
When using the SCD Type 2 load method in SAS Data Integration Studio, which
statement is true when a change is detected?
A. the old record is deleted and the changed record is added
B. the old record is updated with the new values from the changed record
C. the old record is flagged and the changed record is added
D. the old record is merged with the changed record
Answer: C
QUESTION: 65
In SAS Data Integration Studio, the default values for generated surrogate and retained
keys contain which type of values?