A00-260.pdf - SASInstitute A00-260 SAS Data Integration Development http\/killexams.com\/exam-detail\/A00-260 QUESTION 62 In SAS Data Integration Studio

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

This preview shows page 1 - 3 out of 5 pages.

A00-260 SASInstitute SAS Data Integration Development
Image of page 1
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?
Image of page 2
Image of page 3

You've reached the end of your free preview.

Want to read all 5 pages?

  • Fall '20

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture