Free PL-300 Exam Dumps

Question 16

- (Exam Topic 4)
You are modeling data in table named SalesDetail by using Microsoft Power Bl.
You need to provide end users with access to the summary statistics about the SalesDetail data. The users require insights on the completeness of the data and the value distributions.
Which three 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.
PL-300 dumps exhibit
Solution:

Does this meet the goal?

A. Yes
B. No

Correct Answer:A

Question 17

- (Exam Topic 4)
You have a report page that contains the visuals shown in the following exhibit.
PL-300 dumps 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.

Solution:
Box 1: cross-filter
By default, selecting a data point in one visual on a report page will cross-filter or cross-highlight the other visuals on the page.
Box 2: cross-highlight Example:
By default, selecting a data point in one visual on a report page will cross-filter or cross-highlight the other visuals on the page.
PL-300 dumps exhibit
* 1. Let's see what happens when we select Moderation.

* 2. Cross-filtering removes data that doesn't apply. Selecting Moderation in the doughnut chart cross-filters the line chart. The line chart now only displays data points for the Moderation segment.
* 3. Cross-highlighting retains all the original data points but dims the portion that does not apply to your selection. Selecting Moderation in the doughnut chart cross-highlights the column chart. The column chart dims all the data that applies to the Convenience segment and highlights all the data that applies to the Moderation segment.
Reference:
https://docs.microsoft.com/en-us/power-bi/consumer/end-user-interactions

Does this meet the goal?

A. Yes
B. No

Correct Answer:A

Question 18

- (Exam Topic 4)
You have a Power Bl query named Sates that imports the columns shown in the following table.
PL-300 dumps exhibit
Usees only use the dale part of the Sales.Date field. Only rows with a Status of Finished are used in analysis. You need to reduce the load times of the query without affecting the analysis.
Which two actions achieve this goal? Each correct answer presents a complete solution.
NOTL Each correct selection is worth one pant.

A. Remove the rows in which sales [status] has a value of Canceled.
B. Change the data type of sale [Delivery_Time] to Integer
C. Removes (Canceled Date).
D. Split Sales [Sale_Date] into separate date and time columns.
E. Remove sales [Sales_Date].

Correct Answer:AD

Question 19

- (Exam Topic 4)
You plan to embed multiple visualization in a public website.
Your Power BI infrastructure contains the visualizations configured as shown in the following table.
PL-300 dumps exhibit
Which two visualizations can you embed into the website? Each correct answer presents a complete the solution.
NOTE: Each correct selection is worth one point.

A. Visual1
B. Visual2
C. Visual3
D. Visual4
E. Visual5

Correct Answer:BD
References: https://docs.microsoft.com/en-us/power-bi/service-publish-to-web

Question 20

- (Exam Topic 4)
You have sales data in a star schema that contains four tables named Sales, Customer, Date, and Product. The Sales table contains purchase and ship dates.
Most often, you will use the purchase date to analyze the data, but you will analyze the data by both dates independently and together.
You need to design an imported dataset to support the analysis. The solution must minimize the model size and the number of queries against the data source.
Which data modeling design should you use?

A. Use the Auto Date/Time functionality in Microsoft Power Bl and do NOT import the Date table.
B. Duplicate the Date query in Power Query and create active relationships between Sales and both Date tables in the modeling view.
C. On the Date table, use a reference query in Power Query and create active relationships between Sales and both Date tables in the modeling view.
D. Import the Date table twice in Power Query and create active relationships between Sales and both Date tables in the modeling view.

Correct Answer:D
Microsoft recommends defining active relationships whenever possible. They widen the scope and potential of how your model can be used by report authors, and users working with Q&A.
Refactoring methodology (example): Here's a methodology to refactor a model from a single role-playing dimension-type table, to a design with one table per role.
PL-300 dumps exhibit Remove any inactive relationships.
Consider renaming the role-playing dimension-type table to better describe its role. In the example, the Airport table is related to the ArrivalAirport column of the Flight table, so it's renamed as Arrival Airport.
Create a copy of the role-playing table, providing it with a name that reflects its role. If it's an Import table, we recommend defining a calculated table. If it's a DirectQuery table, you can duplicate the Power Query query.
Only one relationship can be active.
Note: If you query two or more tables at the same time, when the data is loaded, Power BI Desktop attempts to find and create relationships for you. The relationship options Cardinality, Cross filter direction, and Make this relationship active are automatically set.
Reference:
https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-create-and-manage-relationships https://docs.microsoft.com/en-us/power-bi/guidance/relationships-active-inactive