PL-300 Mock Test Free – 50 Realistic Questions to Prepare with Confidence.
Getting ready for your PL-300 certification exam? Start your preparation the smart way with our PL-300 Mock Test Free – a carefully crafted set of 50 realistic, exam-style questions to help you practice effectively and boost your confidence.
Using a mock test free for PL-300 exam is one of the best ways to:
Familiarize yourself with the actual exam format and question style
Identify areas where you need more review
Strengthen your time management and test-taking strategy
Below, you will find 50 free questions from our PL-300 Mock Test Free resource. These questions are structured to reflect the real exam’s difficulty and content areas, helping you assess your readiness accurately.
You are using the key influencers visual to identify which factors affect the quantity of items sold in an order.
You add the following fields to the Explain By field:
✑ Customer Country
✑ Product Category
✑ Supplier Country
✑ Sales Employee
✑ Supplier Name
✑ Product Name
✑ Customer City
The key influencers visual returns the results shown in the following exhibit.
What can you identify from the visual?
A. Customers in Austria order 18.8 more units than the average order quantity.
B. Customers in Boise order 20.37 percent more than the average order quantity.
C. Product Category positively influences the quantity per order.
D. Customers in Cork order lower quantities than average.
You have a Power BI workspace that contains a dataset, a report, and a dashboard. The following groups have access:
✑ External users can access the dashboard.
✑ Managers can access the dashboard and a manager-specific report.
✑ Employees can access the dashboard and a row-level security (RLS) constrained report.
You need all users, including the external users, to be able to tag workspace administrators if they identify an issue with the dashboard. The solution must ensure that other users see the issues that were raised.
What should you use?
A. comments
B. chat in Microsoft Teams
C. alerts
D. subscriptions
Suggested Answer: A
Add a personal comment or start a conversation about a dashboard or report with your colleagues. The comment feature is just one of the ways a business user can collaborate with others.
Note: Comments can be added to an entire dashboard, to individual visuals on a dashboard, to a report page, to a paginated report, and to individual visuals on a report page. Add a general comment or add a comment targeted at specific colleagues.
Reference: https://docs.microsoft.com/en-us/power-bi/consumer/end-user-comment
HOTSPOT -
You have a Power BI tenant that hosts the datasets shown in the following table.
You have the following requirements:
The export of reports that contain Personally Identifiable Information (PII) must be prevented.
Data used for financial decisions must be reviewed and approved before use.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Hot Area:
You have the Power BI data model shown in the following exhibit.
The Sales table contains records of sales by day from the last five years up until today’s date.
You plan to create a measure to return the total sales of March 2021 when March 2022 is selected.
Which DAX expression should you use?
A. Calculate (Sum(Sales[Sales]), PREVIOUSYEAR( dimDate[Date])
B. TOTALYTD (SUM(Sales[Sales]), dimDate[Date] )
C. Calculate (SUM(Sales[Sales]), SAMEPERIODLASTYEAR(dimDate[Date] ))
HOTSPOT -
You have a Power BI 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.
The data view for the Orders table is shown in the following exhibit.
The Orders table relates to the Customers table by using the CustomerID column.
The Orders table relates to the Date table by using the OrderDate column.
For each of the following statements, select Yes if the statement is true, Otherwise, select No.
NOTE: Each correct selection is worth one point.
Hot Area:
Suggested Answer:
Box 1: No –
Would not support total sales over time.
Box 2: No –
Would not support new and repeat customer counts
Box 3: Yes
HOTSPOT -
You plan to create the Power BI 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:
✑ Minimize the load times of visuals.
✑ Ensure that the data is loaded to the model based on the refresh requirements.
Which storage mode should you select for each table? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:
Suggested Answer:
Box 1: Dual –
Customer should use the dual storage mode.
Dual: Tables with this setting can act as either cached or not cached, depending on the context of the query that’s submitted to the Power BI dataset. In some cases, you fulfill queries from cached data. In other cases, you fulfill queries by executing an on-demand query to the data source.
Note: You set the Storage mode property to one of these three values: Import, DirectQuery, and Dual.
Box 2: Dual –
You can set the dimension tables (Customer, Geography, and Date) to Dual to reduce the number of limited relationships in the dataset, and improve performance.
Box 3: DirectQuery –
Sales should use the DirectQuery storage mode.
DirectQuery: Tables with this setting aren’t cached. Queries that you submit to the Power BI datasetג€”for example, DAX queriesג€”and that return data from
DirectQuery tables can be fulfilled only by executing on-demand queries to the data source. Queries that you submit to the data source use the query language for that data source, for example, SQL.
Box 4: Import –
Import: Imported tables with this setting are cached. Queries submitted to the Power BI dataset that return data from Import tables can be fulfilled only from cached data.
Reference: https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-storage-mode
You have a Power BI tenant.
You have reports that use financial datasets and are exported as PDF files.
You need to ensure that the reports are encrypted.
What should you implement?
A. Microsoft Intune policies
B. row-level security (RLS)
C. sensitivity labels
D. dataset certifications
Suggested Answer: C
When you create a sensitivity label, you can restrict access to content that the label will be applied to.
When a document or email is encrypted, access to the content is restricted, so that it:
Can be decrypted only by users authorized by the label’s encryption settings.
Remains encrypted no matter where it resides, inside or outside your organization, even if the file’s renamed.
Incorrect:
Not B: Row-level security (RLS) with Power BI can be used to restrict data access for given users. Filters restrict data access at the row level, and you can define filters within roles.
Current limitations for row-level security:
Reference: https://docs.microsoft.com/en-us/microsoft-365/compliance/encryption-sensitivity-labels
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. On each page, modify the interactions of the slicer.
B. Enable visibility of the slicers on Page1 and Page3. Disable visibility of the slicer on Page2.
C. Sync the slicers on Page1 and Page3.
Suggested Answer: A
Control which page visuals are affected by slicers
By default, slicers on report pages affect all the other visualizations on that page, including each other. As you choose values in the list and date slicers that you just created, notice the effects on the other visualizations. The filtered data is an intersection of the values selected in both slicers.
Use visual interactions to exclude some page visualizations from being affected by others. On the Overview page, the Total Sales Variance by FiscalMonth and
District Manager chart shows overall comparative data for district managers by month, which is information that you want to keep visible. Use visual interactions to keep slicer selections from filtering this chart.
1. Go to the Overview page of the report, and then select the DM slicer you previously created.
2. On the Power BI Desktop menu, select the Format menu under Visual Tools, and then select Edit interactions.
3. Filter controls, each with a Filter and a None option, appear above all the visuals on the page. Initially, the Filter option is preselected on all the controls.
4. Select the None option in the filter control above the Total Sales Variance by FiscalMonth and District Manager chart to stop the DM slicer from filtering it.
Reference: https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-slicers
You are building a Power BI report to analyze customer segments.
You need to identify customer segments dynamically based on the Bounce Rate across dimensions such as source, geography, and demographics. The solution must minimize analysis effort.
Which type of visualization should you use?
A. decomposition tree
B. funnel chart
C. Q&A
D. key influencers
Suggested Answer: A
The decomposition tree visual in Power BI lets you visualize data across multiple dimensions. It automatically aggregates data and enables drilling down into your dimensions in any order. It is also an artificial intelligence (AI) visualization, so you can ask it to find the next dimension to drill down into based on certain criteria.
This makes it a valuable tool for ad hoc exploration and conducting root cause analysis.
Reference: https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-decomposition-tree
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:
Suggested Answer:
Box 1: Using a workspace membership
Note 1: The company wants to provide the board with a single package of reports that will contain custom navigation and links to supplementary information.
Sharing is the easiest way to give people access to your reports and dashboards in the Power BI service. You can share with people inside or outside your organization.ֲ¨
Where you can share:
You can share reports and dashboards from My Workspace.
You can share from workspaces other than My Workspace, if you have the Admin or Member role in the workspace. If you have the Contributor or Viewer role, you can share if you have Reshare permissions.
You can share from the Power BI mobile apps.
You can’t share directly from Power BI Desktop.
Box 2: A mail-enabled security group in Azure Active Directory
Mail-Enabled Security Group –
This group also contains a list of email addresses of members and can also be used to control access to OneDrive and SharePoint.
The Mail-Enabled Security Group can be created in the Office 365 Admin Portal
Note: The reports must be made available to the board from powerbi.com. An Azure Active Directory (Azure AD) group will be used to share information with the board.
Incorrect:
* Distribution Group
This group can also be called and Distribution List. The Distribution Group is a group which contains a list of email addresses of members, all of whom will be sent an email when an email is sent to the distribution groups email address.
The Distribution Group can be created in the Azure Active Directory
Reference: https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-share-dashboards https://www.fourmoo.com/2020/04/01/power-bi-which-groups-can-be-used-to-set-permissions-in-power-bi/
DRAG DROP -
In Power Query Editor, you have three queries named ProductCategory, ProductSubCategory, and Product.
Every Product has a ProductSubCategory.
Not every ProductsubCategory has a parent ProductCategory.
You need to merge the three queries into a single query. The solution must ensure the best performance in Power Query.
How should you merge the tables? To answer, drag the appropriate merge types to the correct queries. Each merge type may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Select and Place:
Suggested Answer:
Box 1: Inner –
Every Product has a ProductSubCategory.
A standard join is needed.
One of the join kinds available in the Merge dialog box in Power Query is an inner join, which brings in only matching rows from both the left and right tables.
Box 2: Left outer –
Not every ProductsubCategory has a parent ProductCategory.
One of the join kinds available in the Merge dialog box in Power Query is a left outer join, which keeps all the rows from the left table and brings in any matching rows from the right table.
Reference: https://docs.microsoft.com/en-us/power-query/merge-queries-inner https://docs.microsoft.com/en-us/power-query/merge-queries-left-outer
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You are modeling data by using Microsoft Power BI. Part of the data model is a large Microsoft SQL Server table named Order that has more than 100 million records.
During the development process, you need to import a sample of the data from the Order table.
Solution: You write a DAX expression that uses the FILTER function.
Does this meet the goal?
A. Yes
B. No
Suggested Answer: B
Instead: You add a WHERE clause to the SQL statement.
Note: DAX is not a language designed to fetch the data like SQL rather than used for data analysis purposes. It is always a better and recommended approach to transform the data as close to the data source itself. For example, your data source is a relational database; then, it’s better to go with T-SQL.
SQL is a structured query language, whereas DAX is a formula language used for data analysis purposes. When our data is stored in some structured database systems like SQL server management studio, MySQL, or others, we have to use SQL to fetch the stored data.
Reference: https://www.learndax.com/dax-vs-sql-when-to-use-dax-over-sql/
In Power BI Desktop, you are building a sales report that contains two tables. Both tables have row-level security (RLS) configured.
You need to create a relationship between the tables. The solution must ensure that bidirectional cross-filtering honors the RLS settings.
What should you do?
A. Create an inactive relationship between the tables and select Apply security filter in both directions.
B. Create an active relationship between the tables and select Apply security filter in both directions.
C. Create an inactive relationship between the tables and select Assume referential integrity.
D. Create an active relationship between the tables and select Assume referential integrity.
Suggested Answer: B
By default, row-level security filtering uses single-directional filters, whether the relationships are set to single direction or bi-directional. You can manually enable bi-directional cross-filtering with row-level security by selecting the relationship and checking the Apply security filter in both directions checkbox. Select this option when you’ve also implemented dynamic row-level security at the server level, where row-level security is based on username or login ID.
Reference: https://docs.microsoft.com/en-us/power-bi/enterprise/service-admin-rls
HOTSPOT -
You are building a financial report by using Power BI.
You have a table named financials that contains a column named Date and a column named Sales.
You need to create a measure that calculates the relative change in sales as compared to the previous quarter.
How should you complete the measure? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:
Suggested Answer:
Box 1: CALCULATE –
Calculate the sum.
Box 2: DATEADD –
DATEADD -1 QUARTER will give the previous month.
Box 3: DIVIDE –
Use DIVIDE to get the relative change.
You have a Power BI dashboard that monitors the quality of manufacturing processes. The dashboard contains the following elements:
✑ A line chart that shows the number of defective products manufactured by day
✑ A KPI visual that shows the current daily percentage of defective products manufactured
You need to be notified when the daily percentage of defective products manufactured exceeds 3%.
What should you create?
A. a subscription
B. an alert
C. a smart narrative visual
D. a Q&A visual
Suggested Answer: B
Set alerts in the Power BI service to notify you when data on a dashboard changes above or below limits you set. Alerts can be set on tiles pinned from report visuals or from Power BI Q&A, and only on gauges, KPIs, and cards.
Reference: https://docs.microsoft.com/en-us/power-bi/consumer/end-user-alerts
HOTSPOT -
You need to create a visual as shown in the following exhibit.
The indicator color for Total Sales will be based on % Growth to Last Year.
The solution must use the existing calculations only.
How should you configure the visual? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:
Suggested Answer:
Box 1: Background color –
To apply conditional formatting, select a Table or Matrix visualization in Power BI Desktop. In the Visualizations pane, right-click or select the down-arrow next to the field in the Values well that you want to format. Select Conditional formatting, and then select the type of formatting to apply.
Box 2: Rules –
To format cell background or font color by rules, in the Format by field of the Background color or Font color dialog box, select Rules.
Reference: https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-table-formatting
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 clustered bar chart that contains a measure named Salary as the value and a field named Employee as the axis. Salary is present in the data as a numerical amount representing US dollars.
You need to create a reference line to show which employees are above the median salary.
Solution: You create an average line by using the Salary measure.
Does this meet the goal?
A. Yes
B. No
Suggested Answer: B
Average is not Median.
Instead: You create a percentile line by using the Salary measure and set the percentile to 50%.
The median is the middle value or the 50th percentile of a data set.
Reference: https://dash-intel.com/powerbi/statistical_functions_median.php
Overview -
Litware, Inc. is an online retailer that uses Power BI.
Litware plans to leverage data from an Azure SQL database that stores data for the company's live e-commerce website.
Litware uses Azure Active Directory (Azure AD) to authenticate users.
Existing Environment. Sales Data
Litware has online sales data that has the SQL schema shown in the following table.
In the Date table, the date_id column has a format of yyyymmdd and the month column has a format of yyyymm.
The week column in the Date table and the week_id column in the Weekly_Returns table have a format of yyyyww.
In the Sales table, the sales_id column represents a unique transaction.
The region id column can be managed by only one sales manager.
Existing Environment. Data Concerns
You are concerned with the quality and completeness of the sales data. You must ensure that negative and missing sales_amount values do NOT contribute to the total sales amount calculation.
Existing Environment. Reporting Requirements
Litware identifies the following reporting requirements:
Executives require a visual that shows sales by region.
Executives require a visual that shows returns by region manager and the sales managers that report to them.
The sales managers must be able to see only the sales data of their respective region.
The sales managers require a visual to analyze sales performance versus sales targets.
The sales department requires reports that contain the number of sales transactions.
Users must be able to see the month in each report as shown in the following example: Feb 2020.
The customer service department requires a visual that can be filtered by both sales month and ship month independently.
The maximum allowed latency to include transactions in reports is five minutes.
You need to create a calculated column to display the month based on the reporting requirements.
Which DAX expression should you use?
A. FORMAT(‘Date'[date],”MMM YYYY”)
B. FORMAT(‘Date'[date_id],”MMM”) & ” ” & FORMAT(‘Date'[year], “#”)
C. FORMAT(‘Date'[date_id],”MMM YYYY”)
D. FORMAT(‘Date'[date],”M YY”)
Suggested Answer: A
Users must be able to see the month in each report as shown in the following example: Feb 2020.
Custom date/time formats –
The following format characters can be specified in the format_string to create custom date/time formats:
* mmm
Display the month as an abbreviation (Jan-Dec). Localized.
* yyyy
Display the year as a 4-digit number (100-9999).
* Etc.
Reference: https://docs.microsoft.com/en-us/dax/format-function-dax#predefined-datetime-formats
HOTSPOT -
You have a Power BI report that contains a measure named Total Sales.
You need to create a new measure that will return the sum of Total Sales for a year up to a selected date.
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:
Suggested Answer:
Box 1: TOTALYTD –
TOTALYTD evaluates the specified expression over the interval which begins on the first day of the year and ends with the last date in the specified date column after applying specified filters.
Syntax: TOTALYTD (
,
[, ]
[, ]
Expression – The expression to be evaluated.
Dates – The name of a column containing dates or a one column table containing dates.
Example:
TOTALYTD ( — 2007-01-01 : 2007-05-12
[Sales Amount],
‘Date'[Date]
Box 2: ‘Date'[Date]
Reference: https://dax.guide/totalytd/
You have a CSV file that contains user complaints. The file contains a column named Logged. Logged contains the date and time each complaint occurred. The data in Logged is in the following format: 2018-12-31 at 08:59.
You need to be able to analyze the complaints by the logged date and use a built-in date hierarchy.
What should you do?
A. Apply a transformation to extract the last 11 characters of the Logged column and set the data type of the new column to Date.
B. Change the data type of the Logged column to Date.
C. Split the Logged column by using at as the delimiter.
D. Apply a transformation to extract the first 11 characters of the Logged column.
Suggested Answer: D
Extract the date, which is the first 11 characters.
CSV files have no data types.
Note: A CSV is a comma-separated values file, which allows data to be saved in a tabular format. CSVs look like a garden-variety spreadsheet but with a . csv extension. CSV files can be used with most any spreadsheet program, such as Microsoft Excel or Google Spreadsheets.
Reference: https://www.bigcommerce.com/ecommerce-answers/what-csv-file-and-what-does-it-mean-my-ecommerce-business/
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 should you do?
A. Add salary to the drillthrough fields.
B. Add salary to the visual filters.
C. Add salary to the tooltips.
Suggested Answer: C
Customize tooltips with aggregation or quick measures
You can customize a tooltip by selecting an aggregation function.
Select the arrow beside the field in the Tooltips bucket. Then, select from the available options.
Note: Tooltips are an elegant way of providing more contextual information and detail to data points on a visual. You can customize tooltips in Power BI Desktop and in the Power BI service.
When a visualization is created, the default tooltip displays the data point’s value and category.
Reference: https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-custom-tooltips
DRAG DROP -
You have a Power BI dashboard named DashboardA that contains a tile named TileA. TileA contains a treemap visual from a report named ReportA.
You need to provide the users of DashboardA with additional tiles that relate to the contents of TileA.
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:
Suggested Answer:
Step 1: From ReportA, select Get Insights
Then select ‘Get Insights’ג€¦ From the Datasets + dataflows tab, select More options (…) next to the dataset, and then choose Get insights.
Power BI Quick Insights will now scan the data related to the tile and display a list of potential insights you may want to explore further. To drill into a specific data point, you can even select data in the visual and Quick Insights will focus on that data point when searching for insights.
Power BI uses various algorithms to search for trends in your dataset.
Within seconds, your insights are ready. Select View insights to display visualizations.
The visualizations display in a special Quick Insights canvas with up to 32 separate insight cards. Each card has a chart or graph plus a short description.
Step 2: From DashboardA, select the TileA options, and then select View Insights
The insight screen opens in Focus mode.
Step 3: From Focus mode, pin the relevant visuals to DashboardA
Go to ‘in focus mode’ on a dashboard tile for data loaded into Power BI.
Reference: alt=”Reference Image” />
Power BI uses various algorithms to search for trends in your dataset.
Within seconds, your insights are ready. Select View insights to display visualizations.
<img src=”https://www.examtopics.com/assets/media/exam-media/04331/0019800002.png” alt=”Reference Image” />
The visualizations display in a special Quick Insights canvas with up to 32 separate insight cards. Each card has a chart or graph plus a short description.
Step 2: From DashboardA, select the TileA options, and then select View Insights
The insight screen opens in Focus mode.
Step 3: From Focus mode, pin the relevant visuals to DashboardA
Go to 'in focus mode' on a dashboard tile for data loaded into Power BI.
Reference: https://docs.microsoft.com/en-us/power-bi/create-reports/service-insights
You have a Microsoft Power BI report. The size of PBIX file is 550 MB. The report is accessed by using an App workspace in shared capacity of powerbi.com.
The report uses an imported dataset that contains one fact table. The fact table contains 12 million rows. The dataset is scheduled to refresh twice a day at 08:00 and 17:00.
The report is a single page that contains 15 AppSource visuals and 10 default visuals.
Users say that the report is slow to load the visuals when they access and interact with the report.
You need to recommend a solution to improve the performance of the report.
What should you recommend?
A. Enable visual interactions.
B. Change any DAX measures to use iterator functions.
C. Implement row-level security (RLS).
D. Remove unused columns from tables in the data model.
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. Promote the datasets.
B. Certify the datasets.
C. Feature the dataset on the home page.
D. Publish the datasets in an app.
Suggested Answer: B
Once logged in, you will be presented with a list of datasets that you can access from your various workspaces. This is one reason why having official datasets promoted and certified is recommended, as these will appear at the top of the list, with certified datasets appearing before promoted datasets.
Note: Power BI provides two ways you can endorse your valuable, high-quality content to increase its visibility: promotion and certification.
Promotion: Promotion is a way to highlight content you think is valuable and worthwhile for others to use. It encourages the collaborative use and spread of content within an organization.
Any content owner, as well as any member with write permissions on the workspace where the content is located, can promote the content when they think it’s good enough for sharing.
Certification: Certification means that the content meets the organization’s quality standards and can be regarded as reliable, authoritative, and ready for use across the organization.
Currently it is possible to endorse
Datasets –
Dataflows –
Reports –
Apps –
If dataset discoverability has been enabled in your organization, endorsed datasets can be made discoverable. When a dataset is discoverable, users who don’t have access to it will be able to find it and request access.
Reference: https://exceleratorbi.com.au/new-power-bi-reports-golden-dataset/ https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-endorse-content
You have a Power BI report that contains one page. The page contains two line charts and one bar chart.
You need to ensure that users can perform the following tasks for all three visuals:
• Switch the measures used in the visuals.
• Change the visualization type.
• Add a legend.
The solution must minimize development effort.
What should you do?
A. Create a bookmark for each acceptable combination of visualization type, measure, and legend in the bar chart.
B. Edit the interactions between the three visuals.
You have a Power BI workspace that contains several reports.
You need to provide a user with the ability to create a dashboard that will use the visuals from the reports.
What should you do?
A. Create a row-level security (RLS) role and add the user to the role.
B. Share the reports with the user.
C. Grant the Read permission for the datasets to the user.
DRAG DROP -
You have a Power BI 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:
Suggested Answer:
An entire report page can be pinned to a dashboard, which is called pinning a live tile. It’s called a live tile because you can interact with the tile on the dashboard.
Unlike with individual visualization tiles, changes made in the report are automatically synced with the dashboard.
Step 2: Open the Sales report –
Step 3: Pin the page.
1. Open a report in Editing view.
2. With no visualizations selected, from the menu bar, select Pin to a dashboard.
3. Pin the tile to an existing dashboard or to a new dashboard. Notice the highlighted text: Pin live page enables changes to reports to appear in the dashboard tile when the page is refreshed.
4. Select Pin live. A Success message (near the top right corner) lets you know the page was added, as a tile, to your dashboard.
Reference: alt=”Reference Image” />
4. Select Pin live. A Success message (near the top right corner) lets you know the page was added, as a tile, to your dashboard.
Reference: https://docs.microsoft.com/en-us/power-bi/create-reports/service-dashboard-pin-live-tile-from-report
HOTSPOT -
You are creating a Microsoft Power BI 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.
Sales contains the data shown in the following table.
You are evaluating how to optimize the model.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Hot Area:
Suggested Answer:
Box 1: Yes –
Those two columns not need in the analysis.
Box 2: No –
Can remove the surrogate key OrderDateKey from the analysis.
Box 3: No –
Tax charged not relevant for the analysis.
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 in the column chart, the donut chart redraws by using the data from the selected column.
What should you do?
A. Select the donut chart and set the column chart interaction to Filter.
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 None.
D. Select the column chart and set the donut chart interaction to None.
Suggested Answer: B
Filters remove all but the data you want to focus on.
Note: Enable the visual interaction controls.
1. Select a visualization to make it active.
2. Display the Visual Interactions options.
3. In Power BI Desktop, select Format > Edit interactions.
4. To display the visualization interaction controls, select Edit interactions. Power BI adds filter and highlight icons to all of the other visualizations on the report page.
We can see that the tree map is cross-filtering the line chart and the map, and is cross-highlighting the column chart. You can now change how the selected visualization interacts with the other visualizations on the report page.
Reference: alt=”Reference Image” />
4. To display the visualization interaction controls, select Edit interactions. Power BI adds filter and highlight icons to all of the other visualizations on the report page.
We can see that the tree map is cross-filtering the line chart and the map, and is cross-highlighting the column chart. You can now change how the selected visualization interacts with the other visualizations on the report page.
<img src=”https://www.examtopics.com/assets/media/exam-media/04331/0021200001.jpg” alt=”Reference Image” />
Reference: https://docs.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions
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
Each Customer ID represents a unique customer in the Customer table. Each Address ID represents a unique address in the Address table.
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. Group the Customer and Address tables by the Address ID column.
C. Transpose the Customer and Address tables.
D. Append the Customer and Address tables.
Suggested Answer: A
A merge queries operation joins two existing tables together based on matching values from one or multiple columns. You can choose to use different types of joins, depending on the output you want.
Reference: https://docs.microsoft.com/en-us/power-query/merge-queries-overview
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.)
What should you do?
A. Change the report theme.
B. Change the dashboard theme.
C. Edit the details of each tile.
D. Create a custom CSS file.
Suggested Answer: B
With dashboard themes you can apply a color theme to your entire dashboard, such as corporate colors, seasonal coloring, or any other color theme you might want to apply. When you apply a dashboard theme, all visuals on your dashboard use the colors from your selected theme.
Incorrect:
Not A: With Power BI Desktop report themes, you can apply design changes to your entire report, such as using corporate colors, changing icon sets, or applying new default visual formatting.
Reference: https://docs.microsoft.com/en-us/power-bi/create-reports/service-dashboard-themes
You use Power Query Editor to import and preview sales data from the years 2020 and 2021 in a Microsoft Excel file as shown in the following exhibit.
You need to shape the query to display the following three columns:
• Month
• Sales
• Year
What should you select in Power Query Editor?
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 BI Desktop, customize the current theme.
B. From Power BI Desktop, use a built-in report theme.
C. Create a theme as a PBIVIZ file and import the theme into Power BI Desktop.
D. Create a theme as a JSON file and import the theme into Power BI Desktop.
HOTSPOT -
You have a report page that contains the visuals shown in the following exhibit.
Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.
NOTE: Each correct selection is worth one point.
Hot Area:
HOTSPOT
-
You have a folder that contains 50 JSON files.
You need to use Power BI Desktop to make the metadata of the files available as a single dataset. The solution must NOT store the data of the JSON files.
Which type of data source should you use, and which transformation should you perform? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Overview -
Northwind Traders is a specialty food import company.
The company recently implemented Power BI to better understand its top customers, products, and suppliers.
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.
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 tables:
Orders
Products
Suppliers
Categories
Order Details
Sales Employees
The Orders table contains the following columns.
The Order Details table contains the following columns.
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.
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 reports.
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.
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 statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Hot Area:
Suggested Answer:
Box 1: Yes –
Need to link the tables for: 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.
Box 2: No –
It should be set to Integer.
Box 3: No –
Can use the Region field of the Customer Details table.
The Orders table only has the ShipRegion field
DRAG DROP
-
You receive annual sales data that must be included in Power BI reports.
From Power Query Editor, you connect to the Microsoft Excel source shown in the following exhibit.
You need to create a report that meets the following requirements:
• Visualizes the Sales value over a period of years and months
• Adds a slicer for the month
• Adds a slicer for the year
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.
You have a Power BI report that contains the visuals shown in the following table.
You need to modify the location of each visual.
What should you modify for each visual?
HOTSPOT
-
You are creating a Power BI model in Power BI Desktop.
You need to create a calculated table named Numbers that will contain all the integers from -100 to 100.
How should you complete the DAX calculation? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
In Power Query Editor, you have a query named Sales Data that contains the following columns.
You need to create two queries named Product Dimension and Sales Fact based on the Sales Data query. The solution must minimize maintenance effort and the size of the dataset.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
A. Reference the Sales Data query to create the new queries.
B. Disable the load for the Sales Fact query.
C. Duplicate the Sales Data query to create the new queries.
D. Clear Include in report refresh for the Sales Data query.
You are building a Power BI report.
Users will view the report by using their mobile device.
You need to configure the report to display data based on each user's location.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
A. From Power Query Editor, detect the data types of the relevant columns.
B. In Data Category, set the geographic data category for the relevant columns.
C. Create a hierarchy for columns of the geography data type.
D. Use the columns of the geography data type in all visuals.
E. For the relevant columns, set synonyms to match common geographical terms.
Suggested Answer: BD
B: Identify geographic data in your report
1. In Power BI Desktop, switch to Data View Data View icon.
2. Select a column with geographic data ג€” for example, a City column.
3. On the Modeling tab, select Data Category, then the correct category ג€” in this example, City.
4. Continue setting geographic data categories for any other fields in the model.
D: Create visuals with your geographic data
Switch to Report view Report View icon, and create visuals that use the geographic fields in your data.
In this example, the model also contains a calculated column that brings city and state together in one column.
Publish the report to the Power BI service.
Reference: alt=”Reference Image” />
4. Continue setting geographic data categories for any other fields in the model.
D: Create visuals with your geographic data
Switch to Report view Report View icon, and create visuals that use the geographic fields in your data.
In this example, the model also contains a calculated column that brings city and state together in one column.
<img src=”https://www.examtopics.com/assets/media/exam-media/04331/0021000002.png” alt=”Reference Image” />
Publish the report to the Power BI service.
Reference: https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-mobile-geofiltering
DRAG DROP
-
You publish a dataset that contains data from an on-premises Microsoft SQL Server database.
The dataset must be refreshed daily.
You need to ensure that the Power BI service can connect to the database and refresh the dataset.
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.
DRAG DROP
-
You need to use AI insights to add a column of enhanced data based on the customer feedback. The solution must identify the following:
• What the customers most often provide feedback about
• Whether the customers like your company’s product
• The language of the feedback
Which AI insights service should you use for each output? To answer, drag the appropriate services to the correct outputs. Each service may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
You have a Power BI model that contains a table named Date. The Date table contains the following columns:
• Date
• Fiscal Year
• Fiscal Quarter
• Month Name
• Calendar Year
• Week Number
• Month Number
• Calendar Quarter
You need to create a calculated table based on the Date table. The calculated table must contain only unique combinations of values for Calendar Year, Calendar Quarter, and Calendar Month.
Which DAX function should you include in the table definition?
Overview -
Litware, Inc. is an online retailer that uses Power BI.
Litware plans to leverage data from an Azure SQL database that stores data for the company's live e-commerce website.
Litware uses Azure Active Directory (Azure AD) to authenticate users.
Existing Environment. Sales Data
Litware has online sales data that has the SQL schema shown in the following table.
In the Date table, the date_id column has a format of yyyymmdd and the month column has a format of yyyymm.
The week column in the Date table and the week_id column in the Weekly_Returns table have a format of yyyyww.
In the Sales table, the sales_id column represents a unique transaction.
The region id column can be managed by only one sales manager.
Existing Environment. Data Concerns
You are concerned with the quality and completeness of the sales data. You must ensure that negative and missing sales_amount values do NOT contribute to the total sales amount calculation.
Existing Environment. Reporting Requirements
Litware identifies the following reporting requirements:
Executives require a visual that shows sales by region.
Executives require a visual that shows returns by region manager and the sales managers that report to them.
The sales managers must be able to see only the sales data of their respective region.
The sales managers require a visual to analyze sales performance versus sales targets.
The sales department requires reports that contain the number of sales transactions.
Users must be able to see the month in each report as shown in the following example: Feb 2020.
The customer service department requires a visual that can be filtered by both sales month and ship month independently.
The maximum allowed latency to include transactions in reports is five minutes.
You need to create relationships to meet the reporting requirements of the customer service department.
What should you create?
A. a one-to-many relationship from Date[date_id] to Sales[sales_date_id] and another one-to-many relationship from Date[date_id] to Weekly_Returns[week_id]
B. a one-to-many relationship from Sales[sales_date_id] to Date[date_id] and a one-to-many relationship from Sales[sales_ship_date_id] to Date[date_id]
C. an additional date table named ShipDate, a many-to-many relationship from Sales[sales_date_id] to Date[date_id], and a many-to-many relationship from Sales[sales_ship_date_id] to ShipDate[date_id]
D. an additional date table named ShipDate, a one-to-many relationship from Date[date_id] to Sales[sales_date_id], and a one-to-many relationship from ShipDate[date_id] to Sales[sales_skip_date_id]
You have a Power BI data model that analyzes product sales over time. The data model contains the following tables.
A one-to-many relationship exists between the tables.
The auto date/time option for the data model is enabled.
You need to reduce the size of the data model while maintaining the ability to analyze product sales by month and quarter.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct answer is worth one point.
A. Create a relationship between the Date table and the Sales table.
B. Disable the auto date/time option.
C. Create a Date table and select Mark as Date Table.
D. Disable the load on the Date table.
E. Remove the relationship between the Product table and the Sales table.
HOTSPOT -
You need to create a Power BI report. The first page of 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.
The Sales By Month view must display a column chart visual as shown in the following exhibit.
Users must be able to switch between the views by using buttons on the report page. The selected Chain field must be maintained when switching between views.
What is the minimum number of bookmarks required, and which property should you apply to each bookmark? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:
Suggested Answer:
Box 1: 2 –
One for each visual.
Note: When you edit a report in Power BI Desktop and the Power BI service, you can add report bookmarks to capture the current state of a report page.
Bookmarks save the current filters and slicers, cross-highlighted visuals, sort order, and so on. When others view your report, they can get back to that exact state by selecting your saved bookmark.
Box 2: Display –
Users must be able to switch between the views by using buttons on the report page. The selected Chain field must be maintained when switching between views.
You can select whether each bookmark will apply Data properties, such as filters and slicers; Display properties, such as spotlight and its visibility; and Current page changes, which present the page that was visible when the bookmark was added. These capabilities are useful when you use bookmarks to switch between report views or selections of visuals, in which case you’d likely want to turn off data properties, so that filters aren’t reset when users switch views by selecting a bookmark.
Note: 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 mode of any visible object
Reference: https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-bookmarks
You have the Power BI data model shown in the following exhibit.
The Sales table contains records of sales by day from the last five years up until today’s date.
You plan to create a measure to return the total sales of March 2021 when March 2022 is selected.
Which DAX expression should you use?
A. Calculate (Sum(Sales[Sales]), PREVIOUSYEAR( dimDate[Date])
B. TOTALYTD (SUM(Sales[Sales]), dimDate[Date] )
C. Calculate (SUM(Sales[Sales]), SAMEPERIODLASTYEAR(dimDate[Date] ))
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?
Want a full-length mock test experience? Click here to unlock the complete PL-300 Mock Test Free set and get access to hundreds of additional practice questions covering all key topics.
We regularly update our question sets to stay aligned with the latest exam objectives—so check back often for fresh content!
Start practicing with our PL-300 mock test free today—and take a major step toward exam success!
What can you identify from the visual?
You have the following requirements: The export of reports that contain Personally Identifiable Information (PII) must be prevented. Data used for financial decisions must be reviewed and approved before use. For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point. Hot Area:
The Sales table contains records of sales by day from the last five years up until today’s date. You plan to create a measure to return the total sales of March 2021 when March 2022 is selected. Which DAX expression should you use?
The data view for the Orders table is shown in the following exhibit.
The Orders table relates to the Customers table by using the CustomerID column. The Orders table relates to the Date table by using the OrderDate column. For each of the following statements, select Yes if the statement is true, Otherwise, select No. NOTE: Each correct selection is worth one point. Hot Area:
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: ✑ Minimize the load times of visuals. ✑ Ensure that the data is loaded to the model based on the refresh requirements. Which storage mode should you select for each table? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. Hot Area:
The indicator color for Total Sales will be based on % Growth to Last Year. The solution must use the existing calculations only. How should you configure the visual? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. Hot Area:
In the Date table, the date_id column has a format of yyyymmdd and the month column has a format of yyyymm. The week column in the Date table and the week_id column in the Weekly_Returns table have a format of yyyyww. In the Sales table, the sales_id column represents a unique transaction. The region id column can be managed by only one sales manager. Existing Environment. Data Concerns You are concerned with the quality and completeness of the sales data. You must ensure that negative and missing sales_amount values do NOT contribute to the total sales amount calculation. Existing Environment. Reporting Requirements Litware identifies the following reporting requirements: Executives require a visual that shows sales by region. Executives require a visual that shows returns by region manager and the sales managers that report to them. The sales managers must be able to see only the sales data of their respective region. The sales managers require a visual to analyze sales performance versus sales targets. The sales department requires reports that contain the number of sales transactions. Users must be able to see the month in each report as shown in the following example: Feb 2020. The customer service department requires a visual that can be filtered by both sales month and ship month independently. The maximum allowed latency to include transactions in reports is five minutes. You need to create a calculated column to display the month based on the reporting requirements. Which DAX expression should you use?
The related dimension tables are imported into the model. Sales contains the data shown in the following table.
You are evaluating how to optimize the model. For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point. Hot Area:
You need to modify the dashboard to appear as shown in the Modified Dashboard exhibit. (Click the Modified Dashboard tab.)
What should you do?
You need to shape the query to display the following three columns: • Month • Sales • Year What should you select in Power Query Editor?
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:
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. 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 tables: Orders Products Suppliers Categories Order Details Sales Employees The Orders table contains the following columns.
The Order Details table contains the following columns.
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.
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 reports. 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. 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 statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point. Hot Area:
You need to create a report that meets the following requirements: • Visualizes the Sales value over a period of years and months • Adds a slicer for the month • Adds a slicer for the year 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.
You need to modify the location of each visual. What should you modify for each visual?
You need to create two queries named Product Dimension and Sales Fact based on the Sales Data query. The solution must minimize maintenance effort and the size of the dataset. Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.
A one-to-many relationship exists between the tables. The auto date/time option for the data model is enabled. You need to reduce the size of the data model while maintaining the ability to analyze product sales by month and quarter. Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct answer is worth one point.
The Sales By Month view must display a column chart visual as shown in the following exhibit.
Users must be able to switch between the views by using buttons on the report page. The selected Chain field must be maintained when switching between views. What is the minimum number of bookmarks required, and which property should you apply to each bookmark? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. Hot Area:
