SAS Institute A00-260 - SAS Data Integration Development Exam
Page: 2 / 14
Total 70 questions
Question #6 (Topic: )
Which of the following is NOT defined as part of the New Library Wizard?
A. the type of library
B. the metadata name for the library
C. the location of the library
D. the metadata for the library tables
Answer: D
Question #7 (Topic: )
Within SAS Data Integration Studio, which one of the following is NOT an option available
from the File-> New menu choice under External File grouping?
from the File-> New menu choice under External File grouping?
A. Delimited
B. Fixed Width
C. User Written
D. COBOL Copybook
Answer: D
Question #8 (Topic: )
Which statement correctly defines a System DSN?
A. Not specific to an individual user. Anyone with permission to access the data source can use it.
B. Specific to an individual user. It is available only to the user who creates it.
C. Not specific to an individual user. It can be shared among users even though it is created locally.
D. Specific to an individual user. But it can be shared among users.
Answer: A
Question #9 (Topic: )
In the following display, can status handling be enabled for both the Extract transformation
and the Sort transformation?
and the Sort transformation?
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.
Answer: C
Question #10 (Topic: )
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?
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
