Free PL-300 Mock Exam – Practice Online Confidently

You have a Power Bl query named Sates that imports the columns shown in the following table.

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.

You are building a Power BI report to analyze customer segments. You need to identify customer segments dynamically based on the Bounce Rate across dimensions such as source, geography, and demographics. The solution must minimize analysis effort. Which type of visualization should you use? 

You have a Power BI model that contains a table named Sales. The Sales table contains the following

columns:

• Order Line ID

• Product ID

• Unit Price

• Order ID

• Quantity

Orders are uniquely identified by using the order ID and can have multiple order lines Each order line within

an order contains a different product ID.

You need to write a DAX measure that counts the number of orders.

Which formula should you use?

You use an R visual to produce a map of 500,000 customers. You include the values of CustomerID, Latitude, and Longitude in the fields sent to the visual. Each customer ID is unique. In powerbi.com, when users load the visual, they only see some of the customers. What is the cause of the issue?

You have the CSV file shown in the following table.

You use Power Query Editor to preview the data in the file. You need to transform the data to meet the following requirements: • The first column must contain the month. • The second column must contain the year. • The third column must contain the order amount for the month and year. Which transformation should you use first?