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

In SAS Data Integration Studio, the SCD Type 2 Loader transformation will do which of the following?

Afind row matches using the business key

Bfind row matches using generated cluster numbers

Cfind non-standard values using a generated key

Dfind non-standard values using a business key

Answer : A

Question 3

In SAS Data Integration Studio, which component allows the definition of job flows with dependencies between different jobs?

Athe deployment wizard of SAS Data Integration Studio

Bthe Scheduling Manager plug-in in SAS Management Console

Cthe Scheduling Server

Dthe SAS DATA Step Batch Server

Answer : B

Question 4

Assume that SAS Data Integration Studio Table Loader is being used in a job. The load style selected is Update/Insert. Which statement is true regarding theAssume that SAS Data Integration Studio? Table Loader is being used in a job. The load style selected is Update/Insert. Which statement is true regarding the relationship between the source table and the target table?

AFrom the source table, matching rows are updated in the target table and new rows are added.

BFrom the source table, matching rows AND new rows are added, but the original matching row in the target table is marked as inactive.

CFrom the source table, matching rows are skipped, and new rows are added.

DA or C, depending on further options chosen.

Answer : D

Question 5

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

ASCDType2 Loader

BData Validation

CLookup

DDataFlux lS Job

Answer : C

Question 6

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 7

Consider the job flow diagram in the display. Assume the inner job has a parameter defined specifying a table name. Which statement is FALSE?

AThe Inner Job can be successfully executed by itself, but only if the defined parameter has been assigned a valid default value.

BThe Inner Job cannot be successfully executed by itself unless it is disassociated from the loop job.

CThe Control Table column is mapped to the parameter defined for the Inner Job using the Loop transformation properties window.

DIf the server that executes the job has multiple CPUs, parallel processing can be enabled in the Loop transformation properties window.

Answer : B

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