Welcome to download the Newest 2passeasy PL-300 dumps

https://www.2passeasy.com/dumps/PL-300/ (311 New Questions)

Exam Questions PL-300

Microsoft Power BI Data Analyst

https://www.2passeasy.com/dumps/PL-300/

Passing Certification Exams Made Easy visit - https://www.2PassEasy.com

 Welcome to download the Newest 2passeasy PL-300 dumps
https://www.2passeasy.com/dumps/PL-300/ (311 New Questions)

NEW QUESTION 1
- (Exam Topic 1)
You need to get data from the Microsoft SQL Server tables. What should you use to configure the connection'

A. import that uses a Microsoft account

B. DirectQuery that uses the end-user s credentials
C. DirectQuery that uses a database credential
D. Import that uses a database credential

Answer: C

NEW QUESTION 2
- (Exam Topic 1)
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 wheresales_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/

NEW QUESTION 3
- (Exam Topic 1)
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 calculated column that use a formula of COUNTA(sales [sales_id])
C. a measure that uses a formula of COUNTROWS (Sales)
D. a calculated column that uses a formula of SUM (Sales [sales_id])

Answer: C

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

NEW QUESTION 4
- (Exam Topic 2)
Once the profit and loss dataset is created, which four actions should you perform in sequence to ensure that the business unit analysts see the appropriate profit
and loss data? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

A. Mastered
B. Not Mastered

Answer: A

Explanation:

Passing Certification Exams Made Easy visit - https://www.2PassEasy.com

 Welcome to download the Newest 2passeasy PL-300 dumps
https://www.2passeasy.com/dumps/PL-300/ (311 New Questions)

https://docs.microsoft.com/en-us/power-bi/admin/service-admin-rls https://docs.microsoft.com/en-us/power-bi/connect-data/service-datasets-build-permissions

NEW QUESTION 5
- (Exam Topic 2)
You need to recommend a strategy to consistently define the business unit, department, and product category data and make the data usable across reports.
What should you recommend?

A. Create a shared dataset for each standardized entity.

B. Create dataflows for the standardized data and make the dataflows available for use in all imported datasets.
C. For every report, create and use a single shared dataset that contains the standardized data.
D. For the three entities, create exports of the data from the Power Bl model to Excel and store the data in Microsoft OneDrive for others to use as a source.

Answer: B

NEW QUESTION 6
- (Exam Topic 2)
Which DAX expression should you use to get the ending balances in the balance sheet reports?

A. CALCULATE (SUM( BalanceSheet [BalanceAmount] ), DATESQTD( 'Date'[Date] ))

B. CALCULATE (SUM( BalanceSheet [BalanceAmount] ), LASTDATE( 'Date'[Date] ))
C. FIRSTNONBLANK ( 'Date' [Date]SUM( BalanceSheet[BalanceAmount] ))
D. CALCULATE (MAX( BalanceSheet[BalanceAmount] ), LASTDATE( 'Date' [Date] ))

Answer: A

Explanation:
Scenario: 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.
DATESQTD returns a table that contains a column of the dates for the quarter to date, in the current context. Reference:
https://docs.microsoft.com/en-us/dax/datesqtd-function-dax

NEW QUESTION 7
- (Exam Topic 3)
You need to configure access for the sales department users. The solution must me meet the security requirements. What should you do?

A. Add the sales department as a member of the reports workspace

B. Add the Azure Active Directory group of the sales department as an Admin of the reports workspace.
C. Distribute an app to the users in the Azure Active Directory group of the sales department.
D. Share each report to the Azure Active Directory group of the sales department.

Answer: B

NEW QUESTION 8
- (Exam Topic 3)
You need to create a relationship in the dataset for RLS.
What should you do? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Passing Certification Exams Made Easy visit - https://www.2PassEasy.com

 Welcome to download the Newest 2passeasy PL-300 dumps
https://www.2passeasy.com/dumps/PL-300/ (311 New Questions)

A. Mastered
B. Not Mastered

Answer: A

Explanation:
Text Description automatically generated
Box 1: many-to-one
Each employee in the Sales Employees table is assigned to one sales region. Multiple employees can be assigned to each region.
The Suppliers table has a Region column. Box 2: Suppliers table

NEW QUESTION 9
- (Exam Topic 3)
You need to design the data model to meet the report requirements. What should you do in Power BI Desktop?

A. From Power Query, use a DAX expression to add columns to the Orders table to calculate the calendar quarter of the OrderDate column, the calendar month of
the OrderDate column, the calendar quarter of the ShippedDate column, and the calendar month of the ShippedDate column.
B. From Power Query, add columns to the Orders table to calculate the calendar quarter and the calendar month of the OrderDate column.
C. From Power Bl Desktop, use the Auto date/time option when creating the reports.
D. From Power Query, add a date tabl
E. Create an active relationship to the OrderDate column in the Orders table and an inactive relationship to the ShippedDate column in the Orders table.

Answer: B

Explanation:
Use Power Query to calculate calendar quarter and calendar month. Scenario:
A single dataset must support all three reports:
- The Top Customers report will show the top 20 customers based on the highest sales amounts in a selected
order month or quarter, product category, and sales region.
- The Top Products report will show the top 20 products based on the highest sales amounts sold in a selected order month or quarter, sales region, and product
category.
The data model must minimize the size of the dataset as much as possible, while meeting the report requirements and the technical requirements.

NEW QUESTION 10
- (Exam Topic 3)
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.

A. Mastered

Passing Certification Exams Made Easy visit - https://www.2PassEasy.com

 Welcome to download the Newest 2passeasy PL-300 dumps
https://www.2passeasy.com/dumps/PL-300/ (311 New Questions)

B. Not Mastered

Answer: A

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 10
- (Exam Topic 3)
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.

A. Mastered
B. Not Mastered

Answer: A

Explanation:

Graphical user interface Description automatically generated with low confidence

Box 1: Top N
Scenario: The Top Customers report will show the top 20 customers based on the highest sales amounts in a selected order month or quarter, product category,
and sales region.
Once you drag to SKU to Visual level filter you should get Top N option Note: The two most common filter types: automatic and manual.
Then there are more advanced filters. Box 2: Visual
Once you drag to SKU to Visual level filter you should get Top N option. Reference:
https://powerbidocs.com/2020/01/21/power-bi-top-n-filters/

NEW QUESTION 11
- (Exam Topic 3)
You need to create a solution to meet the notification requirements of the warehouse shipping department. What should you do? To answer, select the appropriate
options in the answer area.
NOTE: Each correct select is worth one point:

Passing Certification Exams Made Easy visit - https://www.2PassEasy.com

 Welcome to download the Newest 2passeasy PL-300 dumps
https://www.2passeasy.com/dumps/PL-300/ (311 New Questions)

A. Mastered
B. Not Mastered

Answer: A

Explanation:

NEW QUESTION 13
- (Exam Topic 3)
You need to create the dataset. Which dataset mode should you use?

A. DirectQuery
B. Import
C. Live connection
D. Composite

Answer: D

NEW QUESTION 14
- (Exam Topic 3)
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.

A. Mastered
B. Not Mastered

Answer: A

Explanation:

NEW QUESTION 15

Passing Certification Exams Made Easy visit - https://www.2PassEasy.com

 Welcome to download the Newest 2passeasy PL-300 dumps
https://www.2passeasy.com/dumps/PL-300/ (311 New Questions)

- (Exam Topic 3)
You need to minimize me size of the dataset. The solution must meet the report requirements What should you do?

A. Change lite OrderlD column in the Orders table to the text data type.
B. Filter out discontinued products while importing the Product table.
C. Remove the QuantityPerUnit column from the Products table
D. Group the Categories table by the CategorylD column.

Answer: D

NEW QUESTION 20
- (Exam Topic 4)
You have a Power Bl visual that uses indicators to show values that are out of range as shown in the following exhibit.

A. Mastered
B. Not Mastered

Answer: A

Explanation:
Answer as selected

NEW QUESTION 25
- (Exam Topic 4)
You have a dashboard that contains tiles pinned from a single report as shown in the Original Dashboard exhibit. (Click the Original Dashboard tab.)

Passing Certification Exams Made Easy visit - https://www.2PassEasy.com

 Welcome to download the Newest 2passeasy PL-300 dumps
https://www.2passeasy.com/dumps/PL-300/ (311 New Questions)

You need to modify the dashboard to appear as shown in the Modified Dashboard exhibit. (Click the Modified Dashboard tab.)

What should you do?

A. Edit the details of each tile.

B. Change the report theme.
C. Change the dashboard theme.
D. Create a custom CSS file.

Answer: C

Explanation:
https://docs.microsoft.com/en-us/power-bi/create-reports/service-dashboard-themes#how-dashboard-themes-wo

NEW QUESTION 30
- (Exam Topic 4)
You have the Power BI data model shown in the following exhibit.

Select the appropriate yes or no.

A. Mastered
B. Not Mastered

Answer: A

Explanation:
Graphical user interface, text, application, email Description automatically generated

NEW QUESTION 34
- (Exam Topic 4)
You have a power BI tenant that hosts the datasets shown in the following table.

Passing Certification Exams Made Easy visit - https://www.2PassEasy.com

 Welcome to download the Newest 2passeasy PL-300 dumps
https://www.2passeasy.com/dumps/PL-300/ (311 New Questions)

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

A. Mastered
B. Not Mastered

Answer: A

Explanation:

NEW QUESTION 39
- (Exam Topic 4)
You have a Microsoft Excel workbook that contains two sheets named Sheet1 and Sheet2. Sheet1 contains the following table named Table1.

Sheet2 contains the following table named Table2.

You need to use Power Query Editor to combine the products from Table1 and Table2 into the following table that has one column containing no duplicate values.

Passing Certification Exams Made Easy visit - https://www.2PassEasy.com

 Welcome to download the Newest 2passeasy PL-300 dumps
https://www.2passeasy.com/dumps/PL-300/ (311 New Questions)

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.

A. Mastered
B. Not Mastered

Answer: A

Explanation:

NEW QUESTION 44
- (Exam Topic 4)

Each employee has one manager as shown in the ParentEmployeelD column, All reporting paths lead to the CEO at the top of the organizational hierarchy.
You need to create a calculated column that returns the count of levels from each employee to the CEO. Which DAX expression should you use?

Passing Certification Exams Made Easy visit - https://www.2PassEasy.com

 Welcome to download the Newest 2passeasy PL-300 dumps
https://www.2passeasy.com/dumps/PL-300/ (311 New Questions)

A. Option A
B. Option B
C. option C
D. Option D

Answer: B

NEW QUESTION 49
- (Exam Topic 4)
You have a Power Bl report named Report1 and a dashboard named Dashboard1, Report1 contains a line chart named Sales by month.
You pin the Sales by month visual to Dashboard1.
In Report1, you change the Sales by month visual to a bar chart. You need to ensure that bar chart displays on Dashboard1. What should you do?

A. Edit the details for the dashboard tile of Dashboard1.

B. Select Refresh visuals for Dashboard1.
C. the Sales by month bar chart to Dashboard1
D. Refresh the dataset used by Report1 and Dashboard1.

Answer: D

NEW QUESTION 52
- (Exam Topic 4)
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 lis
D. The drop-down list will contain the business questions.

Answer: B

Explanation:
When you create a bookmark, the following elements are saved with the bookmark: - The current page - Filters - Slicers, including slicer type (for example,
dropdown or list) and slicer state - Visual selection state (such as cross-highlight filters) - Sort order - Drill location - Visibility of an object (by using the Selection
pane) - The focus or Spotlight modes of any visible object

NEW QUESTION 54
- (Exam Topic 4)
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.)

Passing Certification Exams Made Easy visit - https://www.2PassEasy.com

 Welcome to download the Newest 2passeasy PL-300 dumps
https://www.2passeasy.com/dumps/PL-300/ (311 New Questions)

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 need to edit the Product Category table query to match the desired Power BI model.
How should you complete the advanced query? 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 frag the split bar between panes or scroll to view content. NOTE: Each correct selection is worth one point.

A. Mastered
B. Not Mastered

Answer: A

Explanation:
Graphical user interface, application Description automatically generated
References:
https://msdn.microsoft.com/en-us/library/mt260776.aspx https://msdn.microsoft.com/en-us/library/mt260808.aspx

NEW QUESTION 56
- (Exam Topic 4)
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.

Passing Certification Exams Made Easy visit - https://www.2PassEasy.com

 Welcome to download the Newest 2passeasy PL-300 dumps
https://www.2passeasy.com/dumps/PL-300/ (311 New Questions)

What should you use?

A. Feedback
B. Subscribe
C. Comments
D. Mark as favorite

Answer: C

Explanation:
https://docs.microsoft.com/en-us/power-bi/consumer/end-user-comment

NEW QUESTION 59
- (Exam Topic 4)
You are creating a sales report in Power Bl for the NorthWest region sales territory of your company. Data will come from a view in a Microsoft SQL Server
database. A sample of the data is shown in the following table:

The report will facilitate the following analysis:

• The count of orders and the sum of total sales by Order Date
• The count of customers who placed an order
• The average quantity per order
You need to reduce data refresh times and report query times.
Which two actions should you perform? Each correct answer presents part of the solution
NOTE: Each correct selection is worth one point.

A. Fillet the data to only the NorthWest region sales territory.

B. Remove the CustomerKey and ProductKey columns.
C. Remove the TaxAmt and Freight columns.
D. Set the data type for SatesOrderNumber to Decimal Number

Answer: AC

NEW QUESTION 63
- (Exam Topic 4)
You have a Microsoft Exert spreadsheet named Excel1 that contains survey results. You have a Power Bl dashboard named DashboardA that has Q&A enabled.
You need to ensure that users who can access DashboardA can ask Questions based on the contents of Excel 1 and pm visuals based on their queries to
DashboardA. The solution must minimize development time.
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.

A. Mastered
B. Not Mastered

Answer: A

Explanation:

NEW QUESTION 65
- (Exam Topic 4)
What is the minimum number of Power BI datasets needed to support the reports?

Passing Certification Exams Made Easy visit - https://www.2PassEasy.com

 Welcome to download the Newest 2passeasy PL-300 dumps
https://www.2passeasy.com/dumps/PL-300/ (311 New Questions)

A. a single imported dataset

B. two imported datasets
C. two DirectQuery datasets
D. a single DirectQuery dataset

Answer: A

NEW QUESTION 68
- (Exam Topic 4)
You are building a Power BI 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. decomposition tree
B. funnel chart
C. Q&A
D. key influencers

Answer: A

Explanation:
The key influencers 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 affect churn more than long-term contracts?
Note: 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. For example, suppose you want to figure out what influences employee turnover, which is also known as churn. One factor might
be employment contract length, and another factor might be commute time.
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-influencers

NEW QUESTION 70
- (Exam Topic 4)
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: In the Power Query M code, you replace references to the Excel file with DataSourceExcel. Does this meet the goal?

A. Yes
B. No

Answer: A

Explanation:
Instead modify the source step of the queries to use DataSourceExcel as the file path.
Note: Parameterising a Data Source could be used in many different use cases. From connecting to different data sources defined in Query Parameters to load
different combinations of columns.
Reference:
https://www.biinsight.com/power-bi-desktop-query-parameters-part-1/

NEW QUESTION 73
- (Exam Topic 4)
You need to create a visualization that compares revenue and cost over time. Which type of visualization should you use?

A. stacked area chart

B. donut chart
C. line chart
D. waterfall chart

Answer: C

Explanation:
A line chart or line graph displays the evolution of one or several numeric variables. Data points are connected by straight line segments. A line chart is often used
to visualize a trend in data over intervals of time – a time series – thus the line is often drawn chronologically.
Example:

Passing Certification Exams Made Easy visit - https://www.2PassEasy.com

 Welcome to download the Newest 2passeasy PL-300 dumps
https://www.2passeasy.com/dumps/PL-300/ (311 New Questions)

Reference:
https://www.data-to-viz.com/graph/line.html

NEW QUESTION 76
- (Exam Topic 4)
You are profiling data by using Power Query Editor.
You have a table named Reports that contains a column named State. The distribution and quality data metrics for the data m State is 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.

A. Mastered
B. Not Mastered

Answer: A

Explanation:

Passing Certification Exams Made Easy visit - https://www.2PassEasy.com

 Welcome to download the Newest 2passeasy PL-300 dumps
https://www.2passeasy.com/dumps/PL-300/ (311 New Questions)

NEW QUESTION 79
- (Exam Topic 4)
You have a collection of reports for the HR department of your company. The datasets use row-level security (RLS). The company has multiple sales regions that
each has an HR manager. You need to ensure that the HR managers can interact with the data from their region only. The HR managers must be prevented from
changing the layout of the reports. How should you provision access to the reports for the HR managers?

A. Create a new workspace, copy the datasets and reports, and add the HR managers as members of the workspace.
B. Publish the reports to a different workspace other than the one hosting the datasets.
C. Publish the reports in an app and grant the HR managers access permission.
D. Add the HR managers as members of the existing workspace that hosts the reports and the datasets.

Answer: C

Explanation:
Note: Row-level security (RLS) with Power BI can be used to restrict data access for given users. Filters restrict data access at the row level, and you can define
filters within roles. In the Power BI service, members of a workspace have access to datasets in the workspace. RLS doesn't restrict this data access.
Reference:
https://docs.microsoft.com/en-us/power-bi/admin/service-admin-rls

NEW QUESTION 81
- (Exam Topic 4)
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. Yes
B. No

Answer: B

Explanation:
The filter is applied after the data is imported. Instead add a WHERE clause to the SQL statement. Reference:
https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-sql-tutorial

NEW QUESTION 85
- (Exam Topic 4)
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.

Passing Certification Exams Made Easy visit - https://www.2PassEasy.com

 Welcome to download the Newest 2passeasy PL-300 dumps
https://www.2passeasy.com/dumps/PL-300/ (311 New Questions)

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.

A. Mastered
B. Not Mastered

Answer: A

Explanation:
Box 1: CALCULATE
Start with CALCULATE and use a SUMX.
CALCULATE evaluates an expression in a modified filter context. Box 2: SUM
Box 3: TOPN
TOPN returns the top N rows of the specified table. Box 4: [TransactionDate]
TOPN Syntax: TOPN(<n_value>, <table>, <orderBy_expression>, [<order>[, <orderBy_expression>, [<order>]]…])
The orderBy_expression: Any DAX expression where the result value is used to sort the table and it is evaluated for each row of table.
Reference:
https://docs.microsoft.com/en-us/dax/topn-function-dax

NEW QUESTION 90
- (Exam Topic 4)
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.

A. Add the same slicer to each page and configure Sync slicers.
B. Edit the interactions of the KPI visualization.
C. Configure a page-level filter.
D. Edit the interactions of the slicer that is on the same page as the KPI visualization.
E. Configure a report-level filter.

Answer: AD

Explanation:
Slicers are another way of filtering. They narrow the portion of the dataset that is shown in the other report visualizations.
By default, slicers on report pages affect all the other visualizations on that page, including each other. Use visual interactions to exclude some page visualizations
from being affected by others.
Reference:
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-slicers

NEW QUESTION 93
- (Exam Topic 4)
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?

A. Split the visuals onto multiple pages.

B. Implement row-level security (RLS).
C. Replace the default visuals with custom visuals.

Passing Certification Exams Made Easy visit - https://www.2PassEasy.com

 Welcome to download the Newest 2passeasy PL-300 dumps
https://www.2passeasy.com/dumps/PL-300/ (311 New Questions)

D. Increase the number of times that the dataset is refreshed.

Answer: A

NEW QUESTION 98
- (Exam Topic 4)
You are creating a Microsoft Power Bl imported data model to perform basket analysis. The goal of the analysis is to identify which products are usually bought
together in the same transaction across and within sales territories.
You import a fact table named Sales as shown in the exhibit. (Click the Exhibit tab.)

The related dimension tables are imported into the model.

For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.

A. Mastered
B. Not Mastered

Answer: A

Explanation:
Reference:
https://finance-bi.com/power-bi-basket-analysis/

NEW QUESTION 100

- (Exam Topic 4)
You are using the key influencers visual to identify which factors affect the quantity of items sold in an order. You add the following fields to the Explain By field:
* Customer Country
* Product Category
* Supplier Country
* Sales Employee
* Supplier Name
* Product Name
* Customer City
The key influencers visual returns the results shown in the following exhibit.

Passing Certification Exams Made Easy visit - https://www.2PassEasy.com

 Welcome to download the Newest 2passeasy PL-300 dumps
https://www.2passeasy.com/dumps/PL-300/ (311 New Questions)

What can you identify from the visual?

A. Customers in Austria order 18.8 more units than the average order quantity.
B. Customers in Boise order 20.37 percent more than the average order quantity.
C. Product Category positively influences the quantity per order.
D. Customers in Cork order lower quantities than average.

Answer: A

NEW QUESTION 101

- (Exam Topic 4)
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 create a new query that references DataSourceExcel. Does this meet the goal?

A. Yes
B. No

Answer: B

Explanation:
Instead modify the source step of the queries to use DataSourceExcel as the file path.
Note: Parameterising a Data Source could be used in many different use cases. From connecting to different data sources defined in Query Parameters to load
different combinations of columns.
Reference:
https://www.biinsight.com/power-bi-desktop-query-parameters-part-1/

NEW QUESTION 105

- (Exam Topic 4)
You manage a Power BI model has a table named Sales and product.
You need to ensure that a sales team can view only data that has a CountryRegionName value of United States and a ProductCategory value of Clothing.
What should you do from Power BI Desktop?

A. From Power BI Desktop, create a new role that has the following filter.[countryRegionName]= “United States” && [ProductCategory]= “Clothing”
B. Add the following filters in Query Editor.CountryRegionName is United StatesProductCategory is Clothing
C. From Power BI Desktop, create a new role that has the following filters.[CountryRegionName]= “United States”
D. Add the following filters to a report.CountryRegionName is United SatesProductCategory is Clothing

Answer: D

Explanation:

Passing Certification Exams Made Easy visit - https://www.2PassEasy.com

 Welcome to download the Newest 2passeasy PL-300 dumps
https://www.2passeasy.com/dumps/PL-300/ (311 New Questions)

References: https://docs.microsoft.com/en-us/power-bi/power-bi-how-to-report-filter

NEW QUESTION 110

- (Exam Topic 4)
You have an API that returns more than 100 columns. The following is a sample of column names.
client_notified_timestamp
client_notified_source
client_notified_sourceid
client_notified_value
client_responded_timestamp
client_responded_source
client_responded_sourceid
client_responded_value
You plan to include only a subset of the returned columns.
You need to remove any columns that have a suffix of sourceid.
How should you complete the Power Query M code? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

A. Mastered
B. Not Mastered

Answer: A

Explanation:
Box 1: Table.RemoveColumns
When you do “Remove Columns” Power Query uses the Table.RemoveColumns function Box 2: List.Select
Get a list of columns. Box 3: Text.EndsWith

NEW QUESTION 113

- (Exam Topic 4)
You have a PBiX file that imports several tables from an Azure SQL database. The data will be migrated to another Azure SQL database.
You need to change the connections in the PBIX file. The solution must minimize administrative effort. What should you do?

A. From Power Query Editor, modify the source of each query.

B. Create a PBiT file, open the file, and change the data sources when prompted
C. From Power Query Editor, create new queries.
D. Modify the Data source settings.

Answer: D

NEW QUESTION 117

- (Exam Topic 4)
You have a Microsoft Excel file in a Microsoft OneDrive folder. The file must be imported to a Power Bi dataset
You need to ensure that the dataset can be refreshed in powefbi.com.
Which two connectors can you use to connect to the file? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

A. Text/CSV

Passing Certification Exams Made Easy visit - https://www.2PassEasy.com

 Welcome to download the Newest 2passeasy PL-300 dumps
https://www.2passeasy.com/dumps/PL-300/ (311 New Questions)

B. Folder
C. Excel Workbook
D. SharePoint folder
E. Web

Answer: DE

Explanation:
- Copy and edit Path of the Excel file then use "Web" Connector: Option E
- Copy and edit Path of the OneDrive folder then use "Sharepoint Folder" connector: Option D Source: https://www.youtube.com/watch?v=GGHbbg6yi-A

NEW QUESTION 120

- (Exam Topic 4)
You have an app workspace that contains a dashboard and four reports. All the reports are generated from a single dataset that contains sales data for your
company.
The reports display the data configured as shown in the following table.

You need to ensure that the users of the reports can locate the correct report by using natural language queries. What should you do?

A. From the properties of the dataset, create four Featured Q&A Questions.
B. From the Format settings of the reports, modify the Page Information.
C. From the properties of the dataset, modify the Q&A and Cortana settings.
D. From the properties of the workspace, modify the Language Settings.

Answer: C

Explanation:
References:
https://docs.microsoft.com/en-us/power-bi/service-q-and-a-direct-query#limitations-during-public-preview

NEW QUESTION 124

- (Exam Topic 4)
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?

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]))

Answer: B

Explanation:
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

NEW QUESTION 126

- (Exam Topic 4)

Passing Certification Exams Made Easy visit - https://www.2PassEasy.com

 Welcome to download the Newest 2passeasy PL-300 dumps
https://www.2passeasy.com/dumps/PL-300/ (311 New Questions)

You have the Power Bl model shown in the following exhibit.

There are four departments in the Departments table.

You need to ensure that users can see the data of their respective department only. What should you do?

A. Create a row-level security (RLS) role for each department, and then define the membership of the role.
B. Create a DepartmentID parameter to filter the Departments table.
C. To the ConfidentialData table, add a calculated measure that uses the currentgroup DAX function.
D. Create a slicer that filters Departments based on DepartmentID.

Answer: A

NEW QUESTION 130

- (Exam Topic 4)
The Sales table contains records of sales by day from the last five years up until today's date.
You plan to create a measure to return the total sales Of March 2021 when March 2022 is selected. Which DAX expression should you use?

A. Option A
B. Option B
C. option C
D. Option D

Answer: B

NEW QUESTION 134

- (Exam Topic 4)
In the Power BI service, you create an app workplace that contains several dashboards.
You need to provide a user named user1@contoso.com with the ability to edit and publish dashboards. What should you do?

A. Modify the members of the app workspace.

B. Configure security for the dataset used by the app.
C. Share the dashboard, and then modify the Access settings of the dashboard.
D. From the app workspace, click Update app, and then configure the Access settings.

Answer: C

NEW QUESTION 138

- (Exam Topic 4)
You attempt to connect Purer 81 Desktop to a Cassandra database.
From the Get Data connector list you discover that there is no specific connector for the Cassandra database, You need to select an alternate data connector that
will connect to the database.
Which of connector should you choose?

A. Microsoft SQL Server database

B. ODBC
C. OData
D. OLE DB

Answer: B

NEW QUESTION 142

- (Exam Topic 4)
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

Passing Certification Exams Made Easy visit - https://www.2PassEasy.com

 Welcome to download the Newest 2passeasy PL-300 dumps
https://www.2passeasy.com/dumps/PL-300/ (311 New Questions)

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.

A. Mastered
B. Not Mastered

Answer: A

Explanation:
Diagram, table Description automatically generated
References:
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-radial-gauge-charts

NEW QUESTION 143

- (Exam Topic 4)
You use Power Bi Desktop to create a Power Bl data model and a blank report You need to add the Word Cloud visual shown in the following exhibit to the report.

The solution must minimize development effort

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.

Passing Certification Exams Made Easy visit - https://www.2PassEasy.com

 Welcome to download the Newest 2passeasy PL-300 dumps
https://www.2passeasy.com/dumps/PL-300/ (311 New Questions)

A. Mastered
B. Not Mastered

Answer: A

Explanation:

NEW QUESTION 144

- (Exam Topic 4)
You are creating a Power BI model that contains a table named Store. Store contains the following fields. You plan to create a map visual that will show store
locations and provide the ability to drill down from
Country to State/Province to City. What should you do to ensure that the locations are mapped property?

A. Set the data category of Cit

B. State/Province, and Country.
C. Set Summarization for Cit
D. State/Province, and Country to Don't summarize
E. Change the data type of Cit
F. State/Province, and Country.
G. Create a calculated column that concatenates the values it City, State/Province, and Country.

Answer: A

NEW QUESTION 145

- (Exam Topic 4)
You have a Microsoft Excel workbook that contains two tables.
From Power BI, you create a dashboard that displays data from the tables.
You update the tables each day.
You need to ensure that the virtualizations in the dashboard are updated daily.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to answer area and arrange them in the
correct order.

Passing Certification Exams Made Easy visit - https://www.2PassEasy.com

 Welcome to download the Newest 2passeasy PL-300 dumps
https://www.2passeasy.com/dumps/PL-300/ (311 New Questions)

A. Mastered
B. Not Mastered

Answer: A

Explanation:
Graphical user interface, text, application, email Description automatically generated
References: https://docs.microsoft.com/en-us/power-bi/refresh-scheduled-refresh

NEW QUESTION 147

- (Exam Topic 4)
You have an on-premises Power BI Report Server.
You plan to create a report in Power BI Desktop and publish the report to the report server. Which data source should the report use?

A. Microsoft Azure SQL Database

B. a Microsoft SQL Server database
C. a Microsoft SQL Server Analysis Services (SSAS) database
D. Microsoft Excel

Answer: C

Explanation:
References:
https://docs.microsoft.com/en-us/power-bi/report-server/quickstart-create-powerbi-report https://docs.microsoft.com/en-us/power-bi/report-server/connect-data-
sources

NEW QUESTION 152

- (Exam Topic 4)
You have a column named UnitslnStock as shown in the following exhibit

A. Mastered
B. Not Mastered

Answer: A

Passing Certification Exams Made Easy visit - https://www.2PassEasy.com

 Welcome to download the Newest 2passeasy PL-300 dumps
https://www.2passeasy.com/dumps/PL-300/ (311 New Questions)

Explanation:

NEW QUESTION 153

- (Exam Topic 4)
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.

A. Open the Advanced Editor.

B. Select Column quality.
C. Enable Column profiling based on entire dataset.
D. Select Column distribution.
E. Select Column profile.

Answer: CE

Explanation:
In Power query, the load preview by default is 1000 row. By default, the column quality also only looks at the first 1000 row. You can verify this by the status bar at
the bottom of the Power query window. To change the profiling so it analyses the entire column of data, select the profiling status in the status bar. Then select
Column profiling based on the entire data set.
https://theexcelclub.com/data-profiling-views-in-power-query-excel-and-power-bi/

NEW QUESTION 158

- (Exam Topic 4)
You create a report by using Microsoft Power BI Desktop.
The report uses data from a Microsoft SQL Server Analysis Services (SSAS) cube located on your company’s internal network.
You plan to publish the report to the Power BI Service.
What should you implement ta ensure that users who consume the report from the Power BI Service have the most up-to-date data from the cube?

A. a subscription
B. a scheduled refresh of the dataset
C. an OData feed
D. an On-premises data gateway

Answer: D

Explanation:
When you’ve created dynamic reports in Power BI Desktop, you can share them by publishing to your Power BI site. When you publish a Power BI Desktop file
with a live connection to a tabular model to your Power BI site, an on-premises data gateway must be installed and configured by an administrator.

NEW QUESTION 162

- (Exam Topic 4)
You have a Power Bl workspace named Workspace1 that contains a dataset named DS1 and a report named RPT1.
A user wants to create a report by using the data In DS1 and publish the report to another workspace.
You need to provide the user with the appropriate access. The solution must minimize the number of access permissions granted to the user.
What should you do?

A. Share RPT1 with the user.

B. Add the user as a Viewer of Workspace1.
C. Add the user as a member of Workspace1.
D. Grant the Build permission for DS1 to the user.

Answer: D

NEW QUESTION 166

- (Exam Topic 4)
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?

Passing Certification Exams Made Easy visit - https://www.2PassEasy.com

 Welcome to download the Newest 2passeasy PL-300 dumps
https://www.2passeasy.com/dumps/PL-300/ (311 New Questions)

A. Share the dashboard to the user.

B. Create a subscription.
C. Create a data alert.
D. Tag the user in a comment.

Answer: C

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

- (Exam Topic 4)
You have a Power 31 data model that contains a table named Stores. The table has the following columns:
* Store Name
* Open Date
* Status
* State
* City
You need to create a calculated column named Active Store Name that meets the following requirements: see the explanation for answer.

A. Mastered
B. Not Mastered

Answer: A

Explanation:

NEW QUESTION 168

- (Exam Topic 4)
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?

A. Replace the default visuals with AppSource visuals.

B. Change any DAX measures to use iterator functions.
C. Remove unused columns from tables in the data model.
D. Increase the number of times that the dataset is refreshed

Answer: D

NEW QUESTION 172

- (Exam Topic 4)
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 assign all the users the Viewer role to the workspace.
Does this meet the goal?

A. Yes
B. No

Answer: A

Explanation:
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”.

Passing Certification Exams Made Easy visit - https://www.2PassEasy.com

 Welcome to download the Newest 2passeasy PL-300 dumps
https://www.2passeasy.com/dumps/PL-300/ (311 New Questions)

Reference:
https://powerbi.microsoft.com/en-us/blog/announcing-the-new-viewer-role-for-power-bi-workspaces/

NEW QUESTION 174

- (Exam Topic 4)
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 percentile line by using the Salary measure and
set the percentile to 50%. Does this meet the goal?

A. Yes
B. No

Answer: A

Explanation:
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_percentile.php

NEW QUESTION 179

- (Exam Topic 4)
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. Create a horizontal line that has a fixed value of 24,000.

B. Add a measure to the visual that uses the following DAX expression.Heasurel - PERCENTUEX.EXC (Sales,Sales[Total Sales],©.40)
C. Add a new percentile line that uses Total Sales as the measure and 40% as the percentile.
D. Add a measure to the visual that uses the following DAX expression.Heasurel = PERCENTILEX.INC (Sales,Sales[Total Sales],6.40)

Answer: C

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

Passing Certification Exams Made Easy visit - https://www.2PassEasy.com

 Welcome to download the Newest 2passeasy PL-300 dumps
https://www.2passeasy.com/dumps/PL-300/ (311 New Questions)

Add percentile lines to monitor daily revenue

NEW QUESTION 184

- (Exam Topic 4)
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 date 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.

A. Mastered
B. Not Mastered

Answer: A

Explanation:
* 1- Convert list to table
* 2- Expand Column
* 3- Set Date type
Here is an example: https://youtu.be/B4kzyxnhQfI The definition of the function which expand columns:
https://docs.microsoft.com/en-us/powerquery-m/table-expandrecordcolumn

NEW QUESTION 189

- (Exam Topic 4)
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?

A. Add a salary to the tooltips.

B. Add a salary to the visual filters.
C. Add salary to the drillthrough fields.

Answer: A

Passing Certification Exams Made Easy visit - https://www.2PassEasy.com

 Welcome to download the Newest 2passeasy PL-300 dumps
https://www.2passeasy.com/dumps/PL-300/ (311 New Questions)

Explanation:
Reference:
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-custom-tooltips https://technovids.com/power-bi-filters/

NEW QUESTION 192

- (Exam Topic 4)
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.

A. Mastered
B. Not Mastered

Passing Certification Exams Made Easy visit - https://www.2PassEasy.com

 Welcome to download the Newest 2passeasy PL-300 dumps
https://www.2passeasy.com/dumps/PL-300/ (311 New Questions)

Answer: A

Explanation:
Box 1: Total Sales
Box 2: Occupation
Box 3: City
You can use Expand By to add fields you want to use for setting the level of the analysis without looking for new influencers.
Reference:
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-influencers

NEW QUESTION 196

- (Exam Topic 4)
You have a Q&A visual that displays information from a table named Carriers as shown in the following exhibit.

You need to ensure that users can ask questions by using the term airline or carrier. The solution must minimize changes to the data model.
What should you do?

A. Add a duplicate query named Airline.

B. Add airline as a synonym of carrier.
C. Rename the carrier column as airline in the Carriers query.
D. Rename the query from Carriers to airlines.

Answer: B

Explanation:
Add synonyms to tables and columns: This step applies specifically to Q&A (and not to Power BI reports in general). Users often have a variety of terms they use
to refer to the same thing, such as total sales, net sales, total net sales. You can add these synonyms to tables and columns in the Power BI model.
This step can be important. Even with straightforward table and column names, users of Q&A ask questions using the vocabulary that first comes to them. They're
not choosing from a predefined list of columns. The more sensible synonyms you add, the better your users' experience is with your report.
Reference:
https://docs.microsoft.com/en-us/power-bi/natural-language/q-and-a-best-practices

NEW QUESTION 201

- (Exam Topic 4)
You need to create a Power Bl report. The first page or the report must contain the following two views:
* Sales By Postal Code
* Sales by Month
Both views must display a slicer to select a value for a field named Chain.
The Sales By Postal Code view must display a map visual as shown in the following exhibit.

A. Mastered
B. Not Mastered

Answer: A

Explanation:

Passing Certification Exams Made Easy visit - https://www.2PassEasy.com

 Welcome to download the Newest 2passeasy PL-300 dumps
https://www.2passeasy.com/dumps/PL-300/ (311 New Questions)

NEW QUESTION 202

- (Exam Topic 4)
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).

Passing Certification Exams Made Easy visit - https://www.2PassEasy.com

 Welcome to download the Newest 2passeasy PL-300 dumps
https://www.2passeasy.com/dumps/PL-300/ (311 New Questions)

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.RemoveMatchingRows
B. Table.Distinct
C. Table.InDistinct
D. Table.ReplaceMatchingRows

Answer: B

Explanation:
References: https://msdn.microsoft.com/en-us/library/mt260775.aspx

NEW QUESTION 203

- (Exam Topic 4)
You have the tables shown in the following table.

The Impressions table contains approximately 30 million records per month. You need to create an ad analytics system to meet the following requirements:
Present ad impression counts for the day, campaign, and Site_name. The analytics for the last year are required.
Minimize the data model size.
Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

A. Group the impressions by Ad_id, Site_name, and Impression_date.Aggregate by using the CountRows function.

Passing Certification Exams Made Easy visit - https://www.2PassEasy.com

 Welcome to download the Newest 2passeasy PL-300 dumps
https://www.2passeasy.com/dumps/PL-300/ (311 New Questions)

B. Create one-to-many relationships between the tables.

C. Create a calculated measure that aggregates by using the COUNTROWS function.
D. Create a calculated table that contains Ad_id, Site_name, and Impression_date.

Answer: AB

Explanation:
Grouping in power query reduces the number of rows in the impression table that is gonna be loaded in the model. Creating relationships doesn't increase the size
of the model.

NEW QUESTION 204

- (Exam Topic 4)
You have a Power Bi report. The report contains a visual that snows gross sales by date The visual has anomaly detection enabled.
No anomalies ate detected
You need to increase the likelihood that anomaly detection will identify anomalies in the report. What should you do?

A. Add a data field to the Secondary values field weft

B. Increase the Sensitivity setting.
C. Increase the Expected range transparency setting,
D. Add a data field to the Legend field well

Answer: B

Explanation:
If you increase the sensitivity, the algorithm is more sensitive to changes in your data. In that case, even a slight deviation is marked as an anomaly. If you
decrease the sensitivity, the algorithm is more selective on what it considers an anomaly. reference:
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-anomaly-detection

NEW QUESTION 206

- (Exam Topic 4)
You build a report about warehouse inventory data. The dataset has more than 10 million product records from 200 warehouses worldwide. You have a table
named Products that contains the columns shown in the following table.

Warehouse managers report that it is difficult to use the report because the report uses only the product name in tables and visuals. The product name is
contained within the ProductDescription column and is always the fourth value.
You need to modify the report to support the warehouse managers requirement to explore inventory levels at different levels of the product hierarchy. The solution
must minimize the model size.
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.

A. Mastered
B. Not Mastered

Answer: A

Explanation:

Passing Certification Exams Made Easy visit - https://www.2PassEasy.com

 Welcome to download the Newest 2passeasy PL-300 dumps
https://www.2passeasy.com/dumps/PL-300/ (311 New Questions)

NEW QUESTION 208

- (Exam Topic 4)
You have a query that returns the data shown in the following exhibit.

You need to configure the query to display the data as shown in the following exhibit.

Which step should you use in the query?

A. =Table.ExpandListColum(Table.TransformColunins(Source, {{"classes".Splitter.SplitTextByDelimiter('','', QuoteStyle.None), let itemType - (type nullable text)

meta [Serialized.Text = true] in type {itemType}}}), "classes")
B. = Table.Unpivot(Source, {"classes"}, "Attribute", "Value")
C. = Table.SplitColumn(Source, "classes". Splitter.SplitTextByDelimiterf",", QuoteStyle.None),{"classes.1"})
D. = Table.SplitColumn(Source, "classes". Splitter.SplitTextByPositions({10}), {"classes.1"})

Answer: B

Explanation:
Power Query Unpivot columns: You might want to unpivot data, sometimes called flattening the data, to put it in a matrix format so that all similar values are in one
column. This is necessary, for example, to create a chart or a report.
Chart Description automatically generated

Note:
Syntax: Table.Unpivot(table as table, pivotColumns as list, attributeColumn as text, valueColumn as text) as table
Table.Unpivot translates a set of columns in a table into attribute-value pairs, combined with the rest of the values in each row.
Reference:
https://docs.microsoft.com/en-us/power-query/unpivot-column https://docs.microsoft.com/en-us/powerquery-m/table-unpivot

Passing Certification Exams Made Easy visit - https://www.2PassEasy.com

 Welcome to download the Newest 2passeasy PL-300 dumps
https://www.2passeasy.com/dumps/PL-300/ (311 New Questions)

NEW QUESTION 210

- (Exam Topic 4)
You have an app workspace named Retail Analysis in the Power BI service. You need manage the members that have access to the app workspace. What should
you do?

A. From the Power BI Admin portal, click Usage metrics.

B. From the Office 365 Admin center, click Users.
C. From the Office 365 Admin center, click Groups.
D. From the Power BI Admin portal, click Tenant settings.

Answer: C

Explanation:
References:
https://docs.microsoft.com/en-us/power-bi/service-manage-app-workspace-in-power-bi-and-office-365

NEW QUESTION 213

- (Exam Topic 4)
You have a Microsoft Power BI data model that contains three tables named Orders, Date, and City. There is a one-to-many relationship between Date and Orders
and between City and Orders.
The model contains two row-level security (RLS) roles named Role1 and Role2. Role1 contains the following filter.
City[State Province] = "Kentucky"
Role2 contains the following filter. Date[Calendar Year] = 2020
If a user is a member of both Role1 and Role2, what data will they see in a report that uses the model?

A. The user will see data for which the State Province value is Kentucky and the Calendar Year is 2020.
B. The user will see data for which the State Province value is Kentucky or the Calendar Year is 2020.
C. The user will see only data for which the State Province value is Kentucky.
D. The user will receive an error and will not be able to see the data in the report.

Answer: B

Explanation:
When a report user is assigned to multiple roles, RLS filters become additive. It means report users can see table rows that represent the union of those filters.
Reference:
https://docs.microsoft.com/en-us/power-bi/guidance/rls-guidance

NEW QUESTION 214

- (Exam Topic 4)
Your organization has a team of power users who recently created 20 Power BI dashboards.
The power users share the dashboards with other users in the organization.
When the users attempt to access the dashboards, they receive the error message shown in the exhibit. (Click the Exhibit.)

You need to ensure that all the users can access the dashboards. What should you do first?

A. From the Microsoft Office 365 Admin center, and the Power BI (free) subscription, and then assign a license to each user.
B. From the Power BI Admin portal, modify the Privacy Settings.
C. From the properties of each dashboard, modify the Share dashboard settings.
D. Instruct each user to install Microsoft Office 2016.

Answer: A

Explanation:
References:
http://www.nubo.eu/en/blog/2016/12/Enable-PowerBI-On-Office-365/

NEW QUESTION 217

- (Exam Topic 4)
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?

A. scarterplot
B. bar chart
C. piechart

Passing Certification Exams Made Easy visit - https://www.2PassEasy.com

 Welcome to download the Newest 2passeasy PL-300 dumps
https://www.2passeasy.com/dumps/PL-300/ (311 New Questions)

Answer: B

NEW QUESTION 219

- (Exam Topic 4)
In Power BI Desktop, you are building a sales report that contains two tables. Both tables have row-level security (RLS) configured.
You need to create a relationship between the tables. The solution must ensure that bidirectional cross-filtering honors the RLS settings.
What should you do?

A. Create an active relationship between the tables and select Assume referential integrity.
B. Create an inactive relationship between the tables and select Assume referential integrity.
C. Create an inactive relationship between the tables and select Apply security filter in both directions.
D. Create an active relationship between the tables and select Apply security filter in both directions.

Answer: D

Explanation:
By default, row-level security filtering uses single-directional filters, whether the relationships are set to single direction or bi-directional. You can manually enable
bi-directional cross-filtering with row-level security by selecting the relationship and checking the Apply security filter in both directions checkbox. Select this option
when you've also implemented dynamic row-level security at the server level, where row-level security is based on username or login ID.
Graphical user interface, application, Word Description automatically generated

Reference:
https://docs.microsoft.com/en-us/power-bi/admin/service-admin-rls

NEW QUESTION 220

- (Exam Topic 4)
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:
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.

Answer: C

NEW QUESTION 224

- (Exam Topic 4)
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 an average line by using the Salary measure. Does this meet the goal?

A. Yes
B. No

Answer: B

Explanation:
Instead create a percentile line by using the Salary measure and set the percentile to 50%.
Note: 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_percentile.php

NEW QUESTION 225

- (Exam Topic 4)
You have the line chart shown in the exhibit. (Click the Exhibit tab.)

Passing Certification Exams Made Easy visit - https://www.2PassEasy.com

 Welcome to download the Newest 2passeasy PL-300 dumps
https://www.2passeasy.com/dumps/PL-300/ (311 New Questions)

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.

A. Mastered
B. Not Mastered

Answer: A

Explanation:
* 1. Select the line chart
* 2. Add the average line
* 3. Turn on Data Label

NEW QUESTION 230

- (Exam Topic 4)
You are creating a report in Power BI Desktop.
You load a data extract that includes a free text field named coll.
You need to analyze the frequency distribution of the string lengths in col1. The solution must not affect the size of the model.
What should you do?

A. In the report, add a DAX calculated column that calculates the length of col1
B. In the report, add a DAX function that calculates the average length of col1
C. From Power Query Editor, add a column that calculates the length of col1
D. From Power Query Editor, change the distribution for the Column profile to group by length for col1

Answer: D

Explanation:
From Power Query.. highlight the column.. from the tab view select Column Profile Option.. in the Value distribution section that appears below, from the 3dots..
you can change to group by text length distribution

Passing Certification Exams Made Easy visit - https://www.2PassEasy.com

 Welcome to download the Newest 2passeasy PL-300 dumps
https://www.2passeasy.com/dumps/PL-300/ (311 New Questions)

NEW QUESTION 235

- (Exam Topic 4)
You are preparing a financial report in Power BI.
You connect to the data stored in a Microsoft Excel spreadsheet by using Power Query Editor as shown in the following exhibit.

You need to prepare the data to support the following:

Visualizations that include all measures in the data over time
Year-over-year calculations for all the measures
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.

A. Mastered
B. Not Mastered

Answer: A

Explanation:

NEW QUESTION 239

- (Exam Topic 4)
You plan to create a report that will display sales data from the last year for multiple regions You need to restrict access to individual rows of the data on a per
region-basis by using roles.
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.

Passing Certification Exams Made Easy visit - https://www.2PassEasy.com

 Welcome to download the Newest 2passeasy PL-300 dumps
https://www.2passeasy.com/dumps/PL-300/ (311 New Questions)

A. Mastered
B. Not Mastered

Answer: A

Explanation:

NEW QUESTION 240

- (Exam Topic 4)
You are profiling data by using Power Query Editor.
You have a table that contains a column named column1. Column statistics and Value distribution for column1 are shown in the following exhibit.

A. Mastered
B. Not Mastered

Answer: A

Explanation:

Passing Certification Exams Made Easy visit - https://www.2PassEasy.com

 Welcome to download the Newest 2passeasy PL-300 dumps
https://www.2passeasy.com/dumps/PL-300/ (311 New Questions)

NEW QUESTION 241

- (Exam Topic 4)
You are developing a report page. Some users will navigate the report by using a keyboard, and some users will consume the report by using a screen reader.
You need to ensure that the users can consume the content on a report page in a logical order. What should you configure in Microsoft Power Bl Desktop?

A. the bookmark order

B. the layer order
C. the tab order
D. the X position

Answer: C

Explanation:
If you find yourself unable to navigate to an object or visual while using a keyboard, it may be because the report author has decided to hide that object from the
tab order. Report authors commonly hide decorative objects from the tab order. If you find that you cannot tab through a report in a logical manner, you should
contact the report author. Report authors can set the tab order for objects and visuals.
Reference:
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-accessibility-consuming-tools

NEW QUESTION 242

- (Exam Topic 4)
You import a Power Bl dataset that contains the following tables:
• Date
• Product
• Product Inventory
The Product inventory table contains 25 million rows. A sample of the data is shown in the following table.

The Product Inventory table relates to the Date table by using the DateKey column. The Product inventory table relates to the Product table by using the
ProductKey column. You need to reduce the size of the data model without losing information. What should you do?

A. Change Summarization for DateKey to Don't Summarize.

B. Change the data type of UnitCost to Integer.
C. Remove the relationship between Date and Product Inventory.
D. Remove MovementDate.

Answer: D

NEW QUESTION 243

- (Exam Topic 4)
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.)

Passing Certification Exams Made Easy visit - https://www.2PassEasy.com

 Welcome to download the Newest 2passeasy PL-300 dumps
https://www.2passeasy.com/dumps/PL-300/ (311 New Questions)

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. Change the name of the GeoCode column to Country.
C. Change the name of the Location table to Country.
D. Change the Default Summarization of the GeoCode column.
E. Add a Geoportal column to the Location table.
F. Change the Data Type of the GeoCode column.

Answer: B

Explanation:
References:
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-map-tips-and-tricks

NEW QUESTION 244

- (Exam Topic 4)
You have a Power Bl report hosted on powerbi.com that displays expenses by department for department
managers.
The report contains a line chart that shows expenses by month.
You need to enable users to choose between viewing the report as a line chart or a column chart. The solution must minimize development and maintenance
effort.
What should you do?

A. Add a column chart, a bookmark, and a button for users to choose a visual.
B. Create a mobile report that contains a column chart.
C. Create a separate report page for users to view the column chart.
D. Enable report readers to personalize visuals.

Answer: C

NEW QUESTION 249

- (Exam Topic 4)
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:

Passing Certification Exams Made Easy visit - https://www.2PassEasy.com

 Welcome to download the Newest 2passeasy PL-300 dumps
https://www.2passeasy.com/dumps/PL-300/ (311 New Questions)

A. Mastered
B. Not Mastered

Answer: A

Explanation:

NEW QUESTION 251

- (Exam Topic 4)
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.

A. Mastered
B. Not Mastered

Passing Certification Exams Made Easy visit - https://www.2PassEasy.com

 Welcome to download the Newest 2passeasy PL-300 dumps
https://www.2passeasy.com/dumps/PL-300/ (311 New Questions)

Answer: A

Explanation:
Divide, Calculate, AllSelected. Reference:
https://docs.microsoft.com/en-us/dax/allselected-function-dax

NEW QUESTION 253

- (Exam Topic 4)
You have a query named Customer that imports CSV files from a data lake. The query contains 500 rows as shown in the exhibit. (Click the Exhibit tab.)

Each file contains deltas of any new or modified rows from each load to the data lake. Multiple files can have the same customer ID.
You need to keep only the last modified row for each customer ID.
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.

A. Mastered
B. Not Mastered

Answer: A

Explanation:
1) Duplicate Customer query
2) Group by CustId by Max ModifiedDate (only 2 columns to keep)
3) Merge two queries on CustId and ModifiedDate inner join (to retreive other customer informations related to latest Date)

NEW QUESTION 257

- (Exam Topic 4)
You have a BI dataset and a connected report.
You need to ensure that users can analyze data in Microsoft Excel by connecting directly to the dataset. You grant the users the Build permission for dataset
What Should do next?

A. Change default visual interaction for the report

B. For the report change the Export data setting to Summarized data, data with current layout and underlying data

Passing Certification Exams Made Easy visit - https://www.2PassEasy.com

 Welcome to download the Newest 2passeasy PL-300 dumps
https://www.2passeasy.com/dumps/PL-300/ (311 New Questions)

C. For the report, change the Export data setting to None

D. Certify the dataset used by the report.

Answer: B

NEW QUESTION 259

- (Exam Topic 4)
You open powerbi.com as 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.

A. Mastered
B. Not Mastered

Answer: A

Explanation:
Graphical user interface, text, application, Word, email Description automatically generated
References: https://docs.microsoft.com/en-us/power-bi/service-data-classification

NEW QUESTION 260

- (Exam Topic 4)
You publish a report to a workspace named Customer Services. The report identifies customers that have potential data quality issues that must be investigated by
the customer services department of your company.
You need to ensure that customer service managers can create task lists in Microsoft Excel based on the data. Which report setting should you configure?

A. Don't allow end user to save filters on this report.

B. Change default visual interaction from cross highlighting to cross filtering.
C. Enable the updated filter pane, and show filters in the visual header for this report.
D. Allow users to add comments to this report.
E. Choose the type of data you allow your end users to export.

Answer: E

Explanation:
https://powerbi.microsoft.com/en-us/blog/announcing-persistent-filters-in-the-service/

Passing Certification Exams Made Easy visit - https://www.2PassEasy.com

 Welcome to download the Newest 2passeasy PL-300 dumps
https://www.2passeasy.com/dumps/PL-300/ (311 New Questions)

NEW QUESTION 265

- (Exam Topic 4)
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.

A. Mastered
B. Not Mastered

Answer: A

Explanation:

NEW QUESTION 266

- (Exam Topic 4)
You have the Power BI data model shown in the following exhibit.

A. Mastered
B. Not Mastered

Answer: A

Explanation:

Passing Certification Exams Made Easy visit - https://www.2PassEasy.com

 Welcome to download the Newest 2passeasy PL-300 dumps
https://www.2passeasy.com/dumps/PL-300/ (311 New Questions)

NEW QUESTION 270

- (Exam Topic 4)
You are profiling data by using Power Query Editor.
The AddressLine2 column in a table named Address is 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.

A. Mastered
B. Not Mastered

Answer: A

Explanation:

NEW QUESTION 271

- (Exam Topic 4)
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 have a Power BI model that contains two tables named Sales and Date. Sales contains four columns named TotalCost, DueDate, ShipDate, and OrderDate.
Date contains one column named Date.
The tables have the following relationships:
Sales[DueDate] and Date[Date]

Passing Certification Exams Made Easy visit - https://www.2PassEasy.com

 Welcome to download the Newest 2passeasy PL-300 dumps
https://www.2passeasy.com/dumps/PL-300/ (311 New Questions)

Sales[ShipDate] and Date[Date]

Sales[OrderDate] and Date[Date]
The active relationship is on Sales[DueDate].
You need to create measures to count the number of orders by [ShipDate] and the orders by [OrderDate]. You must meet the goal without duplicating data or
loading additional data.
Solution: You create measures that use the CALCULATE, COUNT, and USERELATIONSHIP DAX functions.
Does this meet the goal?

A. Yes
B. No

Answer: A

Explanation:
References:
https://docs.microsoft.com/en-us/dax/calculate-function-dax https://docs.microsoft.com/en-us/dax/count-function-dax https://docs.microsoft.com/en-
us/dax/userelationship-function-dax

NEW QUESTION 275

- (Exam Topic 4)
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. decomposition tree
B. Q&A
C. smart narrative
D. key influences

Answer: D

NEW QUESTION 277

- (Exam Topic 4)
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?

A. Use default visuals or custom visuals uploaded from a .pbiviz file.

B. Use only default visuals.
C. Use default or any custom visuals from the marketplace.
D. Use default or certified custom visuals.

Answer: C

NEW QUESTION 281

- (Exam Topic 4)
You have the visual shown in the Original exhibit. {Click the Original tab.)

You need to configure the visual as shown in the Modified exhibit. (Click the Modified tab.)

Passing Certification Exams Made Easy visit - https://www.2PassEasy.com

 Welcome to download the Newest 2passeasy PL-300 dumps
https://www.2passeasy.com/dumps/PL-300/ (311 New Questions)

What should you add to the visual?

A. a measure
B. a trendline
C. a forecast
D. an Average line

Answer: C

Explanation:
Explore forecast results by adjusting the desired confidence interval or by adjusting outlier data to see how they affect results.
Timeline Description automatically generated with low confidence
Reference:
https://powerbi.microsoft.com/fr-fr/blog/introducing-new-forecasting-capabilities-in-power-view-for-office-365

NEW QUESTION 286

- (Exam Topic 4)
A business intelligence (Bl) developer creates a dataflow in Power Bl that uses DirectQuery to access tables from an on premises Microsoft SQL server. The
Enhanced Dataflows Compute Engine is turned on for the dataflow.
You need to use the dataflow in a report. The solution must meet the following requirements:
• Minimize online processing operations.
• Minimize calculation times and render times for visuals.
• include data from the current year, up to and including the previous day. What should you do?

A. Create a dataflows connection that has Import mode selected and schedule a dairy refresh.
B. Create a dataflows connection that has DirectQuery mode selected.
C. Create a dataflows connection that has DirectQuery mode selected and configure a gateway connection for the dataset
D. Create a dataflows connection that has Import mode selected and create a Microsoft Power Automate solution to refresh the data hourly.

Answer: A

NEW QUESTION 289

- (Exam Topic 4)
You have two tables named Customers and Invoice in a Power BI model. The Customers table contains the following fields:
CustomerID
Customer City
Customer State
Customer Name
Customer Address 1
Customer Address 2
Customer Postal Code
The Invoice table contains the following fields:
Order ID
Invoice ID
Invoice Date
Customer ID
Total Amount
Total Item Count
The Customers table is related to the Invoice table through the Customer ID columns. A customer can have many invoices within one month.
The Power BI model must provide the following information:
The number of customers invoiced in each state last month
The average invoice amount per customer in each postal code
You need to define the relationship from the Customers table to the Invoice table. The solution must optimize query performance.
What should you configure? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Passing Certification Exams Made Easy visit - https://www.2PassEasy.com

 Welcome to download the Newest 2passeasy PL-300 dumps
https://www.2passeasy.com/dumps/PL-300/ (311 New Questions)

A. Mastered
B. Not Mastered

Answer: A

Explanation:
Box 1: One-to-many
A customer can have many invoices within one month.
Box 2: Single
For One-to-many relationships, the cross filter direction is always from the "one" side, and optionally from the "many" side (bi-directional). For
Single cross filter direction means "single direction", and Both means "both directions". A relationship that filters in both directions is commonly described as bi-
directional.
Reference:
https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-relationships-understand

NEW QUESTION 294

- (Exam Topic 4)
You have the following three versions of an Azure SQL database:
Test
Production
Development
You have a dataset that uses the development database as a data source.
You need to configure the dataset so that you can easily change the data source between the development, test, and production database servers from
powerbi.com.
Which should you do?

A. Create a JSON file that contains the database server name

B. Import the JSON file to the dataset.
C. Create a parameter and update the queries to use the parameter.
D. Create a query for each database server and hide the development tables.
E. Set the data source privacy level to Organizational and use the ReplaceValue Power Query M function.

Answer: B

Explanation:
https://docs.microsoft.com/en-us/learn/modules/create-manage-workspaces-power-bi/4-development-lifecycle-s

NEW QUESTION 295

- (Exam Topic 4)
The data model must support the following analysis:
Total sales by product by month in which the order was placed
Quantities sold by product by day on which the order was placed
Number Of sales transactions by quarter in Which the order was placed
For each Of the following statements, select Yes if the statement is true. Otherwise, select NO.

Passing Certification Exams Made Easy visit - https://www.2PassEasy.com

 Welcome to download the Newest 2passeasy PL-300 dumps
https://www.2passeasy.com/dumps/PL-300/ (311 New Questions)

A. Mastered
B. Not Mastered

Answer: A

Explanation:

NEW QUESTION 300

- (Exam Topic 4)
You have a Power Bl workspace named Inventory that contains a dataset a report and a dashboard. You need to add an additional tile to the dashboard. The tile
must show inventory by location. This
information is NOT visualized in the report. The solution must minimize the impact on the report.
Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

A. Use quick insights on the dashboard.

B. Hide the report page.
C. Ask a question by using Q&A.
D. Add the visual to the report.
E. Pin the visual to the dashboard.

Answer: CE

NEW QUESTION 303

- (Exam Topic 4)
You have a large dataset that contains more than 1 million rows. The table has a datetime column named Date.
You need to reduce the size of the data model. What should you do?

A. Round the hour of the Date column to startOfHour.

B. Change the data type of the Date column to Text.
C. Trim the Date column.
D. Split the Date column into two columns, one that contains only the time and another that contains only the date.

Answer: D

Explanation:
We have to separate date & time tables. Also, we don’t need to put the time into the date table, because the time is repeated every day.
Split your DateTime column into a separate date & time columns in fact table, so that you can join the date to the date table & the time to the time table. The time
need to be converted to the nearest round minute or second so that every time in your data corresponds to a row in your time table.
Reference:
https://intellipaat.com/community/6461/how-to-include-time-in-date-hierarchy-in-power-bi

NEW QUESTION 308

- (Exam Topic 4)
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 median line by using the Salary measure.
Does this meet the goal?

A. Yes
B. No

Answer: B

Explanation:
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

NEW QUESTION 309

- (Exam Topic 4)
You have a dataset named Pens that contains the following columns:
Unit Price
Quantity Ordered

Passing Certification Exams Made Easy visit - https://www.2PassEasy.com

 Welcome to download the Newest 2passeasy PL-300 dumps
https://www.2passeasy.com/dumps/PL-300/ (311 New Questions)

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.

A. Mastered
B. Not Mastered

Answer: A

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 313

- (Exam Topic 4)
You have a folder that contains 100 CSV files.
You need to make the file metadata available as a single dataset by using Power Bi The solution must NOT store the data of the CSV files.
Which three actions should you perform in sequence. To answer, mow the appropriate actions from the list of actions to the answer area and arrange them m the
correct order.
NOTE; More than one order of answer choices is correct. You will receive credit for any of the correct orders you select.

A. Mastered
B. Not Mastered

Answer: A

Explanation:
From Power BI Desktop, select Get Data, and then select Folder. From Power Query Editor, remove the Content column.
From Power Query Editor, expand the Attributes column.

NEW QUESTION 314

- (Exam Topic 4)
You plan to create a Power Bl dataset to analyze attendance at a school. Data will come from two separate views named View1 and View? in an Azure SQL
database. View1 contains the columns shown in the following table.

View2 contains the columns shown in the following table.

Passing Certification Exams Made Easy visit - https://www.2PassEasy.com

 Welcome to download the Newest 2passeasy PL-300 dumps
https://www.2passeasy.com/dumps/PL-300/ (311 New Questions)

The views can be related based on the Class ID column.

Class ID is the unique identifier for the specified class, period, teacher, and school year. For example, the same class can be taught by the same teacher during
two different periods, but the class will have a different class ID.
You need to design a star schema data model by using the data in both views. The solution must facilitate the following analysis:
The count of classes that occur by period
The count of students in attendance by period by day
The average number of students attending a class each month
In which table should you include the Teacher First Name and Period Number fields? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

A. Mastered
B. Not Mastered

Answer: A

Explanation:
Teacher dimension Class dimension

NEW QUESTION 318

- (Exam Topic 4)
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.

A. Mastered
B. Not Mastered

Answer: A

Passing Certification Exams Made Easy visit - https://www.2PassEasy.com

 Welcome to download the Newest 2passeasy PL-300 dumps
https://www.2passeasy.com/dumps/PL-300/ (311 New Questions)

Explanation:

NEW QUESTION 319

- (Exam Topic 4)
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 have a query for a table named Sales. Sales has a column named CustomerlD. The Data Type of CustomerlD is Whole Number.
You refresh the data and find several errors. You discover that new entries in the Sales table contain nonnumeric values.
You need to ensure that nonnumeric values in the CustomerlD column are set to 0. Solution: From Query Editor, select the CustomerlD column and click Remove
Errors. Does this meet the goal?

A. Yes
B. No

Answer: B

NEW QUESTION 321

- (Exam Topic 4)
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 data. 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.

A. Mastered
B. Not Mastered

Answer: A

Explanation:

Passing Certification Exams Made Easy visit - https://www.2PassEasy.com

 Welcome to download the Newest 2passeasy PL-300 dumps
https://www.2passeasy.com/dumps/PL-300/ (311 New Questions)

NEW QUESTION 322

- (Exam Topic 4)
You have a Power Bl report that uses row-level security (RLS).
You need to transfer RLS membership maintenance to an Azure network security team. The solution must NOT provide the Azure network security team with the
ability to manage reports, datasets. or dashboards.
What should you do?

A. Add the Azure network security team as members of the RLS role.
B. Instruct the Azure network security team to create security group
C. Configure RLS to use the groups.
D. Configure custom instructions for the Request access feature that instructs users to contact the Azure network security team.
E. Grant the Read and Build permissions for the Power Bl datasets to the Azure network security team.

Answer: B

NEW QUESTION 325

- (Exam Topic 4)
You have a report in Power BI Desktop.
You add a key influencers visual as shown in the exhibit. (Click the Exhibit tab.)

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.

Passing Certification Exams Made Easy visit - https://www.2PassEasy.com

 Welcome to download the Newest 2passeasy PL-300 dumps
https://www.2passeasy.com/dumps/PL-300/ (311 New Questions)

A. Mastered
B. Not Mastered

Answer: A

Explanation:
- adding more fields to Explain By
-3

NEW QUESTION 327

- (Exam Topic 4)
You have a Power B1 data model that contains two tables named Products and Sales. A one-to-many relationship exists between the tables.
You have a report that contains a report-level filter for Products.
You need to create a measure that will return the percent of total sales for each product. The measure must respect the report-level filter when calculating the total.
How should you complete the DAX measure? To answer drag the appropriate DAX functions to the correct targets- Each function may be used once, more than
once, or not at all the spirt bar between panes or scroll to view content
NOTE: Each correct selection is worth one point

A. Mastered
B. Not Mastered

Answer: A

Explanation:

NEW QUESTION 330

- (Exam Topic 4)
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.

Passing Certification Exams Made Easy visit - https://www.2PassEasy.com

 Welcome to download the Newest 2passeasy PL-300 dumps
https://www.2passeasy.com/dumps/PL-300/ (311 New Questions)

A. Mastered
B. Not Mastered

Answer: A

Explanation:

NEW QUESTION 334

- (Exam Topic 4)
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.

A. Mastered
B. Not Mastered

Answer: A

Explanation:
Text Description automatically generated

Passing Certification Exams Made Easy visit - https://www.2PassEasy.com

 Welcome to download the Newest 2passeasy PL-300 dumps
https://www.2passeasy.com/dumps/PL-300/ (311 New Questions)

References:
https://docs.microsoft.com/en-us/powerquery-m/text-replace https://docs.microsoft.com/en-us/powerquery-m/text-end

NEW QUESTION 338

- (Exam Topic 4)
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.

A. Mastered
B. Not Mastered

Answer: A

Explanation:
User 1 = Member User 2 = Contributor
https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-new-workspaces

NEW QUESTION 343

- (Exam Topic 4)
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. Configure the dataset to use the existing On-premises data gateway.

B. Deploy an On-premises data gateway in personal mode.
C. Set the refresh frequency to Daily.
D. Configure the dataset to use the personal gateway.

Answer: AC

Explanation:
https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-personal-mode

NEW QUESTION 345

- (Exam Topic 4)
You are modifying a Power Bi model by using Power Bl Desktop. You have a table named Sales that contains the following fields.

You have a table named Transaction Size that contains the following data.

You need to create a calculated column to classify each transaction as small, medium, or large based on the value in Sales Amount.
How should you complete the code? 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.

Passing Certification Exams Made Easy visit - https://www.2PassEasy.com

 Welcome to download the Newest 2passeasy PL-300 dumps
https://www.2passeasy.com/dumps/PL-300/ (311 New Questions)

A. Mastered
B. Not Mastered

Answer: A

Explanation:
FILTER | AND | CALCULATE

NEW QUESTION 350

- (Exam Topic 4)
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 have a Power BI report that imports a date table and a sales table from an Azure SQL database data source. The sales table has the following date foreign
keys:
Due Date
Order Date
Delivery Date
You need to support the analysis of sales over time based on all the date foreign keys.
Solution: For each date foreign key, you add inactive relationships between the sales table and the date table. Does this meet the goal?

A. Yes
B. No

Answer: A

NEW QUESTION 354

- (Exam Topic 4)
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 modify the source step of the queries to use DataSourceExcel as the file path. Does this meet the goal?

A. Yes
B. No

Answer: A

Explanation:
Parameterising a Data Source could be used in many different use cases. From connecting to different data sources defined in Query Parameters to load different
combinations of columns.
Reference:
https://www.biinsight.com/power-bi-desktop-query-parameters-part-1/

NEW QUESTION 355

- (Exam Topic 4)
You need to create a visual that enables the adhoc exploration of data as shown in the following exhibit.

Passing Certification Exams Made Easy visit - https://www.2PassEasy.com

 Welcome to download the Newest 2passeasy PL-300 dumps
https://www.2passeasy.com/dumps/PL-300/ (311 New Questions)

Which type of visual should you use?

A. Q&A
B. decomposition tree
C. smart narrative
D. key influencers

Answer: B

NEW QUESTION 357

- (Exam Topic 4)
You have the dashboard shown in the following exhibit.

You need to modify the dashboard to display as shown in the following exhibit.

Passing Certification Exams Made Easy visit - https://www.2PassEasy.com

 Welcome to download the Newest 2passeasy PL-300 dumps
https://www.2passeasy.com/dumps/PL-300/ (311 New Questions)

What should you do?

A. Create and apply a custom dashboard theme.

B. Change the colors of the visuals in the report.
C. Apply the Dark dashboard theme.
D. Upload a snapshot image of the dashboard.

Answer: C

NEW QUESTION 358

- (Exam Topic 4)
You have five sales regions. Each region is assigned a single salesperson.
You have an imported dataset that has a dynamic row-level security (RLS) role named Sales. The Sales role filters sales transaction data by salesperson.
Salespeople must see only the data from their region.
You publish the dataset to powerbi.com, set RLS role membership, and distribute the dataset and related reports to the salespeople.
A salesperson reports that she believes she should see more data. You need to verify what data the salesperson currently sees. What should you do?

A. Use the Test as role option to view data as the salesperson's user account.
B. Use the Test as role option to view data as the Sales role.
C. Instruct the salesperson to open the report in Microsoft Power Bl Desktop.
D. Filter the data in the reports to match the intended logic in the filter on the sales transaction table.

Answer: B

Explanation:
Validate the roles within Power BI Desktop
After you've created your roles, test the results of the roles within Power BI Desktop.From the Modeling tab, select View as.
A picture containing application Description automatically generatedThe View as roles window appears, where you see the roles you've created.Graphical user
interface, text, application Description automatically generated

Select a role you created, and then select OK to apply that role.The report renders the data relevant for that role.
You can also select Other user and supply a given user.Graphical user interface, application Description automatically generated
Select OK.The report renders based on what that user can see.
Reference:
https://docs.microsoft.com/en-us/power-bi/admin/service-admin-rls

NEW QUESTION 362

......

Passing Certification Exams Made Easy visit - https://www.2PassEasy.com

 Welcome to download the Newest 2passeasy PL-300 dumps
https://www.2passeasy.com/dumps/PL-300/ (311 New Questions)

THANKS FOR TRYING THE DEMO OF OUR PRODUCT

Visit Our Site to Purchase the Full Set of Actual PL-300 Exam Questions With Answers.

We Also Provide Practice Exam Software That Simulates Real Exam Environment And Has Many Self-Assessment Features. Order the
PL-300 Product From:

https://www.2passeasy.com/dumps/PL-300/

Money Back Guarantee

PL-300 Practice Exam Features:

* PL-300 Questions and Answers Updated Frequently

* PL-300 Practice Questions Verified by Expert Senior Certified Staff

* PL-300 Most Realistic Questions that Guarantee you a Pass on Your FirstTry

* PL-300 Practice Test Questions in Multiple Choice Formats and Updatesfor 1 Year

Passing Certification Exams Made Easy visit - https://www.2PassEasy.com

Powered by TCPDF (www.tcpdf.org)