SAS A00-260 SAS Certified Data Integration Developer for SAS Exam Practice Test

Which statements are true regarding columns when using SAS Data Integration Studio's New Tables wizard? 1. You can access metadata for any column from any table already registered in metadata but cannot change it. 2. You can access metadata for any column from any table already registered in metadata and can override the imported information. 3. You can define new columns for the table. 4. You cannot define new columns.

Which statement correctly defines a System DSN?

Which of the following is NOT a feature of SAS Data Integration Studio's Data Validation transformation?

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.)

In SAS Data Integration can be specified/defined Studio, primary keys, foreign keys and unique keys in which location?

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?

How do you enable performance statistics for a SAS Data Integration Studio job?