A00-260 Practice Exam Questions and Answers

A.  

HTML

B.  

PDF

C.  

RTF

D.  

XML

A.  

Yes. 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.

B.  

No. 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.

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.

D.  

Yes. 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.

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.

A.  

SAS packages are used to import and export SAS applications.

B.  

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

C.  

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

D.  

SAS packages are used to import and export SAS metadata.

A.  

A folder or directory location on a server where the SAS code from a deployed SAS Data integration Studio job is stored.

B.  

A location in the metadata repository where job flows are deployed.

C.  

A location in the SAS Management console job directory storing the metadata for jobs that can be added to job flows.

D.  

A SAS Folder in the Schedule Manager plug-in within SAS Management Console containing listings of all flows organized by server type.

A.  

A foreign key is one or more columns that are associated with a primary key or unique key in another table.

B.  

A table can have zero or more foreign keys.

C.  

A foreign key cannot exist without an associated primary or unique key.

D.  

A table can have only one foreign key defined.

A.  

Use the New User Written External File wizard.

B.  

Use the New Fixed Width External File wizard.

C.  

Use the New Delimited External File wizard.

D.  

Use the New COBOL Copybook wizard.

A.  

SAS Information Delivery Portal

B.  

SAS Information Map Studio

C.  

SAS Web Report Studio

D.  

SAS OLAP Cube Studio

A.  

the old record is deleted and the changed record is added

B.  

the old record is updated with the new values from the changed record

C.  

the old record is flagged and the changed record is added

D.  

the old record is merged with the changed record

A.  

Data Transfer

B.  

Data Validation

C.  

Data Quality

D.  

Data Extract