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

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

Question 3

Which statement regarding scheduling SAS Data Integration Studio jobs is true?

ATo schedule a job flow you must first use SAS Management Console to deploy the job for scheduling.

BTo schedule the job on the Platform Process Manager you require a dependency generator.

CMultiple job flows can be scheduled to a deployment directory.

DTo schedule a job flow in SAS Management console you must first deploy the job for scheduling using SAS Data Integration Studio.

Answer : D

Question 4

You want to create a job that checks conditions for your data before that data is loaded into a data warehouse. The job should be able to detect error conditions such as missing data or duplicate data and take appropriate actions like registering error conditions in log, etc. Which SAS Data Integration Studio transformation should you use?

AData Transfer

BData Validation

CData Quality

DData Extract

Answer : B

Question 5

The SAS Data Integration Studio SCD Type 2 Loader transformation can do which of the following?

Agenerate cpu statistics

Bgenerate a datetime value

Cgenerates cluster numbers

Dgenerates standardization values

Answer : B

Question 6

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

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

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

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

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

A fact table is populated by using which transformation in SAS Data Integration Studio?

ASCDType2 Loader

BData Validation

CLookup

DDataFlux lS Job

Answer : C

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