WorksheetsPower BI 02 - Connecting & Shaping Data
Total questions: 9
Worksheet time: 5mins
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
