Free A00-260 – SAS Data Integration Development for SAS 9 Practice Test Question

Select all that apply, then click Submit answer.

• ○

  A comma delimited flat file that contains the field names in the first row.

• ○

  Power scheme that is generated by Data Flux.

• ○

  A SAS table scheme that is generated by SAS.

• ○

  A third party RDBMS table that has been generated by the SAS system.
  

Select all that apply, then click Submit answer.

• ○

  Create and replace permanent tables.

• ○

  Maintain access privileges to permanent tables.

• ○

  Apply and maintain constraints on permanent tables.

• ○

  Delete and remove permanent tables.
  

Select all that apply, then click Submit answer.

• ○

  a Web service

• ○

  a SAS Stored Process

• ○

  a Java Runtime Process

• ○

  a SAS Information Map that is accessible in SAS Web Report Studio
  

Select an option, then click Submit answer.

• ○

  An application server that executes service requests based on Simple Object Access Protocol (SOAP) to call dfPower Architect or dfPower Profile jobs.

• ○

  A plug-in to SAS Data Integration Studio allowing you to design jobs specialized for data cleansing operations.

• ○

  An application interface that allows you to build dfPower Architect and dfPower Profile jobs specialized for data cleansing operations.

• ○

  A third party server defined in the SAS metadata repository that allows you to build flows integrating multiple jobs and establishing job dependencies within the flow.
  

Select an option, then click Submit answer.

• ○

  The physical table(s) selected are copied to the application server specified in the library.

• ○

  The physical table(s) selected are copied to the SAS Folders location specified in the wizard.

• ○

  Metadata for the physical table(s) selected is stored on the application server specified in the library.

• ○

  Metadata for the physical table(s) selected is stored in the SAS Folders location specified in the wizard.

Select an option, then click Submit answer.

• ○

  Delimited

• ○

  Fixed Width

• ○

  User Written

• ○

  COBOL Copybook
  

Select an option, then click Submit answer.

• ○

  The Inner Job can be successfully executed by itself, but only if the defined parameter has been assigned a valid default value.

• ○

  The Inner Job cannot be successfully executed by itself unless it is disassociated from the loop job.

• ○

  The Control Table column is mapped to the parameter defined for the Inner Job using the Loop transformation properties window.

• ○

  If the server that executes the job has multiple CPUs, parallel processing can be enabled in the Loop transformation properties window.
  

Select an option, then click Submit answer.

• ○

  Control table

• ○

  Loop transformation

• ○

  Inner Job

• ○

  Loop End