Sample Questions
The following sample questions are not inclusive and do not necessarily represent all of the
types of questions that comprise the exams. The questions are not designed to assess an
individual's readiness to take a certification exam.
SAS Data Integration Development for SAS 9
Question 1
Which of the following servers is NOT a part of the platform for SAS Business Analytics server tier?
A. SAS Metadata Server
B. SAS Workspace Server
C. SAS/CONNECT Server
D. SAS Content Server
correct_answer = "D"
Question 2
Which products are needed on the local host in order to access data from an MS Access Database using an
ODBC Data Source name?
A. SAS/ACCESS interface to DSN
B. SAS/ACCESS interface to MDB
C. SAS/ACCESS interface to PC Files
D. SAS/ACCESS interface to ODBC
correct_answer = "D"
Question 3
Which statement is true regarding external files?
A. External file objects are accessed with SAS INFILE and FILE statements.
B. External files contain only one record per line.
C. External files can be used as input but not as outputs in SAS Data Integration Studio jobs.
D. SAS can only work with Blank, Comma, Semicolon and Tab as delimiters in external files.
correct_answer = "A"
Question 4
Within SAS Data Integration Studio's SQL Join transformation, the option to turn on debug is located in
which Properties pane?
A. Select Properties
B. Create Properties
C. SQL Join Properties