A00-260 Online Practice Questions and Answers

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

A. The physical table(s) selected are copied to the application server specified in the library.

B. The physical table(s) selected are copied to the SAS Folders location specified in the wizard.

C. Metadata for the physical table(s) selected is stored on the application server specified in the library.

D. Metadata for the physical table(s) selected is stored in the SAS Folders location specified in the wizard.

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.

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 batch server is queried to retrieve the command needed to run traditional .SAS programs having DATA and PROC steps?

A. SAS Java Batch Server

B. SAS DATA Step Batch Server

C. SAS Generic Batch Server

D. SAS PROC Step Batch Server

How do you enable performance statistics for a SAS Data Integration Studio job?

A. Define Collect Runtime Statistics on the SAS Data Integration Studio job.

B. Define Collect Table Statistics on the SAS Data Integration Studio job.

C. Define Collect Diagnostics on the SAS Data Integration Studio job.

D. Define Collect Table Statistics on the SAS Data Integration Studio options.

In SAS Data Integration Studio, which output format is supported for the default "out-of-the- box" job report?

A. HTML

B. PDF

C. RTF

D. XML

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

A. metadata objects across metadata servers

B. metadata objects within a logged on user's personal folder

C. metadata objects within a metadata server

D. metadata objects within a logged on user's Checkouts Tree

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.

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

A. SCD Type 2 Loader

B. Data Validation

C. Lookup

D. DataFlux IS Job

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

A. in the source and standardization tables

B. in the source and dimension tables

C. in the target and fact tables

D. in the source, dimension and standardization tables