The Most Update Microsoft PL-300 Dumps Questions To Assess Yourself

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

2. You have a Power BI app named App1. The privacy for the App1 workspace is set to Private.

A user named User1 reports that App1 does not appear in the My organization AppSource. App1 appears in the My organization AppSource for your account.

You need to ensure that User sees App1 from the My organization AppSource.

What should you do?

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

4. You embed a Power BI report in a Microsoft SharePoint Online page.

A user name User1 can access the SharePoint Online page, but the Power BI web part displays the following error message: “This content isn’t available”.

User1 is unable to view the report.

You verify that you can access the SharePoint Online page and that the Power BI report displays as expected.

You need to ensure that User1 can view the report form SharePoint Online.

What should you do?

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

6. HOTSPOT

You are enhancing a Power BI model that has DAX calculations.

You need to create a measure that returns the year-to-date total sales from the same date of the previous calendar year.

Which DAX functions should you use? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

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

8. 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 several reports and dashboards in a workspace.

You need to grant all organizational users read access to a dashboard and several reports.

Solution: You assign all the users the Viewer role to the workspace.

Does this meet the goal?

9. You use an R visual to produce a map of 500,000 customers. You include the values of CustomerID, Latitude, and Longitude in the fields sent to the visual. Each customer ID is unique.

In powerbi.com, when users load the visual, they only see some of the customers.

What is the cause of the issue?

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

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

12. HOTSPOT

You need to create a relationship in the dataset for RLS.

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

13. 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 report-level filter that filters based on the order date.

Does this meet the goal?

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

15. DRAG DROP

You are modeling data in table named SalesDetail by using Microsoft Power Bl.

You need to provide end users with access to the summary statistics about the SalesDetail data. The users require insights on the completeness of the data and the value distributions.

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.

16. For the sales department at your company, you publish a Power Bl report that imports data from a Microsoft Excel We located in a Microsoft SharePoint folder. The data model contains several measures You need to create a Power Bl report from the existing data. The solution must minimize development effort.

Which type of data source should you use?

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

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

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

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

21. You have a report that contains a bar chart and a column chart. The bar chart shows customer count by

customer segment. The column chart shows sales by month.

You need to ensure that when a segment is selected in the bar chart, you see which portion of the total sales for the month belongs to the customer segment.

How should the visual interactions be set on the column chart when the bar chart is selected?

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

23. 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 new column to the Product Subcategory table that uses the following formula.

=if [Subcategory] =null then “NA” else [Subcategory]

Which command should you use in Query Editor?

24. Topic 3, Northwind Traders



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 question 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 question on 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 on 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. General Overview

Northwind Traders is a specialty food import company.

The company recently implemented Power BI to better understand its top customers, products, and suppliers.



Overview. Business Issues

The sales department relies on the IT department to generate reports in Microsoft SQL Server Reporting Services (SSRS). The IT department takes too long to generate the reports and often misunderstands the report requirements.



Existing Environment. Data Sources

Northwind Traders uses the data sources shown in the following table.





Source2 is exported daily from a third-party system and stored in Microsoft SharePoint Online.



Existing Environment. Customer Worksheet

Source2 contains a single worksheet named Customer Details.



The first 11 rows of the worksheet are shown in the following table.





All the fields in Source2 are mandatory.

The Address column in Customer Details is the billing address, which can differ from the shipping address.



Existing Environment. Azure SQL Database

Source1 contains the following table:

- Orders

- Products

- Suppliers

- Categories

- Order Details

- Sales Employees



The Orders table contains the following columns.







The Order Details table contains the following columns.





The address in the Orders table is the shipping address, which can differ from the billing address.



The Products table contains the following columns.







The Categories table contains the following columns.







The Suppliers table contains the following columns.







The Sales Employees table contains the following columns.





Each employee in the Sales Employees table is assigned to one sales region. Multiple employees can be assigned to each region.



Requirements. Report Requirements

Northwind Traders requires the following reports:

- Top Products

- Top Customers

- On-Time Shipping

The Top Customers report will show the top 20 customers based on the highest sales amounts in a selected order month or quarter, product category, and sales region.



The Top Products report will show the top 20 products based on the highest sales amounts sold in a selected order month or quarter, sales region, and product category. The report must also show which suppliers provide the top products.



The On-Time Shipping report will show the following metrics for a selected shipping month or quarter:

- The percentage of orders that were shipped late by country and shipping region

- Customers that had multiple late shipments during the last quarter



Northwind Traders defines late orders as those shipped after the required shipping date.

The warehouse shipping department must be notified if the percentage of late orders within the current month exceeds 5%.

The reports must show historical data for the current calendar year and the last three calendar years.



Requirements. Technical Requirements

Northwind Traders identifies the following technical requirements:

- A single dataset must support all three reports.

- The reports must be stored in a single Power BI workspace.

- Report data must be current as of 7 AM Pacific Time each day.

- The reports must provide fast response times when users interact with a visualization.

- The data model must minimize the size of the dataset as much as possible, while meeting the report requirements and the technical requirements.



Requirements. Security Requirements

Access to the reports must be granted to Azure Active Directory (Azure AD) security groups only.

An Azure AD security group exists for each department.



The sales department must be able to perform the following tasks in Power BI:

- Create, edit, and delete content in the reports.

- Manage permissions for workspaces, datasets, and report.

- Publish, unpublish, update, and change the permissions for an app.

- Assign Azure AD groups role-based access to the reports workspace.



Users in the sales department must be able to access only the data of the sales region to which they are assigned in the Sales Employees table.



Power BI has the following row-level security (RLS) Table filter DAX expression for the Sales Employees table.

[EmailAddress] = USERNAME()



RLS will be applied only to the sales department users. Users in all other departments must be able to view all the data.



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

What should you do in Power BI Desktop?

25. You need to create a relationship in the dataset for RLS.

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

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

27. In Power BI Desktop, you are building a sales report that contains two tables. Both tables have row-level security (RLS) configured.

You need to create a relationship between the tables. The solution must ensure that bidirectional cross-filtering honors the RLS settings.

What should you do?

28. You have a Power BI tenant.

You have reports that use financial datasets and are exported as PDF files.

You need to ensure that the reports are encrypted.

What should you implement?

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

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

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

32. You plan to develop a Power BI report that has a bar chart to display the number of customers by location.

You have a table named Customer that has the following columns:

• Customer ID

• CustomerName

• Address

• City

• ProvState

• Country

You need to allow users to drill down by location. The report will display the number of each customer by Country, and drill down to ProvState, and then to City.

How should you configure the drill down in the bar chart?

33. A business intelligence (Bl) developer creates a dataflow in Power Bl that uses DirectQuery to access tables from an on premises Microsoft SQL server. The Enhanced Dataflows Compute Engine is turned on for the dataflow.

You need to use the dataflow in a report.

The solution must meet the following requirements:

• Minimize online processing operations.

• Minimize calculation times and render times for visuals.

• include data from the current year, up to and including the previous day.

What should you do?

34. You have a sales system that contains the tables shown in the following table.





The Date table is marked as a date table.

DatelD is the date data type. You need to create an annual sales growth percentage measure.

Which DAX expression should you use?

35. 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 several reports and dashboards in a workspace.

You need to grant all organizational users read access to a dashboard and several reports.

Solution: You enable included in app for all assets.

Does this meet the goal?

36. Your organization has a team of power users who recently created 20 Power BI dashboards.

The power users share the dashboards with other users in the organization.

When the users attempt to access the dashboards, they receive the error message shown in the exhibit. (Click the Exhibit.)





You need to ensure that all the users can access the dashboards.

What should you do first?

37. You have an app workspace that contains a dashboard and four reports. All the reports are generated from a single dataset that contains sales data for your company.

The reports display the data configured as shown in the following table.





You need to ensure that the users of the reports can locate the correct report by using natural language queries.

What should you do?

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

39. HOTSPOT

You are creating a Microsoft Power Bl imported data model to perform basket analysis. The goal of the analysis is to identify which products are usually bought together in the same transaction across and within sales territories.

You import a fact table named Sales as shown in the exhibit. (Click the Exhibit tab.)





The related dimension tables are imported into the model.

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

40. You need to create a relationship between the Weekly_Returns table and the Date table to meet the reporting requirements of the regional managers.

What should you do?

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

42. You have a Power B1 report that contains three pages named Page1, Page2, and Page3. All the pages have the same slicers. You need to ensure that all the filters applied to Page1 apply to Page1 and Page3 only.

What should you do?

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

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

45. HOTSPOT

You open powerbi.com 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 selection is worth one point.

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

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

48. DRAG DROP

You are preparing a financial report in Power BI.

You connect to the data stored in a Microsoft Excel spreadsheet by using Power Query Editor as shown in the following exhibit.





You need to prepare the data to support the following:

Visualizations that include all measures in the data over time

Year-over-year calculations for all the measures

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

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

50. 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 model that contains two tables named Sales and Date. Sales contains four columns named TotalCost, DueDate, ShipDate, and OrderDate. Date contains one column named Date.

The tables have the following relationships:

- Sales[DueDate] and Date[Date]

- Sales[ShipDate] and Date[Date]

- Sales[OrderDate] and Date[Date]

The active relationship is on Sales[DueDate].

You need to create measures to count the number of orders by [ShipDate] and the orders by [OrderDate]. You must meet the goal without duplicating data or loading additional data.

Solution: You create measures that use the CALCULATE, COUNT, and USERELATIONSHIP DAX functions.

Does this meet the goal?

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

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

What should you do before you can create the relationship?

53. HOTSPOT

You view a query named Transactions as shown in the following exhibit.





The query gets CSV files from a folder.

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.