Effective Study Techniques for the SAS Institute A00-260 Exam

Questions 11

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

Options:

SAS packages are used to import and export SAS applications.

SAS packages are used to import and export stand-alone SAS programs.

SAS packages are used to import and export third-party metadata.

SAS packages are used to import and export SAS metadata.

Buy Now

Questions 12

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

Options:

The transformation has to be used within a job to interactively test the options with the Test Prompt button

in the Options window from the properties of the transformation within the job editor.

The options can be tested after finalizing and saving the transformation with the Test Prompt item on the

Tools menu.

The options can be tested only after adding all options that are assigned to the source code with the Test

Prompt button in the Options window of the New Transformation wizard.

The options can be tested at any time after adding them to the transformation with the Test Prompt button in

the Options window of the New Transformation wizard.

Buy Now

Questions 13

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

Options:

SAS Java Batch Server

SAS DATA Step Batch Server

SAS Generic Batch Server

SAS PROC Step Batch Server

Buy Now

Questions 14

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 project repository. What will be the outcome of this action on the user's project repository?

Options:

It will become empty and all new and checked out metadata objects will revert to the not checked out state.

It will only contain the new metadata objects. All checked out metadata objects will revert to the not checked

out state.

It will become empty and the DI job called "Create Tables" will no longer be in a checked out state.

It will become empty and will not be accessible until the administrator grants permissions for it to be used

again.

Buy Now

Questions 15

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

Options:

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

Buy Now

Questions 16

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

Options:

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.

Buy Now

Questions 17

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

Options:

generate cpu statistics

generate a datetime value

generates cluster numbers

generates standardization values

Buy Now

Questions 18

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

Options:

business key columns

Type 1 columns

generated columns

non-key columns

Buy Now

Questions 19

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 contains the phone number What action should you take to read this file?