View Mode
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? SAS A00 260 question SAS A00 260 question
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 20 · Page 1 / 2

Premium Access Includes

  • ✓ Quiz Simulator
  • ✓ Exam Mode
  • ✓ Progress Tracking
  • ✓ Question Saving
  • ✓ Flash Cards
  • ✓ Drag & Drops
  • ✓ 3 Months Access
  • ✓ PDF Downloads
Get Premium Access
Scroll to Top

FLASH OFFER

Days
Hours
Minutes
Seconds

avail 10% DISCOUNT on YOUR PURCHASE

  • USE THE CODE GIVEN BELOW ON YOUR CHECKOUT
DISCOUNT10