PL-300 Free Practice Test

- (Exam Topic 4)
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?

1. A. 1318
2. B. 1319
3. C. 21318 Lasalle Street
4. D. 21319 Lasalle Street

Correct Answer: D
Example:
Replace the text "ur" with the text "or" in the table.

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

- (Exam Topic 4)
You have a Power BI report named Report' and a dashboard named Dashboard'. Report1 contains a line chart named Sales by month.
You pin the Sales by month visual to Dashboard1.
In Report1, you change the Sales by month visual to a bar chart. You need to ensure that the bar chart displays on Dashboard', What should you do?

1. A. Refresh the dataset used by Report1 and Dashboard1.
2. B. Select Refresh visuals for Dashboard1.
3. C. Edit the details for the dashboard tile Of Dashboar1.
4. D. Pin the Sales by month bar chart to Dashboard1.

Correct Answer: A

- (Exam Topic 4)
What should you create to meet the reporting requirements of the sales department?

1. A. Option A
2. B. Option B
3. C. option C
4. D. Option D

Correct Answer: C

- (Exam Topic 4)
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.
You have a Microsoft Excel workbook that is saved to Microsoft SharePoint Online. The workbook contains several Power View sheets.
You need to recreate the Power View sheets as reports in the Power Bl service.
Solution: From the Power Bl service, get the data from SharePoint Online, and then click Connect Does this meet the goal?

1. A. Yes
2. B. No

Correct Answer: B
We need to click "Import", not "Connect". References:
https://docs.microsoft.com/en-us/power-bi/service-excel-workbook-files

- (Exam Topic 4)
You have two Azure SQL databases that contain the same tables and columns.
For each database, you create a query that retrieves data from a table named Customers.
You need to combine the Customer tables into a single table. The solution must minimize the size of the data model and support scheduled refresh in powerbi.com.
What should you do? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

Solution:
Graphical user interface, text Description automatically generated with medium confidence
Box 1: Append Queries as New.
There are two primary ways of combining queries: merging and appending.
When you have one or more columns that you’d like to add to another query, you merge the queries.
When you have additional rows of data that you’d like to add to an existing query, you append the query.
Box 2: Disable loading the query to the data model
For every query that loads into model memory will be consumed. and Memory is our asset in the Model, less memory consumption leads to better performance in most of the cases. The best approach is to disable loading.
Reference:
https://docs.microsoft.com/en-us/power-query/append-queries
https://community.powerbi.com/t5/Power-Query/Append-vs-Append-as-new-for-performance/td-p/1822710

Does this meet the goal?

1. A. Yes
2. B. No

Correct Answer: A