PL-300

Your company has employees in 10 states. The company recently decided to associate each state to one of the following three regions: East, West, and North. You have a data model that contains employee information by state. The model does NOT include region information. You have a report that shows...

Topic 3, Misc. Questions You are developing a report page. Some users will navigate the report by using a keyboard, and some users will consume the report by using a screen reader. You need to ensure that the users can consume the content on a report page in a logical...

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

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 correct solution. After you...

Which DAX expression should you use to get the ending balances in the balance sheet reports?A . CALCULATE ( SUM( BalanceSheet [BalanceAmount] ), DATESQTD( 'Date'[Date] ) )B . CALCULATE ( SUM( BalanceSheet [BalanceAmount] ), LASTDATE( 'Date'[Date] ) )C . FIRSTNONBLANK ( 'Date' [Date] SUM( BalanceSheet[BalanceAmount] ) )D . CALCULATE (...

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

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 correct solution. After you...

DRAG DROP You are using existing reports to build a dashboard that will be viewed frequently in portrait mode on mobile phones. You need to build the dashboard. Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer...

You have a report that contains three pages. One of the pages contains a KPI visualization. You need to filter all the visualizations in the report except for the KPI visualization . Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection...

You need to address the data concerns before creating the data model . What should you do in Power Query Editor?A . Select Column distribution.B . Select the sales_amount column and apply a number filter.C . Select Column profile, and then select the sales_amount column.D . Transform the sales_amount column...