Labour Day - Special 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 70dumps

A00-260 Questions and Answers

Question # 6

In the following display, can status handling be enabled for the Extract transformation?

A.

No. The Extract transformation does not have a status handling tab in its Properties window, and the Return Code Check transformation can only provide status handling at the job level.

B.

Yes. The Return Code Check transformation can be added to the END of the job flow - the Status Handling tab in the Return Code Check transformation properties can then establish the desired status handling.

C.

No. The Extract transformation does not have a Status Handling tab in its Properties window, therefore it is not possible to establish status handling for this transformation.

D.

Yes. The Return Code Check transformation can be added to the job flow immediately following the Extract - the Status Handling tab in the Return Code Check transformation properties can then establish the desired status handling.

Full Access
Question # 7

Select the valid reasons for using SAS Data Integration Studio's Table Loader transformation. (Choose two.)

A.

Create and replace permanent tables.

B.

Maintain access privileges to permanent tables.

C.

Apply and maintain constraints on permanent tables.

D.

Delete and remove permanent tables.

Full Access
Question # 8

Which statement defines the characteristics of a SAS Stored Process?

A.

SAS metadata that describes how to collect and store data sources.

B.

A document that stores the steps and locations for building a data mart.

C.

A SAS program that is stored on the server and described by metadata.

D.

A user written SAS PROC step.

Full Access
Question # 9

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

Full Access
Question # 10

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.)

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.

Full Access