SAS a00-260 practice test

SAS Certified Data Integration Developer for SASExam


Question 1

Which statement regarding propagation is FALSE?

  • A. Automatic propagation can be set globally, so every new job will automatically propagate.
  • B. Propagation can only occur in the direction of the job flow diagram (from beginning to end). Propagation from the end to the beginning is not available.
  • C. Automatic propagation that is set globally can be overridden and disabled within a job.
  • D. Automatic propagation that is set globally or at the job level can be overridden and disabled for a selected transformation.
Answer:

B

Discussions

Question 2

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 COLI, is
character with a length of 50. One of the target columns, named COLI, is also character but of length
25. What will happen if the COLI columns are mapped?

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

D

Discussions

Question 3

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.
Answer:

B

Discussions

Question 4

Within SAS Data Integration Studio, which type of expression can be created using the Expression
Builder window in the Where tab of SAS Extract transformation? 1) a SAS expression 2) an SQL
expression 3) an XML expression 4) a constant

  • A. land2only
  • B. land3only
  • C. 1,2and4only
  • D. 1,2,3,and4
Answer:

C

Discussions

Question 5

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

  • A. a Where clause definition
  • B. an Expression Builder window
  • C. afield Expression definition
  • D. a Subquery definition
Answer:

B

Discussions

Question 6

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

Discussions

Question 7

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

Discussions

Question 8

Which statements are true regarding columns when using SAS Data Integration Studios 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. land2
  • B. land3
  • C. 2and3
  • D. 2and4
Answer:

C

Discussions

Question 9

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

Discussions

Question 10

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. &syslast
  • B. syslast
  • C. &target
  • D. %target
Answer:

A

Discussions
To page 2