Designer Core - Data Transformation Flashcards

1
Q

What are the tools that are on this exam?

A

Cross tab, Summarize and Transpose

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

What does the Cross Tab tool do?

A

Creates 1 new value for each categorical value held in a single existing column, pivoting the data from a vertical layout to a horizontal layout

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

In the Crosstab tool, which aggregation options are available for columns with string data?

A
  1. Concatenate values
  2. Use first value associated with header
  3. Use last value associated with header
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

In the crosstab tool, which aggregation options are available for numeric data?

A
  1. Sum values
  2. Average values
  3. Use first or last value associated with header
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

If the incoming data set contains multiple data types when transposing data columns, the values will automatically convert to

A

The most robust data type to accommodate the various values, typically V-String

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

The Crosstab tool will replace special characters and spaces in headers with

A

Underscores (_), to increase speed and efficiency when processing

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

The Crosstab tool automatically sorts headers and groups in what order?

A

Ascending

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

What does the Transpose tool do?

A

Moves values held in multiple horizontal columns into a single column

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

What does the Summarize tool do?

A

It can perform a host of summary calculations, including summing, min and max, grouping, counting, string concatenating, math, spatial object processing, and much more

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

What does the Summarize tool do?

A

It can perform a host of summary calculations, including summing, min and max, grouping, counting, string concatenating, math, spatial object processing, and much more

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

True or False? The Summarize tool can apply summary processes to Spatial, String, and Numeric data types.

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

Which of the following function categories have Action Properties? Select all that apply.
Numeric, Reporting, None, String, and Finance

A

String and Finance

How well did you know this?
1
Not at all
2
3
4
5
Perfectly