A00-260 Studio Practice Questions

A fact table is populated by using which transformation in SAS Data Integration Studio?

• AA. SCD Type 2 Loader
• BB. Data Validation
• CC. Lookup
• DD. DataFlux IS Job

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

Select 2 answers.

• AA. A comma delimited flat file that contains the field names in the first row.
• BB. A dfPower scheme that is generated by DataFlux.
• CC. A SAS table scheme that is generated by SAS.
• DD. A third party RDBMS table that has been generated by the SAS system.

When using the SCD Type 2 load method in SAS Data Integration Studio, which columns can be

• AA. business key columns
• BB. Type 1 columns
• CC. generated columns
• DD. non-key columns

The SAS Data Integration Studio SCD Type 2 Loader transformation performs which of the following?

• AA. Loads source table records into a standardization table.
• BB. Loads dimension table records into a fact table.
• CC. Loads source table records into a dimension table.
• DD. Loads fact table records into a multi-threaded table.

When using the SCD Type 2 load method in SAS Data Integration Studio, which statement is true when a change is detected?

• AA. the old record is deleted and the changed record is added
• BB. the old record is updated with the new values from the changed record
• CC. the old record is flagged and the changed record is added
• DD. the old record is merged with the changed record

SAS Data Integration Studio is dependent on which administration functions?

• AA. Setting up of SAS Information Map environment.
• BB. Setting up of SAS Web and SAS Portal environments.
• CC. Setting up of SAS Application Servers.
• DD. Setting up of SAS Libraries definitions.