SAS Institute A00-260 Online Practice Questions and Exam Preparation

SAS Institute A00-260 Online Questions & Answers

• Question 21:

  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
  C. Inner Job

• Question 22:

  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.
  D. A table can have only one foreign key defined.

• Question 23:

  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
  A. SAS Information Delivery Portal

• Question 24:

  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
  D. COBOL Copybook

• Question 25:

  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.
  C. A SAS program that is stored on the server and described by metadata.

• Question 26:

  In SAS Data Integration Studio, the SCD Type 2 Loader transformation will do which of the following?

  A. find row matches using the business key
  B. find row matches using generated cluster numbers
  C. find non-standard values using a generated key
  D. find non-standard values using a business key
  A. find row matches using the business key

• Question 27:

  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.
  D. Enable the logging facility of the SAS Workspace Server.

• Question 28:

  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
  C. 1, 2 and 4 only

• Question 29:

  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
  A. Exhibit A

• Question 30:

  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
  C. Lookup