(Microsoft) Authentic PL-300 Dumps – Reduce Your Chances of Failure

1. A manager can represent only a single country.

You need to use row-level security (RLS) to meet the following requirements:

The managers must only see the data of their respective country.

The number of RLS roles must be minimized.

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

2. You are creating a report in Power BI Desktop.

You load a data extract that includes a free text field named coll.

You need to analyze the frequency distribution of the string lengths in col1. The solution must not affect the size of the model.

What should you do?

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

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

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

6. You plan to embed multiple visualization in a public website.

Your Power BI infrastructure contains the visualizations configured as shown in the following table.





Which two visualizations can you embed into the website? Each correct answer presents a complete the solution. NOTE: Each correct selection is worth one point.

7. You have a Power Bl report hosted on powerbi.com that displays expenses by department for department managers.

The report contains a line chart that shows expenses by month.

You need to enable users to choose between viewing the report as a line chart or a column chart. The solution must minimize development and maintenance effort.

What should you do?

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

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

10. CORRECT TEXT

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

The table has the following columns.

11. 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 add a Power Apps custom visual to the report.

Does this meet the goal?

12. 1. Topic 1, Litware, Inc. 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 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.



Overview

Litware, Inc. is an online retailer that uses Microsoft Power Bl dashboards and reports.

The company plans to leverage data from Microsoft SQL Server databases, Microsoft Excel files, text files, and several other data sources.

Litware uses Azure Active Directory (Azure AD) to authenticate users.



Existing Environment

Sales Data

Litware has online sales data that has the SQL schema shown in the following table.





In the Date table, the dateid column has a format of yyyymmdd and the month column has a format of yyyymm.

The week column in the Date table and the weekid column in the Weekly_Returns table have a format of yyyyww.

The regionid column can be managed by only one sales manager.



Data Concerns

You are concerned with the quality and completeness of the sales data. You plan to verify the sales data for negative sales amounts.



Reporting Requirements

Litware identifies the following technical requirements:

• Executives require a visual that shows sales by region.

• Regional managers require a visual to analyze weekly sales and returns.

• Sales managers must be able to see the sales data of their respective region only.

• The sales managers require a visual to analyze sales performance versus sales targets.

• The sale department requires reports that contain the number of sales transactions.

• Users must be able to see the month in reports as shown in the following example: Feb 2020.

• The customer service department requires a visual that can be filtered by both sales month and ship month independently.



HOTSPOT

You publish the dataset to powerbi.com.

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

13. You have a dashboard that contains tiles pinned from a single report as shown in the Original Dashboard exhibit. (Click the Original Dashboard tab.)





You need to modify the dashboard to appear as shown in the Modified Dashboard exhibit. (Click the Modified Dashboard tab.)





What should you do?

14. You have a Power BI dashboard that displays different visualizations of company sales.

You enable Q&A on the dashboard.

You need to provide users with sample questions that they can ask when using Q&A.

Which settings should you modify from the Power BI Settings?

15. You have four sales regions. Each region has multiple sales managers.

You implement row-level security (RLS) in a data model. You assign the relevant distribution lists to each role.

You have sales reports that enable analysis by region. The sales managers can view the sales records of their region. The sales managers are prevented from viewing records from other regions.

A sales manager changes to a different region.

You need to ensure that the sales manager can see the correct sales data.

What should you do?

16. You are reviewing a query that produces 10,000 rows in the 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.

17. 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 add a WHERE clause to the SQL statement.

Does this meet the goal?

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

19. You have a Power Bl workspace that contains several reports.

You need to provide a user with the ability to create a dashboard that will use the visuals from the reports.

What should you do?

20. You are building a Power BI report to analyze customer segments.

You need to identify customer segments dynamically based on the Bounce Rate across dimensions such as source, geography, and demographics. The solution must minimize analysis effort.

Which type of visualization should you use?

21. You have the visual shown in the exhibit. (Click the Exhibit tab.)





You need to show the relationship between Total Cost and Total Sales over time.

What should you do?

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

23. You have a report that includes a card visualization.

You need to apply the following conditional formatting to the card while minimizing design effort.

For values that are greater than or equal to 100, the font of the data label must be dark red.

For values that are less than 100, the font of the data label must be dark gray.

Which type of format should you use?

24. You are building a data model for a Power Bl report.

You have data formatted as shown in the following table.





You need to create a clustered bar chart as shown in the following exhibit.





What should you do?

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

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

27. You have the tables shown in the following table.





The Impressions table contains approximately 30 million records per month.

You need to create an ad analytics system to meet the following requirements:

✑ Present ad impression counts for the day, campaign, and Site_name. The analytics for the last year are required.

✑ Minimize the data model size.

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

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

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

30. You are creating a dashboard by using the Power Bl service.

You have an existing report page that contains three charts.

You need to add the charts to the dashboard while maintaining the interactivity between the charts.

What should you do?

31. HOTSPOT

You need to create the Top Customers report.

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

32. 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 each statement based on the information presented in the graphic. NOTE: Each correct selection is worth one point.

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

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

35. DRAG DROP

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

Sales has the following three measures:

✑ A measure named Total Sales Last Year that displays the sales from the previous calendar year. The current value is 32.89 million.

✑ A measure named Total Sales This Year that displays the sales from the current calendar year. The current value is 11.69 million.

✑ A measure named Total Sales Difference that uses a DAX formula of Sales[Last Year] C Sales[This Year].

You need to create the following visualization.





How should you configure the visualization? To answer, drag the appropriate measures to the correct fields. 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.

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

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

38. CORRECT TEXT

The table has the following columns.





You need to add a column that will be used to sort the Year Month column chronologically.

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

40. You need to create the dataset.

Which dataset mode should you use?

41. You build a report to analyze customer transactions from a database that contains the tables shown in the following table.





You import the tables.

Which relationship should you use to link the tables?

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

43. 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 files Transactions201801.csv to Transactions201812.csv have an older layout without the extra fields needed for analysis. Each file contains 10 to 50 transactions."

You get data from the folder and select Combine & Load. The Combine Files dialog box is shown in the exhibit. (Click the Exhibit 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.

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

45. 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 the date foreign keys.

Solution: For each date foreign key, you add inactive relationships between the sales table and the date table.

Does this meet the goal?

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

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. You plan to create a dashboard in the Power BI service that retrieves data from a Microsoft SQL Server database. The dashboard will be shared between the users in your organization.

You need to ensure that the users will see the current data when they view the dashboard.

How should you configure the connection to the data source?

49. Note: This question is a part of a series of questions that present the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a different goal and answer choices, but the text of the scenario is exactly the same in each question in this series.

Start of repeated scenario

You have a Microsoft SQL Server database that has the tables shown in the Database Diagram exhibit. (Click the Exhibit.)





You plan to develop a Power BI model as shown in the Power BI Model exhibit. (Click the Exhibit).





You plan to use Power BI to import data from 2013 to 2015.

Product Subcategory [Subcategory] contains NULL values.

End of repeated scenario.

You implement the Power BI model.

You need to add a measure to rank total sales by product.

The results must appear as shown in the following table.





Which DAX formula should you use?

50. The Sales table contains records of sales by day from the last five years up until today's date.

You plan to create a measure to return the total sales Of March 2021 when March 2022 is selected.

Which DAX expression should you use?

51. You need to design the data model to meet the report requirements.

What should you do in Power BI Desktop?

52. DRAG DROP

You are building a dataset from a JSON file that contains an array of documents.

You need to import attributes as columns from all the documents in the JSON file. The solution must ensure that date attributes can be used as date hierarchies in Microsoft Power BI reports.

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.

53. You need to create a Power BI theme that will be used in multiple reports. The theme will include corporate branding for font size, color, and bar chart formatting.

What should you do?

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

55. You have multiple dashboards.

You need to ensure that when users browse the available dashboards from powerbi.com, they can see which dashboards contain Personally Identifiable Information (PII). The solution must minimize configuration effort and impact on the dashboard design.

What should you use?

56. You need to provide a solution to provide the sales managers with the required access.

What should you include in the solution?

57. From Power 61 Desktop, you publish a new dataset and report lo a Power Bl workspace. The dataset has a row-level security (RLS) role named HR. You need to ensure that the HR team members have RLS applied when they view reports based on the dataset.

What should you do?

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

59. 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 Microsoft Excel workbook that is saved to Microsoft SharePoint Online. The workbook contains several Power View sheets.

You need to recreate the Power View sheets as reports in the Power Bl service.

Solution: From the Power Bl service, get the data from SharePoint Online, and then click Connect

Does this meet the goal?

60. You need to design the data model to meet the report requirements.

What should you do m Power Bl Desktop?

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

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

63. HOTSPOT

You are profiling data by using Power Query Editor.

The AddressLine2 column in a table named Address is 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.

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

65. HOTSPOT

You have a Power BI imported dataset that contains the data model 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.

66. You need to create the required relationship for the executive's visual.

What should you do before you can create the relationship?

67. You have a large dataset that contains more than 1 million rows. The table has a datetime column named Date.

You need to reduce the size of the data model.

What should you do?

68. You build a Power Bi report that displays loT temperature data streaming from a refrigerator.

You publish the report to the Power BI service.

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

What should you do?

69. CORRECT TEXT

You need to create the Top Customers report.

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

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

71. DRAG DROP

You are creating a Power Bi model and report.

You have a single table in a data mode) named Product Product contains the following fields:

• ID

• Name

• Color

• Category

• Total Sales

You need to create a calculated table that shows only the top eight products based on the highest value in Total Sales.

How should you complete the DAX expression? To answer, drag the appropriate values to the coned 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.

72. HOTSPOT

You need to design the data model and the relationships for the Customer Details worksheet and the Orders table by using Power BI. The solution must meet the report requirements.

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

73. HOTSPOT

Your company plans to use Power BI for 20 users in the sales department.

The users will perform the following tasks:

✑ Access a published Power BI app

✑ Modify reports in an app workspace

✑ Share dashboards created in My Workspace

You need to identify which Power BI licenses are required for the tasks. The solution must use the Power BI (free) licenses, whenever possible.

Which license should you identify for each task? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

74. You have a Microsoft Excel file on a file server.

You create a Power BI report and import a table from the Excel file.

You publish the report.

You need to ensure that the data refreshes every four hours.

What should you do first?

75. You are creating a Power BI report to analyze consumer purchasing patterns from a table named Transactions. The Transactions table contains a numeric field named Spend. You need to include a visual that identifies which fields have the greatest impact on Spend.

Which type of visual should you use?

76. CORRECT TEXT

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.

77. 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 query for a table named Sales. Sales has a column named CustomerlD. The Data Type of CustomerlD is Whole Number.

You refresh the data and find several errors. You discover that new entries in the Sales table contain nonnumeric values.

You need to ensure that nonnumeric values in the CustomerlD column are set to 0.

Solution: From Query Editor, select the CustomerlD column and click Remove Errors.

Does this meet the goal?

78. DRAG DROP

You have a Power Bl workspace that contains a single-page report named Sales.

You need to add all the visuals from Sales to a dashboard. The solution must ensure that additional visuals added to the page are 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.

79. 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: You add a WHERE clause to the SQL statement.

Does this meet the goal?

80. HOTSPOT

You have a Power BI report.

You need to create a calculated table to return the 100 highest spending customers.

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.

81. Note: This question is a part of a series of questions that present the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a different goal and answer choices, but the text of the scenario is exactly the same in each question in this series.

Start of repeated scenario

You have a Microsoft SQL Server database that has the tables shown in the Database Diagram exhibit. (Click the Exhibit.)





You plan to develop a Power BI model as shown in the Power BI Model exhibit. (Click the Exhibit).





You plan to use Power BI to import data from 2013 to 2015.

Product Subcategory [Subcategory] contains NULL values.

End of repeated scenario.

You implement the Power BI model.

You add another table named Territory to the model.

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





You need to create a relationship between the Territory table and the Sales table.

Which function should you use in the query for Territory before you create the relationship?

82. You have the visual shown in the Original exhibit. {Click the Original tab.)





You need to configure the visual as shown in the Modified exhibit. (Click the Modified tab.)





What should you add to the visual?

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

84. What is the minimum number of Power BI datasets needed to support the reports?

85. You have a prospective customer list that contains 1,500 rows of data.

The list contains the following fields:

✑ First name

✑ Last name

✑ Email address

✑ State/Region

✑ Phone number

You import the list into Power Query Editor.

You need to ensure that the list contains records for each State/Region to which you want to target a marketing campaign.

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

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

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

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

89. You have a Power BI report that contains four pages.

All the pages contain a slicer for a field named Country,

You need to ensure that when a user selects a county on page l, the selection is retained on page 2 and page 3. The solution must prevent page 4 from being affected by selections on the other pages,

What should you do?

90. 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 the date foreign keys.

Solution: From Power Query Editor, you rename the date query as Due Date. You reference the Due Date query twice to make the queries for Order Date and Delivery Date.

Does this meet the goal?

91. CORRECT TEXT

You have a Power Bl report that contains a measure named Total Sales.

You need to create a new measure that will return the sum of Total Sates for a year up to a selected date.

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.

92. DRAG DROP

In Power Query Editor, you have three queries named ProductCategory, ProductSubCategory, and Product.

Every Product has a ProductSubCategory.

Not every ProductsubCategory has a parent ProductCategory.

You need to merge the three queries into a single query. The solution must ensure the best performance in Power Query.

How should you merge the tables? To answer, drag the appropriate merge types to the correct queries. Each merge type 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.

93. HOTSPOT

You have a Power Bl report named Orders that supports the following analysis:

• Total sales over time

• The count of orders over time

• New and repeat customer counts

The data model size is nearing the limit for a dataset in shared capacity.

The model view for the dataset is shown in the following exhibit.

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