PL-300 Microsoft Exam Questions and Free Practice Test

Question 37

- (Exam Topic 4)
You are creating reports in Power BI Desktop. The model has the following tables.
PL-300 dumps exhibit
There is a relationship between the tables.
You plan to publish a report to the Power BI service that displays Order_amount by Order_date by Full_name. You need to ensure that only the columns required for the report appear in Report View. The solution must
minimize the size of the dataset that is published.
How should you configure the columns in Power BI Desktop? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
PL-300 dumps exhibit
Solution:
Table Description automatically generated

Does this meet the goal?

A. Yes

B. No

Correct Answer:A

Question 38

- (Exam Topic 4)
You are configuring a Microsoft Power Bl data model to enable users to ask natural language questions by using Q&A. You have a table named Customer that has the following measure.
Customer Count = DISTINCTCOUNT(Customer[CustomerID]) Users frequently refer to customers as subscribers.
You need to ensure that the users can get a useful result for "subscriber count" by using Q&A. The solution must minimize the size of the model.
What should you do?

A. Add a description of "subscriber count" to the Customer Count measure.

B. Set Summarize By to None for the CustomerlD column.

C. Add a description of "Subscriber" to the Customer table.

D. Add a synonym of "subscriber" to the Customer table.

Correct Answer:B
You can add synonyms to tables and columns.
Note: This step applies specifically to Q&A (and not to Power BI reports in general). Users often have a variety of terms they use to refer to the same thing, such as total sales, net sales, total net sales. You can add these synonyms to tables and columns in the Power BI model.
This step applies specifically to Q&A (and not to Power BI reports in general). Users often have a variety of terms they use to refer to the same thing, such as total sales, net sales, total net sales. You can add these synonyms to tables and columns in the Power BI model.
Reference:
https://docs.microsoft.com/en-us/power-bi/natural-language/q-and-a-best-practices

Question 39

- (Exam Topic 1)
You need to create the required relationship for the executive's visual. What should you do before you can create the relationship?

A. Change the data type of Sales[region_id] to Whole Number.

B. In the Sales table, add a measure for sum(sales_amount).

C. Change the data type of sales[sales_id] to Text.

D. Change the data type of sales [region_id] to Decimal Number.

Correct Answer:A
Scenario: Executives require a visual that shows sales by region.
Need to change the sales_id column from Varchar to Whole Number (Integer).

Question 40

- (Exam Topic 4)
You have a prospective customer list that contains 1,500 rows of data. The list contains the following fields: PL-300 dumps exhibit First name
Last name
Email address
State/Region
Phone number
You import the list into Power Query Editor.
You need to ensure that the list contains records for each State/Region to which you want to target a marketing campaign.
Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

A. Open the Advanced Editor.

B. Select Column quality.

C. Enable Column profiling based on entire dataset.

D. Select Column distribution.

E. Select Column profile.

Correct Answer:CE
In Power query, the load preview by default is 1000 row. By default, the column quality also only looks at the first 1000 row. You can verify this by the status bar at the bottom of the Power query window. To change the profiling so it analyses the entire column of data, select the profiling status in the status bar. Then select Column profiling based on the entire data set.
https://theexcelclub.com/data-profiling-views-in-power-query-excel-and-power-bi/

START PL-300 EXAM