Instant Download PL-300 Dumps Q&As Provide PDF&Test Engine
Fast Exam Updates PL-300 dumps with PDF Test Engine Practice
NEW QUESTION # 142
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.
Answer:
Explanation:
Reference:
https://community.powerbi.com/t5/Desktop/Error-calculating-QOQ-using-quick-measure/m-p/547054
NEW QUESTION # 143
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?
- A. A user added a comment to a tile.
- B. The dashboard tile cache refreshed.
- C. A new transaction was added to the data source.
- D. A user pressed F5
Answer: D
Explanation:
Reference:
https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-data
NEW QUESTION # 144
You have a Microsoft Power BI data model that contains three tables named Sales, Product, and Date.
The Sales table has an existing measure named [Total Sales] that sums the total sales from the Sales table.
You need to write a calculation that returns the percentage of total sales that a selected ProductCategoryName value represents. The calculation must respect any slicers on ProductCategoryName and must show the percentage of visible total sales. For example, if there are four ProductCategoryName values, and a user filters one out, a table showing ProductCategoryName and the calculation must sum up to 100 percent.
How should you complete the calculation? To answer, drag the appropriate values to the correct targets. Each value may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
Reference:
https://docs.microsoft.com/en-us/dax/allselected-function-dax
NEW QUESTION # 145
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?
- A. Change the data type of the Logged column to Date.
- B. Apply a transformation to extract the last 11 characters of the Logged column and set the data type of the new column to Date.
- C. Apply a transformation to extract the first 11 characters of the Logged column.
- D. Split the Logged column by using at as the delimiter.
Answer: D
Explanation:
Simply create a custom table in Power Query, enter the date shown in the question into a column called Date, and then Split it by a delimiter. No need for spaces on either side of "at" Power BI takes care of the rest:
= Table.SplitColumn(#"Changed Type", "Date", Splitter.SplitTextByDelimiter("at", QuoteStyle.Csv), {"Date.1", "Date.2"}) It will even automatically change the type to Date:
= Table.TransformColumnTypes(#"Split Column by Delimiter",{{"Date.1", type date}, {"Date.2", type time}})
NEW QUESTION # 146
You have the following table named Location.
The GeoCode column represents the country where each customer is located.
You create a map visualization as shown in the exhibit. (Click the Exhibit tab.)
You need to ensure that the map displays the country locations.
What should you do?
- A. Change the name of the Location table to Country.
- B. Change the Default Summarization of the GeoCode column.
- C. Change the Data Type of the GeoCode column.
- D. Change the name of the GeoCode column to
- E. Add a Geoportal column to the Location table.
- F. Replace the values in the GeoCode column with postal codes or zip codes.
Answer: D
Explanation:
Explanation
References:
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-map-tips-and-tricks
NEW QUESTION # 147
You have a Power BI model that contains the following data.
The Date table relates to the Sales table by using the Date columns.
You need to create a calculated table that v/ill contain the following:
Answer:
Explanation:
Explanation
NEW QUESTION # 148
You need to provide a solution to provide the sales managers with the required access.
What should you include in the solution?
- A. Create a security role that has a table filter on the Sales_Manager table where username = UserName()
- B. Create a security role that has a table filter on the Region_Manager table where sales_manager_id = UserPrincipalName().
- C. Create a security role that has a table filter on the Sales_Manager table where name = UserName().
- D. Create a security role that has a table filter on the Sales_Manager table where username = sales_manager_id.
Answer: A
Explanation:
https://powerbi.microsoft.com/en-us/blog/using-username-in-dax-with-row-level-security/
Topic 2, Contoso Ltd,
To start the case study
To display the first question in this case study, click the Next button. Use the buttons in the left pane to explore the content of the case study before you answer the questions. Clicking these buttons displays information such as business requirements, existing environment and problem statements. If the case study has an All Information tab, note that the information displayed is identical to the information displayed on the subsequent tabs. When you are ready to answer a question, click the Question button to return to the question.
Existing Environment
Contoso, Ltd. is a manufacturing company that produces outdoor equipment Contoso has quarterly board meetings for which financial analysts manually prepare Microsoft Excel reports, including profit and loss statements for each of the company's four business units, a company balance sheet, and net income projections for the next quarter.
Data and Sources
Data for the reports comes from three sources. Detailed revenue, cost and expense data comes from an Azure SQL database. Summary balance sheet data comes from Microsoft Dynamics 365 Business Central. The balance sheet data is not related to the profit and loss results, other than they both relate to dates.
Monthly revenue and expense projections for the next quarter come from a Microsoft SharePoint Online list. Quarterly projections relate to the profit and loss results by using the following shared dimensions: date, business unit, department, and product category.
Net Income Projection Data
Net income projection data is stored in a SharePoint Online list named Projections in the format shown in the following table.
Revenue projections are set at the monthly level and summed to show projections for the quarter.
Balance Sheet Data
The balance sheet data is imported with final balances for each account per month in the format shown in the following table.
There is always a row for each account for each month in the balance sheet data.
Dynamics 365 Business Central Data
Business Central contains a product catalog that shows how products roll up to product categories, which roll up to business units. Revenue data is provided at the date and product level. Expense data is provided at the date and department level.
Business Issues
Historically, it has taken two analysts a week to prepare the reports for the quarterly board meetings. Also, there is usually at least one issue each quarter where a value in a report is wrong because of a bad cell reference in an Excel formula. On occasion, there are conflicting results in the reports because the products and departments that roll up to each business unit are not defined consistently.
Planned Changes
Contoso plans to automate and standardize the quarterly reporting process by using Microsoft Power Bl. The company wants to how long it takes to populate reports to less than two days. The company wants to create common logic for business units, products, and departments to be used across all reports, including, but not limited, to the quarterly reporting for the board.
Technical Requirements
Contoso wants the reports and datasets refreshed with minimal manual effort The company wants to provide a single package of reports to the board that contains custom navigation and links to supplementary information.
Maintenance, including manually updating data and access, must be minimized as much as possible.
Security Requirements
The reports must be made available to the board from powerbi.com. A mail-enabled security group will be used to share information with the board.
The analysts responsible for each business unit must see all the data the board sees, except the profit and loss data, which must be restricted to only their business unit's data. The analysts must be able to build new reports from the dataset that contains the profit and loss data, but any reports that the analysts build must not be included in the quarterly reports for the board. The analysts must not be able to share the quarterly reports with anyone.
Report Requirements
You plan to relate the balance sheet to a standard date table in Power Bl in a many-to-one relationship based on the last day of the month. At least one of the balance sheet reports in the quarterly reporting package must show the ending balances for the quarter, as well as for the previous quarter.
Projections must contain a column named RevenueProjection that contains the revenue projection amounts. A relationship must be created from Projections to a table named Date that contains the columns shown in the following table.
The relationships between products and departments to business units must be consistent across all reports.
The board must be able to get the following information from the quarterly reports:
* Revenue trends over time
* Ending balances for each account
* A comparison of expenses versus projections by quarter
* Changes in long-term liabilities from the previous quarter
* A comparison of quarterly revenue versus the same quarter during the prior year
NEW QUESTION # 149
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.
Answer:
Explanation:
Reference:
https://powerbidocs.com/2020/01/21/power-bi-top-n-filters/
NEW QUESTION # 150
You need to create a measure that will return the percentage of late orders.
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:
Explanation
Graphical user interface, application Description automatically generated
Box 1: CALCULATE
CALCULATE evaluates an expression in a modified filter context.
Syntax: CALCULATE(<expression>[, <filter1> [, <filter2> [, ...]]])
Expression - The expression to be evaluated.
filter1, filter2,... (Optional) Boolean expressions or table expressions that defines filters, or filter modifier functions.
Box 2: FILTER
FILTER returns a table that represents a subset of another table or expression.
Syntax: FILTER(<table>,<filter>)
Table- The table to be filtered. The table can also be an expression that results in a table.
Filter - A Boolean expression that is to be evaluated for each row of the table. For example, [Amount] > 0 or
[Region] = "France"
Box 3: Orders[ShippedDate]> Orders[RequiredDate]
Northwind Traders defines late orders as those shipped after the required shipping date.
Reference:
https://docs.microsoft.com/en-us/dax/calculate-function-dax
https://docs.microsoft.com/en-us/dax/filter-function-dax
NEW QUESTION # 151
What should you create to meet the reporting requirements of the sales department?
- A. a measure that uses a formula of COUNTROWS (Sales)
- B. a measure that uses a formula of SUM (Sales [sales_id])
- C. a calculated column that use a formula of COUNTA(sales [sales_id])
- D. a calculated column that uses a formula of SUM (Sales [sales_id])
Answer: A
NEW QUESTION # 152
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?
- A. Modify the members of the app workplace.
- B. Share the dashboards in the app workspace.
- C. Edit the settings of the Power BI web part.
- D. Publish the app workspace.
Answer: A
NEW QUESTION # 153
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?
- A. No
- B. Yes
Answer: A
NEW QUESTION # 154
You have a table that contains the following three columns:
City
Total Sales
Occupation
You need to create a key influencers visualization as shown in the exhibit. (Click the Exhibit tab.)
How should you configure the visualization? 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/visuals/power-bi-visualization-influencers
NEW QUESTION # 155
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.
Answer:
Explanation:
NEW QUESTION # 156
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?
- A. Sync the Country slicer on page 1, page 2, and page 3,
- B. Move the Country slicer from page 2 and page 3 to page 1.
- C. Remove the Country slicer from page 1, page 2, and page 3. Add the Country field to the report-level filters.
- D. Remove the Country slicer from page 1, page 2, and page 3. Add the Country field to the page-level filters.
Answer: D
NEW QUESTION # 157
In Power Bi Desktop, you are creating visualizations in a report based on an imported dataset You need to allow Power Bi users to export the summarized data used to create the visualizations but prevent the users from exporting the underlying data What should you do?
- A. From Power BI Desktop, configure the Data Load settings for the current file.
- B. From Power BI Desktop, configure the Report settings for the current file.
- C. From Power BI Desktop, modify the data source permissions.
- D. From the Power BI service, configure the dataset permissions.
Answer: D
NEW QUESTION # 158
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:
NEW QUESTION # 159
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.
Answer:
Explanation:
Explanation
Box 1: Background color
To format the Color column based on its field values, select Conditional formatting for the Color field, and then select Background color or Font color.
In the Background color or Font color dialog box, select Field value from the Format by drop-down field.
Box 2: Field value
With conditional formatting for tables in Power BI Desktop, you can specify customized cell colors, including color gradients, based on field values.
Reference:
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-table-formatting
NEW QUESTION # 160
......
Exam Valid Dumps with Instant Download Free Updates: https://www.actualtestsit.com/Microsoft/PL-300-exam-prep-dumps.html
PL-300 Dumps First Attempt Guaranteed Success: https://drive.google.com/open?id=1xbn-eDxakjG1iUdEDcCRpPuxE88JS0yk