SAS A00-260 Exam Questions Instant Access

Question 1

In SAS Data Integration Studio, which statement is FALSE regarding status handling?

AWhen a job is executed in SAS Data Integration Studio, a return code for each transformation in the job is captured in a macro variable. The return code for the job is set to the least successful transformation in the job. SAS Data Integration Studio enables you to associate a return code condition, such as Successful, with an action, such as Send Email.

BIf status handling has been defined for a transformation or the job, a macro definition (and a call to it) will be added to the generated code to check for the specified condition(s).

COnly one Condition/Action pair can be defined for a single transformation or for a job.

DThe available Condition/Action pairs for transformations and jobs will vary - that is, different
Condition/Action pairs may exist for the SQL Join transformation versus the Table Loader transformation.

Answer : C

Question 2

In SAS Data Integration Studio, which output format is supported for the default ''out-of-the-box'' job report?

AHTML

BPDF

CRTF

DXML

Answer : A

Question 3

Assume that SAS Data Integration Studio Table Loader is being used in a job. The load style selected is Append to Existing. Which statement is true regardingAssume that SAS Data Integration Studio? Table Loader is being used in a job. The load style selected is Append to Existing. Which statement is true regarding this load style?

AIt generates PROC APPEND code.

BIt generates PROC SQL code.

CIt generates either PROC SQL code or PROC APPEND code depending on further option choices.

DIt generates DATA STEP APPEND code.

Answer : C

Question 4

Within SAS Data Integration Studio, which one of the following is NOT an option available from the File-> New menu choice under External File grouping?

ADelimited

BFixed Width

CUser Written

DCOBOL Copybook

Answer : D

Question 5

SAS Data Integration Studio is dependent on which administration functions?

ASetting up of SAS Information Map environment.

BSetting up of SAS Web and SAS Portal environments.

CSetting up of SAS Application Servers.

DSetting up of SAS Libraries definitions.

Answer : C

Question 6

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.

Answer : C

Question 7

When using the SCD Type 2 load method in SAS Data Integration Studio, which columns can be selected to check for changed data?

Abusiness key columns

BType 1 columns

Cgenerated columns

Dnon-key columns

Answer : D

SAS Certified Data Integration Developer for SAS A00-260 Exam Questions