A00-260 SAS Data Integration Development Questions and Answers

Create and replace permanent tables.

Maintain access privileges to permanent tables.

Apply and maintain constraints on permanent tables.

Delete and remove permanent tables.

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.

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.

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.

in metadata

on any machine that SAS Data Integration Studio can write to

in a SAS catalog

only on the machine where SAS Data Integration Studio is running

SAS packages are used to import and export SAS applications.

SAS packages are used to import and export stand-alone SAS programs.

SAS packages are used to import and export third-party metadata.

SAS packages are used to import and export SAS metadata.

Delimited

Fixed Width

User Written

COBOL Copybook