SAS Institute A00-260 Online Practice Questions and Exam Preparation

SAS Institute A00-260 Online Questions & Answers

• Question 41:

  Assume that you have completed the Register Tables wizard in SAS Data Integration Studio. Which statement is true?

  A. The physical table(s) selected are copied to the application server specified in the library.
  B. The physical table(s) selected are copied to the SAS Folders location specified in the wizard.
  C. Metadata for the physical table(s) selected is stored on the application server specified in the library.
  D. Metadata for the physical table(s) selected is stored in the SAS Folders location specified in the wizard.
  D. Metadata for the physical table(s) selected is stored in the SAS Folders location specified in the wizard.

• Question 42:

  When using SAS Data Integration Studio's SQL Join transformation, which SQL join type can be constructed as either an implicit or an explicit join?

  A. Union
  B. Full
  C. Inner
  D. Cross
  C. Inner

• Question 43:

  A SAS Data Integration Studio job was successfully scheduled and the appropriate event for triggering it occurred. Which statement describes the situation correctly?

  A. The scheduling server calls the SAS DATA Step Batch Server over the SAS Object Server which spawns the job, getting its source code from the deployment directory, and sends the results directly to the Schedule Manager plug-in of the SAS Management Console.
  B. The scheduling server uses the command obtained from the SAS DATA Step Batch Server and the source code from the deployment directory to run the job. The results from the executing command are directly sent to the scheduling server.
  C. The scheduling server uses the command from the deployed job in the deployment directory and executes it with the SAS DATA Step Batch Server which gets the source code from the Metadata Server. The results are sent back to the deployment directory.
  D. The scheduling server uses the command obtained from the Schedule Manager, the source code from SAS DATA Step Batch Server and executes it. The results are directly sent to the scheduling server.
  B. The scheduling server uses the command obtained from the SAS DATA Step Batch Server and the source code from the deployment directory to run the job. The results from the executing command are directly sent to the scheduling server.

• Question 44:

  In SAS Data Integration Studio, which output format is supported for the default "out-of-the- box" job report?

  A. HTML
  B. PDF
  C. RTF
  D. XML
  A. HTML

• Question 45:

  When exporting a SAS package file using SAS Data Integration Studio, where can it be saved?

  A. in metadata
  B. on any machine that SAS Data Integration Studio can write to
  C. in a SAS catalog
  D. only on the machine where SAS Data Integration Studio is running
  B. on any machine that SAS Data Integration Studio can write to

• Question 46:

  Which statement best describes the DataFlux Integration Server?

  A. An application server that executes service requests based on Simple Object Access Protocol (SOAP) to call dfPower Architect or dfPower Profile jobs.
  B. A plug-in to SAS Data Integration Studio allowing you to design jobs specialized for data cleansing operations.
  C. An application interface that allows you to build dfPower Architect and dfPower Profile jobs specialized for data cleansing operations.
  D. 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.
  A. An application server that executes service requests based on Simple Object Access Protocol (SOAP) to call dfPower Architect or dfPower Profile jobs.

• Question 47:

  Assume that a SAS Data Integration Studio job is populating a table, and the table has metadata definitions for two simple indexes. Which of the following is NOT a valid location for viewing which columns are indexed?

  A. the Load Technique tab in the Table Loader transformation properties window
  B. the Indexes tab in the table properties window
  C. the Columns tab in the table properties window
  D. the Columns tab in the Details panel of the open job, with the table selected in the job flow
  A. the Load Technique tab in the Table Loader transformation properties window

• Question 48:

  Consider the job flow diagram in the display. Assume the inner job has a parameter defined specifying a table name. Which statement is FALSE?

  

  A. The Inner Job can be successfully executed by itself, but only if the defined parameter has been assigned a valid default value.
  B. The Inner Job cannot be successfully executed by itself unless it is disassociated from the loop job.
  C. The Control Table column is mapped to the parameter defined for the Inner Job using the Loop transformation properties window.
  D. If the server that executes the job has multiple CPUs, parallel processing can be enabled in the Loop transformation properties window.
  B. The Inner Job cannot be successfully executed by itself unless it is disassociated from the loop job.

• Question 49:

  How do you enable performance statistics for a SAS Data Integration Studio job?

  A. Define Collect Runtime Statistics on the SAS Data Integration Studio job.
  B. Define Collect Table Statistics on the SAS Data Integration Studio job.
  C. Define Collect Diagnostics on the SAS Data Integration Studio job.
  D. Define Collect Table Statistics on the SAS Data Integration Studio options.
  A. Define Collect Runtime Statistics on the SAS Data Integration Studio job.

• Question 50:

  Select the valid reasons for using SAS Data Integration Studio's Table Loader transformation. (Choose two.)

  A. Create and replace permanent tables.
  B. Maintain access privileges to permanent tables.
  C. Apply and maintain constraints on permanent tables.
  D. Delete and remove permanent tables.
  C. Apply and maintain constraints on permanent tables.
  D. Delete and remove permanent tables.