SAS Data Integration Development v6.0 (A00-260)

Page:    1 / 5   
Total 77 questions

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


Answer : B

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


Answer : A

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


Answer : C

Within SAS Data Integration Studio, automatic mappings are disabled for a job. A transformation has defined source columns and defined target columns. One of the source columns, named COL1, is character with a length of 50. One of the target columns, named
COL1, is also character but of length 25. What will happen if the COL1 columns are mapped?

  • A. The COL1 columns are successfully mapped, one-to-one, with no warnings.
  • B. The COL1 columns are not mapped because the lengths are different.
  • C. The COL1 columns are mapped but an expression is defined for the target COL1 that uses a generic specification of the LENGTH function.
  • D. The COL1 columns are successfully mapped, one-to-one, but a warning occurs.


Answer : D

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


Answer : A

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.


Answer : C

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.


Answer : A

The purpose of change management in SAS Data Integration Studio is to manage:

  • A. metadata objects across metadata servers
  • B. metadata objects within a logged on user's personal folder
  • C. metadata objects within a metadata server
  • D. metadata objects within a logged on user's Checkouts Tree


Answer : C

The SAS platform application that can surface the different types of business and analytic content such as information maps, stored processes, and reports on the web browser is:

  • A. SAS Information Delivery Portal
  • B. SAS Information Map Studio
  • C. SAS Web Report Studio
  • D. SAS OLAP Cube Studio


Answer : A

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.


Answer : C

Within SAS Data Integration Studio, how is the internal code of a SAS Code transformation assigned to its options?

  • A. SAS macro variables
  • B. columns of SAS datasets
  • C. SAS formats
  • D. SAS macro calls


Answer : A

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.


Answer : D

Within SAS Data Integration Studio, how many inputs and outputs can be defined for a
Generated transformation?

  • A. A transformation can have zero or more inputs and exactly one output.
  • B. A transformation needs at least one input and at least one output.
  • C. A transformation can have zero or more inputs and zero or more outputs.
  • D. A transformation needs at least one input and exactly one output.


Answer : C

How can you make a SAS Data Integration Studio Generated transformation option required?

  • A. The name of the option has to start with _REQUIRED.
  • B. The type of the column has to be defined as Required Data source column.
  • C. The option can be marked as Requires a non-blank value.
  • D. It is not possible to make an option required.


Answer : C

The SAS Data Integration Studio SCD Type 2 Loader transformation performs which of the following?

  • A. Loads source table records into a standardization table.
  • B. Loads dimension table records into a fact table.
  • C. Loads source table records into a dimension table.
  • D. Loads fact table records into a multi-threaded table.


Answer : C

Page:    1 / 5   
Total 77 questions