Latest Certified Success Dumps Download

CISCO, MICROSOFT, COMPTIA, HP, IBM, ORACLE, VMWARE
A00-260 Examination questions (September)

Achieve New Updated (September) SAS A00-260 Examination questions 21-30

September 25, 2015

Ensurepass

QUESTION 21

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

 

A.

They 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.

B.

They need to select the History menu option for the SAS Data Integration Studio job “Create Tables” once it

has been checked in.

C.

They need to select the History menu option for the SAS Data Integration Studio job “Create Tables”.

D.

They 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 22

In SAS Data Integration Studio, the default values for generated surrogate and retained keys contain which type of values?

 

A.

datetime values

B.

alpha-numeric values

C.

binary values

D.

integer values

 

Answer: D

 

 

QUESTION 23

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

 

A.

SAS packages are used to import and export SAS applications.

B.

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

C.

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

D.

SAS packages are used to import and export SAS metadata.

 

Answer: D

 

 

QUESTION 24

Within SAS Data Integration Studio, which type of expression can be created using the

 

 

 

 

Expression Builder window in the Where tab of SAS Extract transformation? 1) a SAS expression 2) an SQL expression 3) an XML expression 4) a constant

 

A.

1 and 2 only

B.

1 and 3 only

C.

1, 2 and 4 only

D.

1, 2, 3, and 4

 

Answer: C

 

 

QUESTION 25

Which of the following are SAS Data Integration Studio job deployment types? (Choose two.)

 

A.

a Web service

B.

a SAS Stored Process

C.

a Java Runtime Process

D.

a SAS Information Map that is accessible in SAS Web Report Studio

 

Answer: BD

 

 

QUESTION 26

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

 

A.

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

B.

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

C.

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

D.

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

 

Answer: C

 

 

QUESTION 27

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?

 

A.

It generates PROC APPEND code.

B.

It generates PROC SQL code.

C.

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

D.

It generates DATA STEP APPEND code.

 

Answer: C

 

 

QUESTION 28

Which of the following is NOT defined as part of the New Library Wizard?

 

A.

the type of library

B.

the metadata name for the library

C.

the location of the library

D.

the metadata for the library tables

 

Answer: D

 

 

QUESTION 29

In the following display, can status handling be enabled for both the Extract transformation and the Sort transformation?

 

clip_image002

 

 

 

 

 

A.

Yes. The Return Code Check transformation can be added to the job flow immediately following the Sort transformation – the Status Handling tab in this Return Code Check transformation properties can then establish the desired status handling for both the Extract and Sort transformations.

B.

No. Both the Extract and the Sort transformations do not have a Status Handling tab in their corresponding properties window, therefore it is not possible to establish status handling for these transformations.

C.

Yes. The Return Code Check transformation can be added to the job flow twice, once immediately following the Extract, and again immediately following the Sort – the Status Handling tab in each of the Return Code Check transformations properties can then establish the desired status handling.

D.

Yes. The status handling tab in the job properties window will allow you to select which transformation (or even several transformations) that you want to define status handling for.

 

Answer: C

 

 

QUESTION 30

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

 

A.

HTML

B.

PDF

C.

RTF

D.

XML

 

Answer: A

 

Free VCE & PDF File for SAS A00-260 Real Exam

Instant Access to Free VCE Files: CompTIA | VMware | SAP …
Instant Access to Free PDF Files: CompTIA | VMware | SAP …