SAS Institute A00-260 Online Practice Questions and Exam Preparation

SAS Institute A00-260 Online Questions & Answers

• Question 11:

  A user needs to find out who has the SAS Data Integration Studio job "Create Tables" checked out. What action should the user perform?

  A. They need to select the "Properties" menu option and then the "Advanced" tab for the SAS Data Integration Studio job "Create Tables" within Data Integration studio.
  B. They need to select the History menu option for the SAS Data Integration Studio job "Create Tables" once it has been checked in.
  C. They need to select the History menu option for the SAS Data Integration Studio job "Create Tables".
  D. They are not able to find out who has the SAS Data Integration Studio job "Create Tables" in checked out status because they are not an administrator.
  C. They need to select the History menu option for the SAS Data Integration Studio job "Create Tables".

• Question 12:

  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. 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).
  C. Only one Condition/Action pair can be defined for a single transformation or for a job.
  D. 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. Only one Condition/Action pair can be defined for a single transformation or for a job.

• Question 13:

  When writing postcode in the Precode and Postcode tab of the Transpose transformation in SAS Data Integration Studio, which symbol allows you to reference the transformation output table regardless of the actual physical name for that target table?

  A. andsyslast
  B. syslast
  C. andtarget
  D. %target
  A. andsyslast

• Question 14:

  The profile reports generated in dfPower Profile jobs are viewed: A. in dfPower Profile (Viewer)

  B. in the Reports tab of dfPower Profile (Configurator)
  C. in any HTML viewer
  D. in any text viewer
  A

• Question 15:

  The Platform Process Manager server is part of the Platform Suite for SAS. Which statement is FALSE regarding the Platform Process Manager server?

  A. The server enables you to schedule jobs using a variety of recurrence criteria and dependencies on other jobs, time events, or file events.
  B. The server enables you to schedule jobs using a variety of recurrence criteria but does NOT allow you to specify any type of dependencies.
  C. The Flow Manager application (part of the Platform Suite for SAS) can be used to manage already scheduled jobs.
  D. Metadata for the Platform Process Manager server must be defined and must include the network address or host name of a machine as well as the port number for the server.
  B. The server enables you to schedule jobs using a variety of recurrence criteria but does NOT allow you to specify any type of dependencies.

• Question 16:

  Within SAS Data Integration Studio's SQL Join transformation, the Validate Expression button is located in:

  A. a Where clause definition
  B. an Expression Builder window
  C. a field Expression definition
  D. a Subquery definition
  B. an Expression Builder window

• Question 17:

  A SAS administrator has performed the "Clear Projects" action to remove the lock on a SAS Data Integration Studio job called "Create Tables" that some user has checked out in their project repository. What will be the outcome of this action on the user's project repository?

  A. It will become empty and all new and checked out metadata objects will revert to the not checked out state.
  B. It will only contain the new metadata objects. All checked out metadata objects will revert to the not checked out state.
  C. It will become empty and the DI job called "Create Tables" will no longer be in a checked out state.
  D. It will become empty and will not be accessible until the administrator grants permissions for it to be used again.
  C. It will become empty and the DI job called "Create Tables" will no longer be in a checked out state.

• Question 18:

  Assume that SAS Data Integration Studio Table Loader is being used in a job. The load style selected is Update/Insert. Which statement is true regarding theAssume that SAS Data Integration Studio? Table Loader is being used in a job. The load style selected is Update/Insert. Which statement is true regarding the relationship between the source table and the target table?

  A. From the source table, matching rows are updated in the target table and new rows are added.
  B. From the source table, matching rows AND new rows are added, but the original matching row in the target table is marked as inactive.
  C. From the source table, matching rows are skipped, and new rows are added.
  D. A or C, depending on further options chosen.
  D. A or C, depending on further options chosen.

• Question 19:

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

  

  A. No. The Extract transformation does not have a status handling tab in its Properties window, and the Return Code Check transformation can only provide status handling at the job level.
  B. Yes. The Return Code Check transformation can be added to the END of the job flow - the Status Handling tab in the Return Code Check transformation properties can then establish the desired status handling.
  C. No. The Extract transformation does not have a Status Handling tab in its Properties window, therefore it is not possible to establish status handling for this transformation.
  D. Yes. The Return Code Check transformation can be added to the job flow immediately following the Extract - the Status Handling tab in the Return Code Check transformation properties can then establish the desired status handling.
  B. Yes. The Return Code Check transformation can be added to the END of the job flow - the Status Handling tab in the Return Code Check transformation properties can then establish the desired status handling.

• Question 20:

  Which of the following is NOT defined as part of the New Library Wizard?

  A. the type of library
  B. the metadata name for the library
  C. the location of the library
  D. the metadata for the library tables
  D. the metadata for the library tables