PL-300 V3

DRAG DROP You need to create a DAX measure in the data model that only allows users to see projections at the appropriate levels of granularity. How should you complete the measure? To answer, drag the appropriate values to the correct targets. Each value may be used once, more than...

You have a Power BI report named Report' and a dashboard named Dashboard'. Report1 contains a line chart named Sales by month. You pin the Sales by month visual to Dashboard1. In Report1, you change the Sales by month visual to a bar chart. You need to ensure that the...

You are creating a visual to show the ranking of product categories by sales revenue. Your company's security policy states that you cannot send data outside of your Microsoft Power Bl tenant Which approach provides the widest variety of visuals while adhering to the security policy?A . Use default visuals...

HOTSPOT You have two Azure SQL databases that contain the same tables and columns. For each database, you create a query that retrieves data from a table named Customers. You need to combine the Customer tables into a single table. The solution must minimize the size of the data model...

You have a CSV file that contains user complaints. The file contains a column named Logged logged contains the date and time each complaint occurred. The data in Logged is m the following format: 2018-12-31 at 08:59. You need to be able to analyze the complaints by the logged date...

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

HOTSPOT You need to create a solution to meet the notification requirements of the warehouse shipping department. What should you do? To answer, select the appropriate options in the answer area. NOTE: Each correct select is worth one point: View AnswerAnswer:

CORRECT TEXT You have a Power B1 model that contains a table named Date. The table has the following columns. View AnswerAnswer:

You need to create a relationship between the Weekly_Returns table and the Date table to meet the reporting requirements of the regional managers . What should you do?A . In the Weekly.Returns table, create a new calculated column named date-id in a format of yyyymmdd and use the calculated column...

Topic 3, Northwind Traders Case study 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 to...