A00-260 Online Practice Questions and Answers

Within SAS Data Integration Studio, which one of the following is NOT an option available from the File-> New menu choice under External File grouping?

A. Delimited

B. Fixed Width

C. User Written

D. COBOL Copybook

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

A. Yes. The Return Code Check transformation can be added to the job flow immediately following the Sort transformation - the Status Handling tab in this Return Code Check transformation properties can then establish the desired status handling for both the Extract and Sort transformations.

B. No. Both the Extract and the Sort transformations do not have a Status Handling tab in their corresponding properties window, therefore it is not possible to establish status handling for these transformations.

C. Yes. The Return Code Check transformation can be added to the job flow twice, once immediately following the Extract, and again immediately following the Sort - the Status Handling tab in each of the Return Code Check transformations properties can then establish the desired status handling.

D. Yes. The status handling tab in the job properties window will allow you to select which transformation (or even several transformations) that you want to define status handling for.

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

Within SAS Data Integration Studio, which type of expression can be created using the Expression Builder window in the Where tab of SAS Extract transformation? 1) a SAS expression 2) an SQL expression 3) an XML expression 4) a constant

A. 1 and 2 only

B. 1 and 3 only

C. 1, 2 and 4 only

D. 1, 2, 3, and 4

Consider the job flow diagram in the display. Assume the inner job has a parameter defined specifying a table name. Which statement is FALSE?

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

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

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

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

Which statement is FALSE regarding foreign keys?

A. A foreign key is one or more columns that are associated with a primary key or unique key in another table.

B. A table can have zero or more foreign keys.

C. A foreign key cannot exist without an associated primary or unique key.

D. A table can have only one foreign key defined.

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

A. Create and replace permanent tables.

B. Maintain access privileges to permanent tables.

C. Apply and maintain constraints on permanent tables.

D. Delete and remove permanent tables.

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 Integration Studio? Table Loader is being used in a job. The load style selected is Update/Insert. Which statement is true regarding the relationship between the source table and the target table?

A. From the source table, matching rows are updated in the target table and new rows are added.

B. From the source table, matching rows AND new rows are added, but the original matching row in the target table is marked as inactive.

C. From the source table, matching rows are skipped, and new rows are added.

D. A or C, depending on further options chosen.

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

A. SAS packages are used to import and export SAS applications.

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

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

D. SAS packages are used to import and export SAS metadata.

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 statements are true regarding columns when using SAS Data Integration Studio's New Tables wizard? 1. You can access metadata for any column from any table already registered in metadata but cannot change it. 2. You can access metadata for any column from any table already registered in metadata and can override the imported information. 3. You can define new columns for the table. 4. You cannot define new columns.

A. 1 and 2

B. 1 and 3

C. 2 and 3

D. 2 and 4

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, how many inputs and outputs can be defined for a Generated transformation?

A. A transformation can have zero or more inputs and exactly one output.

B. A transformation needs at least one input and at least one output.

C. A transformation can have zero or more inputs and zero or more outputs.

D. A transformation needs at least one input and exactly one output.

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

A. The name of the option has to start with _REQUIRED.

B. The type of the column has to be defined as Required Data source column.

C. The option can be marked as Requires a non-blank value.

D. It is not possible to make an option required.

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

A. find row matches using the business key

B. find row matches using generated cluster numbers

C. find non-standard values using a generated key

D. find non-standard values using a business key