SAS Institute A00-260 - SAS Data Integration Development Exam
Page: 3 / 14
Total 70 questions
Question #11 (Topic: )
Consider the job flow diagram in the display. Which of these objects has parameters
defined for it?
defined for it?
A. Control table
B. Loop transformation
C. Inner Job
D. Loop End
Answer: C
Question #12 (Topic: )
You want to create a table containing all customers from Italy. Assume that global
customer order information is available in a single table. Identify the SAS Data Integration
Studio transformation that will help you perform the task easily.
customer order information is available in a single table. Identify the SAS Data Integration
Studio transformation that will help you perform the task easily.
A. Append
B. Extract
C. Lookup
D. Mining Results
Answer: B
Question #13 (Topic: )
In the following display, can status handling be enabled for the Extract transformation?
A. No. The Extract transformation does not have a status handling tab in its Properties window, and the Return Code Check transformation can only provide status handling at the job level.
B. Yes. The Return Code Check transformation can be added to the END of the job flow - the Status Handling tab in the Return Code Check transformation properties can then establish the desired status handling.
C. No. The Extract transformation does not have a Status Handling tab in its Properties window, therefore it is not possible to establish status handling for this transformation.
D. Yes. The Return Code Check transformation can be added to the job flow immediately following the Extract - the Status Handling tab in the Return Code Check transformation properties can then establish the desired status handling.
Answer: B
Question #14 (Topic: )
You want to create a job that checks conditions for your data before that data is loaded into
a data warehouse. The job should be able to detect error conditions such as missing data
or duplicate data and take appropriate actions like registering error conditions in log, etc.
Which SAS Data Integration Studio transformation should you use?
a data warehouse. The job should be able to detect error conditions such as missing data
or duplicate data and take appropriate actions like registering error conditions in log, etc.
Which SAS Data Integration Studio transformation should you use?
A. Data Transfer
B. Data Validation
C. Data Quality
D. Data Extract
Answer: B
Question #15 (Topic: )
Given the table below as a source table for the Transpose transformation in SAS Data
Integration Studio:
In the Options tab in the Properties window for the Transpose transformation, if the
columns are assigned as follows:
Select columns to transpose (VAR statement): Payment
Select a column for Output column names (ID statement): Month
Select columns whose values define groups of records to transpose (BY statement): Name
Which of the following tables is a possible resulting target table?
Integration Studio:
In the Options tab in the Properties window for the Transpose transformation, if the
columns are assigned as follows:
Select columns to transpose (VAR statement): Payment
Select a column for Output column names (ID statement): Month
Select columns whose values define groups of records to transpose (BY statement): Name
Which of the following tables is a possible resulting target table?
A. Exhibit A
B. Exhibit B
C. Exhibit C
D. Exhibit D
Answer: A
