Pass the SAS Institute Data Integration Developer A00-260 Questions and answers with ExamsMirror

The transformation has to be used within a job to interactively test the options with the Test Prompt button

in the Options window from the properties of the transformation within the job editor.

The options can be tested after finalizing and saving the transformation with the Test Prompt item on the

Tools menu.

The options can be tested only after adding all options that are assigned to the source code with the Test

Prompt button in the Options window of the New Transformation wizard.

The options can be tested at any time after adding them to the transformation with the Test Prompt button in

the Options window of the New Transformation wizard.

SAS Information Delivery Portal

SAS Information Map Studio

SAS Web Report Studio

SAS OLAP Cube Studio

the old record is deleted and the changed record is added

the old record is updated with the new values from the changed record

the old record is flagged and the changed record is added

the old record is merged with the changed record

Execute the stored process in SAS Data Integration Studio.

Execute the stored process in SAS Management Console.

Execute the stored process using the SAS Add-In for Microsoft Office or SAS Enterprise Guide.

Execute the stored process using SAS Display Manager's Stored Process Test window.

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.

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.

Loads source table records into a standardization table.

Loads dimension table records into a fact table.

Loads source table records into a dimension table.

Loads fact table records into a multi-threaded table.

a Where clause definition

an Expression Builder window

a field Expression definition

a Subquery definition

Automatic propagation can be set globally, so every new job will automatically propagate.

Propagation can only occur in the direction of the job flow diagram (from beginning to end). Propagation from

the end to the beginning is not available.

Automatic propagation that is set globally can be overridden and disabled within a job.

Automatic propagation that is set globally or at the job level can be overridden and disabled for a selected

transformation.

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.