A00-260 Sample Questions Answers

A foreign key is one or more columns that are associated with a primary key or unique key in another table.

A table can have zero or more foreign keys.

A foreign key cannot exist without an associated primary or unique key.

A table can have only one foreign key defined.

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.

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.

Append

Extract

Lookup

Mining Results

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.

Data Validation

Lookup

DataFlux IS Job

Table Loader