Online Access Free A00-260 Exam Questions

How can you test the interaction of the options of a SAS Data Integration Studio Generated transformation?

• A.The options can be tested after finalizing and saving the transformation with the Test Prompt item on the Tools menu.
• B.The transformation has to be used within a job to interactively test the options with the Test Prompt button in the Options window from the properties of the transformation within the job editor.
• C.The options can be tested at any time after adding them to the transformation with the Test Prompt button in the Options window of the New Transformation wizard.
• D.The options can be tested only after adding all options that are assigned to the source code with the Test Prompt button in the Options window of the New Transformation wizard.

In SAS Data Integration Studio, source table records and dimension table records are combined for output using which transformation?

• A.Table Loader
• B.Data Validation
• C.Lookup
• D.DataFlux IS Job

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 third party RDBMS table that has been generated by the SAS system.
• B.A SAS table scheme that is generated by SAS.
• C.Power scheme that is generated by Data Flux.
• D.A comma delimited flat file that contains the field names in the first row.

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.If using the Append to Existing load style, indexes and constraints can be added but not removed.
• C.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.
• D.You can control the removal and/or creation of indexes and constraints in the target table for all Load Styles.

In SAS Data Integration Studio, which statement is FALSE regarding status handling?

• A.When a job is executed in SAS Data Integration Studio, a return code for each
  transformation in the job is
  captured in a macro variable. The return code for the job is set to the least successful
  transformation in the
  job. SAS Data Integration Studio enables you to associate a return code condition, such as
  Successful, with an
  action, such as Send Email.
• B.The available Condition/Action pairs for transformations and jobs will vary - that is,
  different
  Condition/Action pairs may exist for the SQL Join transformation versus the Table Loader
  transformation.
• C.If status handling has been defined for a transformation or the job, a macro definition
  (and a call to it)
  will be added to the generated code to check for the specified condition(s).
• D.Only one Condition/Action pair can be defined for a single transformation or for a job.