[Sep-2023] PL-300 Dumps are Available for Instant Access from TestKingFree
Study resources for the Valid PL-300 Braindumps!
Passing Score, Duration & Questions For Microsoft PL-300 Exam
Number of Questions: 40-60 questions
Time Duration: 180 minutes
Languages: English, Japanese, Chinese (Simplified), Korean, German, French, Spanish, Portuguese (Brazil), Arabic (Saudi Arabia), Russian, Chinese (Traditional), Italian
The passing score: 700
NEW QUESTION # 10
Which DAX expression should you use to get the ending balances in the balance sheet reports?
- A. CALCULATE ( SUM( BalanceSheet [BalanceAmount] ), LASTDATE( 'Date'[Date] ) )
- B. CALCULATE ( MAX( BalanceSheet[BalanceAmount] ), LASTDATE( 'Date' [Date] ) )
- C. FIRSTNONBLANK ( 'Date' [Date] SUM( BalanceSheet[BalanceAmount] ) )
- D. CALCULATE ( SUM( BalanceSheet [BalanceAmount] ), DATESQTD( 'Date'[Date] ) )
Answer: D
NEW QUESTION # 11
HOTSPOT
You have a power BI tenant that hosts the datasets shown in the following table.
You have the following requirements:
* The export of reports that contain Personally Identifiable Information (Pll) must be prevented.
* Data used for financial decisions must be reviewed and approved before use.
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 # 12
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?
- A. Q&A
- B. smart narrative
- C. key influences
- D. decomposition tree
Answer: C
NEW QUESTION # 13
You publish a Microsoft Power BI dataset to powerbi.com. The dataset appends data from an on-premises Oracle database and an Azure SQL database by using one query.
You have admin access to the workspace and permission to use an existing On-premises data gateway for which the Oracle data source is already configured.
You need to ensure that the data is updated every morning. The solution must minimize configuration effort.
Which two actions should you perform when you configure scheduled refresh? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
- A. Set the refresh frequency to Daily.
- B. Configure the dataset to use the existing On-premises data gateway.
- C. Deploy an On-premises data gateway in personal mode.
- D. Configure the dataset to use the personal gateway.
Answer: A,B
Explanation:
Explanation
https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-personal-mode
NEW QUESTION # 14
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?
- A. From the app workspace, click Update app, configure the Content settings, and then click Update app.
- B. From the app workspace, share the dashboard.
- C. From the app workspace settings, add a member.
- D. From the app workspace, click Update app, configure the Access setting, and then click Update app.
Answer: D
NEW QUESTION # 15
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 # 16
You are creating an analytics report that will consume data from the tables shown in the following table.
There is a relationship between the tables.
There are no reporting requirements on employeejd and employee_photo.
You need to optimize the data model
What should you configure for employeejd and employee.photo? To answer, select the appropriate options in the answer area.
Answer:
Explanation:
Explanation
Table Description automatically generated
Box 1: Hide
Optimize data by hiding fields and sorting visualization data
Box 2: Delete
The fastest way to optimize your Power BI report is to limit the number of columns to only the ones you need in your data model. Go through your tables in Power Query and determine what fields are being used. Delete these columns if they are not being used in any of your reports or calculations.
Reference:
https://tessellationtech.io/optimizing-power-bi-reports/
NEW QUESTION # 17
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.
Answer:
Explanation:
NEW QUESTION # 18
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 # 19
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. Replace the values in the GeoCode column with postal codes or zip codes.
- B. Add a Geoportal column to the Location table.
- C. Change the Default Summarization of the GeoCode column.
- D. Change the Data Type of the GeoCode column.
- E. Change the name of the Location table to Country.
- F. Change the name of the GeoCode column to Country.
Answer: F
Explanation:
Reference:
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-map-tips-and-tricks
NEW QUESTION # 20
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?
- A. no impact
- B. highlight
- C. filter
Answer: B
NEW QUESTION # 21
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.
Answer:
Explanation:
Reference:
https://www.kasperonbi.com/get-the-ytd-of-the-same-period-last-year/
NEW QUESTION # 22
You have a table that contains a column named Phone. The following is a sample of the data in the Phone column.
You need to add a new column that contains the data in the format of nnn-nnn-nnnn.
How should you complete the Query Editor formula? 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/powerquery-m/text-replace
https://docs.microsoft.com/en-us/powerquery-m/text-end
NEW QUESTION # 23
You plan to create the chart shown in the following exhibit.
How should you create the dashed horizontal line denoting the 40th percentile of daily sales for the period shown?
- A. Add a new percentile line that uses Total Sales as the measure and 40% as the percentile.
- B. Add a measure to the visual that uses the following DAX expression.Heasurel - PERCENTUEX.EXC (Sales,Sales[Total Sales],6.40)
- C. Add a measure to the visual that uses the following DAX expression.Heasurel = PERCENTILEX.INC (Sales,Sales[Total Sales],6.40)
- D. Create a horizontal line that has a fixed value of 24,000.
Answer: A
Explanation:
The analytics feature enables you to show percentiles across groups specified along a specific axis.
Example:
1. Click on the analytics tab
2. Select Percentile
3. You can choose a specific percentile along with other formatting options.
4. Drag a date or non-numeric dimension into the Axis of a column chart
Add percentile lines to monitor daily revenue
NEW QUESTION # 24
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:
Reference:
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-table-formatting
NEW QUESTION # 25
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 # 26
You are building a Power B1 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?
- A. Q&A
- B. decomposition tree
- C. key influencers
- D. funnel chart
Answer: B
NEW QUESTION # 27
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 create an Azure Active Directory group that contains all the users. You share each report and dashboard to the group.
Does this meet the goal?
- A. No
- B. Yes
Answer: B
Explanation:
Explanation
Statements and questions are tricky and confusing. When the access is granted for the group (all users) for ALL (each) dashboards and ALL (each) reports in the workspace, then the will have read access to the specific (A, one) Dashboard and several reports, because they are part of all dashboards and reports. There is no statement, that for the other dashboards (except the one) and the other reports (except the several) that access must be prevented. They are also accessible (maybe it is not desired but not stated here).
NEW QUESTION # 28
......
Updated PL-300 Tests Engine pdf - All Free Dumps Guaranteed: https://learningtree.testkingfree.com/Microsoft/PL-300-practice-exam-dumps.html