SAS Institute A00-260 Online Practice Questions and Exam Preparation

SAS Institute A00-260 Online Questions & Answers

• Question 61:

  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.
  A. A comma delimited flat file that contains the field names in the first row.
  C. A SAS table scheme that is generated by SAS.

• Question 62:

  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.
  C. Loads source table records into a dimension table.

• Question 63:

  Registering metadata for an ODBC data source involves registering:

  A. a library that will use a SAS/ACCESS engine to a specific database
  B. only an ODBC data source definition
  C. a server definition that points to the ODBC data source and a library accessing this server definition
  D. a table pointing directly to the ODBC data source
  C. a server definition that points to the ODBC data source and a library accessing this server definition

• Question 64:

  In the following display, can status handling be enabled for both the Extract transformation and the Sort transformation?

  

  A. Yes. The Return Code Check transformation can be added to the job flow immediately following the Sort transformation - the Status Handling tab in this Return Code Check transformation properties can then establish the desired status handling for both the Extract and Sort transformations.
  B. No. Both the Extract and the Sort transformations do not have a Status Handling tab in their corresponding properties window, therefore it is not possible to establish status handling for these transformations.
  C. Yes. The Return Code Check transformation can be added to the job flow twice, once immediately following the Extract, and again immediately following the Sort - the Status Handling tab in each of the Return Code Check transformations properties can then establish the desired status handling.
  D. Yes. The status handling tab in the job properties window will allow you to select which transformation (or even several transformations) that you want to define status handling for.
  C. Yes. The Return Code Check transformation can be added to the job flow twice, once immediately following the Extract, and again immediately following the Sort - the Status Handling tab in each of the Return Code Check transformations properties can then establish the desired status handling.

• Question 65:

  Within SAS Data Integration Studio, how is the internal code of a SAS Code transformation assigned to its options?

  A. SAS macro variables
  B. columns of SAS datasets
  C. SAS formats
  D. SAS macro calls
  A. SAS macro variables

• Question 66:

  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.
  D. The COL1 columns are successfully mapped, one-to-one, but a warning occurs.

• Question 67:

  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.
  C. Setting up of SAS Application Servers.

• Question 68:

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

• Question 69:

  Which batch server is queried to retrieve the command needed to run traditional .SAS programs having DATA and PROC steps?

  A. SAS Java Batch Server
  B. SAS DATA Step Batch Server
  C. SAS Generic Batch Server
  D. SAS PROC Step Batch Server
  B. SAS DATA Step Batch Server

• Question 70:

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

  A. generate cpu statistics
  B. generate a datetime value
  C. generates cluster numbers
  D. generates standardization values
  B. generate a datetime value