A00-260 Online Practice Questions and Answers

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?

A. Use the New User Written External File wizard.

B. Use the New Fixed Width External File wizard.

C. Use the New Delimited External File wizard.

D. Use the New COBOL Copybook wizard.

SAS Data Integration Studio is dependent on which administration functions?

A. Setting up of SAS Information Map environment.

B. Setting up of SAS Web and SAS Portal environments.

C. Setting up of SAS Application Servers.

D. Setting up of SAS Libraries definitions.

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

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

You want to create a job that checks conditions for your data before that data is loaded into a data warehouse. The job should be able to detect error conditions such as missing data or duplicate data and take appropriate actions like registering error conditions in log, etc. Which SAS Data Integration Studio transformation should you use?

A. Data Transfer

B. Data Validation

C. Data Quality

D. Data Extract

Which of the following are SAS Data Integration Studio job deployment types? (Choose two.)

A. a Web service

B. a SAS Stored Process

C. a Java Runtime Process

D. a SAS Information Map that is accessible in SAS Web Report Studio

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.

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.

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.

The SAS platform application that can surface the different types of business and analytic content such as information maps, stored processes, and reports on the web browser is:

A. SAS Information Delivery Portal

B. SAS Information Map Studio

C. SAS Web Report Studio

D. SAS OLAP Cube Studio