PL-300 V4

You are creating a query to be used as a Country dimension in a star schema. A snapshot of the source data is shown in the following table. You need to create the dimension. The dimension must contain a list of unique countries. Which two actions should you perform? Each...

You are building a Power Bl report. Users will view the report by using their mobile device. You need to configure the report to display data based on each user s location. Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection...

You need to configure access for the sales department users. The solution must me meet the security requirements. What should you do?A . Add the sales department as a member of the reports workspace B. Add the Azure Active Directory group of the sales department as an Admin of the...

HOTSPOT You need to create a Power BI report. The first page of the report must contain the following two views: * Sales By Postal Code * Sales by Month Both views must display a slicer to select a value for a field named Chain. The Sales By Postal Code...

HOTSPOT You are profiling data by using Power Query Editor. You have a table named Reports that contains a column named State. The distribution and quality data metrics for the data m State is shown in the following exhibit. Use the drop-down menus to select the answer choice that completes...

You need to design the data model to meet the report requirements. What should you do in Power BI Desktop?A . 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...

HOTSPOT You have a table that contains a column named Phone. The following is a sample of the data in the Phone column. You need to add a new column that contains the data in the format of nnn-nnn-nnnn. How should you complete the Query Editor formula? To answer, select...

HOTSPOT You need to grant access to the business unit analysts. What should you configure? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. View AnswerAnswer: Explanation: Box 1: The Viewer role to the workspace The Viewer role gives a read-only...

HOTSPOT You have a Power BI model that has the following tables: ✑ Product (Product_id, Product_Name) ✑ Sales (Order_id, Order_Date, Product_id, Salesperson_id, Sales_Amount) ✑ Salesperson (Salesperson_id, Salesperson_name, address) You plan to create the following measure. Measure1 = DISTINCTCOUNT(Sales[ProductID]) You need to create the following relationships: ✑ Sales to Product ✑...

You have a line chart that shows the number of employees in a department over time. You need to see the total salary costs of the employees when you hover over a data point. What is possible way to achieve this goal?A . Add a salary to the tooltips. B....