SAS Institute A00-260 Online Practice Questions and Exam Preparation

SAS Institute A00-260 Online Questions & Answers

• Question 31:

  Which of the following is NOT a feature of SAS Data Integration Studio's Data Validation transformation?

  A. The Data Validation transformation can generate match codes to provide de-duplication capabilities.
  B. The Data Validation transformation can perform missing-value detection and invalid- value validation in a single pass of the data.
  C. The Data Validation transformation provides de-duplication capabilities.
  D. The Data Validation transformation provides error-condition handling.
  A. The Data Validation transformation can generate match codes to provide de-duplication capabilities.

• Question 32:

  When using the SCD Type 2 load method in SAS Data Integration Studio, which columns can be selected to check for changed data?

  A. business key columns
  B. Type 1 columns
  C. generated columns
  D. non-key columns
  D. non-key columns

• Question 33:

  Which definition cannot be imported using a SAS Metadata Bridge?

  A. Server definition
  B. Library definition
  C. Table definition
  D. Column Definition
  A. Server definition

• Question 34:

  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
  C. metadata objects within a metadata server

• Question 35:

  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.
  C. The option can be marked as Requires a non-blank value.

• Question 36:

  Which action is performed by the Lookup transformation in SAS Data Integration Studio?

  A. combines rows from multiple tables into a single row
  B. combines rows from multiple tables into multiple rows
  C. validates that values are unique
  D. validates that values are not null
  A. combines rows from multiple tables into a single row

• Question 37:

  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
  B. in the source and dimension tables

• Question 38:

  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.
  A. Use the New User Written External File wizard.

• Question 39:

  Within SAS Data Integration Studio, how many inputs and outputs can be defined for a Generated transformation?

  A. A transformation can have zero or more inputs and exactly one output.
  B. A transformation needs at least one input and at least one output.
  C. A transformation can have zero or more inputs and zero or more outputs.
  D. A transformation needs at least one input and exactly one output.
  C. A transformation can have zero or more inputs and zero or more outputs.

• Question 40:

  After creating a stored process from a SAS Data Integration Studio job, how can you test the stored process to make sure it runs correctly?

  A. Execute the stored process in SAS Data Integration Studio.
  B. Execute the stored process in SAS Management Console.
  C. Execute the stored process using the SAS Add-In for Microsoft Office or SAS Enterprise Guide.
  D. Execute the stored process using SAS Display Manager's Stored Process Test window.
  C. Execute the stored process using the SAS Add-In for Microsoft Office or SAS Enterprise Guide.