Labour Day Special - Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: top65certs

Data Integration Developer A00-260 Release Date

Page: 2 / 3
Total 70 questions

SAS Data Integration Development Questions and Answers

Question 5

The profile reports generated in dfPower Profile jobs are viewed:

Options:

A.

in dfPower Profile (Viewer)

B.

in the Reports tab of dfPower Profile (Configurator)

C.

in any HTML viewer

D.

in any text viewer

Question 6

In SAS Data Integration Studio, the SCD Type 2 Loader transformation will do which of the following?

Options:

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

Question 7

In order to use the SAS Data Integration Studio's Apply Lookup Standardization transformation, Data Quality options must be setup. Select the valid Scheme Repository Types. (Choose two.)

Options:

A.

A comma delimited flat file that contains the field names in the first row.

B.

Power scheme that is generated by Data Flux.

C.

A SAS table scheme that is generated by SAS.

D.

A third party RDBMS table that has been generated by the SAS system.

Question 8

When using SAS Data Integration Studio's SQL Join transformation, which SQL join type can be constructed as either an implicit or an explicit join?

Options:

A.

Union

B.

Full

C.

Inner

D.

Cross

Page: 2 / 3
Total 70 questions