A00-260 Online Practice Questions and Answers

Consider the job flow diagram in the display. Which of these objects has parameters defined for it?

A. Control table

B. Loop transformation

C. Inner Job

D. Loop End

Which of the following is NOT a feature of SAS Data Integration Studio's Data Validation transformation?

A. The Data Validation transformation can generate match codes to provide de-duplication capabilities.

B. The Data Validation transformation can perform missing-value detection and invalid- value validation in a single pass of the data.

C. The Data Validation transformation provides de-duplication capabilities.

D. The Data Validation transformation provides error-condition handling.

In SAS Data Integration Studio, which statement is FALSE regarding status handling?

A. When a job is executed in SAS Data Integration Studio, a return code for each transformation in the job is captured in a macro variable. The return code for the job is set to the least successful transformation in the job. SAS Data Integration Studio enables you to associate a return code condition, such as Successful, with an action, such as Send Email.

B. If status handling has been defined for a transformation or the job, a macro definition (and a call to it) will be added to the generated code to check for the specified condition(s).

C. Only one Condition/Action pair can be defined for a single transformation or for a job.

D. The available Condition/Action pairs for transformations and jobs will vary - that is, different Condition/Action pairs may exist for the SQL Join transformation versus the Table Loader transformation.

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

A. The scheduling server calls the SAS DATA Step Batch Server over the SAS Object Server which spawns the job, getting its source code from the deployment directory, and sends the results directly to the Schedule Manager plug-in of the SAS Management Console.

B. The scheduling server uses the command obtained from the SAS DATA Step Batch Server and the source code from the deployment directory to run the job. The results from the executing command are directly sent to the scheduling server.

C. The scheduling server uses the command from the deployed job in the deployment directory and executes it with the SAS DATA Step Batch Server which gets the source code from the Metadata Server. The results are sent back to the deployment directory.

D. The scheduling server uses the command obtained from the Schedule Manager, the source code from SAS DATA Step Batch Server and executes it. The results are directly sent to the scheduling server.

Which statement defines the characteristics of a SAS Stored Process?

A. SAS metadata that describes how to collect and store data sources.

B. A document that stores the steps and locations for building a data mart.

C. A SAS program that is stored on the server and described by metadata.

D. A user written SAS PROC step.

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

A. the Keys tab in the properties of a Table Loader transformation

B. the Keys tab in the properties for any transformation

C. the Keys tab in the properties of a table metadata object

D. the Keys tab in the properties of a job metadata object

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.

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.

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.

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