PL-300: Microsoft Power BI Data Analyst practice questions, page 14 of 17, with answer review and explanations.
Question 66
You are creating a report in Power BI Desktop. You load a data extract that includes a free text field named coll. You need to analyze the frequency distribution of the string lengths in col1. The solution must not affect the size of the model. What should you do?
In the report, add a DAX calculated column that calculates the length of col1
In the report, add a DAX function that calculates the average length of col1
From Power Query Editor, add a column that calculates the length of col1
From Power Query Editor, change the distribution for the Column profile to group by length for col1
Question 67
You have a collection of reports for the HR department of your company. The datasets use row-level security (RLS). The company has multiple sales regions. Each sales region has an HR manager. You need to ensure that the HR managers can interact with the data from their region only. The HR managers must be prevented from changing the layout of the reports. How should you provision access to the reports for the HR managers?
Publish the reports in an app and grant the HR managers access permission.
Create a new workspace, copy the datasets and reports, and add the HR managers as members of the workspace.
Publish the reports to a different workspace other than the one hosting the datasets.
Add the HR managers as members of the existing workspace that hosts the reports and the datasets.
Question 68
You need to provide a user with the ability to add members to a workspace. The solution must use the principle of least privilege. Which role should you assign to the user?
Viewer
Admin
Contributor
Member
Question 69
You have a Power BI query named Sales that imports the columns shown in the following table. Users only use the date part of the Sales_Date field. Only rows with a Status of Finished are used in analysis. You need to reduce the load times of the query without affecting the analysis. Which two actions achieve this goal? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.
Remove the rows in which Sales[Status] has a value of Canceled.
Remove Sales[Sales_Date].
Change the data type of Sale[Delivery_Time] to Integer.
Split Sales[Sale_Date] into separate date and time columns.
Remove Sales[Canceled Date].
Question 70
You build a report to analyze customer transactions from a database that contains the tables shown in the following table. You import the tables. Which relationship should you use to link the tables?