Microsoft PL-300 Practice Test - Questions Answers, Page 7
List of questions
Question 61

You publish a report to a workspace named Customer Services. The report identifies customers that have potential data quality issues that must be investigated by the customer services department of your company. You need to ensure that customer service managers can create task lists in Microsoft Excel based on the data. Which report setting should you configure?
Don't allow end user to save filters on this report.
Change default visual interaction from cross highlighting to cross filtering.
Enable the updated filter pane, and show filters in the visual header for this report.
Allow users to add comments to this report.
Choose the type of data you allow your end users to export.
Explanation:
https://powerbi.microsoft.com/en-us/blog/announcing-persistent-filters-in-the-service/
Question 62

You have a report that contains three pages. One of the pages contains a KPI visualization. You need to filter all the visualizations in the report except for the KPI visualization. Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.
Add the same slicer to each page and configure Sync slicers.
Edit the interactions of the KPI visualization.
Configure a page-level filter.
Edit the interactions of the slicer that is on the same page as the KPI visualization.
Configure a report-level filter.
Explanation:
Slicers are another way of filtering. They narrow the portion of the dataset that is shown in the other report visualizations. By default, slicers on report pages affect all the other visualizations on that page, including each other. Use visual interactions to exclude some page visualizations from being affected by others.
Reference:
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-slicers
Question 63

You have a Microsoft Power Bl dashboard.
You need to ensure that consumers of the dashboard can give you feedback that will be visible to the other consumers of the dashboard. What should you use?
Feedback
Subscribe
Comments
Mark as favorite
Explanation:
https://docs.microsoft.com/en-us/power-bi/consumer/end-user-comment
Question 64

You have a Microsoft SharePoint Online site that contains several document libraries. One of the document libraries contains manufacturing reports saved as Microsoft Excel files. All the manufacturing reports have the same data structure.
You need to load only the manufacturing reports to a table for analysis.
What should you do in Microsoft Power Bl Desktop?
Get data from a SharePoint Online folder, enter the site URL, and then select Combine & Load.
Get data from a SharePoint Online list and enter the site URL. Edit the query and filter by the path to the manufacturing reports library.
Get data from a SharePoint Online folder and enter the site URL. Edit the query and filter by the path to the manufacturing reports library.
Get data from a SharePoint Online list, enter the site URL, and then select Combine & Load.
Explanation:
We have to import Excel files from SharePoint, so we need the connector SharePoint folder which is used to get access to the files stored in the library. SharePoint list is a collection of content that has rows and columns (like a table) and is used for task lists, calendars, etc. Since we have to filter only on manufacturing reports, we have to select Transform and then filter by the corresponding folder path. https://docs.microsoft.com/en-us/power-query/connectors/sharepointlist
Question 65

You create the following step by using Power Query Editor.
= Table.ReplaceValue(SalesLT_Address,"1318","1319",Replacer.ReplaceText,{"AddressLine1"}) A row has a value of 21318 Lasalle Street in the AddressLine1 column. What will the value be when the step is applied?
1318
1319
21318 Lasalle Street
21319 Lasalle Street
Explanation:
Example:
Replace the text "ur" with the text "or" in the table.
Reference:
https://docs.microsoft.com/en-us/powerquery-m/table-replacevalue
Question 66

You import a large dataset to Power Query Editor.
You need to identify whether a column contains only unique values.
Which two Data Preview options can you use? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point
Show whitespace
Column distribution
Column profile
Column quality
Monospaced
Question 67

Your company has employees in 10 states.
The company recently decided to associate each state to one of the following three regions: East, West, and North. You have a data model that contains employee information by state. The model does NOT include region information. You have a report that shows the employees by state.
You need to view the employees by region as quickly as possible.
What should you do?
Create a new aggregation that summarizes by employee.
Create a new group on the state column and set the Group type to List.
Create a new group on the state column and set the Group type to Bin.
Create a new aggregation that summarizes by state.
Explanation:
https://www.mssqltips.com/sqlservertip/4720/binning-and-grouping-data-with-power-bi/
Question 68

You have a query that returns the data shown in the following exhibit.
You need to configure the query to display the data as shown in the following exhibit.
Which step should you use in the query?
=Table.ExpandListColum(Table.TransformColunins(Source, {{"classes".
Splitter.SplitTextByDelimiter('','', QuoteStyle.None), let itemType - (type nullable text) meta [Serialized.Text = true] in type {itemType}}}), "classes")
= Table.Unpivot(Source, {"classes"}, "Attribute", "Value")
= Table.SplitColumn(Source, "classes". Splitter.SplitTextByDelimiterf",", QuoteStyle.None),
{"classes.1"})
= Table.SplitColumn(Source, "classes". Splitter.SplitTextByPositions({10}), {"classes.1"})
Explanation:
Power Query Unpivot columns: You might want to unpivot data, sometimes called flattening the data, to put it in a matrix format so that all similar values are in one column. This is necessary, for example, to create a chart or a report.
Note:
Syntax: Table.Unpivot(table as table, pivotColumns as list, attributeColumn as text, valueColumn as text) as table Table.Unpivot translates a set of columns in a table into attribute-value pairs, combined with the rest of the values in each row.
Reference:
https://docs.microsoft.com/en-us/power-query/unpivot-column
https://docs.microsoft.com/en-us/powerquery-m/table-unpivot
Question 69

You have a large dataset that contains more than 1 million rows. The table has a datetime column named Date. You need to reduce the size of the data model.
What should you do?
Round the hour of the Date column to startOfHour.
Change the data type of the Date column to Text.
Trim the Date column.
Split the Date column into two columns, one that contains only the time and another that contains only the date.
Explanation:
We have to separate date & time tables. Also, we don’t need to put the time into the date table, because the time is repeated every day. Split your DateTime column into a separate date & time columns in fact table, so that you can join the date to the date table & the time to the time table. The time need to be converted to the nearest round minute or second so that every time in your data corresponds to a row in your time table.
Reference:
https://intellipaat.com/community/6461/how-to-include-time-in-date-hierarchy-in-power-bi
Question 70

You have a custom connector that returns ID, From, To, Subject, Body, and Has Attachments for every email sent during the past year. More than 10 million records are returned. You build a report analyzing the internal networks of employees based on whom they send emails to.
You need to prevent report recipients from reading the analyzed emails. The solution must minimize the model size. What should you do?
Implement row-level security (RLS) so that the report recipients can only see results based on the emails they sent.
Remove the Subject and Body columns during the import.
From Model view, set the Subject and Body columns to Hidden.
Question