Power BI 02 - Connecting & Shaping Data

Which three tabs in the Query Editor contain data shaping and transformation tools?

• Home, Transform, Add Column

• Transform, Load, Add Column

• Load, Transform, Analyze

• Transform, Design, Analyze

The Query Editor "Transform" tools overwrite the existing values in a column

• Yes

• No

Statistics tools are accessible from the Add Column tab in the Query

• Yes

• No

In which scenario would the Trim tool be most helpful?

• When you want to reduce the length of a text string

• When you want to remove a fixed number of characters from the endo of a string

• When you want to remove a variable number of characters from the end of a string

• When you want to make sure that your text doesn't have leading or trailing spaces

• When you want to remove spaces between words in a string

Merging queries makes tables wider by adding columns, and appending queries makes tables taller by adding rows

• Yes

• No

• NA

Which term best describes the process of transforming a table from a horizontal orientation to a vertical orientation by turning distinct column values into rows?

• Transposing

• Pivoting

• Unpivoting

• Hinging

All queries in a Power BI file will refresh by default?

• Yes

• No

Which type of column would you add to create a series of values that uniquely identify each row?

• Index

• Conditional

• Sequential

• Count

• Series

Which of the following could represent a valid hierarchy?

• Country > City > State

• Peach > Pear > Plum

• Zip Code > State > Department

• Product Category > Product Brand > Product