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

After creating a stored process from a SAS Data Integration Studio job, how can you test the stored process to make sure it runs correctly?

A.

Execute the stored process in SAS Data Integration Studio.

B.

Execute the stored process in SAS Management Console.

C.

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

D.

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

You want to create a table containing all customers from Italy. Assume that global customer order information is available in a single table. Identify the SAS Data Integration Studio transformation that will help you perform the task easily.

A.

Append

B.

Extract

C.

Lookup

D.

Mining Results

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

A.

generate cpu statistics

B.

generate a datetime value

C.

generates cluster numbers

D.

generates standardization values

When using the Table Loader transformation in SAS Data Integration Studio to update an existing table containing indexes or constraints, which statement is true?

A.

You can control the removal and/or creation of indexes and constraints in the target table only if you are

using a Load style other than Replace.

B.

You can control the removal and/or creation of indexes and constraints in the target table for all Load

Styles.

C.

If using the Append to Existing load style, indexes and constraints can be added but not removed.

D.

For the Update/Insert load style it is possible to remove indexes not required for the Update/Insert

processing, but no indexes can be added.

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?

A.

Data Transfer

B.

Data Validation

C.

Data Quality

D.

Data Extract

The purpose of change management in SAS Data Integration Studio is to manage:

A.

metadata objects across metadata servers

B.

metadata objects within a logged on user's personal folder

C.

metadata objects within a metadata server

D.

metadata objects within a logged on user's Checkouts Tree

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

A.

SCD Type 2 Loader

B.

Data Validation

C.

Lookup

D.

DataFlux IS Job

When exporting a SAS package file using SAS Data Integration Studio, where can it be saved?

A.

in metadata

B.

on any machine that SAS Data Integration Studio can write to

C.

in a SAS catalog

D.

only on the machine where SAS Data Integration Studio is running

Which action is required for enabling performance statistics on the executing SAS Workspace Server?

A.

Define a logfile for output.

B.

Define Collect Diagnostics for the SAS Data Integration Studio job.

C.

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

D.

Enable the logging facility of the SAS Workspace Server.

In SAS Data Integration Studio, source table records and dimension table records are combined for output using which transformation?

A.

Data Validation

B.

Lookup

C.

DataFlux IS Job

D.

Table Loader