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…

The correct answer is C. 1, 2 and 4 only. Option C is correct because the Expression Builder in the Where tab of SAS Extract transformation supports SAS expressions, SQL expressions, and constants - giving users flexibility to filter data using either SAS or SQL syntax, or to compare against a fixed constant value. XML…

Create and work with metadata for SAS Data Integration Studio

Question

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

A1 and 2 only
B1 and 3 only
C1, 2 and 4 only
D1, 2, 3, and 4

How the community answered

(42 responses)

A
7% (3)
B
2% (1)
C
88% (37)
D
2% (1)

Explanation

Option C is correct because the Expression Builder in the Where tab of SAS Extract transformation supports SAS expressions, SQL expressions, and constants - giving users flexibility to filter data using either SAS or SQL syntax, or to compare against a fixed constant value. XML expressions (option 3) are not a supported expression type within this tool, making any answer that includes XML (options B and D) incorrect. Option A is also wrong because it excludes constants, which are valid in the Expression Builder. A helpful memory tip: think of the three valid types as the "2+1" rule - two query languages (SAS and SQL) plus 1 simple value type (constant); XML is a data format/markup language, not a query expression type, so it doesn't belong in a filter builder context.

Topics

#Expression Builder#Where clause#Extract transformation#Expression types

Community Discussion

No community discussion yet for this question.

Full A00-260 Practice