Question No 1

Assume that a SAS Data Integration Studio job is populating a table, and the table has metadata definitions for two simple indexes. Which of the following is NOT a valid location for viewing which columns are indexed?

Choose the Choices:

the Load Technique tab in the Table Loader transformation properties window

the Indexes tab in the table properties window

the Columns tab in the table properties window

the Columns tab in the Details panel of the open job, with the table selected in the job flow

Question No 2

Consider the job flow diagram in the display. Assume the inner job has a parameter defined specifying a table name. Which statement is FALSE?

Choose the Choices:

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.

Question No 3

In SAS Data Integration Studio, source table records and dimension table records are combined for output using which transformation?

Choose the Choices:

Question No 4

The SAS Data Integration Studio SCD Type 2 Loader transformation performs which of the following?

Choose the Choices:

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.

Question No 5

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

Choose the Choices:

Practice SAS A00-260 Exam Questions

Question No 1

Question No 2

Question No 3

Question No 4

Question No 5

A00-260 Exam Features

A00-260 PDF Dumps