ExamGecko
Home / Microsoft / PL-300 / List of questions
Ask Question

Microsoft PL-300 Practice Test - Questions Answers, Page 7

List of questions

Question 61

Report
Export
Collapse

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.

Don't allow end user to save filters on this report.

Change default visual interaction from cross highlighting to cross filtering.

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.

Enable the updated filter pane, and show filters in the visual header for this report.

Allow users to add comments to this report.

Allow users to add comments to this report.

Choose the type of data you allow your end users to export.

Choose the type of data you allow your end users to export.

Suggested answer: E

Explanation:

https://powerbi.microsoft.com/en-us/blog/announcing-persistent-filters-in-the-service/

asked 05/10/2024
Andrew Dobie
34 questions

Question 62

Report
Export
Collapse

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.

Add the same slicer to each page and configure Sync slicers.

Edit the interactions of the KPI visualization.

Edit the interactions of the KPI visualization.

Configure a page-level filter.

Configure a page-level filter.

Edit the interactions of the slicer that is on the same page as the KPI visualization.

Edit the interactions of the slicer that is on the same page as the KPI visualization.

Configure a report-level filter.

Configure a report-level filter.

Suggested answer: A, D

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

asked 05/10/2024
victoria nagy
37 questions

Question 63

Report
Export
Collapse

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

Feedback

Subscribe

Subscribe

Comments

Comments

Mark as favorite

Mark as favorite

Suggested answer: C

Explanation:

https://docs.microsoft.com/en-us/power-bi/consumer/end-user-comment

asked 05/10/2024
Priyantha Perea
40 questions

Question 64

Report
Export
Collapse

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 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 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 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.

Get data from a SharePoint Online list, enter the site URL, and then select Combine & Load.

Suggested answer: B

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

asked 05/10/2024
Garvey Butler
44 questions

Question 65

Report
Export
Collapse

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

1318

1319

1319

21318 Lasalle Street

21318 Lasalle Street

21319 Lasalle Street

21319 Lasalle Street

Suggested answer: D

Explanation:

Example:

Microsoft PL-300 image Question 32 explanation 106289 10052024010716000000

Replace the text "ur" with the text "or" in the table.

Reference:

https://docs.microsoft.com/en-us/powerquery-m/table-replacevalue

asked 05/10/2024
test fdf
47 questions

Question 66

Report
Export
Collapse

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

Show whitespace

Column distribution

Column distribution

Column profile

Column profile

Column quality

Column quality

Monospaced

Monospaced

Suggested answer: A, D
asked 05/10/2024
Lea Kohl
46 questions

Question 67

Report
Export
Collapse

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 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 List.

Create a new group on the state column and set the Group type to Bin.

Create a new group on the state column and set the Group type to Bin.

Create a new aggregation that summarizes by state.

Create a new aggregation that summarizes by state.

Suggested answer: B

Explanation:

https://www.mssqltips.com/sqlservertip/4720/binning-and-grouping-data-with-power-bi/

asked 05/10/2024
Kristian Gutierrez
47 questions

Question 68

Report
Export
Collapse

You have a query that returns the data shown in the following exhibit.

Microsoft PL-300 image Question 35 106292 10052024010716000000

You need to configure the query to display the data as shown in the following exhibit.

Microsoft PL-300 image Question 35 106292 10052024010716000000

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.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.Unpivot(Source, {"classes"}, "Attribute", "Value")

= Table.SplitColumn(Source, "classes". Splitter.SplitTextByDelimiterf",", QuoteStyle.None),

{"classes.1"})

= Table.SplitColumn(Source, "classes". Splitter.SplitTextByDelimiterf",", QuoteStyle.None),

{"classes.1"})

= Table.SplitColumn(Source, "classes". Splitter.SplitTextByPositions({10}), {"classes.1"})

= Table.SplitColumn(Source, "classes". Splitter.SplitTextByPositions({10}), {"classes.1"})

Suggested answer: B

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.

Microsoft PL-300 image Question 35 explanation 106292 10052024010716000000

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

asked 05/10/2024
Cristian Pernia
42 questions

Question 69

Report
Export
Collapse

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.

Round the hour of the Date column to startOfHour.

Change the data type of the Date column to Text.

Change the data type of the Date column to Text.

Trim the Date column.

Trim the Date column.

Split the Date column into two columns, one that contains only the time and another that contains only the date.

Split the Date column into two columns, one that contains only the time and another that contains only the date.

Suggested answer: D

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

asked 05/10/2024
Alex Bu
45 questions

Question 70

Report
Export
Collapse

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.

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.

Remove the Subject and Body columns during the import.

From Model view, set the Subject and Body columns to Hidden.

From Model view, set the Subject and Body columns to Hidden.

Suggested answer: B
asked 05/10/2024
IOSSIF ZINGUER
46 questions
Total 370 questions
Go to page: of 37
Search

Related questions