WorksheetsPower BI - Data Transformation & Modeling
Total questions: 15
Worksheet time: 15mins
Which three tabs in the Query Editor contain data shaping and transformation tools?
Home, Transform, Add Column
Transform, Load, Add Column
Load, Transform, Analyze
Load, Design, Analyze
TRUE or FALSE: The Query Editor "Transform" tools overwrite the existing values in a column
True
False
TRUE or FALSE: Statistics tools are accessible from the Add Column tab in the Query Editor
True
False
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 fixed number of characters from the end of the string
When you want to remove variable number of characters from the end of the string
When you want to make sure that your text doesn't have leading or trailing spaces
TRUE or FALSE: Merging queries makes tables wider by adding columns, and appending queries makes tables taller by adding rows
True
False
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
Why might you normalize a data model?
To make it more efficient
To minimize the risk of error during data modifications
To simplify queries and analysis
All of the above
Which type of table generally contains foreign keys?
Data Table
Fact Table
Lookup Tables
All Tables
What can you do to prevent users from filtering with invalid fields from a data model?
Delete the table
Delete the field
Activate the "Hide in Report View" option
What are the three core views in Power BI desktop?
Report, Data, Queries
Report, Queries, Relationships (Model)
Report, Data, Relationships (Model)
Queries, Data, Relationships (Model)
In the typical Power BI workflow, which of the following takes place after data is loaded but before reports are built?
Table relationships are formed
User-level permission are established
Parameter and roles are defined
True or False. The applied steps are used to repeat the steps every time the table is loaded.
True
False
True or False. To enable two tables to be joined. A unique key between the 2 tables is required.
True
False
Which of the following statements is true about shaping data with Power BI Desktop?
The order in which you shape or transform data doesn't matter, it all comes out the same.
When shaping or transforming data in Power BI Desktop, the source data remains unchanged.
When shaping or transforming data in Power BI Desktop, the source data is also shaped and transformed.
What is the Power Bi file Format?
.pbi
.pbix
xls
