In order to use the SAS Data Integration Studio’s Apply Lookup Standardization transformation, Data
Quality options must be setup. Select the valid Scheme Repository Types. (Choose two.)
Options
Discussion
No comments yet. Be the first to comment.
Be respectful. No spam.
Correct Answer:
A, C
Q: 2
Select the valid reasons for using SAS Data Integration Studio’s Table Loader transformation. (Choose
two.)
Options
Discussion
No comments yet. Be the first to comment.
Be respectful. No spam.
Correct Answer:
C, D
Q: 3
In SAS Data Integration Studio, the SCD Type 2 Loader transformation will do which of the following?
Options
Discussion
No comments yet. Be the first to comment.
Be respectful. No spam.
Correct Answer:
A
Q: 4
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?
Options
Discussion
No comments yet. Be the first to comment.
Be respectful. No spam.
Correct Answer:
B
Q: 5
In SAS Data Integration Studio, which component allows the definition of job flows with
dependencies between different jobs?
Options
Discussion
No comments yet. Be the first to comment.
Be respectful. No spam.
Correct Answer:
B
Q: 6
Which statement is FALSE regarding foreign keys?
Options
Discussion
No comments yet. Be the first to comment.
Be respectful. No spam.
Correct Answer:
D
Q: 7
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?
Options
Discussion
No comments yet. Be the first to comment.
Be respectful. No spam.
Correct Answer:
A
Q: 8
Which definition cannot be imported using a SAS Metadata Bridge?
Options
Discussion
No comments yet. Be the first to comment.
Be respectful. No spam.
Correct Answer:
A
Q: 9
When using the Table Loader transformation to load an existing target table that contains one or
more indexes in SAS Data Integration Studio, which statement is true?
Options
Discussion
No comments yet. Be the first to comment.
Be respectful. No spam.
Correct Answer:
D
Q: 10
Within SAS Data Integration Studio, which type of expression can be created using the Expression
Builder window in the Where tab of SAS Extract transformation? 1) a SAS expression 2) an SQL
expression 3) an XML expression 4) a constant
Options
Discussion
No comments yet. Be the first to comment.
Be respectful. No spam.
Correct Answer:
C
Q: 11
A fact table is populated by using which transformation in SAS Data Integration Studio?
Options
Discussion
No comments yet. Be the first to comment.
Be respectful. No spam.
Correct Answer:
C
Q: 12
Consider the job flow diagram in the display. Which of these objects has parameters defined for it?
Options
Discussion
No comments yet. Be the first to comment.
Be respectful. No spam.
Correct Answer:
C
Q: 13
When exporting a SAS package file using SAS Data Integration Studio, where can it be saved?
Options
Discussion
No comments yet. Be the first to comment.
Be respectful. No spam.
Correct Answer:
B
Q: 14
Assume that you have completed the Register Tables wizard in SAS Data Integration Studio. Which
statement is true?
Options
Discussion
No comments yet. Be the first to comment.
Be respectful. No spam.
Correct Answer:
D
Q: 15
Which action is performed by the Lookup transformation in SAS Data Integration Studio?
