Question No. 1

In SAS Data Integration Studio, the SCD Type 2 Loader transformation will do which of the following?

Afind row matches using the business key

Bfind row matches using generated cluster numbers

Cfind non-standard values using a generated key

Dfind non-standard values using a business key

Show Answer

Correct Answer: A

Question No. 2

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?

Athe Load Technique tab in the Table Loader transformation properties window

Bthe Indexes tab in the table properties window

Cthe Columns tab in the table properties window

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

Show Answer

Correct Answer: A

Question No. 3

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

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

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

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

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

Show Answer

Correct Answer: B

Question No. 4

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

AData Validation

BLookup

CDataFlux lS Job

DTable Loader

Show Answer

Correct Answer: B

Question No. 5

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

ALoads source table records into a standardization table.

BLoads dimension table records into a fact table.

CLoads source table records into a dimension table.

DLoads fact table records into a multi-threaded table.

Show Answer

Correct Answer: C

Free SAS A00-260 Exam Actual Questions

The questions for A00-260 were last updated On May 6, 2024