2023 PL-300 exam torrent PL-300 Study Guide
Easily pass PL-300 Exam with our Dumps & PDF Test Engine
NEW QUESTION # 96
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.
Answer:
Explanation:
NEW QUESTION # 97
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?
- A. Create a new table based on the Date table where date-id is unique, and then create a many-to-many relationship to Weekly_Return.
- B. In the Weekly.Returns table, create a new calculated column named date-id in a format of yyyymmdd and use the calculated column to create a relationship to the Date table.
- C. Add the Weekly_Returns data to the Sales table by using related DAX functions.
Answer: B
Explanation:
Scenario: Region managers require a visual to analyze weekly sales and returns.
To relate the two tables we need a common column.
NEW QUESTION # 98
You are creating a Microsoft Power BI data model that has the tables shown in the following table.
The Products table is related to the ProductCategory table through the ProductCategoryID column.
You need to ensure that you can analyze sales by product category.
How should you configure the relationships from Products to ProductCategory? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
Reference:
https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-relationships-understand
NEW QUESTION # 99
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?
- A. Tag the user in a comment.
- B. Create a subscription.
- C. Create a data alert.
- D. Share the dashboard to the user.
Answer: B
Explanation:
You can subscribe yourself and your colleagues to the report pages, dashboards, and paginated reports that matter most to you. Power BI e-mail subscriptions allow you to:
Decide how often you want to receive the emails: daily, weekly, hourly, monthly, or once a day after the initial data refresh.
Choose the time you want to receive the email, if you choose daily, weekly, hourly, or monthly.
Note: Email subscriptions don't support most custom visuals. The one exception is those custom visuals that have been certified.
Email subscriptions don't support R-powered custom visuals at this time.
Incorrect Answers:
A: Set data alerts to notify you when data in your dashboards changes beyond limits you set.
Reference:
https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-report-subscribe
https://docs.microsoft.com/en-us/power-bi/create-reports/service-set-data-alerts
NEW QUESTION # 100
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 are a.
Answer:
Explanation:
NEW QUESTION # 101
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.
Answer:
Explanation:
NEW QUESTION # 102
DRAG DROP
You are using existing reports to build a dashboard that will be viewed frequently in portrait mode on mobile phones.
You need to build the dashboard.
Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
Answer:
Explanation:
NEW QUESTION # 103
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.
Answer:
Explanation:
Reference:
https://docs.microsoft.com/en-us/power-bi/service-create-distribute-apps
https://docs.microsoft.com/en-us/power-bi/service-collaborate-power-bi-workspace
NEW QUESTION # 104
You plan to create the Power Bl model shown in the exhibit. (Click the Exhibit tab.) The data has the following refresh requirements:
* Customer must be refreshed daily.
* Date must be refreshed once every three years.
* Sales must be refreshed in near real time.
* SalesAggregate must be refreshed once per week.
You need to select the storage modes for the tables. The solution must meet the following requirements:
Answer:
Explanation:
Explanation
NEW QUESTION # 105
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?
- A. Table.Distinct
- B. Table.RemoveMatchingRows
- C. Table.ReplaceMatchingRows
- D. Table.InDistinct
Answer: A
Explanation:
Explanation
References: https://msdn.microsoft.com/en-us/library/mt260775.aspx
NEW QUESTION # 106
You have a Power Bl report that contains three pages. The pages are used to analyze sales across various countries.
You add a sheer named Country to each page of the report.
You need to configure the report to meet the following requirements:
* When a user selects a country on the first page, the report must filter the other pages.
* The second and third pages must display only the filtered results.
Which task should you perform for each requirement? To answer, drag the appropriate task to the correct requirement. Each task 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.
Answer:
Explanation:
NEW QUESTION # 107
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.
Answer:
Explanation:
NEW QUESTION # 108
You have a dataset named Pens that contains the following columns:
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.
Answer:
Explanation:
Explanation
Box 1: A scatter plot...
A scatter chart always has two value axes to show: one set of numerical data along a horizontal axis and another set of numerical values along a vertical axis. The chart displays points at the intersection of an x and y numerical value, combining these values into single data points. Power BI may distribute these data points evenly or unevenly across the horizontal axis. It depends on the data the chart represents.
Box 2: Automatically find clusters
Scatter charts are a great choice to show patterns in large sets of data, for example by showing linear or non-linear trends, clusters, and outliers.
Reference:
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-scatter
NEW QUESTION # 109
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] - 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.
Answer:
Explanation:
Reference:
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-radial-gauge-charts
NEW QUESTION # 110
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.
Answer:
Explanation:
Reference:
https://docs.microsoft.com/en-us/dax/topn-function-dax
NEW QUESTION # 111
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 dat a. 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.
Answer:
Explanation:
1 - Create a blank query a sa data soure.
2 - Specify the following query, then close and apply.,,,,,
3 - Create a visual for the query table.
NEW QUESTION # 112
What should you create to meet the reporting requirements of the sales department?
- A. a measure that uses a formula of SUM (Sales [sales_id])
- B. a measure that uses a formula of COUNTROWS (Sales)
- C. a calculated column that uses a formula of SUM (Sales [sales_id])
- D. a calculated column that use a formula of COUNTA(sales [sales_id])
Answer: B
Explanation:
The sale department requires reports that contain the number of sales transactions.
The COUNTROWS function counts the number of rows in the specified table, or in a table defined by an expression.
Reference:
https://docs.microsoft.com/en-us/dax/countrows-function-dax
Topic 2, Contoso Ltd,
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
NEW QUESTION # 113
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?
- A. Apply row-level security (RLS) to the shared dataset.
- B. Clear Allow recipients to share your dashboard and Allow users to build new content using the underlying datasets for the dataset.
- C. Select the Allow end users to export both summarized and underlying data from the service or Report Server Export data option for the report.
- D. Select the Don't allow end users to export any data from the service or Report Server Export data option for the report.
Answer: D
NEW QUESTION # 114
......
PL-300 PDF Pass Leader, PL-300 Latest Real Test: https://troytec.itpassleader.com/Microsoft/PL-300-dumps-pass-exam.html