Free Practice Questions for SAS A00-260 Exam

Question 1

Which of the following are SAS Data Integration Studio job deployment types? (Choose two.)

Aa Web service

Ba SAS Stored Process

Ca Java Runtime Process

Da SAS Information Map that is accessible in SAS Web Report Studio

Correct Answer: B. a SAS Stored Process; D. a SAS Information Map that is accessible in SAS Web Report Studio

Question 2

In the following display, can status handling be enabled for both the Extract transformation and the Sort transformation?

AYes. The Return Code Check transformation can be added to the job flow immediately following the Sort transformation - the Status Handling tab in this Return Code Check transformation properties can then establish the desired status handling for both the Extract and Sort transformations.

BNo. Both the Extract and the Sort transformations do not have a Status Handling tab in their corresponding properties window, therefore it is not possible to establish status handling for these transformations.

CYes. The Return Code Check transformation can be added to the job flow twice, once immediately following the Extract, and again immediately following the Sort - the Status Handling tab in each of the Return Code Check transformations properties can then establish the desired status handling.

DYes. The status handling tab in the job properties window will allow you to select which transformation (or even several transformations) that you want to define status handling for.

Correct Answer: C. Yes. The Return Code Check transformation can be added to the job flow twice, once immediately following the Extract, and again immediately following the Sort - the Status Handling tab in each of the Return Code Check transformations properties can then establish the desired status handling.

Question 3

In SAS Data Integration can be specified/defined Studio, primary keys, foreign keys and unique keys in which location?

Athe Keys tab in the properties of a Table Loader transformation

Bthe Keys tab in the properties for any transformation

Cthe Keys tab in the properties of a table metadata object

Dthe Keys tab in the properties of a job metadata object

Correct Answer: C. the Keys tab in the properties of a table metadata object

Question 4

In SAS Data Integration Studio, which component allows the definition of job flows with dependencies between different jobs?

Athe deployment wizard of SAS Data Integration Studio

Bthe Scheduling Manager plug-in in SAS Management Console

Cthe Scheduling Server

Dthe SAS DATA Step Batch Server

Correct Answer: B. the Scheduling Manager plug-in in SAS Management Console

Question 5

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

AHTML

BPDF

CRTF

DXML

Correct Answer: A. HTML

Question 6

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

ASAS macro variables

Bcolumns of SAS datasets

CSAS formats

DSAS macro calls

Correct Answer: A. SAS macro variables

Question 7

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

ASAS packages are used to import and export SAS applications.

BSAS packages are used to import and export stand-alone SAS programs.

CSAS packages are used to import and export third-party metadata.

DSAS packages are used to import and export SAS metadata.

Correct Answer: D. SAS packages are used to import and export SAS metadata.

Question 8

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.

Correct Answer: D. The COLI columns are successfully mapped, one-to-one, but a warning occurs.

Question 9

In SAS Data Integration Studio, the default values for generated surrogate and retained keys contain which type of values?

Adatetime values

Balpha-numeric values

Cbinary values

Dinteger values

Correct Answer: D. integer values

Question 10

Which statement defines the characteristics of a SAS Stored Process?

ASAS metadata that describes how to collect and store data sources.

BA document that stores the steps and locations for building a data mart.

CA SAS program that is stored on the server and described by metadata.

DA user written SAS PROC step.

Correct Answer: C. A SAS program that is stored on the server and described by metadata.