11/6 - Week 1

The Append Fields tool is limited to generating no more than 16 appends per record.

• True

• False

If the Sort tool is configured to sort on the Field column in Ascending order, with "Use Dictionary Order'' unchecked. what would the output be for the number set 1, 2, 20,100?

• 1 | 2 | 20 | 100

• 1 | 100 | 2 | 20

• 1 | 2 |100 | 20

• 100 | 20 | 2 | 1

Which of the following statements is FALSE about tool annotations?

• Annotations can appear above or below the tool on the canvas.

• Annotations allow you to change the ID number of a toot

• Annotations can be customized with your own text

• Annotations can be disabled so they don't show up on the canvas.

The Sort tool can not be configured to sort more than 5 columns.

• True

• False

Which is string data types support only ASCII characters?

• V_WString

• WString

• V_String

• Line

The default and only data type for Document Constants is a string.

• True

• False

If the Sort tool is configured to sort on the Field column in Ascending order: with ''Use Dictionary Order'' checked, what would the output be for the number set 1, 2, 20, 100?

• 1 | 20 | 2 | 100

• 1 | 2 | 20 | 100

• 100 | 20 | 2 | 1

• 2 | 20 | 1 | 100

Which of the following sampling methods are available in the Sample tool?

• first N% of rows

• First N rows per group (column)

• Skip last N rows

• Skip all rows

Dynamic/Unknown fields that pass through the Select tool are always added after an the known fields in the data stream.

• True

• False

Where can metadata be viewed in Designer?

• Only the Results Window

• Results and Overview Windows

• Results and Configuration Windows

• Only the Overview Window