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 31-40

September 25, 2015

Ensurepass

QUESTION 31

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

 

A.

Create and replace permanent tables.

B.

Maintain access privileges to permanent tables.

C.

Apply and maintain constraints on permanent tables.

D.

Delete and remove permanent tables.

 

Answer: CD

 

 

 

QUESTION 32

How can you test the interaction of the options of a SAS Data Integration Studio Generated transformation?

 

A.

The transformation has to be used within a job to interactively test the options with the Test Prompt button

in the Options window from the properties of the transformation within the job editor.

B.

The options can be tested after finalizing and saving the transformation with the Test Prompt item on the

Tools menu.

C.

The options can be tested only after adding all options that are assigned to the source code with the Test

Prompt button in the Options window of the New Transformation wizard.

D.

The options can be tested at any time after adding them to the transformation with the Test Prompt button in

the Options window of the New Transformation wizard.

 

Answer: D

 

 

QUESTION 33

Which action is required for enabling performance statistics on the executing SAS Workspace Server?

 

A.

Define a logfile for output.

B.

Define Collect Diagnostics for the SAS Data Integration Studio job.

C.

Define Collect Runtime statistics for the SAS Data Integration Studio job.

D.

Enable the logging facility of the SAS Workspace Server.

 

Answer: D

 

 

QUESTION 34

The SAS platform application that can surface the different types of business and analytic content such as information maps, stored processes, and reports on the web browser is:

 

A.

SAS Information Delivery Portal

B.

SAS Information Map Studio

 

 

 

 

C.

SAS Web Report Studio

D.

SAS OLAP Cube Studio

 

Answer: A

 

 

QUESTION 35

When using the Table Loader transformation to load an existing target table that contains one or more indexes in SAS Data Integration Studio, which statement is true?

 

A.

Indexes are removed when the Table Loader executes and must be re-created using the Table Structure

transformation.

B.

Indexes are automatically preserved when the Table Loader executes.

C.

Indexes are removed at the beginning of the load process and must be re-created in a subsequent job step.

D.

Indexes can be removed or preserved at the beginning of the process depending on options chosen. Additional

table loader options specify whether to re-create the index at the end of the process.

 

Answer: D

 

 

QUESTION 36

The Platform Process Manager server is part of the Platform Suite for SAS. Which statement is FALSE regarding the Platform Process Manager server?

 

A.

The server enables you to schedule jobs using a variety of recurrence criteria and dependencies on other jobs,

time events, or file events.

B.

The server enables you to schedule jobs using a variety of recurrence criteria but does NOT allow you to

specify any type of dependencies.

C.

The Flow Manager application (part of the Platform Suite for SAS) can be used to manage already scheduled

jobs.

D.

Metadata for the Platform Process Manager server must be defined and must include the network address or host

name of a machine as well as the port number for the server.

 

 

 

 

 

Answer: B

 

 

QUESTION 37

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

 

A.

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

B.

If 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).

C.

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

D.

The 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 38

When writing postcode in the Precode and Postcode tab of the Transpose transformation in SAS Data Integration Studio, which symbol allows you to reference the transformation output table regardless of the actual physical name for that target table?

 

A.

&syslast

B.

syslast

C.

&target

D.

%target

 

Answer: A

 

 

QUESTION 39

 

SAS Data Integration Studio is dependent on which administration functions?

 

A.

Setting up of SAS Information Map environment.

B.

Setting up of SAS Web and SAS Portal environments.

C.

Setting up of SAS Application Servers.

D.

Setting up of SAS Libraries definitions.

 

Answer: C

 

 

QUESTION 40

When using the SCD Type 2 load method in SAS Data Integration Studio, which statement is true when a change is detected?

 

A.

the old record is deleted and the changed record is added

B.

the old record is updated with the new values from the changed record

C.

the old record is flagged and the changed record is added

D.

the old record is merged with the changed record

 

Answer: C

 

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 …