A00-260 Online Practice Questions and Answers

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.

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.

Which statement regarding scheduling SAS Data Integration Studio jobs is true?

A. To schedule a job flow you must first use SAS Management Console to deploy the job for scheduling.

B. To schedule the job on the Platform Process Manager you require a dependency generator.

C. Multiple job flows can be scheduled to a deployment directory.

D. To schedule a job flow in SAS Management console you must first deploy the job for scheduling using SAS Data Integration Studio.

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.

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.

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 definition cannot be imported using a SAS Metadata Bridge?

A. Server definition

B. Library definition

C. Table definition

D. Column Definition

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, named COL1, is character with a length of 50. One of the target columns, named COL1, is also character but of length 25. What will happen if the COL1 columns are mapped?

A. The COL1 columns are successfully mapped, one-to-one, with no warnings.

B. The COL1 columns are not mapped because the lengths are different.

C. The COL1 columns are mapped but an expression is defined for the target COL1 that uses a generic specification of the LENGTH function.

D. The COL1 columns are successfully mapped, one-to-one, but a warning occurs.

Which statement best describes the DataFlux Integration Server?

A. An application server that executes service requests based on Simple Object Access Protocol (SOAP) to call dfPower Architect or dfPower Profile jobs.

B. A plug-in to SAS Data Integration Studio allowing you to design jobs specialized for data cleansing operations.

C. An application interface that allows you to build dfPower Architect and dfPower Profile jobs specialized for data cleansing operations.

D. A third party server defined in the SAS metadata repository that allows you to build flows integrating multiple jobs and establishing job dependencies within the flow.

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