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.

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

When writing postcode in the Precode and Postcode tab of the Transpose transformation in SAS Data Integration Studio, which symbol allows you to reference the transformation output table regardless of the actual physical name for that target table?

A. andsyslast

B. syslast

C. andtarget

D. %target

Given the table below as a source table for the Transpose transformation in SAS Data Integration Studio:

In the Options tab in the Properties window for the Transpose transformation, if the columns are assigned as follows: Select columns to transpose (VAR statement): Payment Select a column for Output column names (ID statement): Month Select columns whose values define groups of records to transpose (BY statement): Name Which of the following tables is a possible resulting target table?

A. Exhibit A

B. Exhibit B

C. Exhibit C

D. Exhibit D

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.

In order to use the SAS Data Integration Studio's Apply Lookup Standardization transformation, Data Quality options must be setup. Select the valid Scheme Repository Types. (Choose two.)

A. A comma delimited flat file that contains the field names in the first row.

B. Power scheme that is generated by Data Flux.

C. A SAS table scheme that is generated by SAS.

D. A third party RDBMS table that has been generated by the SAS system.

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, an index can be specified/defined in which location?

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

B. the Indexes tab in the properties of a table metadata object

C. the Indexes tab in the properties for any transformation

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

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.

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's SQL Join transformation, the Validate Expression button is located in:

A. a Where clause definition

B. an Expression Builder window

C. a field Expression definition

D. a Subquery definition

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

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, the default values for generated surrogate and retained keys contain which type of values?

A. datetime values

B. alpha-numeric values

C. binary values

D. integer values