PL-300 Free Practice Test

- (Exam Topic 4)
You have the following table named Location.

The GeoCode column represents the country where each customer is located. You create a map visualization as shown in the exhibit. (Click the Exhibit tab.)

You need to ensure that the map displays the country locations. What should you do?

1. A. Replace the values in the GeoCode column with postal codes or zip codes.
2. B. Change the name of the GeoCode column to Country.
3. C. Change the name of the Location table to Country.
4. D. Change the Default Summarization of the GeoCode column.
5. E. Add a Geoportal column to the Location table.
6. F. Change the Data Type of the GeoCode column.

Correct Answer: B
References:
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-map-tips-and-tricks

- (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 query for a table named Sales. Sales has a column named CustomerlD. The Data Type of CustomerlD is Whole Number.
You refresh the data and find several errors. You discover that new entries in the Sales table contain nonnumeric values.
You need to ensure that nonnumeric values in the CustomerlD column are set to 0. Solution: From Query Editor, select the CustomerlD column and click Remove Errors. Does this meet the goal?

1. A. Yes
2. B. No

Correct Answer: B

- (Exam Topic 4)
You use Power 81 Desktop to load data from a Microsoft SQL Server database. While waiting for the data to load, you receive the following error.

You need to resolve the error.
What are two ways to achieve the goal? Each correct answer presents a complete solution NOTE: Each correct selection is worth one point.

1. A. Split long running queries into subsets Of columns and use power Query to the queries
2. B. Disable query folding on long running queries
3. C. Reduce number of rows and columns returned by each query.
4. D. Use Power Query to combine long running queries into one query.

Correct Answer: BD

- (Exam Topic 4)
What is the minimum number of Power BI datasets needed to support the reports?

1. A. a single imported dataset
2. B. two imported datasets
3. C. two DirectQuery datasets
4. D. a single DirectQuery dataset

Correct Answer: A

- (Exam Topic 2)
You need to calculate the last day of the month in the balance sheet data to ensure that you can relate the balance sheet data to the Date table. Which type of calculation and which formula should you use? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

Solution:
Box 1: A DAX Calculated measure
Box 2: Date.EndofQuarter(#date([Year],[Mont],1))
ENDOFQUARTER returns the last date of the quarter in the current context for the specified column of dates. The following sample formula creates a measure that returns the end of the quarter, for the current context.
= ENDOFQUARTER(DateTime[DateKey]) Reference:
https://docs.microsoft.com/en-us/dax/endofquarter-function-dax

Does this meet the goal?

1. A. Yes
2. B. No

Correct Answer: A