Good PL-300 Exam Dumps Save Your Preparation Time

1. 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 the employees by state.

You need to view the employees by region as quickly as possible.

What should you do?

2. You build a Power Bl report that displays 10T temperature data streaming from a refrigerator.

You publish the report to the Bl service.

You need to be notified when the temperature rises above four degrees Celsius.

What should you do?

3. You need to create a visualization to meet the reporting requirements of the sales managers.

How Should create the Visualization? TO answer, select the appropriate options in the answer area.

4. HOTSPOT

You have a Power B1 report that contains the fields shown in the following exhibit.





Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic. NOTE: Each correct selection is worth one point.

5. 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 is worth one point.

6. You have a Power Bl report that contains five pages.

Pages 1 to 4 are visible and page 5 is hidden.

You need to create a solution that will enable users to quickly navigate from the first page to all the other visible pages. The solution must minimize development and maintenance effort as pages are added to the report.

What should you do first?

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

8. In Power Bi Desktop, you are creating visualizations in a report based on an imported dataset. You need to allow Power Bi users to export the summarized data used to create the visualizations but prevent the users from exporting the underlying data

What should you do?

9. You have a Power Bi data model that imports data from a Microsoft Excel spreadsheet. You use Power Query to load a query that contains both renamed and custom columns. Later you attempt to reload the query and receive the following error message

Expression.Error; The column 'Category’ of the table wasn’t found.

What are two possible causes of the error? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

10. 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 and use a built-in date hierarchy.

What should you do?

11. HOTSPOT

You need to create a Power Bl report.

The first page or 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 view must display a map visual as shown in the following exhibit.

12. DRAG DROP

You build a report about warehouse inventory data. The dataset has more than 10 million product records from 200 warehouses worldwide.

You have a table named Products that contains the columns shown in the following table.





Warehouse managers report that it is difficult to use the report because the report uses only the product name in tables and visuals. The product name is contained within the ProductDescription column and is always the fourth value.

You need to modify the report to support the warehouse managers requirement to explore inventory levels at different levels of the product hierarchy. The solution must minimize the model size.

Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

13. You have a Power 31 data model that contains a table named Stores.

The table has the following columns:

* Store Name

* Open Date

* Status

* State

* City

You need to create a calculated column named Active Store Name that meets the following requirements:

14. You have a Power BI report that uses a dataset based on an Azure Analysis Services live connection.

You need to ensure that users can use Q&A from the Power BI service for the dataset.

What should you do?

15. You have a source that contains a comumn. The column contains case sensitive date. You have a Power BI semantic model in DirectQuery mode. You connect to the model and discover that it contains undefined values and errors. You need to resolve the issue.

Solution: You change the semantic model mode.

Does this meet the goal?

16. HOTSPOT

How should you distribute the reports to the board? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

17. You use Power 81 Desktop to load data from a Microsoft SQL Server database.

While waiting for the data to load, you receive the following error.





You need to resolve the error.

What are two ways to achieve the goal? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

18. You have a Power BI report. The report contains visualizations that have interactions. You need to identify which visualizations take the longest to complete.

What should you use?

19. HOTSPOT

Your company has affiliates who help the company acquire customers.

You build a report for the affiliate managers at the company to assist them in understanding affiliate performance.

The managers request a visual showing the total sales value of the latest 50 transactions for each affiliate.

You have a data model that contains the following tables.





You need to develop a measure to support the visual.

How should you complete the DAX expression? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

20. HOTSPOT

You have a report in Power BI Desktop.

You add a key influencers visual as shown in the exhibit. (Click the Exhibit tab.)





Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic. NOTE: Each correct selection is worth one point.

21. What should you create to meet the reporting requirements of the sales department?

22. You have a Power BI data model that analyzes product sales ever time.

The data model contains the following tables.





A one-to-many relationship exists between the tables. The auto date/time option for the data model enabled.

You need to reduce the size of the data model while maintaining the ability to analyze product sales by month and quarter.

Which two actions should you perform?

23. HOTSPOT

You are building a financial report by using Power BI.

You have a table named financials that contains a column named Date and a column named Sales.

You need to create a measure that calculates the relative change in sales as compared to the previous quarter.

How should you complete the measure? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

24. You have a Power BI semantic model named Model1 that contains two table named DimDate and FactSales. There is an active relationship between DimDate and FactSales. DimDate is marked as the date table.

FactSales contains the following data.





Model1 contains the following measure:





You have a report that uses Model1. The report has a single report page that has a page level filter set to may 9, 2024. The result of the Previous Year measure is displayed in a card visual.

Which value appear in the card visual?

25. DRAG DROP

Exhibit:





You need to create a report that meets the requirements:

• Visualizes the Sales value over a period of years and months

• Adds a Slicer for the month

• Adds a Slicer for the year

Which three actions Should you perform in sequence?

26. 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 and support scheduled refresh in powerbi.com.

What should you do? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

27. HOTSPOT

You are profiling data by using Power Query Editor.

You have a table that contains a column named column1.

Column statistics and Value distribution for column1 are shown in the following exhibit.

28. DRAG DROP

You receive revenue data that must be included in Microsoft Power Bl reports.

You perform an initial load of the data from a Microsoft Excel source as shown in the following exhibit.





You plan to create several visuals from the data, including a visual that shows revenue split by year and product.

You need to transform the data to ensure that you can build the visuals. The solution must ensure that the columns are named appropriately for the data that they contain.

Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

29. HOTSPOT

You have the Power BI data model shown in the following exhibit.





Select the appropriate yes or no.

30. DRAG DROP

You have a Power B1 data model that contains two tables named Products and Sales.

A one-to-many relationship exists between the tables.

You have a report that contains a report-level filter for Products.

You need to create a measure that will return the percent of total sales for each product. The measure must respect the report-level filter when calculating the total.

How should you complete the DAX measure? To answer drag the appropriate DAX functions to the correct targets- Each function may be used once, more than once, or not at all the spirt bar between panes or scroll to view content. NOTE: Each correct selection is worth one point

31. You have a Power B1 semantic model named Model 1 that runs in import storage node.

You need to reduce the size of Model.

Which two action should you perform? Each connect answer presents a complete solution. NOTE: Each correct selection is worth one point.

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

33. DRAG DROP

You have a Power BI workspace that contains a single report named Sales.

You need to add all the visuals from Sales to a dashboard. The solution must ensure that additional visual added to the page area added automatically to the dashboard.

Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

34. 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 answer a question in this scenario, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.

You have a clustered bar chart that contains a measure named Salary as the value and a field named Employee as the axis. Salary is present in the data as numerical amount representing US dollars.

You need to create a reference line to show which employees are above the median salary.

Solution: You create a constant line and set the value to .5.

Does this meet the goal?

35. HOTSPOT

You have a Power Bl report.

You have the following tables.





You have the following DAX measure.

36. HOTSPOT

You have a dataset that contains revenue data from the past year.

You need to use anomaly detection in Power Bl to show anomalies in the dataset.

What should you configure? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

37. You have a data source that contain a column. The column contains case sensitive data.

You have a Power BI semantic model in DirectQuery mode.

You connect to the model and discover that it contains undefined values and errors.

You need to resolve the issue.

Solution: You implicitly convert the values into the required types.

Does this meet the goal?

38. HOTSPOT

You are using Power Query Editor to preview the data in a column named Max Temp.

The column statistics and value distribution are shown in the following exhibit.





Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic. NOTE: Each correct selection is worth one point.

39. DRAG DROP

You use Power Query Editor to preview the data shown in the following exhibit





You need to clean and transform the query so that all the rows of data are maintained, and error values in the discount column are replaced with a discount of 0.05. The solution must minimize administrative effort.

Which three actions should you perform in sequence? To answer move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

40. Which DAX expression should you use to get the ending balances in the balance sheet reports?

41. HOTSPOT

You have a semantic model named Model1 that contains the following tables





There is an active relationship between SaleDate and Date. There is an inactive relationship between ShippingDate and Date.

You need to create a new measure that will display the total amount of sales and support slicing by ShippingDate.

42. DRAG DROP

You have a folder that contains 100 CSV files.

You need to make the file metadata available as a single dataset by using Power Bi The solution must NOT store the data of the CSV files.

Which three actions should you perform in sequence. To answer, mow the appropriate actions from the list of actions to the answer area and arrange them m the correct order.

NOTE; More than one order of answer choices is correct. You will receive credit for any of the correct orders you select.

43. You have a report in Power Bl named report1 that is based on a shared dataset.

You need to minimize the risk of data exfiltration for report1. The solution must prevent other reports from being affected.

What should you do?

44. DRAG DROP

You receive annual sales data that must be included in Power Bl reports.

From Power Query Editor, you connect to the Microsoft Excel source shown in the following exhibit.





You need to create a report that meets the following requirements:

• Visualizes the Sales value over a period of years and months

• Adds a slicer for the month

• Adds a slicer for the year

45. You import a large dataset to Power Query Editor.

You need to identify whether a column contains only unique values.

Which two Data Preview options can you use? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point

46. DRAG DROP

You have a Microsoft Exert spreadsheet named Excel1 that contains survey results.

You have a Power Bl dashboard named Dashboard A that has Q&A enabled.

You need to ensure that users who can access Dashboard A can ask Questions based on the contents of Excel 1 and pm visuals based on their queries to Dashboard A. The solution must minimize development time.

Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

47. DRAG DROP

You have a Microsoft Excel workbook that contains two sheets named Sheet1 and Sheet2.

Sheet1 contains the following table named Table1.





Sheet2 contains the following table named Table2.





You need to use Power Query Editor to combine the products from Table1 and Table2 into the following table that has one column containing no duplicate values.





Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

48. HOTSPOT

You have a Power B1 report that contains the table visual shown in the following exhibit.





You need to modify the visual to display as shown in the following exhibit.





How should you configure the visual? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

49. You have a Power Bl report that contains a table visual. The visual contains a column.

The column contains whole numbers ranging from o* 1 to 20.

You need to use conditional formatting to meet the following requirements:

• Visually compare the values without having to read the text containing the number.

• Show a different format for each distinct value

• Hide the numeric value of ColumnA.

• Minimize development effort.

Which formatting should you use?

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

• State/Region

• Country

• Postal Code

Each Customer ID represents a unique customer m the Customer table. Each Address ID represents a unique address m the Address table. You need to create a query that has one row per customer. Each row must contain City. State/Region, and Country for each customer.

What should you do?

51. 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 answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.

You are modeling data by using Microsoft Power Bl. Part of the data model is a large Microsoft SQL Server table named Order that has more than 100 million records.

During the development process, you need to import a sample of the data from the Order table.

Solution: You write a DAX expression that uses the FILTER function.

Does this meet the goal?

52. HOTSPOT

You are creating a column chart visualization.

You configure groups as shown in the Groups exhibit. {Click the Groups tab.)





The visualization appears as shown in the Chart exhibit. (Click the Chart tab.)





For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.

53. DRAG DROP

You use Power Query Editor to load two queries named Query 1 and Query2 Query1 results in the following error.

54. Remove unused columns from tables in the data model. This will reduce the size of your PBIX file and make your data model more efficient. You can use Power Query Editor to remove any columns that are not used in your report or calculations.





You need to shape the query to display the following three columns:

* Month

* Sales

* Year

What should you select in Power Query Editor?

55. In the Power BI service, you create an app workplace that contains several dashboards.

You need to provide a user named [email protected] with the ability to edit and publish dashboards.

What should you do?

56. HOTSPOT

You use Power Query Editor to review a query that contains a column named Country.

You need to view the following information in the Data preview view for the Country column:

• The percentage of values that contain errors.

• The count of empty values.

What should you enable? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

57. HOTSPOT

You have a Power Bl semantic model that contains a table named Opportunity.

The Opportunity table contains a column named Qualification

The Qualification column contains values between 0 and V

You need to build a new measure to score the opportunities on a scale of low, medium, and high.

How should you complete the DAX formula? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

58. HOTSPOT

You plan to use Power Query Editor to get data from an API.

The API returns a JSON response.

You have a username and password tor the API.

Which data source and authentication method should you use to connect to the API? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

59. You have sales data in a star schema that contains four tables named Sales, Customer, Date, and Product. The Sales table contains purchase and ship dates.

Most often, you will use the purchase date to analyze the data, but you will analyze the data by both dates independently and together.

You need to design an imported dataset to support the analysis. The solution must minimize the model size and the number of queries against the data source.

Which data modeling design should you use?

60. You have a Power Bl workspace that contains a dataset. a report, and a dashboard.

The following groups have access:

• External users can access the dashboard.

• Managers can access the dashboard and a manager-specific report.

• Employees can access the dashboard and a row-level security (RLS) constrained report.

You need all users, including the external users, to be able to tag workspace administrators if they identify an issue with the dashboard. The solution must ensure that other users see the issues that were raised.

What should you use?

61. You have a Microsoft Power Bl dashboard.

You need to ensure that consumers of the dashboard can give you feedback that will be visible to the other consumers of the dashboard.

What should you use?

62. You have a Fabric workspace named Workspace1 that contains two Power Bl reports named Report1 and Report2.

You create a workspace app that contains both reports.

You need to ensure that the app meets the following requirements:

• Report1 must be visible to all the users in your organization.

• Report2 must be visible to only a security group named Group1.

What should you do next?

63. DRAG DROP

You have a Microsoft Power Bl workspace.

You need to grant the user capabilities shown in the following table.





The solution must use the principle of least privilege.

Which user role should you assign to each user? To answer, drag the appropriate roles to the correct users. Each role may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content. NOTE: Each correct selection is worth one point.

64. Topic 2, Contoso Ltd, Case Study



Overview

Contoso Ltd. is a manufacturing company that produces sports equipment. Contoso holds quarterly board meetings for which financial analysts manually prepare Microsoft Excel reports, including balance sheets and profit and loss statements for each of the company s four business units.



Data for the reports comes from the sources shown in the following table.





The balance sheet data is unrelated to the profit and loss results other than they both relate to dates.



The balance sheet data is imported and includes the final monthly balances of each account in the format shown in the following table.





The balance sheet data always includes a row for each account for each month.



The product catalog shows how products roll up to product categories, which roll up to the business units the product list is provided in the format shown in the following table.







Revenue data is provided at the date and product level. Expense data is provided at the date and department level.

Contoso wants the reports and datasets refreshed with minimum manual effort.

The company wants to provide the board with 3 single package of reports that will contain custom navigation and links to supplementary information.

Maintenance, including maturity updating data and access, must be minimized as much as possible.



The reports must be made available to the board from powerbi.com. A group in Microsoft Azure Active Director)' (Azure AD), part of Microsoft Entra. will be used to share information with the board.



Contoso identifies the following security requirements for analyst access:

• Analysts must be able to access all balance sheet and product catalog data.

• Analysts must be able to access only the profit and loss data of their respective business unit

• Analysts must be able to create new reports from the dataset that contains the profit and loss data, but the reports built by the analysts must NOT be included in the quarterly reports for the board.

• Analysts must NOT be able to share the quarterly reports with anyone.

• Analysts must NOT be able to make new reports by using the balance sheet data.

You plan to relate the balance sheet table to a date table in Power Bl in a many-to-one relationship based on the last day of the month. At least one of the balance sheet reports in the quarterly reporting package must show the ending balances for the quarter, as well as for the previous quarter.



The date table will contain the columns shown in the following table.





The definitions and attributes for the products departments, and business units must be consistent across all the reports.

The board must be able to get the following information from the quarterly reports:

• Revenue trends over time

• The ending balances of each account

• Changes m long-term liabilities from the previous quarter

• The percent of total revenue contributed by each product category

• A comparison of quarterly revenue versus the same quarter from the previous year

The reports must be updated with the latest data by 5 AM each day.



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 to ensure that you are able to complete all questions included on this exam in the time provided.

To answer the questions included in a case study, you will need to reference information that is provided in the case study. Case studies might contain exhibits and other resources that provide more information about the scenario that is described in the case study. Each question is independent of the other questions in this case study.

At the end of this case study, a review screen will appear. This screen allows you to review your answers and to make changes before you move to the next section of the exam. After you begin a new section, you cannot return to this section.



To start the case study

To display the first question in this case study, click the Next button. Use the buttons in the left pane to explore the content of the case study before you answer the questions. Clicking these buttons displays information such as business requirements, existing environment and problem statements. If the case study has an All Information tab, note that the information displayed is identical to the information displayed on the subsequent tabs. When you are ready to answer a question, click the Question button to return to the question.



Existing Environment

Contoso, Ltd. is a manufacturing company that produces outdoor equipment Contoso has quarterly board meetings for which financial analysts manually prepare Microsoft Excel reports, including profit and loss statements for each of the company's four business units, a company balance sheet, and net income projections for the next quarter.



Data and Sources

Data for the reports comes from three sources. Detailed revenue, cost and expense data comes from an Azure SQL database. Summary balance sheet data comes from Microsoft Dynamics 365 Business Central. The balance sheet data is not related to the profit and loss results; other than they both relate to dates.

Monthly revenue and expense projections for the next quarter come from a Microsoft SharePoint Online list. Quarterly projections relate to the profit and loss results by using the following shared dimensions: date, business unit, department, and product category.



Net Income Projection Data

Net income projection data is stored in a SharePoint Online list named Projections in the format shown in the following table.





Revenue projections are set at the monthly level and summed to show projections for the quarter.



Balance Sheet Data

The balance sheet data is imported with final balances for each account per month in the format shown in the following table.





There is always a row for each account for each month in the balance sheet data.



Dynamics 365 Business Central Data

Business Central contains a product catalog that shows how products roll up to product categories, which roll up to business units. Revenue data is provided at the date and product level. Expense data is provided at the date and department level.



Business Issues

Historically, it has taken two analysts a week to prepare the reports for the quarterly board meetings. Also, there is usually at least one issue each quarter where a value in a report is wrong because of a bad cell reference in an Excel formula. On occasion, there are conflicting results in the reports because the products and departments that roll up to each business unit are not defined consistently.



Planned Changes

Contoso plans to automate and standardize the quarterly reporting process by using Microsoft Power Bl. The company wants to how long it takes to populate reports to less than two days. The company wants to create common logic for business units, products, and departments to be used across all reports, including, but not limited, to the quarterly reporting for the board.



Technical Requirements

Contoso wants the reports and datasets refreshed with minimal manual effort

The company wants to provide a single package of reports to the board that contains custom navigation and links to supplementary information.

Maintenance, including manually updating data and access, must be minimized as much as possible.



Security Requirements

The reports must be made available to the board from powerbi.com. A mail-enabled security group will be used to share information with the board.

The analysts responsible for each business unit must see all the data the board sees, except the profit and loss data, which must be restricted to only their business unit's data. The analysts must be able to build new reports from the dataset that contains the profit and loss data, but any reports that the analysts build must not be included in the quarterly reports for the board. The analysts must not be able to share the quarterly reports with anyone.



Report Requirements

You plan to relate the balance sheet to a standard date table in Power Bl in a many-to-one relationship based on the last day of the month. At least one of the balance sheet reports in the quarterly reporting package must show the ending balances for the quarter, as well as for the previous quarter.



Projections must contain a column named RevenueProjection that contains the revenue projection amounts. A relationship must be created from Projections to a table named Date that contains the columns shown in the following table.





The relationships between products and departments to business units must be consistent across all reports.

The board must be able to get the following information from the quarterly reports:

• Revenue trends over time

• Ending balances for each account

• A comparison of expenses versus projections by quarter

• Changes in long-term liabilities from the previous quarter

• A comparison of quarterly revenue versus the same quarter during the prior year



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 once, or not at all. You may need to drag the split bar between panes or scroll to view content. NOTE: Each correct selection is worth one point.

65. You are using the key influencers visual to identify which factors affect the quantity of items sold in an order.

You add the following fields to the Explain By field:

* Customer Country

* Product Category

* Supplier Country

* Sales Employee

* Supplier Name

* Product Name

* Customer City

The key influencers visual returns the results shown in the following exhibit.





What can you identify from the visual?

66. You have a CSV file that contains user complaints. The file contains a column named Logged. Logged contains the date and time each compliant occurred.

The data in Logged is in the following format:

2018-12-31 at 08:59.

You need to be able to analyze the complaints by the logged date and use a built-in date hierarchy.

What should you do?

67. HOTSPOT

You create a Power Bl dataset that contains the table shown in the following exhibit.





You need to make the table available as an organizational data type In Microsoft Excel.

How should you configure the properties of the table? To answer select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

68. You have a Power B1 semantic model that contains tour queries named Query 1, Query2, Query3, and Query4, Query1 loads customer data Into the model and is referenced by the other three queries. You discover that data refresh for the model is slow.

You need to improve the data refresh time. The solution must minimi2e costs.

What should you do?

69. You have an on-premises Power BI Report Server.

You plan to create a report in Power BI Desktop and publish the report to the report server.

Which data source should the report use?

70. You have a BI dataset and a connected report.

You need to ensure that users can analyze data in Microsoft Excel by connecting directly to the dataset.

You grant the users the Build permission for dataset

What Should do next?

71. You are building a Power Bl report that uses data from an Azure SQL database named erp1.

You Import the following tables.





You need to perform the following analyses:

• Orders sold over time that include a measure of the total order value

• Orders by attributes of products sold

The solution must minimize update times when interacting with visuals in the report.

What should you do first?

72. You have a report that contains four pages. Each page contains slicers for the same four fields. Users report that when they select values on a slicer on one page, the visuals are not updated on all the pages. You need to recommend a solution to ensure that users can select a value once to filter the results on all the pages.

What are two possible recommendations to achieve this goal? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

73. 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 answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.

You have an on-premises data gateway.

You need to reduce the amount of data sent through the gateway by semantic models that run in Import storage mode.

Solution: You create aggregations to summarize results.

Does this meet the goal?

74. You manage a Power BI model has a table named Sales and product.

You need to ensure that a sales team can view only data that has a CountryRegionName value of United States and a ProductCategory value of Clothing.

What should you do from Power BI Desktop?

75. 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 answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.

You have a Power BI report that imports a date table and a sales table from an Azure SQL database data source.

The sales table has the following date foreign keys:

• Due Date

• Order Date

• Delivery Date

You need to support the analysis of sales over time based on all three dates at the same time.

Solution; You create measures that use the uSEREIATIOHSHIP DAX function to filter sales on the inactive relationships between the sales table and the date table.

Does this meet the goal?

76. Your company has training videos that are published to Microsoft Stream.

You need to surface the videos directly in a Microsoft Power BI dashboard.

Which type of tile should you add?

77. Which two types of visualizations can be used in the balance sheet reports to meet the reporting goals? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

78. You have a Power Bl report

You have a table named Dalai that contains 10 million rows.

Data is used in the following visuals:

• A card that shows the number of records

• A bar chart that snows total transaction amount by territory

• A scatter plot that shows transaction amount and profit amount on the axes and points colored by territory

You need to modify the scatter plot to make it easier for users to identify meaningful patterns. The solution must not affect the accuracy of the other visuals.

What should you do?

79. You have a table that contains sales data and approximately 1,000 rows.

You need to identify outliers in the table.

Which type of visualization should you use?

80. You have a Microsoft Power BI data model that contains three tables named Orders, Date, and City.

There is a one-to-many relationship between Date and Orders and between City and Orders.

The model contains two row-level security (RLS) roles named Role1 and Role2.

Role1 contains the following filter.

City[State Province] = "Kentucky"

Role2 contains the following filter.

Date[Calendar Year] = 2020

If a user is a member of both Role1 and Role2, what data will they see in a report that uses the model?

81. HOTSPOT

Vou have a Power B1 semantic model that contains the following table named Employees.





An employee is considered active if the TermDate column for that employee contains no value.

You need to create a DAX measure that will count the number of active employees.

How should you complete the DAX expression? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

82. You have a Power B1 dataset that contains quarterly sales performance data.

You need to enable managers to review the data in a format that meets the following requirements:

• Is optimized for printing.

• Renders data in Microsoft Excel, Word, PowerPoint, and PDF formats.

What should you create?

83. You have a Power BI dashboard that monitors the quality of manufacturing processes. The dashboard contains the following elements:

A line chart that shows the number of defective products manufactured by day.

A KPI visual that shows the current daily percentage of defective products manufactured.

You need to be notified when the daily percentage of defective products manufactured exceeds 3%.

What should you create?

84. You have a custom connector that returns ID, From, To, Subject, Body, and Has Attachments for every email sent during the past year. More than 10 million records are returned.

You build a report analyzing the internal networks of employees based on whom they send emails to.

You need to prevent report recipients from reading the analyzed emails. The solution must minimize the model size.

What should you do?

85. You have a Power Bl report that contains the table shown in the following exhibit.





The table contains conditional formatting that shows which stores are above, near, or below the monthly quota for returns. You need to ensure that the table is accessible to consumers of reports who have color vision deficiency.

What should you do?

86. A user creates a Power B1 report named ReportA that uses a custom theme You create a dashboard named DashboardA.

You need to ensure that DashboardA uses the custom theme. The solution must minimize development effort.

Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

87. 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 answer a question in this scenario, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.

You have a clustered bar chart that contains a measure named Salary as the value and a field named Employee as the axis. Salary is present in the data as numerical amount representing US dollars.

You need to create a reference line to show which employees are above the median salary.

Solution: You create a percentile line by using the Salary measure and set the percentile to 50%.

Does this meet the goal?

88. 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 scheduled to refresh twice a day at 08:00 and 17:00.

The report is a single page that contains 15 custom visuals and 10 default visuals.

Users say that the report is slow to load the visuals when they access and interact with the report

You need to recommend a solution to improve the performance of the report.

What should you recommend?

89. 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 answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.

From Power Query Editor, you profile the data shown in the following exhibit.





The IoT GUID and IoT ID columns are unique to each row in query.

You need to analyze IoT events by the hour and day of the year. The solution must improve dataset performance.

Solution: You remove the loT GUID column and retain the loT ID column.

Does this meet the goal?

90. HOTSPOT

You have a Power BI report that contains the table visual shown in the following exhibit.

91. You have the dashboard shown in the following exhibit.





You need to modify the dashboard to display as shown in the following exhibit.





What should you do?

92. You have a Power Bi report. The report contains a visual that snows gross sales by date The visual has anomaly detection enabled.

No anomalies ate detected

You need to increase the likelihood that anomaly detection will identify anomalies in the report.

What should you do?

93. 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 answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.

You create a parameter named DataSourceExcel that holds the file name and location of a Microsoft Excel data source.

You need to update the query to reference the parameter instead of multiple hard-coded copies of the location within each query definition.

Solution: You modify the source step of the queries to use DataSourceExcel as the file path.

Does this meet the goal?

94. You have the CSV file shown in the following table.





You use Power Query Editor to preview the data in the file.

You need to transform the data to meet the following requirements:

• The first column must contain the month.

• The second column must contain the year.

• The third column must contain the order amount for the month and year.

Which transformation should you use first?

95. You have a Power Bl report named Report1 and a dashboard named Dashboard1, 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 bar chart displays on Dashboard1.

What should you do?

96. You create the following step by using Power Query Editor.

= Table.ReplaceValue(SalesLT_Address,"1318","1319",Replacer.ReplaceText,{"AddressLine1"})

A row has a value of 21318 Lasalle Street in the AddressLine1 column.

What will the value be when the step is applied?

97. You have a Microsoft Power Bl dashboard. The report used to create the dashboard uses an imported dataset from a Microsoft SQL Server data source.

The dashboard is shown in the exhibit. (Click the Exhibit tab.)





What occurred at 12:03:06 PM?

98. DRAG DROP

You have a Power Bi report that contains five bookmarks.

You need to add an object to the report from which users can navigate between three specific bookmarks.

How should you complete the task? To answer, drag the appropriate actions to the correct steps, each action may be used once more than once, or not at all. You may need to drag the split bar between panes or scroll lo view content. NOTE: Each correct selection is worth one point.

99. 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 answer a question in this scenario, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.

You have a clustered bar chart that contains a measure named Salary as the value and a field named Employee as the axis. Salary is present in the data as numerical amount representing US dollars.

You need to create a reference line to show which employees are above the median salary.

Solution: You create an average line by using the Salary measure.

Does this meet the goal?

100. You have a Microsoft Power BI 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 scheduled to refresh twice a day at 08:00 and 17:00.

The report is a single page that contains 15 AppSource visuals and 10 default visuals.

Users say that the report is slow to load the visuals when they access and interact with the report.

You need to recommend a solution to improve the performance of the report.

What should you recommend?

101. HOTSPOT

You are using Power Bi Desktop to connect to an Azure SQL database.

The connection is configured as shown in the following exhibit.







Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic. NOTE: Each correct solution is worth one point

102. You have a Power BI model that contains a table named Sales.

The Sales table contains the following columns:

• Order Line ID

• Product ID

• Unit Price

• Order ID

• Quantity

Orders are uniquely identified by using the order ID and can have multiple order lines Each order line within an order contains a different product ID.

You need to write a DAX measure that counts the number of orders.

Which formula should you use?

103. HOTSPOT

You need to calculate the last day of the month in the balance sheet data to ensure that you can relate the balance sheet data to the Date table.

Which type of calculation and which formula should you use? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

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

105. You have a collection of reports for the HR department of your company. The datasets use row-level security (RLS). The company has multiple sales regions that each has an HR manager. You need to ensure that the HR managers can interact with the data from their region only. The HR managers must be prevented from changing the layout of the reports.

How should you provision access to the reports for the HR managers?

106. You import a Power Bl dataset that contains the following tables:

• Date

• Product

• Product Inventory

The Product inventory table contains 25 million rows.

A sample of the data is shown in the following table.





The Product Inventory table relates to the Date table by using the DateKey column. The Product inventory table relates to the Product table by using the ProductKey column. You need to reduce the size of the data model without losing information.

What should you do?

107. HOTSPOT

You are creating a quick measure as shown in the following exhibit.





You need to create a monthly rolling average measure for Sales over time.

How should you configure the quick measure calculation? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

108. HOTSPOT

You have a query that contains customer data in Power Query Editor as shown in the following exhibit.

109. You have a Rawer Bl report That imports a dace table and a sales table from an Azure SQL database data source.

The sales table has the following date foreign keys:

• Due Date

• Order Date

• Delivery Date

You need to support the analysis of sales over time based on all three dates at the same time.

Solution: From the Fields pane, you rename the date table as Due Date. You use a DAX expression to create Order Date and Delivery Date as calculated tables. You create active relationships between the sales table and each date table.

Does this meet the goal?

110. You have a Power Bi model mat contains a table named Date.

The Date table contains the fallowing columns:

• Date

• Fiscal year

• Fiscal Quartet

• Month Name

• Calendar Year

• Week Number

• Month Number

• Calendar Quarter

You need to create a calculated table based on the Date table. The calculated tab*e must contain only unique combinations of values for Calendar Year. Calendar Quarter and Calendar Month.

Which DAX function should you include in the table deflation?

111. DRAG DROP

You have the Power Bl data model shown in the following exhibit.

You create two row-level security (RlS) roles named Manager and CFO.

You plan to publish the dataset to the Power Bl service.

You need to create DAX expressions for the RLS filters.

The solution must meet the following requirements:

• Each manager must see only the data in the Sales and Human Resources tables for their own country.

• The CFO must be prevented from seeing the data in the Human Resources table.

• The CFO must see the sales data of all countries.

How should you complete the DAX expressions to meet the requirements? To answer, drag the appropriate expressions to the correct targets. Each expression may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content. NOTE: Each correct selection is worth one point.





The Country table contains the following data.





You plan to publish the dataset to the Power Bl service.

You need to create DAX expressions for the RLS filters.

The solution must meet the following requirements:

• Each manager must see only the data in the Sales and Human Resources tables for their own country.

• The CFO must be prevented from seeing the data in the Human Resources table.

• The CFO must see the sales data of all countries.

How should you complete the DAX expressions to meet the requirements? To answer, drag the appropriate expressions to the correct targets. Each expression may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content. NOTE: Each correct selection is worth one point.

112. 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 answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.

You are modeling data by using Microsoft Power BI. Part of the data model is a large Microsoft SQL Server table named Order that has more than 100 million records.

During the development process, you need to import a sample of the data from the Order table.

Solution: From Power Query Editor, you import the table and then add a filter step to the query.

Does this meet the goal?

113. You have a Power Bi report for the procurement department.

The report contains data from the following tables.





There is a one-to-many relationship from Suppliers to Lineitems that uses the ID and Supplier ID columns.

The report contains the visuals shown in the following table.





You need to minimize the size of the dataset without affecting the visuals.

What should you do?

114. You have two Power Bl reports named ReportA and ReportB that each uses a distinct color palette. You are creating a Power Bl dashboard that will include two visuals from each report

You need to use a consistent dark theme for the dashboard. The solution must preserve the original colors of the reports.

Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

115. 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 answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.

You have an on-premises data gateway.

You need to reduce the amount of data sent through the gateway by semantic models that run in Import storage mode.

Solution: You configure incremental refresh.

Does this meet the goal?

116. HOTSPOT

You have the data lineage shown in the following exhibit.





Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic. NOTE: Each correct selection is worth one point.

117. HOTSPOT

You have a Power BI semantic model named Model1.

You need to create a measure that will display the sales result for all units. The solution must maintain the existing filter.

How should you complete the DAX expression? TO answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

118. HOTSPOT

You have a column named UnitslnStock as shown in the following exhibit.





UnitsInStock has 75 non-null values, of which 51 are unique.

Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic. NOTE: Each correct selection is worth one point.

119. You use Power BI Desktop to open a PBIX file that contains a Microsoft Excel data source.

You attempt to refresh the data and receive the following error message.

Expression.Error: The Colum ‘cost’ of the table wasn’t found.

What is a possible cause of the error?

120. You have the Power Bl model shown in the following exhibit.





There are four departments in the Departments table.

You need to ensure that users can see the data of their respective department only.

What should you do?

121. HOTSPOT

You use Microsoft Power B1 Desktop to review the data shown in the following exhibit.

122. You have a Power B1 model that contains a table named Date.

The table has the following columns.

123. HOTSPOT





You have a dataset that has the permissions shown in the following exhibit.

Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic. NOTE: Each correct selection is worth one point.

124. DRAG DROP

You are modifying a Power Bi model by using Power Bl Desktop.

You have a table named Sales that contains the following fields.





You have a table named Transaction Size that contains the following data.





You need to create a calculated column to classify each transaction as small, medium, or large based on the value in Sales Amount.

How should you complete the code? To answer, drag the appropriate values to the correct targets.

Each value may be used once, more than once, or not at all.

You may need to drag the split bar between panes or scroll to view content. NOTE: Each correct selection is worth one point.

125. You have a Power BI semantic model that contains a table named Table1.

Table1 contains the following columns:

* WebsiteName

* URL

You need to create a report named Report1 that will contain a table visual.

The solution must meet the following requirements.

* Display the website name

* Enable users to navigate to the website’s URL by selecting the website name.

What should you use?

126. ion have a Power BI dataset that contains a table named Temperature Readings.

Temperature Readings contains the columns shown in the following table.





The table has 12 million rows. All the columns are needed for analysis.

You need to optimize the dataset to decrease the model size. The solution must not affect the precision of the data.

What should you do?

127. HOTSPOT

You need to create a visual as shown in the following exhibit.





The indicator color for Total Sales will be based on % Growth to Last Year.

The solution must use the existing calculations only.

How should you configure the visual? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

128. You have a Power Bl report for the marketing department.

The report reports on web traffic to a blog and contains data from the following tables.





There is a one-to-many relationship from Posts to Traffic that uses the URL and URL Visited columns.

The report contains the visuals shown in the following table.





The dataset takes a long time to refresh.

You need to modify Posts and Traffic queries to reduce toad times.

Which two actions will reduce the toad times? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

129. You open a query in Power Query Editor.

You need to identify the percentage of empty values in each column as quickly as possible.

Which Data Preview option should you select?

130. 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 answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.

From Power Query Editor, you profile the data shown in the following exhibit.





The IoT GUID and IoT ID columns are unique to each row in query.

You need to analyze IoT events by the hour and day of the year. The solution must improve dataset performance.

Solution: You split the loT DateTime column into a column named Date and a column named Time.

Does this meet the goal?

131. You need to create the semantic model.

Which storage mode should you use for the tables in the semantic model?

132. What should you create to meet the reporting requirements of the sales department?

133. You plan to create the chart shown in the following exhibit.





How should you create the dashed horizontal line denoting the 40th percentile of daily sales for the period shown?