PL-300 exam

DRAG DROP You have a Microsoft Power BI data model that contains three tables named Sales, Product, and Date. The Sales table has an existing measure named [Total Sales] that sums the total sales from the Sales table. You need to write a calculation that returns the percentage of total...

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...

You have a large dataset that contains more than 1 million rows. The table has a datetime column named Date. You need to reduce the size of the data model. What should you do?A . Round the hour of the Date column to startOfHour.B . Change the data type of...

You have the visual shown in the Original exhibit. (Click the Original tab.) You need to configure the visual as shown in the Modified exhibit. (Click the Modified tab.) What should you add to the visual?A . a measureB . a trendlineC . a forecastD . an Average lineView AnswerAnswer:...

You need to create the relationship between the product list and the revenue results. The solution must minimize the time it takes to render visuals. What should you set as the relationship cardinality?A . One to oneB . Many to oneC . One to manyD . Many to manyView AnswerAnswer:...

You import two Microsoft Excel tables named Customer and Address into Power Query. Customer contains the following columns: ✑ Customer ID ✑ Customer Name ✑ Phone ✑ Email Address ✑ Address ID Address contains the following columns: ✑ Address ID ✑ Address Line 1 ✑ Address Line 2 ✑ City...

You need to provide a solution to provide the sales managers with the required access. What should you include in the solution?A . Create a security role that has a table filter on the Sales_Manager table where username = UserName()B . Create a security role that has a table filter...

Topic 2, Contoso Ltd, Case Study Overview This is a case study. Case studies are not timed separately. You can use as much exam time as you would like to complete each case. However, there may be additional case studies and sections on this exam. You must manage your time...

HOTSPOT You need to design the data model and the relationships for the Customer Details worksheet and the Orders table by using Power BI. The solution must meet the report requirements. For each of the following statement, select Yes if the statement is true, Otherwise, select No. NOTE: Each correct...

HOTSPOT 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....