A datetime values 23 B alpha numeric values C binary values D integer values

A datetime values 23 b alpha numeric values c binary

This preview shows page 2 - 5 out of 5 pages.

A. datetime values 23
Image of page 2
B. alpha-numeric values C. binary values D. integer values Answer: D QUESTION: 66 In SAS Data Integration Studio, the SCD Type 2 Loader transformation will do which of the following? A. find row matches using the business key B. find row matches using generated cluster numbers C. find non-standard values using a generated key D. find non-standard values using a business key Answer: A QUESTION: 67 In SAS Data Integration Studio, where must the columns included in a business key exist? A. in the source and standardization tables B. in the source and dimension tables C. in the target and fact tables D. in the source, dimension and standardization tables Answer: B QUESTION: 68 Which action is performed by the Lookup transformation in SAS Data Integration Studio? A. combines rows from multiple tables into a single row B. combines rows from multiple tables into multiple rows C. validates that values are unique D. validates that values are not null Answer: A 24
Image of page 3
QUESTION: 69 The SAS Data Integration Studio SCD Type 2 Loader transformation can do which of the following? A. generatecpu statistics B. generate adatetime value C. generates cluster numbers D. generates standardization values Answer: B QUESTION: 70 When using the SCD Type 2 load method in SAS Data Integration Studio, which columns can be selected to check for changed data? A. business key columns B. Type 1 columns C. generated columns D. non-key columns Answer: D 25
Image of page 4
For More exams visit http s ://killexams.com /vendors-exam-list Kill your exam at First Attempt .... Guaranteed!
Image of page 5

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