ExamGecko
Login
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
Open VPLUS File
Convert VPLUS to PDF

Related questions

You have the tables shown in the following table. The Impressions table contains approximately 30 million records per month. You need to create an ad analytics system to meet the following requirements: Present ad impression counts for the day, campaign, and Site_name. The analytics for the last year are required. Minimize the data model size. Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution. After you answer a question in this scenario, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. You have a clustered bar chart that contains a measure named Salary as the value and a field named Employee as the axis. Salary is present in the data as numerical amount representing US dollars. You need to create a reference line to show which employees are above the median salary. Solution: You create a median line by using the Salary measure. Does this meet the goal?
You have a Power BI model that contains a table named Sales. The Sales table contains the following columns: * Order Line ID * Product ID * Unit Price * Order ID * Quantity Orders are uniquely identified by using the order ID and can have multiple order lines Each order line within an order contains a different product ID. You need to write a DAX measure that counts the number of orders. Which formula should you use?
HOTSPOT You have the Power Bl data model shown in the following exhibit. You need to create a measure to count the number of product categories that had products sold during a selected period. How should you complete the DAX expression? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution. After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. From Power Query Editor, you profile the data shown in the following exhibit. The IoT GUID and IoT ID columns are unique to each row in query. You need to analyze IoT events by the hour and day of the year. The solution must improve dataset performance. Solution: You split the loT DateTime column into a column named Date and a column named Time. Does this meet the goal?
You have an Azure SQL database that contains sales transactions. The database is updated frequently. You need to generate reports from the data to detect fraudulent transactions. The data must be visible within five minutes of an update. How should you configure the data connection?
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?
You are profiling data by using Power Query Editor. You have a table named Reports that contains a column named State. The distribution and quality data metrics for the data m State is shown in the following exhibit. Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic. NOTE: Each correct selection is worth one point.
DRAG DROP You are using existing reports to build a dashboard that will be viewed frequently in portrait mode on mobile phones. You need to build the dashboard. Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
DRAG DROP You have a Microsoft Power BI data model that contains three tables named Sales, Product, and Date. The Sales table has an existing measure named [Total Sales] that sums the total sales from the Sales table. You need to write a calculation that returns the percentage of total sales that a selected ProductCategoryName value represents. The calculation must respect any slicers on ProductCategoryName and must show the percentage of visible total sales. For example, if there are four ProductCategoryName values, and a user filters one out, a table showing ProductCategoryName and the calculation must sum up to 100 percent. How should you complete the calculation? To answer, drag the appropriate values to the correct targets. Each value may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content. NOTE: Each correct selection is worth one point.