Continue to Check PL-300 Free Dumps (Part 3, Q81-Q120): Verify That the PL-300 Dumps (V19.02) May Be So Helpful for Preparation

1. DRAG DROP

You have the line chart shown in the exhibit. (Click the Exhibit tab.)

You need to modify the chart to meet the following requirements:

✑ Identify months that have order counts above the mean.

✑ Display the mean monthly order count.

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.

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

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

4. You use Power Query to import two tables named Order Header and Order Details from an Azure SQL database. The Order Header table relates to the Order Details table by using a column named Order ID in each table.

You need to combine the tables into a single query that contains the unique columns of each table.

What should you select in Power Query Editor?

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

6. You have the dataset shown in the following exhibit.

You need to ensure that the visual shows only the 10 cities that have the highest sales profit.

What should you do?

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

8. You need to create a visualization that compares revenue and cost over time.

Which type of visualization should you use?

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

10. You need to configure access for the sales department users. The solution must me meet the security requirements.

What should you do?

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

12. You have a Microsoft SharePoint Online site that contains several document libraries. One of the document libraries contains manufacturing reports saved as Microsoft Excel files. All the manufacturing reports have the same data structure.

You need to load only the manufacturing reports to a table for analysis.

What should you do in Microsoft Power Bl Desktop?

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

14. You have a line chart that shows the number of employees in a department over time.

You need to see the total salary costs of the employees when you hover over a data point.

What is possible way to achieve this goal?

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

16. 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 (Pll). The solution must minimize configuration effort and impact on the dashboard design.

What should you use?

17. You need to create the semantic model.

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

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

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

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

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

22. You are developing a sales report that will have multiple pages. Each page will answer a different business question.

You plan to have a menu page that will show all the business questions.

You need to ensure that users can click each business question and be directed to the page where the question is answered. The solution must ensure that the menu page will work when deployed to any workspace.

What should you include on the menu page?

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

24. You need to create the relationship between the product list and the revenue results. The solution must minimize the time it takes to render visuals.

What should you set as the relationship cardinality?

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

26. You have a collection of reports for the HR department of your company.

You need to create a visualization for the HR department that shows a historic employee counts and predicts trends during the next six months.

Which type of visualization should you use?

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

28. You create a dashboard by using the Microsoft Power Bl Service. The dashboard contains a card visual that shows total sales from the current year. You grant users access to the dashboard by using the viewer role on the workspace. A user wants to receive daily notifications of the number shown on the card visual. You need to automate the notifications.

What should you do?

29. HOTSPOT

You have a dataset named Pens that contains the following columns:

✑ Item

✑ Unit Price

✑ Quantity Ordered

You need to create a visualization that shows the relationship between Unit Price and Quantity Ordered. The solution must highlight orders that have a similar unit price and ordered quantity.

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

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

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

32. You have a report that contains three pages. One of the pages contains a KPI visualization. You need to filter all the visualizations in the report except for the KPI visualization.

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

33. You need to get data from the Microsoft SQL Server tables.

What should you use to configure the connection'

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

35. You need to create the On-Time Shipping report. The report must include a visualization that shows the percentage of late orders.

Which type of visualization should you create?

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

37. HOTSPOT

You have a report page that contains the visuals 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.

38. You are configuring a Microsoft Power Bl data model to enable users to ask natural language questions by using Q&A. You have a table named Customer that has the following measure.

Customer Count = DISTINCTCOUNT(Customer[CustomerID])

Users frequently refer to customers as subscribers.

You need to ensure that the users can get a useful result for "subscriber count" by using Q&A. The solution must minimize the size of the model.

What should you do?

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

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