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

Question

Options

• AA comma delimited flat file that contains the field names in the first row.
• BPower scheme that is generated by Data Flux.
• CA SAS table scheme that is generated by SAS.
• DA third party RDBMS table that has been generated by the SAS system.

• A
  94% (48)
• B
  4% (2)
• D
  2% (1)

Explanation

Options A and C are correct because SAS Data Integration Studio's Apply Lookup Standardization transformation supports two specific Scheme Repository Types: a comma-delimited flat file where the first row contains field names (A), and a SAS table scheme generated by SAS itself (C) - both are native, SAS-compatible formats that the transformation can read and process without external dependencies.

Option B is incorrect because "Power scheme generated by DataFlux" uses fabricated terminology - DataFlux/SAS Data Quality products use Quality Knowledge Base (QKB) schemes, not "Power schemes," making this a distractor designed to confuse candidates familiar with the DataFlux brand.

Option D is incorrect because it is self-contradictory: a "third-party RDBMS table" implies an external vendor's database, yet claims it is "generated by the SAS system" - this hybrid description does not represent a valid, supported scheme repository type.

Memory tip: Think "flat or SAS-native" - the two valid scheme types are the simplest portable format (a CSV-style flat file with a header row) and SAS's own table format. If an option references a third-party system or invents unfamiliar SAS/DataFlux terminology, it is a distractor.

No community discussion yet for this question.