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?
You've reached the end of your free preview.
Want to read all 5 pages?
- Fall '20