A00-260 Practice Exam Questions with Answers SAS Data Integration Development Certification

the old record is deleted and the changed record is added

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

the old record is flagged and the changed record is added

the old record is merged with the changed record

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

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

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

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

find row matches using the business key

find row matches using generated cluster numbers

find non-standard values using a generated key

find non-standard values using a business key

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.

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.

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.

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.

SAS metadata that describes how to collect and store data sources.

A document that stores the steps and locations for building a data mart.

A SAS program that is stored on the server and described by metadata.

A user written SAS PROC step.

The scheduling server calls the SAS DATA Step Batch Server over the SAS Object Server which spawns the job,

getting its source code from the deployment directory, and sends the results directly to the Schedule Manager

plug-in of the SAS Management Console.

The scheduling server uses the command obtained from the SAS DATA Step Batch Server and the source code from

the deployment directory to run the job. The results from the executing command are directly sent to the

scheduling server.

The scheduling server uses the command from the deployed job in the deployment directory and executes it with

the SAS DATA Step Batch Server which gets the source code from the Metadata Server. The results are sent back

to the deployment directory.

The scheduling server uses the command obtained from the Schedule Manager, the source code from SAS DATA Step

Batch Server and executes it. The results are directly sent to the scheduling server.

Execute the stored process in SAS Data Integration Studio.

Execute the stored process in SAS Management Console.

Execute the stored process using the SAS Add-In for Microsoft Office or SAS Enterprise Guide.

Execute the stored process using SAS Display Manager's Stored Process Test window.

&syslast

syslast

&target

%target

Exhibit A

Exhibit B

Exhibit C

Exhibit D

a library that will use a SAS/ACCESS engine to a specific database

only an ODBC data source definition

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

a table pointing directly to the ODBC data source

in dfPower Profile (Viewer)

in the Reports tab of dfPower Profile (Configurator)

in any HTML viewer

in any text viewer

Not specific to an individual user. Anyone with permission to access the data source can use it.

Specific to an individual user. It is available only to the user who creates it.

Not specific to an individual user. It can be shared among users even though it is created locally.

Specific to an individual user. But it can be shared among users.

Data Transfer

Data Validation

Data Quality

Data Extract

generated by the Lookup transformation

copied from source tables into dimension tables

generated by the SCD Type 2 Loader transformation

copied from dimension tables into source tables

Union

Full

Inner

Cross

the Indexes tab in the properties of a Table Loader transformation

the Indexes tab in the properties of a table metadata object

the Indexes tab in the properties for any transformation

the Indexes tab in the properties of a job metadata object