Microsoft - PL 300.VJan 2024.by .HuynDair.127q

Microsoft.PL-300.vJan-2024.by.HuynDair.
127q
Number: PL-300
Passing Score: 800
Time Limit: 120
Website: www.VCEplus.io File Version: 12.0
Twitter: https://twitter.com/VCE_Plus
Exam Code: PL-300

Exam Name: Microsoft Power BI Data Analyst
IT Certification Exams - Questions & Answers | VCEplus.io

Case Study 02
Topic 2, Contoso Ltd, Case Study
Overview
This is a case study. Case studies are not timed separately. You can use as much exam time as you would like to complete each case. However, there may be additional case studies and sections on this exam. You must manage
your time to ensure that you are able to complete all questions included on this exam in the time provided.
To answer the questions included in a case study, you will need to reference information that is provided in the case study. Case studies might contain exhibits and other resources that provide more information about the
scenario that is described in the case study. Each question is independent of the other questions in this case study.
At the end of this case study, a review screen will appear. This screen allows you to review your answers and to make changes before you move to the next section of the exam. After you begin a new section, you cannot
return to this section.
To start the case study
To display the first question in this case study, click the Next button. Use the buttons in the left pane to explore the content of the case study before you answer the questions. Clicking these buttons displays information such
as business requirements, existing environment and problem statements.
If the case study has an All Information tab, note that the information displayed is identical to the information displayed on the subsequent tabs. When you are ready to answer a question, click the
Qbutton to return to the question.
Existing Environment
Contoso, Ltd. is a manufacturing company that produces outdoor equipment Contoso has quarterly board meetings for which financial analysts manually prepare Microsoft Excel reports, including profit and loss statements
for each of the company's four business units, a company balance sheet, and net income projections for the next quarter.
Data and Sources
Data for the reports comes from three sources. Detailed revenue, cost and expense data comes from an Azure SQL database. Summary balance sheet data comes from Microsoft Dynamics 365 Business Central. The balance
sheet data is not related to the profit and loss results, other than they both relate to dates.
Monthly revenue and expense projections for the next quarter come from a Microsoft SharePoint Online list. Quarterly projections relate to the profit and loss results by using the following shared dimensions: date, business
unit, department, and product category.
Net Income Projection Data
www.VCEplus.io
Net income projection data is stored in a SharePoint Online list named Projections in the format shown in the following table.
Revenue projections are set at the monthly level and summed to show projections for the quarter.
Balance Sheet Data
The balance sheet data is imported with final balances for each account per month in the format shown in the following table.

There is always a row for each account for each month in the balance sheet data.
Dynamics 365 Business Central Data
Business Central contains a product catalog that shows how products roll up to product categories, which roll up to business units. Revenue data is provided at the date and product level. Expense data is provided at the date and department
level.
Business Issues
Historically, it has taken two analysts a week to prepare the reports for the quarterly board meetings.
Also, there is usually at least one issue each quarter where a value in a report is wrong because of a bad cell reference in an Excel formula. On occasion, there are conflicting results in the reports because the products and departments that roll
up to each business unit are not defined consistently.
Planned Changes
Contoso plans to automate and standardize the quarterly reporting process by using Microsoft Power Bl. The company wants to how long it takes to populate reports to less than two days. The company wants to create common logic for
business units, products, and departments to be used across all reports, including, but not limited, to the quarterly reporting for the board.
Technical Requirements
Contoso wants the reports and datasets refreshed with minimal manual effort The company wants to provide a single package of reports to the board that contains custom navigation and links to supplementary information.
Maintenance, including manually updating data and access, must be minimized as much as possible.
Security Requirements
www.VCEplus.io
The reports must be made available to the board from powerbi.com. A mail-enabled security group will be used to share information with the board.
The analysts responsible for each business unit must see all the data the board sees, except the profit and loss data, which must be restricted to only their business unit's data. The analysts must be able to build new reports from the dataset
that contains the profit and loss data, but any reports that the analysts build must not be included in the quarterly reports for the board. The analysts must not be able to share the quarterly reports with anyone.
Report Requirements
You plan to relate the balance sheet to a standard date table in Power Bl in a many-to-one relationship based on the last day of the month. At least one of the balance sheet reports in the quarterly reporting package must show the ending
balances for the quarter, as well as for the previous quarter.
Projections must contain a column named RevenueProjection that contains the revenue projection amounts. A relationship must be created from Projections to a table named Date that contains the columns shown in the following table.
The relationships between products and departments to business units must be consistent across all reports.
The board must be able to get the following information from the quarterly reports:
• Revenue trends over time
• Ending balances for each account
• A comparison of expenses versus projections by quarter
• Changes in long-term liabilities from the previous quarter
• A comparison of quarterly revenue versus the same quarter during the prior year
QUESTION 1
Which two types of visualizations can be used in the balance sheet reports to meet the reporting goals? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.
A. a line chart that shows balances by quarter filtered to account categories that are long-term liabilities.
B. a clustered column chart that shows balances by date (x-axis) and account category (legend) without filters.

C. a clustered column chart that shows balances by quarter filtered to account categories that are long-term liabilities.
D. a pie chart that shows balances by account category without filters.
E. a ribbon chart that shows balances by quarter and accounts in the legend.
Correct Answer: A, E
Section:
Explanation:
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-types-for-reports-and-qand-a
QUESTION 2
DRAG DROP
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.
Select and Place:
www.VCEplus.io
Correct Answer:
Section:
Explanation:
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
QUESTION 3

HOTSPOT
How should you distribute the reports to the board? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
Hot Area:
Answer Area:
Section:
www.VCEplus.io
Explanation:
Box 1: Using a workspace membership
Scenario:
The company wants to provide a single package of reports to the board that contains custom navigation and links to supplementary information. Note: Workspace is a shared environment for a group of people. You can have
multiple Power BI content in a workspace. One workspace can have hundreds of dashboards, reports, and datasets in it. Box 2: A mail-enabled security group
Scenario: Security Requirements
The reports must be made available to the board from powerbi.com. A mail-enabled security group will be used to share information with the board.
QUESTION 4
You need to ensure that the data is updated to meet the report requirements. The solution must minimize configuration effort.
What should you do?
A. From each report in powerbi.com. select Refresh visuals

B. From Power Bl Desktop, download the PBIX file and refresh the data.
C. Configure a scheduled refresh without using an on-premises data gateway.
D. Configure a scheduled refresh by using an on-premises data gateway
Correct Answer: C
Section:
QUESTION 5

You need to create the relationship between the product list and the revenue results. The solution must minimize the time it takes to render visuals.
What should you set as the relationship cardinality?
A. One to one
B. Many to one
C. One to many
D. Many to many
Correct Answer: C
Section:
QUESTION 6
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.
Correct Answer: B
Section:
QUESTION 7
support the reports?
A. two imported datasets

www.VCEplus.io
B. a single DirectQuery dataset
C. two DirectQuery datasets
D. a single imported dataset
Correct Answer: D
Section:
Explanation:
"The analysts responsible for each business unit must see all the data the board sees, except the profit and loss data, which must be restricted to only their business unit's data. The analysts must be able to build new reports
from the dataset that contains the profit and loss data" => one dataset and two separate workspaces Reason: All data can be imported into one dataset also if these are two logical models. Shared dimensions can be
reconsumed in both models. Reports and additional materials can be shared to the board with an app. The "profit and loss" data model needs RLS for the analysts and the analysts must have just read access to the original
workspace. In a separate workspace with contributer (or more rights) they can create new reports (with live connection to the dataset). It is also stated that the new reports mustn't be shared so therefore no need to include
them into the app. Import vs. DirectQuery: Due to RLS requirements an imported dataset is needed.
It is not possible with file sources and Sharepoint lists.
QUESTION 8
You plan to develop a Power BI report that has a bar chart to display the number of customers by location. You have a table named Customer that has the following columns:
• Customer ID
• CustomerName
• Address
• City
• ProvState
• Country

You need to allow users to drill down by location. The report will display the number of each customer by Country, and drill down to ProvState, and then to City. How should you configure the drill down in the bar chart?
A. In the Value field, add Country. In the Legend field, add ProvState at the top, followed by City.
B. In the Legend field, add Country. In the Axis field, add ProvState at the top, followed by City.
C. In the Axis field, add Country at the top, followed by ProvState, and then City.
D. In the Value field, add Country at the top, followed by ProvState, and then City.
Correct Answer: C
Section:
Explanation:
Reference:
https://docs.microsoft.com/en-us/power-bi/guided-learning/visualizations#step-18
https://docs.microsoft.com/en-us/power-bi/power-bi-visualization-drill-down
QUESTION 9
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] )
www.VCEplus.io
)
D. CALCULATE (
MAX( BalanceSheet[BalanceAmount] ),
LASTDATE( 'Date' [Date] )
)
Correct Answer: A
Section:
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
Case Study 03
Topic 3, Northwind Traders
Case study
This is a case study. Case studies are not timed separately. You can use as much exam time as you would like to complete each case. However, there may be additional case studies and sections on this exam. You must manage
your time to ensure that you are able to complete all question included on this exam in the time provided.
To answer the questions included in a case study, you will need to reference information that is provided in the case study. Case studies might contain exhibits and other resources that provide more information about the
scenario that is described in the case study. Each question is independent of the other question on this case study.
At the end of this case study, a review screen will appear. This screen allows you to review your answers and to make changes before you move to the next section of the exam. After you begin a new section, you cannot

return to this section.
To start the case study
To display the first question on this case study, click the Next button. Use the buttons in the left pane to explore the content of the case study before you answer the questions. Clicking these buttons displays information such
as business requirements, existing environment, and problem statements.
If the case study has an All Information tab, note that the information displayed is identical to the information displayed on the subsequent tabs. When you are ready to answer a question, click the
Qbutton to return to the question.
Overview. General Overview
Northwind Traders is a specialty food import company.
The company recently implemented Power BI to better understand its top customers, products, and suppliers.
Overview. Business Issues
The sales department relies on the IT department to generate reports in Microsoft SQL Server Reporting Services (SSRS). The IT department takes too long to generate the reports and often misunderstands the report
requirements.
Existing Environment. Data Sources
Northwind Traders uses the data sources shown in the following table.
Source2 is exported daily from a third-party system and stored in Microsoft SharePoint Online.
Existing Environment. Customer Worksheet
Source2 contains a single worksheet named Customer Details. The first 11 rows of the worksheet are shown in the following table.
All the fields in Source2 are mandatory.

www.VCEplus.io
The Address column in Customer Details is the billing address, which can differ from the shipping address.
Existing Environment. Azure SQL Database
Source1 contains the following table:
Orders
Products
Suppliers
Categories
Order Details
Sales Employees
The Orders table contains the following columns.

The Order Details table contains the following columns.
www.VCEplus.io
The address in the Orders table is the shipping address, which can differ from the billing address.
The Products table contains the following columns.
The Categories table contains the following columns.

The Suppliers table contains the following columns.
The Sales Employees table contains the following columns.
www.VCEplus.io
Each employee in the Sales Employees table is assigned to one sales region. Multiple employees can be assigned to each region.
Requirements. Report Requirements
Northwind Traders requires the following reports:
Top Products
Top Customers
On-Time Shipping
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 report must also show which suppliers provide the top products.
The On-Time Shipping report will show the following metrics for a selected shipping month or quarter:
The percentage of orders that were shipped late by country and shipping region Customers that had multiple late shipments during the last quarter Northwind Traders defines late orders as those shipped after the required shipping date.
The warehouse shipping department must be notified if the percentage of late orders within the current month exceeds 5%.
The reports must show historical data for the current calendar year and the last three calendar years.
Requirements. Technical Requirements
Northwind Traders identifies the following technical requirements:
A single dataset must support all three reports.
The reports must be stored in a single Power BI workspace.

Report data must be current as of 7 AM Pacific Time each day.
The reports must provide fast response times when users interact with a visualization.
The data model must minimize the size of the dataset as much as possible, while meeting the report requirements and the technical requirements.
Requirements. Security Requirements
Access to the reports must be granted to Azure Active Directory (Azure AD) security groups only. An Azure AD security group exists for each department.
The sales department must be able to perform the following tasks in Power BI:
Create, edit, and delete content in the reports.
Manage permissions for workspaces, datasets, and report.
Publish, unpublish, update, and change the permissions for an app.
Assign Azure AD groups role-based access to the reports workspace.
Users in the sales department must be able to access only the data of the sales region to which they are assigned in the Sales Employees table.
Power BI has the following row-level security (RLS) Table filter DAX expression for the Sales Employees table.
[EmailAddress] = USERNAME()
RLS will be applied only to the sales department users. Users in all other departments must be able to view all the data.
QUESTION 1
HOTSPOT
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.
Hot Area:
www.VCEplus.io
Answer Area:
Section:
Explanation:
QUESTION 2
HOTSPOT
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.
Hot Area:

Answer Area:
Section:
Explanation:
QUESTION 3
You need to design the data model to meet the report requirements.
What should you do in Power BI Desktop?
www.VCEplus.io
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 table. Create an active relationship to the OrderDate column in the Orders table and an inactive relationship to the ShippedDate column in the Orders table.
Correct Answer: B
Section:
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.
QUESTION 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. bar chart
B. scatterplot
C. pie chart

Correct Answer: A
Section:
Explanation:
Scenario: The On-Time Shipping report will show the following metrics for a selected shipping month or quarter:
The percentage of orders that were shipped late by country and shipping region Customers that had multiple late shipments during the last quarter Note: Bar and column charts are some of the most widely used visualization
charts in Power BI. They can be used for one or multiple categories. Both these chart types represent data with rectangular bars, where the size of the bar is proportional to the magnitude of data values. The difference
between the two is that if the rectangles are stacked horizontally, it is called a bar chart. If the rectangles are vertically aligned, it is called a column chart.
Reference:
https://www.pluralsight.com/guides/bar-and-column-charts-in-power-bi
QUESTION 5
HOTSPOT
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.
Hot Area:
www.VCEplus.io
Answer Area:

Section:
Explanation:
Box 1: CALCULATE
www.VCEplus.io
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
QUESTION 6
HOTSPOT
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.
Hot Area:

Answer Area:
www.VCEplus.io
Section:
Explanation:
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/
Exam C
QUESTION 1
You have a dashboard that contains tiles pinned from a single report as shown in the Original Dashboard exhibit. (Click the Original Dashboard tab.)

You need to modify the dashboard to appear as shown in the Modified Dashboard exhibit. (Click the Modified Dashboard tab.)
www.VCEplus.io
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.
Correct Answer: C

Section:
Explanation:
https://docs.microsoft.com/en-us/power-bi/create-reports/service-dashboard-themes#howdashboard-themes-work
QUESTION 2
You have the dataset shown in the following exhibit.
www.VCEplus.io
You need to ensure that the visual shows only the 10 cities that have the highest sales profit.
What should you do?
A. Add a Top N filter to the visual.

B. Configure the Sales Profit measure to use the RANKX function.
C. Add a calculated column to the table that uses the TOPN function. In the visual, replace Sales Profit with the calculated column.
D. Add a calculated column to the table that returns the city name if the city is in the top 10, otherwise the calculated column will return "Not in Top 10". In the visual, replace Sales Profit with the calculated column.
D18912E1457D5D1DDCBD40AB3BF70D5D
Correct Answer: A
Section:
Explanation:
Power BI Top N Filters are useful to display the top performing records, and Bottom N filters are helpful to display the least performing records. For example, we can display top or bottom 10 products by orders or sales. Note:
Select the Column you want to display the Top Sales Profit
Then change the Filter Type of that Column to Top N
Fill in Top / Bottom number field

And lastly drag to the By Value filed your Sales Profit
Reference:
https://www.tutorialgateway.org/power-bi-top-10-filters/
QUESTION 3
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
Correct Answer: B
Section:
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
QUESTION 4
DRAG DROP
www.VCEplus.io
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.
Select and Place:
Correct Answer:

Section:
Explanation:
QUESTION 5
HOTSPOT
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.
www.VCEplus.io
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.
Hot Area:

Answer Area:
Section:
Explanation:
QUESTION 6
www.VCEplus.io
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.
Correct Answer: A
Section:

QUESTION 7
You publish a Microsoft Power BI dataset to powerbi.com. The dataset appends data from an onpremises 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.
Correct Answer: A, C
Section:
Explanation:
https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-personal-mode
QUESTION 8
You need to provide a user with the ability to add members to a workspace. The solution must use the principle of least privilege. Which role should you assign to the user?
A. Viewer
B. Contributor
C. Member
D. Admin
Correct Answer: C
Section:
Explanation:
www.VCEplus.io
A Member can add members or others with lower permissions.
Note:

QUESTION 9
You create a dataset sourced from dozens of flat files in Azure Blob storage. The dataset uses incremental refresh. From powerbi.com, you deploy the dataset and several related reports to Microsoft Power BI Premium
capacity. You discover that the dataset refresh fails after the refresh runs out of resources.
What is a possible cause of the issue?
A. Query folding is not occurring.

B. You selected Only refresh complete periods.
C. The data type of the column used to partition the data changed.
D. A filter is missing on the report.
Correct Answer: A
Section:
Explanation:
The Power BI service partitions data based on date range. This is what enables only certain partitions to be refreshed incrementally. To make this work, the partition filter conditions are pushed down to the source system by
including them in the queries. Using Power Query terminology, this is called “query folding”. It is not recommended that incremental refresh is used when the required query folding cannot take place.
Reference:
https://powerbi.microsoft.com/en-us/blog/incremental-refresh-query-folding/
QUESTION 10
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 publish an app to the entire organization.
A. Yes
www.VCEplus.io
B. No
Correct Answer: B
Section:
Explanation:
QUESTION 11
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).
www.VCEplus.io
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 add a measure to rank total sales by product. The results must appear as shown in the following table.

Which DAX formula should you use?
A. Product Ranking= RANKX (Product, [SalesAmount], , DESC, Skip)

B. Product Ranking= RANKX (ALL, (‘Product’), [SalesAmount], , DESC, Dense)
C. Product Ranking= RANKX (ALL, (‘Product’), [SalesAmount], , DESC, Skip)
D. Product Ranking= RANKX (ALL (‘Product’), [SalesAmount], , Asc, Dense
Correct Answer: B
Section:
Explanation:
Reference: https://msdn.microsoft.com/en-us/library/gg492185.aspx
QUESTION 12
You manage a Power BI model has a table named Sales and product. www.VCEplus.io
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
Correct Answer: D
Section:
Explanation:
Reference: https://docs.microsoft.com/en-us/power-bi/power-bi-how-to-report-filter
QUESTION 13
You have a Microsoft SharePoint Online site that contains several document libraries. One of the document libraries contains manufacturing reports saved as Microsoft Excel files. All the manufacturing reports have the same
data structure.
You need to load only the manufacturing reports to a table for analysis.
What should you do in Microsoft Power Bl Desktop?
A. Get data from a SharePoint Online folder, enter the site URL, and then select Combine & Load.
B. Get data from a SharePoint Online list and enter the site URL. Edit the query and filter by the path to the manufacturing reports library.
C. Get data from a SharePoint Online folder and enter the site URL. Edit the query and filter by the path to the manufacturing reports library.
D. Get data from a SharePoint Online list, enter the site URL, and then select Combine & Load.

Correct Answer: B
Section:
Explanation:
We have to import Excel files from SharePoint, so we need the connector SharePoint folder which is used to get access to the files stored in the library. SharePoint list is a collection of content that has rows and columns (like a
table) and is used for task lists, calendars, etc. Since we have to filter only on manufacturing reports, we have to select Transform and then filter by the corresponding folder path. https://docs.microsoft.com/en-us/power-
query/connectors/sharepointlist
QUESTION 14
You create the following step by using Power Query Editor.
= Table.ReplaceValue(SalesLT_Address,"1318","1319",Replacer.ReplaceText,{"AddressLine1"}) A row has a value of 21318 Lasalle Street in the AddressLine1 column. What will the value be when the step is applied?
A. 1318
B. 1319
C. 21318 Lasalle Street
D. 21319 Lasalle Street
Correct Answer: D
Section:
Explanation:
Example:
www.VCEplus.io

www.VCEplus.io

Replace the text "ur" with the text "or" in the table.
Reference:
https://docs.microsoft.com/en-us/powerquery-m/table-replacevalue
QUESTION 15
You import a large dataset to Power Query Editor.
You need to identify whether a column contains only unique values.
Which two Data Preview options can you use? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point
A. Show whitespace
B. Column distribution
C. Column profile
D. Column quality
E. Monospaced
Correct Answer: A, D
Section:
QUESTION 16
Your company has employees in 10 states.
The company recently decided to associate each state to one of the following three regions: East, West, and North. You have a data model that contains employee information by state. The model does NOT include region
information. You have a report that shows the employees by state.
You need to view the employees by region as quickly as possible.
What should you do?
A. Create a new aggregation that summarizes by employee.

www.VCEplus.io
B. Create a new group on the state column and set the Group type to List.
C. Create a new group on the state column and set the Group type to Bin.
D. Create a new aggregation that summarizes by state.
Correct Answer: B
Section:
Explanation:
https://www.mssqltips.com/sqlservertip/4720/binning-and-grouping-data-with-power-bi/
QUESTION 17
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"})
Correct Answer: B
Section:
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.
www.VCEplus.io
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
QUESTION 18
Solution: You create a percentile line by using the Salary measure and set the percentile to 50%.
A. Yes

B. No
Correct Answer: A
Section:
Explanation:
The 50th percentile is also known as the median or middle value where 50 percent of observations fall below.
Reference:
QUESTION 19
Solution: You create an Azure Active Directory group that contains all the users. You share each report and dashboard to the group. Does this meet the goal?
A. Yes
B. No
Correct Answer: A
Section:
Explanation:
Statements and questions are tricky and confusing. When the access is granted for the group (all users) for ALL (each) dashboards and ALL (each) reports in the workspace, then the will have read access to the specific (A,
one) Dashboard and several reports, because they are part of all dashboards and reports. There is no statement, that for the other dashboards (except the one) and the other reports (except the several) that access must be
www.VCEplus.io
prevented. They are also accessible (maybe it is not desired but not stated here).
QUESTION 20
Solution: You assign all the users the Viewer role to the workspace.
A. Yes
B. No
Correct Answer: A
Section:
Explanation:
QUESTION 21
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

B. Folder
C. Excel Workbook
D. SharePoint folder
E. Web
Correct Answer: B, C
Section:
Explanation:
QUESTION 22
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.
Correct Answer: A
Section:
QUESTION 23
www.VCEplus.io
DRAG DROP
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.

Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
Select and Place:
www.VCEplus.io
Correct Answer:
Section:
Explanation:
QUESTION 24
HOTSPOT
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:
Hot Area:
Answer Area:
www.VCEplus.io
Section:
Explanation:
QUESTION 25
HOTSPOT
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.
Hot Area:
Answer Area:
www.VCEplus.io
Section:
Explanation:
QUESTION 26
HOTSPOT
You have a dataset that contains revenue data from the past year.
You need to use anomaly detection in Power Bl to show anomalies in the dataset.
What should you configure? To answer, select the appropriate options in the answer area.
Hot Area:
Answer Area:

Section:
Explanation:
QUESTION 27
DRAG DROP
You have a Power Bl workspace that contains a single-page report named Sales.
You need to add all the visuals from Sales to a dashboard. The solution must ensure that additional visuals added to the page are added automatically to the dashboard. Which three actions should you perform in sequence?
To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
Select and Place:
www.VCEplus.io
Correct Answer:
Section:
Explanation:
QUESTION 28
HOTSPOT
You have a Power Bl report.
You have the following tables.

You have the following DAX measure.
Hot Area:
Answer Area:
www.VCEplus.io
Section:
Explanation:
QUESTION 29
HOTSPOT
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.
Hot Area:

Answer Area:
Section:
Explanation:
QUESTION 30
HOTSPOT
www.VCEplus.io
You have a column named UnitslnStock as shown in the following exhibit

www.VCEplus.io
UnitsInStock has 75 non-null values, of which 51 are unique.

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.
Hot Area:

Answer Area:
Section:
Explanation:
QUESTION 31
www.VCEplus.io
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.
Correct Answer: D
Section:
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
QUESTION 32
You have a custom connector that returns ID, From, To, Subject, Body, and Has Attachments for every email sent during the past year. More than 10 million records are returned. You build a report analyzing the internal
networks of employees based on whom they send emails to.
You need to prevent report recipients from reading the analyzed emails. The solution must minimize the model size. What should you do?
A. Implement row-level security (RLS) so that the report recipients can only see results based on the emails they sent.
B. Remove the Subject and Body columns during the import.

C. From Model view, set the Subject and Body columns to Hidden.
Correct Answer: B
Section:
QUESTION 33
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.
A. Group the impressions by Ad_id, Site_name, and Impression_date.

Aggregate by using the CountRows function.
B. Create one-to-many relationships between the tables. www.VCEplus.io
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.
Correct Answer: A, B
Section:
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.
QUESTION 34
Your company has training videos that are published to Microsoft Stream.
You need to surface the videos directly in a Microsoft Power BI dashboard.
Which type of tile should you add?
A. video
B. custom streaming data
C. text box
D. web content
Correct Answer: D
Section:
Explanation:
https://docs.microsoft.com/en-us/stream/portal-embed-video

https://docs.microsoft.com/en-us/power-bi/create-reports/service-dashboard-add-widget#addweb-content
QUESTION 35
You open a query in Power Query Editor.
You need to identify the percentage of empty values in each column as quickly as possible.
Which Data Preview option should you select?
A. Show whitespace
B. Column profile
C. Column distribution
D. Column quality
Correct Answer: D
Section:
Explanation:
Column quality: In this section, we can easily see valid, Error and Empty percentage of data values associated with the Selected table. Note: In Power Query Editor, Under View tab in Data Preview Section we can see the
following data profiling functionalities:
Column quality
Column distribution
Column profile
Reference:
https://community.powerbi.com/t5/Community-Blog/Data-Profiling-in-Power-BI-Power-BI-Update-April-2019/ba-p/674555
QUESTION 36
First name
Last name
www.VCEplus.io
You have a prospective customer list that contains 1,500 rows of dat a. The list contains the following fields:
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.
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.
Correct Answer: C, E
Section:
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/
QUESTION 37

You import two Microsoft Excel tables named Customer and Address into Power Query. Customer contains the following columns:
Customer ID
Customer Name
Phone
Email Address
Address ID
Address contains the following columns:
Address ID
Address Line 1
Address Line 2
City
State/Region
Country
Postal Code
The Customer ID and Address ID columns represent unique rows.
You need to create a query that has one row per customer. Each row must contain City, State/Region, and Country for each customer. What should you do?
A. Merge the Customer and Address tables.

B. Transpose the Customer and Address tables.
C. Group the Customer and Address tables by the Address ID column.
D. Append the Customer and Address tables.
Correct Answer: A
Section:
Explanation:
There are two primary ways of combining queries: merging and appending.www.VCEplus.io
When you have one or more columns that you’d like to add to another query, you merge the queries.
When you have additional rows of data that you’d like to add to an existing query, you append the query.
Reference:
https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-shape-and-combine-data
QUESTION 38
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 names. Import the JSON file to the dataset.
B. Create a parameter and update the queries to use the parameter.
C. Create a query for each database server and hide the development tables.
D. Set the data source privacy level to Organizational and use the ReplaceValue Power Query M function.
Correct Answer: B
Section:
Explanation:
https://docs.microsoft.com/en-us/learn/modules/create-manage-workspaces-power-bi/4-development-lifecycle-strategy

QUESTION 39
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:
2018-12-31 at 08:59.
You need to be able to analyze the complaints by the logged date and use a built-in date hierarchy. D18912E1457D5D1DDCBD40AB3BF70D5D
What should you do?
A. Change the data type of the Logged column to Date.

B. Apply a transform to extract the last 11 characters of the Logged column and set the data type of the new column to Date.
C. Create a column by example that starts with 2018-12-31 and set the data type of the new column to Date.
D. Apply a transform to extract the first 11 characters of the Logged column.
Correct Answer: C
Section:
QUESTION 40
You have an Azure SQL database that contains sales transactions. The database is updated frequently. You need to generate reports from the data to detect fraudulent transactions. The data must be visible within five minutes
of an update. How should you configure the data connection?
A. Add a SQL statement.

B. Set Data Connectivity mode to DirectQuery.
C. Set the Command timeout in minutes setting.
D. Set Data Connectivity mode to Import.
Correct Answer: B
Section:
Explanation:
www.VCEplus.io
With Power BI Desktop, when you connect to your data source, it's always possible to import a copy of the data into the Power BI Desktop. For some data sources, an alternative approach is available: connect directly to the
data source using DirectQuery.
DirectQuery: No data is imported or copied into Power BI Desktop. For relational sources, the selected tables and columns appear in the Fields list. For multi-dimensional sources like SAP Business Warehouse, the dimensions
and measures of the selected cube appear in the Fields list. As you create or interact with a visualization, Power BI Desktop queries the underlying data source, so you’re always viewing current data.
Reference:
https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-use-directquery
QUESTION 41
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.
Correct Answer: B
Section:

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
QUESTION 42
You have sales data in a star schema that contains four tables named Sales, Customer, Date, and Product. The Sales table contains purchase and ship dates.
Most often, you will use the purchase date to analyze the data, but you will analyze the data by both dates independently and together. You need to design an imported dataset to support the analysis. The solution must
minimize the model size and the number of queries against the data source. Which data modeling design should you use?
A. Use the Auto Date/Time functionality in Microsoft Power BI and do NOT import the Date table.
B. Duplicate the Date query in Power Query and use active relationships between both Date tables.
C. On the Date table, use a reference query in Power Query and create active relationships between Sales and both Date tables in the modeling view.
D. Create an active relationship between Sales and Date for the purchase date and an inactive relationship for the ship date.
Correct Answer: D
Section:
Explanation:
Only one relationship can be active.
Note: If you query two or more tables at the same time, when the data is loaded, Power BI Desktop attempts to find and create relationships for you. The relationship options Cardinality, Cross filter direction, and Make this
relationship active are automatically set.
Reference:
https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-create-and-managerelationships
QUESTION 43
www.VCEplus.io
Solution: You create a constant line and set the value to .5.
A. Yes
B. No
Correct Answer: B
Section:
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:
QUESTION 44
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
Correct Answer: C
Section:
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:
Incorrect Answers:
A: Stacked area charts are not appropriate to study the evolution of each individual group: it is very hard to substract the height of other groups at each time point. Note: A stacked area chart is the extension of a basic area chart. It displays the
each group.
Reference:
www.VCEplus.io
evolution of the value of several groups on the same graphic. The values of each group are displayed on top of each other, what allows to check on the same figure the evolution of both the total of a numeric variable, and the importance of
https://www.data-to-viz.com/graph/line.html
QUESTION 45
You are developing a sales report that will have multiple pages. Each page will answer a different business question. You plan to have a menu page that will show all the business questions.
You need to ensure that users can click each business question and be directed to the page where the question is answered. The solution must ensure that the menu page will work when deployed to any workspace.
What should you include on the menu page?
A. Create a text box for each business question and insert a link.
B. Create a button for each business question and set the action type to Bookmark.
C. Create a Power Apps visual that contains a drop-down list. The drop-down list will contain the business questions.
Correct Answer: B
Section:
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
QUESTION 46
You use an R visual to produce a map of 500,000 customers. You include the values of CustomerID, Latitude, and Longitude in the fields sent to the visual. Each customer ID is unique. In powerbi.com, when users load the
visual, they only see some of the customers.
What is the cause of the issue?

A. The visual was built by using a different version of R.
B. The data comes from a Microsoft SQL Server source.
C. The data is deduplicated.
D. Too many records were sent to the visual.
Correct Answer: D
Section:
Explanation:
R visuals in the Power BI service have a few limitations including:
Data size limitations – data used by the R visual for plotting is limited to 150,000 rows. If more than 150,000 rows are selected, only the top 150,000 rows are used and a message is displayed on the image. Additionally, the
input data has a limit of 250 MB.
Reference:
https://docs.microsoft.com/en-us/power-bi/visuals/service-r-visuals
QUESTION 47
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.
Correct Answer: A
Section:
Explanation:
Reference:
www.VCEplus.io
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-custom-tooltips
https://technovids.com/power-bi-filters/
QUESTION 48
You have a report that contains a bar chart and a column chart. The bar chart shows customer count by customer segment. The column chart shows sales by month. You need to ensure that when a segment is selected in the
bar chart, you see which portion of the total sales for the month belongs to the customer segment. How should the visual interactions be set on the column chart when the bar chart is selected?
A. no impact
B. highlight
C. filter
Correct Answer: B
Section:
Explanation:
HIGHLIGHT as the question required us to "you see which portion of the total sales for the month belongs to the customer segment" -- in order to see WHICH portion, you need to still see the whole visual, highlight is most
appropriate. If the requirement stated to ONLY SEE THE PORTION IT RELATES TO then filter would be appropriate.
QUESTION 49
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.
Correct Answer: C
Section:
QUESTION 50
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.)
www.VCEplus.io
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.
Correct Answer: A
Section:
Explanation:
Reference: http://www.nubo.eu/en/blog/2016/12/Enable-PowerBI-On-Office-365/
QUESTION 51
You embed a Power BI report in a Microsoft SharePoint Online page.
A user name User1 can access the SharePoint Online page, but the Power BI web part displays the following error message: “This content isn’t available”. User1 is unable to view the report.
You verify that you can access the SharePoint Online page and that the Power BI report displays as expected. You need to ensure that User1 can view the report form SharePoint Online.
What should you do?

A. Publish the app workspace.
B. Edit the settings of the Power BI web part.
C. Modify the members of the app workplace.
D. Share the dashboards in the app workspace.
Correct Answer: C
Section:
Explanation:
Reference: https://docs.microsoft.com/en-us/power-bi/service-embed-report-spo
QUESTION 52
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.
www.VCEplus.io
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.
Correct Answer: C
Section:
Explanation:
Reference: https://docs.microsoft.com/en-us/power-bi/service-q-and-a-direct-query#limitationsduring-public-preview
QUESTION 53
You plan to create a dashboard in the Power BI service that retrieves data from a Microsoft SQL Server database. The dashboard will be shared between the users in your organization. You need to ensure that the users will
see the current data when they view the dashboard.
How should you configure the connection to the data source?
A. Deploy an on-premises data gateway (personal mode). Import the data by using the Import Data Connectivity mode.
B. Deploy an on-premises data gateway. Import the data by using the Import Data Connectivity mode.
C. Deploy an on-premises data gateway. Import the data by using the DirectQuery Data Connectivity mode.

D. Deploy an on-premises data gateway (personal mode). Import the data by using the DirectQuery Data Connectivity mode.
Correct Answer: D
Section:
Explanation:
Reference: https://docs.microsoft.com/en-us/power-bi/desktop-directquery-about#power-biconnectivity-modes
QUESTION 54
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
Correct Answer: C
Section:
Explanation:
Reference:
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
QUESTION 55
www.VCEplus.io
You have a Power BI app named App1. The privacy for the App1 workspace is set to Private.
A user named User1 reports that App1 does not appear in the My organization AppSource. App1 appears in the My organization AppSource for your account. You need to ensure that User sees App1 from the My organization
AppSource.
What should you do?
A. From the app workspace, click Update app, configure the Content settings, and then click Update app.
B. From the app workspace settings, add a member.
C. From the app workspace, click Update app, configure the Access setting, and then click Update app.
D. From the app workspace, share the dashboard.
Correct Answer: C
Section:
Explanation:
Reference: https://docs.microsoft.com/en-us/power-bi/service-organizational-content-packintroduction#what-is-appsource
QUESTION 56
You plan to embed multiple visualization in a public website.
Your Power BI infrastructure contains the visualizations configured as shown in the following table.

Which two visualizations can you embed into the website? Each correct answer presents a complete the solution. NOTE: Each correct selection is worth one point.
A. Visual1
B. Visual2
C. Visual3
D. Visual4
E. Visual5
Correct Answer: B, D
Section:
Explanation:
Reference: https://docs.microsoft.com/en-us/power-bi/service-publish-to-web
www.VCEplus.io
QUESTION 57
You have a Power BI dashboard that displays different visualizations of company sales.
You enable Q&A on the dashboard.
You need to provide users with sample questions that they can ask when using Q&A.
Which settings should you modify from the Power BI Settings?
A. Subscriptions
B. Dashboards
C. Datasets
D. Workbooks
Correct Answer: C
Section:
Explanation:
Reference: https://docs.microsoft.com/en-us/power-bi/service-q-and-a-create-featured-questions
QUESTION 58
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.
Correct Answer: C
Section:
Explanation:
Reference: https://docs.microsoft.com/en-us/power-bi/service-manage-app-workspace-in-power-biand-office-365
QUESTION 59
You plan to use Power BI Desktop optimized for Power BI Report Server to create a report. The report will be published to Power BI Report Server. You need to ensure that all the visualization in the report can be consumed by
users.
Which two types of visualizations should you exclude from the report? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.
A. Funnel charts
B. Custom visuals
C. Bubble maps
D. Breadcrumbs
E. R visuals
Correct Answer: D, E
Section:
Explanation:
www.VCEplus.io
Reference: https://powerbi.microsoft.com/en-us/guided-learning/reportserver-quickstart-powerbireport/
QUESTION 60
Note: This question is part of a series of questions that use 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 the same in each question in this series.
You have a Microsoft SQL Server database that contains the following tables.

www.VCEplus.io
The following columns contain date information:

- Date[Month] in the mmyyyy format
- Date[Date_ID] in the ddmmyyyy format
- Date[Date_name] in the mm/dd/yyyy format
- Monthly_returns[Month_ID] in the mmyyyy format
The Order table contains more than one million rows.
The Store table has a relationship to the Monthly_returns table on the Store_ID column. This is the only relationship between the tables. You plan to use Power BI Desktop to create an analytics solution for the data.
You need to create a relationship between the Monthly_returns table and Date[Date_ID].
What should you do before you create the relationship?
A. In the Date table, create a new calculated column named MonthJD that uses the yyyydd format.
B. In the Monthly_returns table, create a new calculated column named DateJD that uses the ddmmyyyy format.
C. To the Order table, add a calculated column that uses the RELATED(Monthly_returns[Month_ID]) DAX formula.
D. To the Date table, add a calculated column that uses the RE LATE D(Monthly_ret urns [MonthJD]) DAX formula.
Correct Answer: B
Section:
Explanation:
Reference:
https://docs.microsoft.com/en-us/power-bi/desktop-create-and-manage-relationships
QUESTION 61
Note: This question is part of a series of questions that use 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 the same in each question in this series.
You have a Microsoft SQL Server database that contains the following tables.
www.VCEplus.io

www.VCEplus.io

The following columns contain date information:
- Date[Month] in the mmyyyy format
- Date[Date_ID] in the ddmmyyyy format
- Date[Date_name] in the mm/dd/yyyy format
- Monthly_returns[Month_ID] in the mmyyyy format
The Order table contains more than one million rows.
The Store table has a relationship to the Monthly_returns table on the Store_ID column. This is the only relationship between the tables. You plan to use Power BI Desktop to create an analytics solution for the data.
You need to create a relationship between the Order table and the Store table on the Store_ID column. What should you do before you create the relationship?
A. In the Order table query, use the Table.TrasformRows function.

B. In the Store table query, use the Table.TrasformRows function.
C. In the Store table query, use the Table.TrasformColumnTypes function.
D. In the Order table query, use the Table.TrasformColumnTypes function.
Correct Answer: C
Section:
QUESTION 62
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 Microsoft Excel workbook that is saved to Microsoft SharePoint
Online. The workbook contains several Power View sheets. You need to recreate the Power View sheets as reports in the Power Bl service.
Solution: Copy the workbook to Microsoft OneDrive for Business. From Excel, click Publish to Power Bl, and then click Upload Does this meet the goal?
A. Yes
B. No www.VCEplus.io
Correct Answer: B
Section:
QUESTION 63
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 Microsoft Excel workbook that is saved to Microsoft SharePoint
Online. The workbook contains several Power View sheets. You need to recreate the Power View sheets as reports in the Power Bl service.
Solution: From the Power Bl service, get the data from SharePoint Online, and then click Connect Does this meet the goal?
A. Yes
B. No
Correct Answer: B
Section:
Explanation:
We need to click "Import", not "Connect".
Reference:
https://docs.microsoft.com/en-us/power-bi/service-excel-workbook-files
QUESTION 64

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.
A. Yes
B. No
Correct Answer: B
Section:
QUESTION 65
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.)
www.VCEplus.io
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.
Correct Answer: B
Section:
Explanation:
Reference:
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-map-tips-and-tricks
QUESTION 66
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]
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.
A. Yes
B. No
Correct Answer: A
Section:
www.VCEplus.io
Explanation:
Reference:
https://docs.microsoft.com/en-us/dax/count-function-dax
https://docs.microsoft.com/en-us/dax/userelationship-function-dax
QUESTION 67
HOTSPOT
You are creating a column chart visualization.
You configure groups as shown in the Groups exhibit. {Click the Groups tab.)

The visualization appears as shown in the Chart exhibit. (Click the Chart tab.)
www.VCEplus.io
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
Hot Area:

Answer Area:
Section:
Explanation:
QUESTION 68
HOTSPOT
You need to create a visual as shown in the following exhibit. www.VCEplus.io
The indicator color for Total Sales will be based on % Growth to Last Year.
The solution must use the existing calculations only.
How should you configure the visual? To answer, select the appropriate options in the answer area.
Hot Area:

Answer Area:
Section:
Explanation:
Box 1: Background color www.VCEplus.io
To format the Color column based on its field values, select Conditional formatting for the Color field, and then select Background color or Font color. In the Background color or Font color dialog box, select Field value from
the Format by drop-down field. Box 2: Field value
With conditional formatting for tables in Power BI Desktop, you can specify customized cell colors, including color gradients, based on field values.
Reference:
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-table-formatting
QUESTION 69
HOTSPOT
You are creating a quick measure as shown in the following exhibit.

You need to create a monthly rolling average measure for Sales over time-How should you configure the quick measure calculation? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
Hot Area:
www.VCEplus.io
Answer Area:

Section:
Explanation:
Box 1: Total Sales
We select the field Total Sales
Box 2: Date
Select a date field.
Box 3: Month
Monthly periods.
Reference:
www.VCEplus.io
https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-quick-measures
QUESTION 70
HOTSPOT
You are creating an analytics report that will consume data from the tables shown in the following table.
There is a relationship between the tables.

There are no reporting requirements on employeejd and employee_photo.
You need to optimize the data model
What should you configure for employeejd and employee.photo? To answer, select the appropriate options in the answer area.
Hot Area:

Answer Area:
Section:
Explanation:
Box 1: Hide
Optimize data by hiding fields and sorting visualization data
Box 2: Delete
www.VCEplus.io
The fastest way to optimize your Power BI report is to limit the number of columns to only the ones you need in your data model. Go through your tables in Power Query and determine what fields are being used. Delete
these columns if they are not being used in any of your reports or calculations.
Reference:
https://tessellationtech.io/optimizing-power-bi-reports/
QUESTION 71
HOTSPOT
You are creating a Microsoft Power Bl model that has two tables named CityData and Sales. CityData contains only the data shown in the following table.
Sales contains only the data shown in the following table.

Hot Area:
Answer Area:
www.VCEplus.io
Section:
Explanation:
Box 1: Yes
The Related function returns a related value from another table.
The RELATED function requires that a relationship exists between the current table and the table with related information. You specify the column that contains the data that you want, and the function follows an existing
many-to-one relationship to fetch the value from the specified column in the related table. If a relationship does not exist, you must create a relationship. Box 2: Yes
Box 3: No
TX only occurs in the Sales table, but not in the CityData table.
Reference:
https://docs.microsoft.com/en-us/dax/related-function-dax
QUESTION 72
DRAG DROP
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.
Select and Place:
www.VCEplus.io
Correct Answer:

Section:
Explanation: www.VCEplus.io
Reference: https://docs.microsoft.com/en-us/power-bi/refresh-scheduled-refresh
QUESTION 73
HOTSPOT
Your company plans to use Power BI for 20 users in the sales department. The users will perform the following tasks:
Access a published Power BI app
Modify reports in an app workspace
Share dashboards created in My Workspace
You need to identify which Power BI licenses are required for the tasks. The solution must use the Power BI (free) licenses, whenever possible. Which license should you identify for each task? To answer, select the appropriate
options in the answer area. NOTE: Each correct selection is worth one point.
Hot Area:

Answer Area:
www.VCEplus.io

Section:
Explanation:
www.VCEplus.io
https://docs.microsoft.com/en-us/power-bi/service-create-distribute-apps
https://docs.microsoft.com/en-us/power-bi/service-collaborate-power-bi-workspace
QUESTION 74
HOTSPOT
You open powerbi.com as shown in the following exhibit.

Hot Area:
Answer Area:
www.VCEplus.io
Section:
Explanation:
Reference: https://docs.microsoft.com/en-us/power-bi/service-data-classification
QUESTION 75
HOTSPOT
You have a Power BI model that has the following tables:
Product (Product_id, Product_Name)
Sales (Order_id, Order_Date, Product_id, Salesperson_id, Sales_Amount) Salesperson (Salesperson_id, Salesperson_name, address) You plan to create the following measure. Measure1 = DISTINCTCOUNT(Sales[ProductID])
You need to create the following relationships:
Sales to Product
Sales to Salesperson
The solution must ensure that you can use Measure1 to display the count of products sold by each salesperson. How should you configure the relationships? To answer, select the appropriate options in the answer area.
Hot Area:

Answer Area:
Section:
Explanation:
www.VCEplus.io
QUESTION 76
DRAG DROP
You have a Power BI 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
Select and Place:

Correct Answer:
Section:
Explanation:
QUESTION 77
DRAG DROP
Exhibit:
You need to create a report that meets the requirements:

• Visualizes the Sales value over a period of years and months
• Adds a Slicer for the month
www.VCEplus.io
• Adds a Slicer for the year
Which three actions Should you perform in sequence?
Select and Place:
Correct Answer:

Section:
Explanation:
QUESTION 78
HOTSPOT
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.
Hot Area:
Answer Area:
www.VCEplus.io
Section:
Explanation:
QUESTION 79
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.
Correct Answer: C

Section:
QUESTION 80
DRAG DROP
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.
Select and Place:
www.VCEplus.io
Correct Answer:

Section:
Explanation:
QUESTION 81
HOTSPOT www.VCEplus.io
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.
Hot Area:
Answer Area:
www.VCEplus.io
Section:
Explanation:
Reference:
https://finance-bi.com/power-bi-basket-analysis/
QUESTION 82
DRAG DROP
You have a Microsoft Power Bl workspace.
You need to grant the user capabilities shown in the following table.
The solution must use the principle of least privilege.

Which user role should you assign to each user? To answer, drag the appropriate roles to the correct users. Each role may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.

Select and Place:
Correct Answer:
Section:
Explanation:
User 1 = Member
User 2 = Contributor
https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-new-workspaces
QUESTION 83
HOTSPOT
You have a report in Power BI Desktop as shown in the following exhibit.
www.VCEplus.io
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.
Hot Area:

Answer Area:
www.VCEplus.io
Section:
Explanation:
QUESTION 84
DRAG DROP
You have a Power BI model that contains a table named Sales. Sales has the following three measures:
A measure named Total Sales Last Year that displays the sales from the previous calendar year. The current value is 32.89 million. A measure named Total Sales This Year that displays the sales from the current calendar year.
The current value is 11.69 million. A measure named Total Sales Difference that uses a DAX formula of Sales[Last Year] – Sales[This Year]. You need to create the following visualization.
How should you configure the visualization? To answer, drag the appropriate measures to the correct fields. Each value may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
Select and Place:

Correct Answer:
Section:
Explanation:
www.VCEplus.io
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-radial-gauge-charts
QUESTION 85
HOTSPOT
You are creating reports in Power BI Desktop. The model has the following tables.
There is a relationship between the tables.

You plan to publish a report to the Power BI service that displays Order_amount by Order_date by Full_name. You need to ensure that only the columns required for the report appear in Report View. The solution must minimize the size of the
dataset that is published. How should you configure the columns in Power BI Desktop? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
Hot Area:

Answer Area:
www.VCEplus.io
Section:
Explanation:
QUESTION 86
HOTSPOT
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.

Hot Area:
Answer Area:
www.VCEplus.io
Section:
Explanation:
https://docs.microsoft.com/en-us/powerquery-m/text-replace
https://docs.microsoft.com/en-us/powerquery-m/text-end
QUESTION 87
You maintain a Power Bl workspace that contains a supplier quality dashboard. The dashboard contains 10 card visuals, two map visuals and five bar chart visuals. The dashboard mobile layout is shown in the exhibit. (Click
the Exhibit tab.)
You need to modify the dashboard mobile layout to meet the following requirements:
• Only show single-value visuals.
• Minimize scrolling.
What should you do?
A. Remove the card visual, increase the size of the map and bar chart visuals
B. Decrease the size of the map and bar chart visuals Move all the card visuals to the top of the layout.
C. Move the bar chart visuals to the top of the layout Remove the map visuals. Decrease the size of the card visuals.
D. Decrease the size of the card visuals. Remove the map and bar chart visuals.
Correct Answer: D
Section:

QUESTION 88
You have a Power Bl report
You have a table named Dalai that contains 10 million rows. Data is used in the following visuals:
• A card that shows the number of records
• A bar chart that snows total transaction amount by territory
• A scatter plot that shows transaction amount and profit amount on the axes and points colored by territory You need to modify the scatter plot to make it easier for users to identify meaningful patterns. The solution must
not affect the accuracy of the other visuals-What should you do?
A. Apply a row filter to the Dalai query in Power Query Editor.

B. Add a trend line to the scatter plot
C. Enable high-density sampling on the scatter plot
D. Add a count field of the transaction amount to the size bucket of the scatter plot
Correct Answer: B
Section:
QUESTION 89
You are creating a line chart in a Power Bl report 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.
www.VCEplus.io
A.
Correct Answer: A
Section:
Explanation:
Answer: A
Explanation:
Answer as selected

QUESTION 90
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
Correct Answer: B
Section:
Explanation:
QUESTION 91
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
Correct Answer: D
Section:
www.VCEplus.io
QUESTION 92
You have a Power Bl visual that uses indicators to show values that are out of range as shown in the following exhibit.
A.

Correct Answer: A
Section:
Explanation:
Answer: A
Explanation:
Answer as selected
QUESTION 93
You have a Power BI report that contains three pages named Page1, Page2, and Page3. All the pages have the same slicers. You need to ensure that all the filters applied to Page1 apply to Page1 and Page3 only. What should
you do?
A. Sync the slicers on Page1 and Page3

B. On each page, modify the interactions of the slicer.
C. Enable visibility of the slicers on Page1 and Page3. Disable visibility of the slicer on Page2.
Correct Answer: A
Section:
QUESTION 94
www.VCEplus.io
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.
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.
Correct Answer: C, E
Section:
QUESTION 95
You have a report that contains a donut chart and a clustered column chart. Interactions between the visuals use the default settings. You need to modify the report so that when you select a column m the column chart, the
donut chart redraws by using the data from the selected column. What should you do?
A. Select the column chart and set the donut chart interaction to None.
B. Select the column chart and set the donut chart interaction to Filter

C. Select the donut chart and set the column chart interaction to Filter
D. Select the donut chart and set the column chart interaction to Nona.
Correct Answer: B
Section:
QUESTION 96
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.
Correct Answer: D
Section:
QUESTION 97
You import a Power Bl dataset that contains the following tables:
• Date
• Product
• Product Inventory
www.VCEplus.io
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.
Correct Answer: D
Section:
QUESTION 98
You have more than 100 published datasets.
Ten of the datasets were verified to meet your corporate quality standards.
You need to ensure that the 10 verified datasets appear at the top of the list of published datasets whenever users search for existing datasets. What should you do?
A. Publish the datasets in an app.

B. Promote the datasets.
C. Feature the dataset on the home page.

D. Certify the datasets.
Correct Answer: D
Section:
QUESTION 99
You need to create a Power BI theme that will be used in multiple reports. The theme will include corporate branding for font size, color, and bar chart formatting. What should you do?
A. From Power Bl Desktop, customize the current theme,

B. From power Bl Desktop, use a built in report theme.
C. Create a theme as a JSON file and import the theme into Power Bl Desktop.
D. Create a theme as a PBIVlZ file and import the theme into Power Bl Desktop.
Correct Answer: B
Section:
QUESTION 100
DRAG DROP
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.
www.VCEplus.io
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.
Select and Place:

Correct Answer:
Section:
Explanation:
QUESTION 101
HOTSPOT
www.VCEplus.io
You are using Power Bi Desktop to connect to an Azure SQL database The connection is configured 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 solution is worth one point
Hot Area:
www.VCEplus.io
Answer Area:
Section:
Explanation:
https://docs.microsoft.com/en-us/power-query/connectors/azuresqldatabaseThe following table lists all of the advanced options you can set in Power Query Desktop and PowerQuery Online. Advanced option
Description
Command timeout in minutes
If your connection lasts longer than 10 minutes (the default timeout), you can enter another the connection open longer. This option is only available in Power Query Desktop. SQL statement
For information, go to Import data from a database using native database query.
Include relationship columns

If checked, includes columns that might have relationships to other tables. If this box is cleared, columns. Navigate using full hierarchy
If checked, the navigator displays the complete hierarchy of tables in the database you're connecting navigator displays only the tables whose columns and rows contain data. Enable SQL Server Failover support
If checked, when a node in the Azure SQL failover group isn't available, Power Query moves when failover occurs. If cleared, no failover occurs.
QUESTION 102
HOTSPOT
You have a report page that contains the visuals shown in the following exhibit.
www.VCEplus.io
Hot Area:
Answer Area:

Section:
Explanation:
Box 1: cross-filter
By default, selecting a data point in one visual on a report page will cross-filter or cross-highlight the other visuals on the page.
Box 2: cross-highlight
Example:
By default, selecting a data point in one visual on a report page will cross-filter or cross-highlight the other visuals on the page.
www.VCEplus.io
1. Let's see what happens when we select Moderation.

2. Cross-filtering removes data that doesn't apply. Selecting Moderation in the doughnut chart crossfilters the line chart. The line chart now only displays data points for the Moderation segment.
3. Cross-highlighting retains all the original data points but dims the portion that does not apply to your selection. Selecting Moderation in the doughnut chart cross-highlights the column chart. The column chart dims all the data that applies to
the Convenience segment and highlights all the data that applies to the Moderation segment.
Reference:
https://docs.microsoft.com/en-us/power-bi/consumer/end-user-interactions
QUESTION 103
HOTSPOT
You have two Azure SQL databases that contain the same tables and columns.
www.VCEplus.io
For each database, you create a query that retrieves data from a table named Customers.
You need to combine the Customer tables into a single table. The solution must minimize the size of the data model and support scheduled refresh in powerbi.com. What should you do? To answer, select the appropriate
options in the answer area.
Hot Area:
Answer Area:

Section:
Explanation:
Box 1: Append Queries as New.
There are two primary ways of combining queries: merging and appending.
When you have one or more columns that you’d like to add to another query, you merge the queries.
When you have additional rows of data that you’d like to add to an existing query, you append the query. Box 2: Disable loading the query to the data model
For every query that loads into model memory will be consumed. and Memory is our asset in the Model, less memory consumption leads to better performance in most of the cases. The best approach is to disable loading.
Reference:
https://docs.microsoft.com/en-us/power-query/append-queries
QUESTION 104
HOTSPOT
You have a folder of monthly transaction extracts.
You plan to create a report to analyze the transaction data.
www.VCEplus.io
You receive the following email message: "Hi. I've put 24 files of monthly transaction data onto the shared drive. File Transactions201901.csv through Transactions201912.csv have the latest set of columns, but files
Transactions201801.csv to Transactions201812.csv have an older layout without the extra fields needed for analysis. Each file contains 10 to 50 transactions." You get data from the folder and select Combine & Load. The
Combine Files dialog box is shown in the exhibit. (Click the Exhibit tab.)

Hot Area:
Answer Area:
Section:
Explanation:
Box 1: Yes
The four columns used in the 2018 transactions are already displayed.
Box 2: Yes
www.VCEplus.io
The columns used are based on the entire dataset. The additional columns in the 2019 files will be detected. Box 3: Yes
Note: Under the hoods, Power BI will automatically detect which delimiter to use, and may even promote the first row as headers. You can manually change the delimiter, or define how Power BI should handle data types.
You can set it to automatically detect data types based on first 200 rows, or the entire dataset or you can even opt out the detection of data types.
QUESTION 105
DRAG DROP
You receive revenue data that must be included in Microsoft Power Bl reports.
You perform an initial load of the data from a Microsoft Excel source as shown in the following exhibit.
You plan to create several visuals from the data, including a visual that shows revenue split by year and product. You need to transform the data to ensure that you can build the visuals. The solution must ensure that the columns are named
appropriately for the data that they contain. Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
Select and Place:

Correct Answer:
www.VCEplus.io
Section:
Explanation:
Step 1: Select Use Header as First Row.
Step 2: Select Department and Product and Unpivot Other Columns
Unpivot Other Columns: This command unpivots unselected columns. Use this command in a query when not all columns are known. New columns added during a refresh operation are also unpivoted. Step 3: Rename the
Attribute column to Year and the Value column to Revenue.
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.

When you unpivot, you unpack the attribute-value pairs that represent an intersection point of the new columns and re-orient them into flattened columns:
Values (in blue on the left) are unpivoted into a new column (in blue on the right).
Attributes (in green on the left) are unpivoted into a new column (in green on the right) and duplicates are correspondingly mapped to the new Values column.
Reference:
https://support.microsoft.com/en-us/office/unpivot-columns-power-query-0f7bad4b-9ea1-49c1-9d95-f588221c7098
QUESTION 106
HOTSPOT
You view a query named Transactions as shown in the following exhibit.
www.VCEplus.io
The query gets CSV files from a folder.

Hot Area:

Answer Area:
www.VCEplus.io
Section:
Explanation:
Box 1: 9
9 distinct CSV files.
Box 2: 10
10 distinct dates.
https://pediaa.com/what-is-the-difference-between-unique-and-distinct-insql/#:~:text=Unique%20and%20Distinct%20are%20two%20SQL%20constraints.,the%20records%20from%20a%20table.
QUESTION 107
HOTSPOT
You are profiling data by using Power Query Editor.
The AddressLine2 column in a table named Address is shown in the following exhibit.
Hot Area:

Answer Area:
www.VCEplus.io
Section:
Explanation:
QUESTION 108
DRAG DROP
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).
www.VCEplus.io
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.

Select and Place:
www.VCEplus.io
Correct Answer:

www.VCEplus.io
Section:
Explanation:
Reference:
https://msdn.microsoft.com/en-us/library/mt260776.aspx
https://msdn.microsoft.com/en-us/library/mt260808.aspx
QUESTION 109
You have a Power BI report named Report' and a dashboard named Dashboard'. 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 the bar chart displays on Dashboard',
What should you do?
A. Refresh the dataset used by Report1 and Dashboard1.

B. Select Refresh visuals for Dashboard1.
C. Edit the details for the dashboard tile Of Dashboar1.

D. Pin the Sales by month bar chart to Dashboard1.
Correct Answer: A
Section:
QUESTION 110
You have a Power B1 report. The report contains a line chart that displays sales data for several regions.
You need to add an element to the report that will enable users to filter the sales data to include only a selected region.
Which two elements achieve the goal? Each correct answer presents a complete solution.
A. a slicer visual
B. a drillthrough filter
C. a table visual
D. a card visual
E. a Key Performance Indicator (KPI) visual
Correct Answer: A, D
Section:
QUESTION 111
DRAG DROP
You plan to use Power BI to create a quarterly profit report that meets the following requirements:
* Compares profit margins across sales regions

www.VCEplus.io
* Emphasizes the percentage of total profits contributed by each product category in dollars and as a percentage
Which type of visual should you use for each requirement? To answer, drag the appropriate visuals to the correct requirements. Each visual 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.
Select and Place:
Correct Answer:

Section:
Explanation:
QUESTION 112
HOTSPOT
You have a Power B1 report that contains the table visual shown in the following exhibit.
www.VCEplus.io
You need to modify the visual to display as shown in the following exhibit.
How should you configure the visual? To answer, select the appropriate options in the answer area.
Hot Area:

Answer Area:
Section:
Explanation:
www.VCEplus.io

Microsoft - PL 300.VJan 2024.by .HuynDair.127q

Uploaded by

Copyright:

Available Formats

Microsoft - PL 300.VJan 2024.by .HuynDair.127q

Uploaded by

Document Information

Original Description:

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Microsoft - PL 300.VJan 2024.by .HuynDair.127q

Uploaded by

Copyright:

Available Formats

Microsoft.PL-300.vJan-2024.by.HuynDair.

Exam Code: PL-300

IT Certification Exams - Questions & Answers | VCEplus.io

IT Certification Exams - Questions & Answers | VCEplus.io

IT Certification Exams - Questions & Answers | VCEplus.io

Select and Place:

IT Certification Exams - Questions & Answers | VCEplus.io

A. From each report in powerbi.com. select Refresh visuals

IT Certification Exams - Questions & Answers | VCEplus.io

A. Create a shared dataset for each standardized entity.

A. two imported datasets

IT Certification Exams - Questions & Answers | VCEplus.io

IT Certification Exams - Questions & Answers | VCEplus.io

All the fields in Source2 are mandatory.

IT Certification Exams - Questions & Answers | VCEplus.io

The Categories table contains the following columns.

IT Certification Exams - Questions & Answers | VCEplus.io

The Sales Employees table contains the following columns.

IT Certification Exams - Questions & Answers | VCEplus.io

IT Certification Exams - Questions & Answers | VCEplus.io

IT Certification Exams - Questions & Answers | VCEplus.io

IT Certification Exams - Questions & Answers | VCEplus.io

IT Certification Exams - Questions & Answers | VCEplus.io

IT Certification Exams - Questions & Answers | VCEplus.io

What should you do?

A. Edit the details of each tile.

IT Certification Exams - Questions & Answers | VCEplus.io

A. Add a Top N filter to the visual.

IT Certification Exams - Questions & Answers | VCEplus.io

Select and Place:

IT Certification Exams - Questions & Answers | VCEplus.io

View2 contains the columns shown in the following table.

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

IT Certification Exams - Questions & Answers | VCEplus.io

There are four departments in the Departments table.

IT Certification Exams - Questions & Answers | VCEplus.io

A. Configure the dataset to use the existing On-premises data gateway.

IT Certification Exams - Questions & Answers | VCEplus.io

A. Query folding is not occurring.

IT Certification Exams - Questions & Answers | VCEplus.io

You plan to use Power BI to import data from 2013 to 2015.

IT Certification Exams - Questions & Answers | VCEplus.io

A. Product Ranking= RANKX (Product, [SalesAmount], , DESC, Skip)

IT Certification Exams - Questions & Answers | VCEplus.io

IT Certification Exams - Questions & Answers | VCEplus.io

IT Certification Exams - Questions & Answers | VCEplus.io

A. Create a new aggregation that summarizes by employee.

IT Certification Exams - Questions & Answers | VCEplus.io

IT Certification Exams - Questions & Answers | VCEplus.io

IT Certification Exams - Questions & Answers | VCEplus.io

Sheet2 contains the following table named Table2.

IT Certification Exams - Questions & Answers | VCEplus.io

Select and Place:

IT Certification Exams - Questions & Answers | VCEplus.io

IT Certification Exams - Questions & Answers | VCEplus.io

IT Certification Exams - Questions & Answers | VCEplus.io

Select and Place:

IT Certification Exams - Questions & Answers | VCEplus.io