A00-260 Online Practice Questions and Answers

The ability to deploy a SAS Data Integration Studio job as a Web service or a SAS Stored Process requires additional set up that is performed in which client application?

A. SAS Data Integration Studio

B. SAS Enterprise Guide

C. SAS Job Deployment Studio

D. SAS Management Console

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 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 statement is FALSE regarding foreign keys?

A. A foreign key is one or more columns that are associated with a primary key or unique key in another table.

B. A table can have zero or more foreign keys.

C. A foreign key cannot exist without an associated primary or unique key.

D. A table can have only one foreign key defined.

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.

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.

The SAS Data Integration Studio SCD Type 2 Loader transformation performs which of the following?

A. Loads source table records into a standardization table.

B. Loads dimension table records into a fact table.

C. Loads source table records into a dimension table.

D. Loads fact table records into a multi-threaded table.

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

In SAS Data Integration Studio, surrogate and retained key values are:

A. generated by the Lookup transformation

B. copied from source tables into dimension tables

C. generated by the SCD Type 2 Loader transformation

D. copied from dimension tables into source tables

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