SAS Institute SAS Institute Certifications A00-260 Questions & Answers

• Question 11:

  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.

  Correct Answer: C

• Question 12:

  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.

  Correct Answer: C

• Question 13:

  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.

  Correct Answer: C

• Question 14:

  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

  Correct Answer: A

• Question 15:

  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.

  Correct Answer: D

• Question 16:

  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.

  Correct Answer: C

• Question 17:

  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

  Correct Answer: A

• Question 18:

  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

  Correct Answer: C

• Question 19:

  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.

  Correct Answer: A

• Question 20:

  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

  Correct Answer: A