Summer Sale Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: ecus65

SAS Institute A00-260 - SAS Data Integration Development

SAS Institute A00-260 Premium Access     Download Demo    
Page: 2 / 3
Total 70 questions

In SAS Data Integration Studio, the default values for generated surrogate and retained keys contain which type of values?

A.

datetime values

B.

alpha-numeric values

C.

binary values

D.

integer values

The profile reports generated in dfPower Profile jobs are viewed:

A.

in dfPower Profile (Viewer)

B.

in the Reports tab of dfPower Profile (Configurator)

C.

in any HTML viewer

D.

in any text viewer

Within SAS Data Integration Studio's SQL Join transformation, the Validate Expression button is located in:

A.

a Where clause definition

B.

an Expression Builder window

C.

a field Expression definition

D.

a Subquery definition

Which of the following is NOT defined as part of the New Library Wizard?

A.

the type of library

B.

the metadata name for the library

C.

the location of the library

D.

the metadata for the library tables

When using the SCD Type 2 load method in SAS Data Integration Studio, which columns can be selected to check for changed data?

A.

business key columns

B.

Type 1 columns

C.

generated columns

D.

non-key columns

Which statement regarding propagation is FALSE?

A.

Automatic propagation can be set globally, so every new job will automatically propagate.

B.

Propagation can only occur in the direction of the job flow diagram (from beginning to end). Propagation from

the end to the beginning is not available.

C.

Automatic propagation that is set globally can be overridden and disabled within a job.

D.

Automatic propagation that is set globally or at the job level can be overridden and disabled for a selected

transformation.

Assume that a SAS Data Integration Studio job is populating a table, and the table has metadata definitions for two simple indexes. Which of the following is NOT a valid location for viewing which columns are indexed?

A.

the Load Technique tab in the Table Loader transformation properties window

B.

the Indexes tab in the table properties window

C.

the Columns tab in the table properties window

D.

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

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

A.

the deployment wizard of SAS Data Integration Studio

B.

the Scheduling Manager plug-in in SAS Management Console

C.

the Scheduling Server

D.

the SAS DATA Step Batch Server

Which statement best describes the DataFlux Integration Server?

A.

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

dfPower Architect or dfPower Profile jobs.

B.

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

operations.

C.

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

data cleansing operations.

D.

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.

SAS Data Integration Studio is dependent on which administration functions?

A.

Setting up of SAS Information Map environment.

B.

Setting up of SAS Web and SAS Portal environments.

C.

Setting up of SAS Application Servers.

D.

Setting up of SAS Libraries definitions.