SAS A00 260
Q: 1
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
Q: 2
Select the valid reasons for using SAS Data Integration Studio’s Table Loader transformation. (Choose
two.)
Options
Q: 3
In SAS Data Integration Studio, the SCD Type 2 Loader transformation will do which of the following?
Options
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
Q: 5
In SAS Data Integration Studio, which component allows the definition of job flows with
dependencies between different jobs?
Options
Q: 6
Which statement is FALSE regarding foreign keys?
Options
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
Q: 8
Which definition cannot be imported using a SAS Metadata Bridge?
Options
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
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
Question 1 of 10
