A00-260 Exam Questions

In the following display, can status handling be enabled for both the Extract transformation and the Sort transformation?

When writing postcode in the Precode and Postcode tab of the Transpose transformation in SAS Data Integration Studio, which symbol allows you to reference the transformation output...

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?

An identity hierarchy specifies a list of identities and the order of precedence of those identities. Which listing of identities is ranked from highest priority to lowest priority...

Which statement best describes a deployment directory as used in the Schedule Manager in SAS Management Console?

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

Which of the following are SAS Data Integration Studio job deployment types? (Choose two.)

A SAS Data Integration Studio job was successfully scheduled and the appropriate event for triggering it occurred. Which statement describes the situation correctly?

Which statement defines the characteristics of a SAS Stored Process?

Which batch server is queried to retrieve the command needed to run traditional .SAS programs having DATA and PROC steps?

In SAS Data Integration Studio, primary keys, foreign keys and unique keys can be specified/defined in which location?

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

In SAS Data Integration Studio, an index can be specified/defined in which location?

Which statement is FALSE regarding foreign keys?

Assume that SAS Data Integration Studio Table Loader is being used in a job. The load style selected is Append to Existing. Which statement is true regardingAssume that SAS Data In...

Select the valid reasons for using SAS Data Integration Studio's Table Loader transformation. (Choose two.)

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 Int...

When using the Table Loader transformation to load an existing target table that contains one or more indexes in SAS Data Integration Studio, which statement is true?

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 f...

Which statement is true regarding SAS packages created in SAS Data Integration Studio?

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

Within SAS Data Integration Studio, automatic mappings are disabled for a job. A transformation has defined source columns and defined target columns. One of the source columns, na...

The profile reports generated in dfPower Profile jobs are viewed:

A SAS administrator has performed the "Clear Projects" action to remove the lock on a SAS Data Integration Studio job called "Create Tables" that some user has checked out in their...

Which statement best describes the DataFlux Integration Server?

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

The SAS platform application that can surface the different types of business and analytic content such as information maps, stored processes, and reports on the web browser is:

A user needs to find out who has the SAS Data Integration Studio job "Create Tables" checked out. What action should the user perform?

Within SAS Data Integration Studio, how is the internal code of a SAS Code transformation assigned to its options?

How can you test the interaction of the options of a SAS Data Integration Studio Generated transformation?

Within SAS Data Integration Studio, how many inputs and outputs can be defined for a Generated transformation?

How can you make a SAS Data Integration Studio Generated transformation option required?

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

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

In SAS Data Integration Studio, surrogate and retained key values are:

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

When using the SCD Type 2 load method in SAS Data Integration Studio, which statement is true when a change is detected?

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

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

In SAS Data Integration Studio, where must the columns included in a business key exist?

Which action is performed by the Lookup transformation in SAS Data Integration Studio?

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

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

Assume that you have completed the Register Tables wizard in SAS Data Integration Studio. Which statement is true?

You want to register an external file with the following structure: first line contains Customer First and Last Name second line is address1 third line is address 2 fourth line con...

Registering metadata for an ODBC data source involves registering:

SAS Data Integration Studio is dependent on which administration functions?

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?

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

Metadata repositories are a collection of files in a physical folder. In what format are the files stored?