Free PL-300 Exam Dumps

Question 61

- (Exam Topic 4)
You have a report that contains a bar chart and a column chart. The bar chart shows customer count by customer segment. The column chart shows sales by month.
You need to ensure that when a segment is selected in the bar chart, you see which portion of the total sales for the month belongs to the customer segment.
How should the visual interactions be set on the column chart when the bar chart is selected?

A. no impact
B. highlight
C. filter

Correct Answer:B
HIGHLIGHT as the question required us to "you see which portion of the total sales for the month belongs to the customer segment" -- in order to see WHICH portion, you need to still see the whole visual, highlight is most appropriate. If the requirement stated to ONLY SEE THE PORTION IT RELATES TO then filter would be appropriate.

Question 62

- (Exam Topic 4)
You are enhancing a Power BI model that has DAX calculations.
You need to create a measure that returns the year-to-date total sales from the same date of the previous calendar year.
Which DAX functions should you use? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
PL-300 dumps exhibit
Solution:
Reference:
https://www.kasperonbi.com/get-the-ytd-of-the-same-period-last-year/

Does this meet the goal?

A. Yes
B. No

Correct Answer:A

Question 63

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

A. Show whitespace
B. Column distribution
C. Column profile
D. Column quality
E. Monospaced

Correct Answer:AD

Question 64

- (Exam Topic 1)
You need to create relationships to meet the reporting requirements of the customer service department. What should you create?

A. an additional date table named ShipDate, a one-to-many relationship from Sales[sales_date_id] to Date[date_id], and a one-to-many relationship from Sales[sales_ship_date_id] to ShipDate[date_id]
B. an additional date table named ShipDate, a many-to-many relationship from Sales[sales_date_id] to Date[date_id], and a many-to-many relationship from Sales[sales_ship_date_id] to ShipDate[date_id]
C. a one-to-many relationship from Date[date_id] to Sales[sales_date_id] and another one-to-many relationship from Date[date_id] to Weekly_Returns[week_id]
D. a one-to-many relationship from Sales[sales_date_id] to Date[date_id] and a one-to-many relationship from Sales[sales_ship_date_id] to Date[date_id]
E. a one-to-many relationship from Date[date_id] to Sales[sales_date_id] and another one-to-many relationship from Date[date_id] to Sales[sales_ship_date_id]

Correct Answer:A
Scenario: The customer service department requires a visual that can be filtered by both sales month and ship month independently.
Reference:
https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-relationships-understand

Question 65

- (Exam Topic 4)
You have a PBiX file that imports several tables from an Azure SQL database. The data will be migrated to another Azure SQL database.
You need to change the connections in the PBIX file. The solution must minimize administrative effort. What should you do?

A. From Power Query Editor, modify the source of each query.
B. Create a PBiT file, open the file, and change the data sources when prompted
C. From Power Query Editor, create new queries.
D. Modify the Data source settings.

Correct Answer:D