Question 1

You want to create a table containing all customers from Italy. Assume that global customer order information is available in a single table. Identify the SAS Data Integration Studio transformation that will help you perform the task easily.

AAppend

BExtract

CLookup

DMining Results

Answer : B

Question 2

Within SAS Data Integration Studio, how many inputs and outputs can be defined for a Generated transformation?

AA transformation can have zero or more inputs and exactly one output.

BA transformation needs at least one input and at least one output.

CA transformation can have zero or more inputs and zero or more outputs.

DA transformation needs at least one input and exactly one output.

Answer : C

Question 3

A user needs to find out who has the SAS Data Integration Studio job ''Create Tables'' checked out. What action should the user perform?

AThey need to select the ''Properties'' menu option and then the ''Advanced'' tab for the SAS Data Integration Studio job ''Create Tables'' within Data Integration studio.

BThey need to select the History menu option for the SAS Data Integration Studio job ''Create Tables'' once it has been checked in.

CThey need to select the History menu option for the SAS Data Integration Studio job ''Create Tables''.

DThey are not able to find out who has the SAS Data Integration Studio job ''Create Tables'' in checked out status because they are not an administrator.

Answer : C

Question 4

Which statement is true regarding SAS packages created in SAS Data Integration Studio?

ASAS packages are used to import and export SAS applications.

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

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

DSAS packages are used to import and export SAS metadata.

Answer : D

Question 5

In SAS Data Integration Studio, surrogate and retained key values are:

Agenerated by the Lookup transformation

Bcopied from source tables into dimension tables

Cgenerated by the SCD Type 2 Loader transformation

Dcopied from dimension tables into source tables

Answer : C

Free Practice Questions for SAS A00-260 Exam

Question 1

Question 2

Question 3

Question 4

Question 5