PL-300 exam

You need to create relationships to meet the reporting requirements of the customer service department. What should you create?A . an additional date table named ShipDate, a one-to-many relationship from Sales[sales_date_id] to Date[date_id], and a one-to-many relationship from Sales[sales_ship_date_id] to ShipDate[date_id]B . an additional date table named ShipDate, a many-to-many...

You merge data from Sales.Region, Region_Manager, Sales_Manager, and Manager into a single table named Region. What should you do next to meet the reporting requirements of the executives?A . Apply row-level security (RLS) to the Region table based on the sales manager username.B . Configure a bi-directional relationship between Region...

Topic 4, Misc. Questions Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a...

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

You have a data model that contains many complex DAX expressions. The expressions contain frequent references to the RELATED and RELATEDTABLE functions. You need to recommend a solution to minimize the use of the RELATED and RELATEDTABLE functions. What should you recommend?A . Merge tables by using Power Query.B ....

You have a Microsoft Power Bl report. The size of PBIX file is 550 MB. The report is accessed by using an App workspace in shared capacity of powerbi.com. The report uses an imported dataset that contains one fact table. The fact table contains 12 million rows. The dataset is...

You need to ensure that the data is updated to meet the report requirements. The solution must minimize configuration effort. What should you do?A . From each report in powerbi.com. select Refresh visualsB . From Power Bl Desktop, download the PBIX file and refresh the data.C . Configure a scheduled...

You build a report to help the sales team understand its performance and the drivers of sales. The team needs to have a single visualization to identify which factors affect success. Which type of visualization should you use?A . Key influencesB . Funnel chartC . Q&AD . Line and clustered...

HOTSPOT You have a folder of monthly transaction extracts. You plan to create a report to analyze the transaction data. You receive the following email message: "Hi. I've put 24 files of monthly transaction data onto the shared drive. File Transactions201901.csv through Transactions201912.csv have the latest set of columns, but...

You need to recommend a strategy to consistently define the business unit, department, and product category data and make the data usable across reports. What should you recommend?A . Create a shared dataset for each standardized entity.B . Create dataflows for the standardized data and make the dataflows available for...