SAS Institute A00-260 Online Practice Questions and Exam Preparation

SAS Institute A00-260 Online Questions & Answers

• Question 1:

  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
  D. SAS Management Console

• Question 2:

  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
  C. generated by the SCD Type 2 Loader transformation

• Question 3:

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

  A. 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.
  B. The options can be tested after finalizing and saving the transformation with the Test Prompt item on the Tools menu.
  C. 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.
  D. 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 at any time after adding them to the transformation with the Test Prompt button in the Options window of the New Transformation wizard.

• Question 4:

  Which statement is true regarding SAS packages created in SAS Data Integration Studio?

  A. SAS packages are used to import and export SAS applications.
  B. SAS packages are used to import and export stand-alone SAS programs.
  C. SAS packages are used to import and export third-party metadata.
  D. SAS packages are used to import and export SAS metadata.
  D. SAS packages are used to import and export SAS metadata.

• Question 5:

  When using the Table Loader transformation to load an existing target table that contains one or more indexes in SAS Data Integration Studio, which statement is true?

  A. Indexes are removed when the Table Loader executes and must be re-created using the Table Structure transformation.
  B. Indexes are automatically preserved when the Table Loader executes.
  C. Indexes are removed at the beginning of the load process and must be re-created in a subsequent job step.
  D. Indexes can be removed or preserved at the beginning of the process depending on options chosen. Additional table loader options specify whether to re-create the index at the end of the process.
  D. Indexes can be removed or preserved at the beginning of the process depending on options chosen. Additional table loader options specify whether to re-create the index at the end of the process.

• Question 6:

  Which statement regarding scheduling SAS Data Integration Studio jobs is true?

  A. To schedule a job flow you must first use SAS Management Console to deploy the job for scheduling.
  B. To schedule the job on the Platform Process Manager you require a dependency generator.
  C. Multiple job flows can be scheduled to a deployment directory.
  D. To schedule a job flow in SAS Management console you must first deploy the job for scheduling using SAS Data Integration Studio.
  D. To schedule a job flow in SAS Management console you must first deploy the job for scheduling using SAS Data Integration Studio.

• Question 7:

  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.
  B. You can control the removal and/or creation of indexes and constraints in the target table for all Load Styles.

• Question 8:

  In SAS Data Integration Studio, an index can be specified/defined in which location?

  A. the Indexes tab in the properties of a Table Loader transformation
  B. the Indexes tab in the properties of a table metadata object
  C. the Indexes tab in the properties for any transformation
  D. the Indexes tab in the properties of a job metadata object
  B. the Indexes tab in the properties of a table metadata object

• Question 9:

  Assume that SAS Data Integration Studio Table Loader is being used in a job. The load style selected is Append to Existing. Which statement is true regardingAssume that SAS Data Integration Studio? Table Loader is being used in a job. The load style selected is Append to Existing. Which statement is true regarding this load style?

  A. It generates PROC APPEND code.
  B. It generates PROC SQL code.
  C. It generates either PROC SQL code or PROC APPEND code depending on further option choices.
  D. It generates DATA STEP APPEND code.
  C. It generates either PROC SQL code or PROC APPEND code depending on further option choices.

• Question 10:

  Which statements are true regarding columns when using SAS Data Integration Studio's New Tables wizard? 1. You can access metadata for any column from any table already registered in metadata but cannot change it. 2. You can access metadata for any column from any table already registered in metadata and can override the imported information. 3. You can define new columns for the table. 4. You cannot define new columns.

  A. 1 and 2
  B. 1 and 3
  C. 2 and 3
  D. 2 and 4
  C. 2 and 3