SAS A00-260 Exam Practice Test Instant Access

Question 1

The ability to deploy a SAS Data Integration Studio job as a Web service or a SAS Stored Process requires additional set up that is performed in which client application?

ASAS Data Integration Studio

BSAS Enterprise Guide

CSAS Job Deployment Studio

DSAS Management Console

Answer : D

Question 2

How do you enable performance statistics for a SAS Data Integration Studio job?

ADefine Collect Runtime Statistics on the SAS Data Integration Studio job.

BDefine Collect Table Statistics on the SAS Data Integration Studio job.

CDefine Collect Diagnostics on the SAS Data Integration Studio job.

DDefine Collect Table Statistics on the SAS Data Integration Studio options.

Answer : A

Question 3

In SAS Data Integration Studio, where must the columns included in a business key exist?

Ain the source and standardization tables

Bin the source and dimension tables

Cin the target and fact tables

Din the source, dimension and standardization tables

Answer : B

Question 4

Assume that you have completed the Register Tables wizard in SAS Data Integration Studio. Which statement is true?

AThe physical table(s) selected are copied to the application server specified in the library.

BThe physical table(s) selected are copied to the SAS Folders location specified in the wizard.

CMetadata for the physical table(s) selected is stored on the application server specified in the library.

DMetadata for the physical table(s) selected is stored in the SAS Folders location specified in the wizard.

Answer : D

Question 5

Registering metadata for an ODBC data source involves registering:

Aa library that will use a SASIACCESS engine to a specific database

Bonly an ODBC data source definition

Ca server definition that points to the ODBC data source and a library accessing this server definition

Da table pointing directly to the ODBC data source

Answer : C

Question 6

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?

AIndexes are removed when the Table Loader executes and must be re-created using the Table Structure transformation.

BIndexes are automatically preserved when the Table Loader executes.

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

DIndexes 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 7

Which batch server is queried to retrieve the command needed to run traditional .SAS programs having DATA and PROC steps?

ASAS Java Batch Server

BSAS DATA Step Batch Server

CSAS Generic Batch Server

DSAS PROC Step Batch Server

Answer : B

SAS A00-260 SAS Certified Data Integration Developer for SAS Exam Practice Test