PL-300 Practice Test practice questions, page 13 of 16, with answer review and explanations.
Question 61
You have a CSV file that contains user complaints. The file contains a column named Logged. Logged contains the date and time each complaint occurred. The data in Logged is in the following format: 2018-12-31 at 08:59. You need to be able to analyze the complaints by the logged date and use a built-in date hierarchy. What should you do?
Create a column by example that starts with 2018-12-31 and set the data type of the new column to Date
Create a column by example that starts with 2018-12-31
Apply a transformation to extract the last 11 characters of the Logged column
Add a conditional column that outputs 2018 if the Logged column starts with 2018 and set the data type of the new column to Whole Number
Question 62
You have a Microsoft Power BI report. The size of PBIX file is 550 MB. The report is accessed by using an App workspace in shared capacity of powerbi.com. The report uses an imported dataset that contains one fact table. The fact table contains 12 million rows. The dataset is scheduled to refresh twice a day at 08:00 and 17:00. The report is a single page that contains 15 AppSource visuals and 10 default visuals. Users say that the report is slow to load the visuals when they access and interact with the report. You need to recommend a solution to improve the performance of the report. What should you recommend?
Change any DAX measures to use iterator functions.
Implement row-level security (RLS).
Replace the default visuals with AppSource visuals.
Split the visuals onto multiple pages.
Question 63
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 64
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 65
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?