Question 1

You need to design the data model to meet the report requirements. What should you do m Power Bl Desktop?

Options :

A : From Power Query, add columns to the Orders table to calculate the calendar quarter and the calendar month of the OrderDate column.

B : From Power Bi Desktop, use the Auto date/time option when creating the reports.

C : From Power Query, add a date table. Create an active relationship to the OrderDate column in the Orders table and an inactive relationship to the ShippedDate column in the Orders table.

D : From Power Query, use a DAX expression to add columns to the Orders table to calculate the calendar quarter of the OrderDate column, the calendar month of the OrderDate column, the calendar quarter of the ShippedDate column, and the calendar month of the ShippedDate column

Answer: B

Question 2

You are creating a Microsoft Power Bl model that has two tables named CityData and Sales. CityData

contains only the data shown in the following table.

Sales contains only the data shown in the following table.

For each of the following statements, select Yes if the statement is true. Otherwise, select No.

NOTE: Each correct selection is worth one point.

Options :

A : In the Sales table, you can write a DAX expression that uses the RELATED() function to get data from the CityData table.

B : A DAX expression of sales total CALCULATE (SUM(Sales [Sales]), ALL(Sales)) will produce the correct total sales value for each state, based on the data model.

C : A table visualization that uses cityData[state] and Sales [Sales] will contain sales from the state of TX

Answer: A,B

Question 3

In Power BI Desktop, you have a dataset that contains a table. You create a table visual on a Power BI report page as shown in the following exhibit

You need to configure the visual to display the referenced image instead of the URL in the Plant Image column. What should you do?

Options :

A : Set the Data category of the Plant Image field to Image URL

B : Set the Data type of the Plant Image field to Binary.

C : Set the Data category of the Plant Image field to Web URL.

D : From the Formatting tab. select Values, and then set URL icons to On for the table.

Answer: A

Question 4

You manage a Power BI model has a table named Sales and product.

You need to ensure that a sales team can view only data that has a CountryRegionName value of United States

and a ProductCategory value of Clothing.

What should you do from Power BI Desktop?

Options :

A : From Power BI Desktop, create a new role that has the following filter [countryRegionName]= “United States” && [ProductCategory]= “Clothing”

B : Add the following filters in Query Editor.CountryRegionName is United StatesProductCategory is Clothing

C : From Power BI Desktop, create a new role that has the following filters.[CountryRegionName]= “United States”

D : Add the following filters to a report.CountryRegionName is United SatesProductCategory is Clothing

Answer: D

Question 5

You have a report that includes a card visualization. You need to apply the following conditional formatting to the card while minimizing design effort. For values that are greater than or equal to 100, the font of the data label must be dark red. For values that are less than 100, the font of the data label must be dark gray. Which type of format should you use?

Options :

A : Color scale

B : Rules

C : Field value

Answer: B

Free PL-300 Mock Exam – Practice Online Confidently

Buying Options: