SAS A00-260 Exam Questions Instant Access

Question 1

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?

AThe COLI columns are successfully mapped, one-to-one, with no warnings.

BThe COLI columns are not mapped because the lengths are different.

CThe COLI columns are mapped but an expression is defined for the target COLI that uses a generic specification of the LENGTH function.

DThe COLI columns are successfully mapped, one-to-one, but a warning occurs.

Answer : D

Question 2

Registering metadata for an ODBC data source involves registering:

Aa library that will use a SASIACCESS engine to a specific database

Bonly an ODBC data source definition

Ca server definition that points to the ODBC data source and a library accessing this server definition

Da table pointing directly to the ODBC data source

Answer : C

Question 3

In SAS Data Integration Studio, surrogate and retained key values are:

Agenerated by the Lookup transformation

Bcopied from source tables into dimension tables

Cgenerated by the SCD Type 2 Loader transformation

Dcopied from dimension tables into source tables

Answer : C

Question 4

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

AHTML

BPDF

CRTF

DXML

Answer : A

Question 5

A fact table is populated by using which transformation in SAS Data Integration Studio?

ASCDType2 Loader

BData Validation

CLookup

DDataFlux lS Job

Answer : C

Question 6

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

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

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

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

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

Answer : B

Question 7

Which statement is true regarding SAS packages created in SAS Data Integration Studio?

SAS Certified Data Integration Developer for SAS A00-260 Exam Questions