A00-260 SAS Data Integration Development Questions and Answers

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

No. Both the Extract and the Sort transformations do not have a Status Handling tab in their corresponding properties window, therefore it is not possible to establish status handling for these transformations.

Yes. The Return Code Check transformation can be added to the job flow twice, once immediately following the Extract, and again immediately following the Sort - the Status Handling tab in each of the Return Code Check transformations properties can then establish the desired status handling.

Yes. The status handling tab in the job properties window will allow you to select which transformation (or even several transformations) that you want to define status handling for.

SAS macro variables

columns of SAS datasets

SAS formats

SAS macro calls

An application server that executes service requests based on Simple Object Access Protocol (SOAP) to call

dfPower Architect or dfPower Profile jobs.

A plug-in to SAS Data Integration Studio allowing you to design jobs specialized for data cleansing

operations.

An application interface that allows you to build dfPower Architect and dfPower Profile jobs specialized for

data cleansing operations.

A third party server defined in the SAS metadata repository that allows you to build flows integrating

multiple jobs and establishing job dependencies within the flow.

The COL1 columns are successfully mapped, one-to-one, with no warnings.

The COL1 columns are not mapped because the lengths are different.

The COL1 columns are mapped but an expression is defined for the target COL1 that uses a generic specification

of the LENGTH function.

The COL1 columns are successfully mapped, one-to-one, but a warning occurs.

Define Collect Runtime Statistics on the SAS Data Integration Studio job.

Define Collect Table Statistics on the SAS Data Integration Studio job.

Define Collect Diagnostics on the SAS Data Integration Studio job.

Define Collect Table Statistics on the SAS Data Integration Studio options.

Define a logfile for output.

Define Collect Diagnostics for the SAS Data Integration Studio job.

Define Collect Runtime statistics for the SAS Data Integration Studio job.

Enable the logging facility of the SAS Workspace Server.

combines rows from multiple tables into a single row

combines rows from multiple tables into multiple rows

validates that values are unique

validates that values are not null

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

Power scheme that is generated by Data Flux.

A SAS table scheme that is generated by SAS.

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

1 and 2 only

1 and 3 only

1, 2 and 4 only

1, 2, 3, and 4

in the source and standardization tables

in the source and dimension tables

in the target and fact tables

in the source, dimension and standardization tables

The Inner Job can be successfully executed by itself, but only if the defined parameter has been assigned a valid default value.

The Inner Job cannot be successfully executed by itself unless it is disassociated from the loop job.

The Control Table column is mapped to the parameter defined for the Inner Job using the Loop transformation properties window.

If the server that executes the job has multiple CPUs, parallel processing can be enabled in the Loop transformation properties window.

Setting up of SAS Information Map environment.

Setting up of SAS Web and SAS Portal environments.

Setting up of SAS Application Servers.

Setting up of SAS Libraries definitions.

Not specific to an individual user. Anyone with permission to access the data source can use it.

Specific to an individual user. It is available only to the user who creates it.

Not specific to an individual user. It can be shared among users even though it is created locally.

Specific to an individual user. But it can be shared among users.

& syslast

syslast

& target

%target

Delimited

Fixed Width

User Written

COBOL Copybook

metadata objects across metadata servers

metadata objects within a logged on user ' s personal folder

metadata objects within a metadata server

metadata objects within a logged on user ' s Checkouts Tree

Exhibit A

Exhibit B

Exhibit C

Exhibit D

They need to select the " Properties " menu option and then the " Advanced " tab for the SAS Data Integration

Studio job " Create Tables " within Data Integration studio.

They need to select the History menu option for the SAS Data Integration Studio job " Create Tables " once it

has been checked in.

They need to select the History menu option for the SAS Data Integration Studio job " Create Tables " .

They are not able to find out who has the SAS Data Integration Studio job " Create Tables " in checked out

status because they are not an administrator.