A00-260 Sample Questions Answers

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

time events, or file events.

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

specify any type of dependencies.

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

jobs.

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.

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

transformation.

Indexes are automatically preserved when the Table Loader executes.

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

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.

They need to select the "Properties" menu option and then the "Advanced" tab for the SAS Data Integration

Studio job "Create Tables" within Data Integration studio.

They need to select the History menu option for the SAS Data Integration Studio job "Create Tables" once it

has been checked in.

They need to select the History menu option for the SAS Data Integration Studio job "Create Tables".

They are not able to find out who has the SAS Data Integration Studio job "Create Tables" in checked out

status because they are not an administrator.

Append

Extract

Lookup

Mining Results

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

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

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

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

combines rows from multiple tables into a single row

combines rows from multiple tables into multiple rows

validates that values are unique

validates that values are not null

Use the New User Written External File wizard.

Use the New Fixed Width External File wizard.

Use the New Delimited External File wizard.

Use the New COBOL Copybook wizard.

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.

Create and replace permanent tables.

Maintain access privileges to permanent tables.

Apply and maintain constraints on permanent tables.

Delete and remove permanent tables.

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

An application server that executes service requests based on Simple Object Access Protocol (SOAP) to call

dfPower Architect or dfPower Profile jobs.

A plug-in to SAS Data Integration Studio allowing you to design jobs specialized for data cleansing

operations.

An application interface that allows you to build dfPower Architect and dfPower Profile jobs specialized for

data cleansing operations.

A third party server defined in the SAS metadata repository that allows you to build flows integrating

multiple jobs and establishing job dependencies within the flow.

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

business key columns

Type 1 columns

generated columns

non-key columns

the Load Technique tab in the Table Loader transformation properties window

the Indexes tab in the table properties window

the Columns tab in the table properties window

the Columns tab in the Details panel of the open job, with the table selected in the job flow

SAS Information Delivery Portal

SAS Information Map Studio

SAS Web Report Studio

SAS OLAP Cube Studio

Define a logfile for output.

Define Collect Diagnostics for the SAS Data Integration Studio job.

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

Enable the logging facility of the SAS Workspace Server.

in dfPower Profile (Viewer)

in the Reports tab of dfPower Profile (Configurator)

in any HTML viewer

in any text viewer

Data Validation

Lookup

DataFlux IS Job

Table Loader