PL-300 Dumps is a truly effective material developed by a professional IT exam team to prepare for the Microsoft Power BI Data Analyst exam.
The newly updated PL-300 dumps comes with both PDF and VCE study tools, you can study Microsoft Power BI Data Analyst exam questions anywhere using the PL-300 PDF file or the PL-300 VCE engine.
Lead4Pass PL-300 Dumps provides 146 exam questions and answers along with an analysis of each question to help you progress quickly and ultimately succeed on the Microsoft Power BI Data Analyst exam.
You can go directly to the PL-300 dumps location: https://www.leads4pass.com/pl-300.html. Get your first try and guarantee your success on the Microsoft Power BI Data Analyst exam.
And we also provide a part of PL-300 free dumps for your reference
QUESTION 1:
You are configuring a Microsoft Power BI data model to enable users to ask natural language questions by using QandA. You have a table named Customer that has the following measure.
Customer Count = DISTINCT COUNT(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 QandA. The solution must minimize the size of the model.
What should you do?
A. Add a synonym of “subscriber count” to the Customer Count measure.
B. Add a calculated table named Subscriber that is a duplicate of the Customer table.
C. Add a description of “subscriber count” to the Customer Count measure.
D. Add a synonym of “subscriberlD” to the CustomerlD column.
Correct Answer: A
QUESTION 2:
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.
D18912E1457D5D1DDCBD40AB3BF70D5D
What should you do?
A. Change the data type of the Logged column to Date.
B. Apply a transform to extract the last 11 characters of the Logged column and set the data type of the new column to Date.
C. Create a column by example that starts with 2018-12-31 and set the data type of the new column to Date.
D. Apply a transform to extract the first 11 characters of the Logged column.
Correct Answer: C
QUESTION 3:
You have a sales system that contains the tables shown in the following table.
The Date table is marked as a date table. DateID is the date data type. You need to create an annual sales growth percentage measure. Which DAX expression should you use?
A. SUM(sales[sales_amount]) – CALCULATE(SUM(sales[sales_amount]), SAMEPERIODLASTYEAR(\’Date\'[DateID])
B. (SUM(‘Sales’[sales_amount]) – CALCULATE(SUM(‘Sales’[sales_amount]),
SAMEPERIODLASTYEAR(‘Date’[DateID])))/ CALCULATE(SUM(‘Sales’[sales_amount]),
SAMEPERIODLASTYEAR(‘Date’[DateID]))
C. CALCULATE(SUM(sales[sales_amount]), DATESYTD(‘Date’[DateID]))
D. CALCULATE(SUM(sales[sales_amount]), SAMEPERIODLASTYEAR(‘Date’[DateID]))
Correct Answer: B
SAMEPERIODLASTYEAR returns a table that contains a column of dates shifted one year back in time from the dates in the specified dates column, in the current context.
Reference: https://docs.microsoft.com/en-us/dax/sameperiodlastyear-function-dax
QUESTION 4:
You have a Power BI dataset that contains a table named Temperature Readings. Temperature Readings contains the columns shown in the following table.
The table has 12 million rows. All the columns are needed for analysis.
You need to optimize the dataset to decrease the model size. The solution must not affect the precision of the data.
What should you do?
A. Split the DateTime column into separate date and time columns.
B. Change the data type of the DateTime column to Date.
C. Change the data type of the Latitude column to Fixed Decimal.
D. Disable the Power Query load.
Correct Answer: D
Disable Power Query query load.
Power Query queries that are intended to support data integration with other queries should not be loaded to the model.
To avoid loading the query to the model, take care to ensure that you disable query load in these instances.
QUESTION 5:
Your company has training videos that are published to Microsoft Stream. You need to surface the videos directly in a Microsoft Power BI dashboard. Which type of tile should you add?
A. video
B. custom streaming data
C. text box
D. web content
Correct Answer: B
The only way to visualize a streaming dataset is to add a tile and use the streaming dataset as a custom streaming data source.
Reference: https://docs.microsoft.com/en-us/power-bi/connect-data/service-real-time-streaming
QUESTION 6:
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 on 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 publish an app to the entire organization.
Does this meet the goal?
A. Yes
B. No
Correct Answer: B
Instead, assign all the users the Viewer role to the workspace.
Note: The Viewer role gives a read-only experience to its users. They can view dashboards, reports, or workbooks in the workspace, but can\’t browse the datasets or dataflows. Use the Viewer role wherever you would previously use a classic workspace set to “Members can only view Power BI content”.
Reference: https://powerbi.microsoft.com/en-us/blog/announcing-the-new-viewer-role-for-power-bi-workspaces/
QUESTION 7:
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?
A. Create a text box for each business question and insert a link.
B. Create a button for each business question and set the action type to Bookmark.
C. Create a Power Apps visual that contains a drop-down list. The drop-down list will contain the business questions.
Correct Answer: B
Power BI enables data insights and better decision-making, while Power Apps enables everyone to build and use apps that connect to business data. Using the Power Apps visual, you can pass context-aware data to a canvas app, which updates in real-time as you make changes to your report. Now, your app users can derive business insights and take actions from right within their Power BI reports and dashboards.
Reference: https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/powerapps-custom-visual
QUESTION 8:
DRAG-DROP
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.
Select and Place:
Correct Answer:
Box 1: CALCULATE
CALCULATE rvaluates an expression in a modified filter context.
Box 2: DIVIDE
As a data modeler, when you write a DAX expression to divide a numerator by a denominator, you can choose to use the DIVIDE function or the divide operator (/ – forward slash). When using the DIVIDE function, you must pass in the numerator and denominator expressions.
Box 3: ALL SELECTED
ALL SELECTED removes context filters from columns and rows in the current query, while retaining all other context filters or explicit filters.
The ALLSELECTED function gets the context that represents all rows and columns in the query, while keeping explicit filters and contexts other than row and column filters. This function can be used to obtain visual totals in queries.
Example:
measure \’Reseller Sales\'[Reseller Visual Total]=calculate(sum(\’Reseller Sales\'[Sales Amount]), ALLSELECTED())
Reference:
https://docs.microsoft.com/en-us/dax/allselected-function-dax
QUESTION 9:
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.
Select and Place:
Correct Answer:
When you view dashboards in portrait mode on a phone, you notice the dashboard tiles are laid out one after another, all the same size. In the Power BI service, you can create a customized view of a dashboard, specifically for portrait mode on phones.
Step 1: Open the Dashboard.
Step 2: Change the dashboard view to a Phone view
Step 3: Pin items from the reports to the dashboard.
Step 4: Rearrange, resize, or remote items from the Phone view.
Create a phone view of a dashboard
1. In the Power BI service, open a dashboard (Step 1)
2. Select the arrow next to Web view in the upper-right corner > select Phone view. (Step2)
The phone dashboard edit view opens. Here you can unpin, resize, and rearrange tiles to fit the phone view. The web version of the dashboard doesn\’t change.
3. Select a tile to drag, resize, or unpin. You notice the other tiles move out of the way as you drag a tile. The unpinned tiles go in the Unpinned tiles pane, where they stay unless you add them back.
4. If you change your mind, select Reset tiles to put them back in the size and order they were before.
5. When you\’re satisfied with the phone dashboard layout, select the arrow next to the Phone view in the upper-right corner and select Web view.
Power BI saves the phone layout automatically.
QUESTION 10:
HOTSPOT
You have a dataset named Pens that contains the following columns:
1. Unit Price
2. 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.
Hot Area:
Correct Answer:
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
QUESTION 11:
DRAG-DROP
You are building a dataset from a JSON file that contains an array of documents.
You need to import attributes as columns from all the documents in the JSON file. The solution must ensure that data attributes can be used as date hierarchies in Microsoft Power BI reports.
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.
Select and Place:
Correct Answer:
Step 1: Expand the records.
First Open the Power BI desktop and navigate to Power Query, import the JSON file, then load the data, click on the record to expand it, and see the record and list.
Step 2: Add columns that use data type conversions.
Step 3: Convert the list to a table
QUESTION 12:
You build a report to help the sales team understand its performance and the drivers of sales. The team needs to have a single visualization to identify which factors affect success. Which type of visualization should you use?
A. Key influences
B. Funnel chart
C. QandA
D. Line and clustered column chart
Correct Answer: A
The key influencers visual helps you understand the factors that drive a metric you\’re interested in. It analyzes your data, ranks the factors that matter, and displays them as key influencers.
The key influencer visual is a great choice if you want to:
See which factors affect the metric being analyzed. Contrast the relative importance of these factors. For example, do short-term contracts have more impact on churn than long-term contracts?
Reference:
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-influencers
QUESTION 13:
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 on 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 a 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 median line by using the Salary measure.
Does this meet the goal?
A. Yes
B. No
Correct Answer: A
The 50th percentile is also known as the median or middle value where 50 percent of observations fall below.
Reference: https://dash-intel.com/powerbi/statistical_functions_median.php
……
You can also download the PL-300 free dumps online:https://drive.google.com/file/d/1D-kQhxSETI0NOJFjwVd9dTVckQbq9oqY/view?usp=sharing
If you’ve ever taken the DA-100 Analyzing Data with Microsoft Power BI exam, you should know that this exam has expired! The PL-300 Microsoft Power BI Data Analyst exam is the new replacement.
Download the Microsoft PL-300 dumps https://www.leads4pass.com/pl-300.html (146 Q&A). Get the best Microsoft Power BI Data Analyst exam materials to help you prepare for the exam.
