Power BI Data Analyst Certification (PL-300) Practice Test 11

Insurance work is a chain of quotes, binds, claims, severity, and lag. Power BI keeps that chain visible for underwriters, with filters that respect who may see which book of business. Data scientists sit model output beside historical loss so business owners share one picture. The Power BI Data Analyst Associate certification, awarded after PL-300, shows you can be trusted with that reporting. Benefits include employer recognition, a structured skill checklist, and a credential you renew rather than a one-time course badge. This Free Microsoft Power BI Data Analyst Associate Certification (PL-300) Practice Test 11 is meant for repetition until the clock feels manageable. Insurers that hire Power BI-capable analysts include State Farm, Progressive, and USAA. U.S. base pay varies by city and industry: junior data analysts often earn $58,000–$75,000, mid-level analysts commonly earn $78,000–$108,000, and senior data analysts frequently reach $112,000–$145,000. Synergisticit JOPP helps jobseekers get certified, prepared, and hired at top tech companies through our Job Placement programs—Java DevOps Full Stack JOPP and Data Science JOPP.

If you want to learn how to get hired as a Power BI Data Analyst, Data Scientist, Data Engineer, AI or ML engineer, Java developer, or software engineer, contact Synergisticit for expert upskilling and marketing connections to companies. Visit Synergisticit Contact Us and Synergisticit JOPP.

Welcome to your Microsoft Power BI - Test-11

Name

Phone

Q1. You have two tables as shown in the exhibit. There are no unique values in either table. The tables are related by the product name.

You need to create relationships in the data model to enable visuals to be created that contain data from both tables.

How should you model these tables?

Select 1 option(s):

Create a table that contains unique IDs and create two one-to-many relationships.

Set the relationship cardinality to one-to-one between the two tables.

Set the relationship cardinality to one-to-many between the two tables.

Set the relationship cardinality to many-to-many between the two tables.

Q2. You create a report using the RegionalSales table as shown in the exhibit. You use the PERCENTILEX.EXC function in a measure to calculate the 95% percentile for the Sales column in the RegionalSales table as shown below:

Percentile95 = PERCENTILEX.EXC(RegionalSales, RegionalSales[Sales], 0.95)
When you add the measure to a line chart visualization, an error is shown with unsupported percentile.
You need to resolve the error and show the 95% percentile on the visual. What should you do?

Select 1 option(s):

Replace the function with the PERCENTILEX.INC function.

Use binning and add 20 bins to the value column.

Add a forecast to the visualization at 95% confidence level.

Replace the function with the PERCENTILE.EXC function.

Q3. You have a very large dataset, and you want to reduce its size. A table called Telemetry contains multiple records per day with the datetime, deviceid, devicetype, readingtype, and readingvalue.

You need to produce reports showing average values for devicetype and readingtype. The Telemetry table is set to DirectQuery storage mode. You need to create aggregations for date, devicetype, readingtype, and readingvalue.
Which of the following five actions should you perform in sequence?

Select 1 option(s):

Q4. You are modeling sales data as shown in the below exhibit.

Microsoft Power BI data model diagram illustrating relationships between tables and fields.

You need to show the variance of sales for the different product types. You decide to use a Quick measure.
How should you configure the Quick measure? Select the correct column names for the Quick Measure setup.

Select 2 option(s):

Base Value = Order Number

Category = Amount

Base Value = Amount

Category = TypeName

Category = Order Number

Base Value = TypeName

Q5. You create a Power Bl report for regional sales data.

You write a measure to calculate the Percentage of Sales. The measure is calculating the percentages incorrectly as shown in the exhibit named Incorrect below.
Power BI data table showing regional sales data and percentages.

Incorrect
You need to re-write the measure so that the percentage is correct for each country and region and the total percentage is 100 percent. The measure should calculate the percentages as shown in the below exhibit named Correct.
Power BI data visualization showing regional sales data and percentages.

Correct
How should you re-write the measure? To answer, select the appropriate option from the drop-down menu.

Select 1 option(s):

Percentage of Sales = DIVIDE(SUM(RegionalSales[Sales]), CALCULATE(SUM(RegionaISaIes[Sales]), REMOVEFILTERS() ))

Percentage of Sales = DIVIDE(SUM(RegionalSales[Sales]), CALCULATE(SUM(RegionaISaIes[Sales]), ALL(RegionalSales[Country]) ))

Percentage of Sales = DIVIDE(SUM(RegionalSales[Sales]), CALCULATE(SUM(RegionaISaIes[Sales]), ALLSELECTED('RegionalSales'[Region]) ))

Q6. You work for a retail organization that uses Power Bl. The schema for the tables is shown in the below exhibits.

Data table showing Product ID and Product Name for Microsoft Power BI Data Analyst certification

Microsoft Power BI data table sample for data modeling and analysis practice.

Power BI data table displaying customer ID, name, and ZIP code for data analysis practice.

Power BI data table showing Basket ID, Product ID, and Amount for data analysis practice.

Database table schema illustrating data types for Power BI data analysis.

The Customer table contains the names and IDs of the customers. The Product table contains the ids and names of the products. When a customer purchases from the retail establishment, a record in the Basket table is created to link the Customer to that purchase. The Products added to their Basket are stored in the Basket Items table.
You need to find the number of customers who purchased the same set of products. You add a slicer for Product Name to your report to choose the set of products.
How should you create the measure to count the number of customers who purchased the products selected? To answer, select the appropriate option.

Select 1 option(s):

ProductsSelected = COUNT('Product'[ProductID]) PurchasedSelected = IF(COUNT('Basket Items'[ProductID]) [ProductsSelected], 1, 0) CustomerCount = SUM(VALUES(Customer[CustomerID]), [PurchasedSelected])

ProductsSelected = COUNTX('Product'[ProductID]) PurchasedSelected = SUM(COUNTX('Basket Items'[ProductID]) [ProductsSelected], 1, 0) CustomerCount = SUM(VALUES(Customer[CustomerID]), [PurchasedSelected])

ProductsSelected = DISTINCTCOUNT('Product'[ProductID]) PurchasedSelected = IF(DISTINCTCOUNT('Basket Items'[ProductID]) [ProductsSelected], 1, 0) CustomerCount = SUMX(VALUES(Customer[CustomerID]), [PurchasedSelected])

ProductsSelected = COUNTX('Product'[ProductID]) PurchasedSelected = SUMX(COUNTX('Basket Items'[ProductID]) [ProductsSelected], 1, 0) CustomerCount = IF(VALUES(Customer[CustomerID]), [PurchasedSelected])

Q7. You import a table into Power BI. The schema is shown in the below exhibit.

Microsoft Power BI data table schema illustrating table and column names with data types.

You need to configure the columns in the table.
Which Summarize option should you recommend for aggregating the columns for use in visualizations?
Microsoft Power BI data modeling interface with Amount, Order Number, and DateKey fields.

Select 1 option(s):

Amount: Sum Order Number: Average DateKey: Count

Amount: Sum Order Number: Count DateKey: None

Amount: Sum Order Number: Sum DateKey: Average

Amount: None Order Number: Count DateKey: Average

Q8. You have tables named Employee and Salary, as shown in the below exhibit.

Employee and salary data tables illustrating Power BI data modeling concepts.

You have a slicer that filters employees based on Salary range. You have another slicer that filters employees based on Company.
A visualization that shows employees along with salaries is not showing the correct values. You need the Company slicer to show only values within the range of the Salary slicer. You need to fix the relationship between the Employee and Salary tables.
Which two actions should you perform? Each correct answer presents part of the solution.

Select 2 option(s):

Set the cross filter direction to single.

Set the cross filter direction to both.

Set cardinality to one-to-many from the Employee table to the Salary table.

Select Apply security filter in both directions.

Q9. You need to create time-series visualizations based on the dates in the table shown in the below exhibit.

Microsoft Power BI data model table illustrating Sales data and column types.

Orders are received during the working week and are typically shipped within a week.
You need to define a date table to support visualizations. For each of the following statements, select Yes if the statement is true. Otherwise, select No.
1. A date table must have a column with the Date data type.
2. You can mark the table named Sales as a date table.
3. You can create two date tables, one for order date and one for ship date, and mark both as date tables.

Select 1 option(s):

1. Yes 2. Yes 3. No

1. No 2. No 3. No

1. Yes 2. Yes 3. Yes

1. Yes 2. No 3. No

1. Yes 2. No 3. Yes

1. No 2. Yes 3. No

Q10. You create a data model and report in Power Bl desktop. The data model contains multiple tables, many relationships, and a set of measures.

Users report poor performance when using your report.
How can you identify the source of the performance issues?

Select 1 option(s):

use the Performance analyzer.

use the ALM Toolkit.

use the Tabular Editor.

use the DAX Studio tool.

Q11. You create reports using the data model shown in the below exhibit.

Power BI data model diagram illustrating relationships between Product, Sales, and Customer tables.

You have the following measure that is performing poorly The measure calculates the change in sales each year.
SalesChangeYoY = IF(SUM(Sales[Amount]), DIVIDE([SumofSales] – CALCULATE([SumofSales], SAMEPERIODLASTYEAR(Sales[Date])), CALCULATE([SumofSales], SAMEPERIODLASTYEAR(Sales[Date]))))
You need to improve the performance of the measure. What should you do?

Select 1 option(s):

Change the cardinality of both relationships to many-to-many

Create a calculated column containing the sales amount for the previous year

Change the cross filter directions on both relationships to Both

Rewrite the measures using DAX variables

Q12. You have a table named Sales. You need to create a measure that calculates sales from the previous year based on a dynamic period, as shown in the below exhibit.

Microsoft Power BI data visualization of sales data, highlighting 2019 and 2020 sales figures.

Which two DAX expressions can you use to achieve your goal? Each correct answer presents a complete solution.

Select 2 option(s):

_PY Sales = CALCULATE(SUM(Sales[Sales]), DATEADD('Calendar'[Date].[Date], -1, MONTH))

_PY Sales = CALCULATE(SUM(Sales[Sales]), DATEADD('Calendar'[Date].[Date], -1, YEAR))

_PY Sales = CALCULATE(SUM(Sales[Sales]), PARALLELPERIOD('Calendar'[Date], -1, YEAR))

_PY Sales = CALCULATE(SUM(Sales[Sales]), SAMEPERIODLASTYEAR('Calendar'[Date]))

Q13. You have a Product table and a Sales table that are connected through a one-to-many relationship using the ProductName column, as shown in the exhibit.

Data model diagram illustrating Product and Sales tables for Power BI data analysis.

You need to optimize model performance. Which two actions should you perform? Each correct answer presents part of the solution.

Select 2 option(s):

Create a new one-to-many relationship between the Sales and Product tables using the ProductlD column.

Create a new one-to-many relationship between the Product and Sales tables using the ProductlD column.

Change the data type of the ProductName column from text to whole number in the Product table.

Remove the existing relationship based on the ProductName column between the Product and Sales tables.

Q14. You load sales data into Power BI. Your organization uses many different terms for sales data such as revenue, net sales, and total sales.

You need to configure the Sales table and its columns for users to successfully use the Q&A feature in Dashboards.
Solution: Mark the Sales table as the date table. Does this solution meet the goal?

Select 1 option(s):

Yes

Q15. You create a report to help sales users understand their data. You need to use the appropriate type of visualization for each of the requirements of the sales team.

Which visualizations should you use for each requirement stated below:
Identify outliers in customers with sales opportunities.

Select 1 option(s):

Scatter

Waterfall

Treemap

Card

Key influencers

KPI

Q16. Which of the following visuals is not included as part of Power Bl and must be added as a custom visual?

Select 1 option(s):

Stacked Area

Histogram

Donut

Waterfall

Q17. You create multiple Power Bl dashboards. You define the data classifications and tags.

You need to show users how the data in the dashboards is classified.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
1. Data classifications are defined at the tenant level.
2. Access to dashboards with data classification configured is controlled by Azure Active Directory (AD) security groups.
3. The data classification for a dashboard is always displayed.

Select 1 option(s):

1. Yes 2. No 3. No

1. Yes 2. Yes 3. Yes

1. No 2. No 3. Yes

1. Yes 2. No 3. Yes

1. No 2. Yes 3. Yes

1. No 2. No 3. No

Q18. You create the stacked column chart shown in the below exhibit.

Power BI data visualization of units sold by product and segment.

When you hover over a data point in the visual you need to also show the value of goods sold, Total sales.
What are two possible ways to achieve this goal? Each correct answer presents a complete solution.

Select 2 option(s):

Enable Total labels on the visual

Add Total sales to Drill through on the visual

Enable Data labels on the visual

Add Total sales to Tooltips on the visual

Create a report tooltip page with a card visual for Total sales

Q19. After you have pinned a report visual to create a dashboard tile, you can later modify the visual’s properties and the Power Bl service will automatically update the dashboard tile with the new visual property values.

Select 1 option(s):

Correct

Incorrect

Q20. You have two dashboards in the same workspace named Production and Manufacturing. Your company Power Bl administrator creates the following two dashboard data classifications:

• Medium Impact (MEDI) as default.
• High Impact (HIGH).
You need to use the newly created classifications in the dashboards. The Production dashboard should be classified as Medium Impact. The Manufacturing dashboard should be classified as High Impact.
Which two actions should you perform? Each correct answer presents part of the solution.

Select 2 option(s):

Set Data classification as Medium Impact.

Go to Production dashboard > settings.

Go to Manufacturing dashboard > settings.

Set Data classification as High Impact.

Q21. To create a column chart that displays Quantity by Color and can be drilled down to show Quantity by Stock Item.

Which of the following solves the problem? More than one answer can be correct.

Select 2 option(s):

Put Color on Axis and Stock Item on Tooltips

Put Color and Stock Item on the axis

Put Color on axis and Stock Item on legend

Create a Stock Item hierarchy that includes Color and Stock Item and use the hierarchy on axis.

Q22. You create a report page and pin the page to a dashboard in the Power BI service. You receive many enquiries from users asking you about the data and requesting additional visuals on the dashboard.

You need to enable the Q&A feature that appears as “Ask a question about your data” at the top of the dashboard above the visuals.
How should you enable this feature?
Solution: Add Q&A button on the report page.
Does this solution meet the goal?

Select 1 option(s):

Yes

Q23. You create Power Bl reports and dashboards.

Your company has standard corporate colors and fonts that must be used on reports and dashboards. There is a set list of colors for data in visuals. The colors are shades of red, crimson, and maroon. All tiles should have a background color of light blue. Your company also wants to use different pictures for report and dashboard backgrounds at special times during the year, such as holidays and the end of the company’s financial year.
You need to customize themes to meet these requirements.
Which theme should you use for the following requirement?
“Set the tile background color”

Select 1 option(s):

Dashboard or report theme

Dashboard theme

Report theme

Q24. You have Power Bl Premium with assigned capacity. You have a dataset containing employee key performance indicators (KPls).

You create a Power Bl report with a visual that shows employees with low scoring KPls. You pin the visual to a dashboard and share the dashboard with users in Human Resources (HR).
HR users need to be able to generate a list of employees to investigate for poor performance and import that list into their HR system.
What should you do?

Select 1 option(s):

Configure Cloud App Security.

Grant HR users the Reshare permission on the dataset.

Grant HR users Build permission on the dataset.

Apply a sensitivity label in the dashboard settings.

Q25. What happens when you click on Focus mode of a tile in Power Bl dashboard?

Select 1 option(s):

The tile you selected expands and takes the full space

The Power Bl desktop file opens.

The Power Bl desktop file gets downloaded

The report from which the tile was pinned opens.

Q26. You create a report to help sales users understand their data. You need to use the appropriate type of visualization for each of the requirements of the sales team.

Which visualizations should you use for each requirement stated below:
Show the factors that affect the outcome of sales opportunities.

Select 1 option(s):

Waterfall

Treemap

KPI

Key influencers

Scatter

Card

Q27. You create a Power Bl report to help users understand their data. You need to use the appropriate type of visualization for each of the requirements.

Which visualizations should you use for the below-stated requirement?
“Take actions from within a report”

Select 1 option(s):

Power Apps

Python

Q28. You import a set of financial data and create a measure to show the percentage change since the previous quarter.

You need to format a visualization to match the one shown in the exhibit.
Power BI data table showing monthly sales and sales QoQ% performance.

The graduated color is determined by the percentage change since the previous quarter.
How should you configure the visual? Select the appropriate option for the two process steps.

Select 2 option(s):

Format by: Rules Conditional formatting: Icons

Format by: Field value Conditional formatting: Data bars

Conditional formatting: Font color Conditional formatting: Background color

Format by: Color scale

Q29. You create a Power Bl report containing a corrplot R visual for a dataset that has 1 million rows of sales data. You publish the report to the Power Bl service. Users can only see some of the sales data and an error is displayed.

You need to identify the root cause of this issue. What is preventing all the data from be displayed?

Select 1 option(s):

The visual has too many rows.

The data rows are unique.

The report has been published in an app.

Corrplot is not supported in Powerbi.com.

Q30. You create several Power Bl report pages.

You need to make the report pages more interactive for users.
To answer, drag the appropriate Power Bl feature for the stated requirement.
“Create a view of a report page with the filters applied”

Select 1 option(s):

Bookmarks

Buttons

Comments

Selection pane

Q31. You create Power Bl reports and dashboards.

Dashboard or report theme

Report theme

Dashboard theme

Q32. You work for a multinational company as a data analyst.

You create a Power Bl report for your company. The report has three pages containing visualizations of sales data. You need to filter the visuals for all three report pages whenever a country is selected.
What are two possible ways to achieve this goal? Each correct answer presents a complete solution.

Select 2 option(s):

Create a bookmark for each page and for each country.

Add a page level filter to each of the three pages using Country as the data field.

Add a report level filter using Country as the data field.

Add a slicer to each of the three pages with Country as the field and configure Sync slicers.

Create a visual for Country and set the interaction behavior for each of the other visuals

Q33. You have a matrix visual that shows Sales % and Sales by Product Line as shown in the exhibit.

Power BI data visualization of sales by product line, demonstrating data modeling and report visualization

The Sales % measure shows as a percentage the contribution of sales in that product line for overall sales. You need to add a background color to the Sales measure as follows:
When the Sales % contribution is >= 15 and <=17 percent, highlight it in light yellow.
What should you do to configure conditional formatting? To answer, select the appropriate options for each of the blank field.
Microsoft Power BI data analysis interface illustrating data modeling and visualization techniques.

Select 4 option(s):

is greater than or equal to 0.15 Number

Based on field > Sales

Format by > Color Scale

Based on field > Sales %

Format by > Rules

is less than or equal to 0.17 Number

Q34. You create a Power Bl report for your company. The report has four pages containing visualization of financial data. Page 1 contains visualizations that show income and expenditure. Page 2 contains visualizations that analyze Accounts Payable. Page 3 contains visualizations on Accounts Receivable. Page 4 contains visualizations on Fixed Assets. You add a fifth page, home page.

How should you configure the home page to allow users to navigate to the report pages?
Solution:
• Create a bookmark for each report page.
• Add four buttons to the home page and set action type to Bookmark.
• On each button, select the bookmark for the page.
Does this solution meet the goal?

Select 1 option(s):

Yes

Q35. You create a Power Bl report for your company. The report has four pages containing visualization of financial data. Page 1 contains visualizations that show income and expenditure. Page 2 contains visualizations that analyze Accounts Payable. Page 3 contains visualizations on Accounts Receivable. Page 4 contains visualizations on Fixed Assets. You add a fifth page, home page.

How should you configure the home page to allow users to navigate to the report pages?
Solution:
• Set Include in app to Yes for the report.
• Create a Power BI app.
• Enable navigation builder.
• Include the report in the navigation.
• Publish the app.
Does this solution meet the goal?

Select 1 option(s):

Yes

Q36. You create the report page shown in the below exhibit.

Microsoft Power BI data visualization dashboard with bar and pie charts illustrating sales by product

You need to configure the interactions of the visuals.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
1. To make the Sales by Product visual show the portion of the segment selected in the Pie chart, you should select the Sales by Product visual and edit the interactions on the Sales by Segment chart.
2. To not filter the Sales by Segment chart when a column in the Sales by Product visual is clicked, you should set the interaction behavior to None.
3. To focus on the proportion of Sales by Product for a selected segment, you should set the interaction behavior to Filter.

Select 1 option(s):

1. Yes 2. Yes 3. No

1. Yes 2. No 3. No

1. Yes 2. Yes 3. Yes

1. No 2. Yes 3. Yes

1. No 2. No 3. Yes

1. No 2. Yes 3. No

Q37. Which page view types are available in Power Bl Report View? Choose the correct answers.

Select 3 option(s):

Fit to Width

Fit to page

Full Screen

Actual Size

Q38. You create a report to help sales users understand their data. You need to use the appropriate type of visualization for each of the requirements of the sales team.

Which visualizations should you use for each requirement stated below:
Show progress of sales opportunities won against target.

Select 1 option(s):

Scatter

Key influencers

Card

KPI

Waterfall

Treemap

Q39. You create a report page and pin the page to a dashboard in the Power BI service. You receive many enquiries from users asking you about the data and requesting additional visuals on the dashboard.

You need to enable the Q&A feature that appears as “Ask a question about your data” at the top of the dashboard above the visuals.
How should you enable this feature?
Solution: Enable the Q&A option in Page information on the report page.
Does this solution meet the goal?

Select 1 option(s):

Yes

Q40. You have a dashboard in Power Bl that has visuals created from data in the Common Data Service. The dashboard contains a KPI visual.

You need to automate the notification of alerts when the KPI value exceeds a threshold. Which two options are available when configuring an alert in Power Bl service? Each correct answer presents a complete solution.

Select 2 option(s):

Push a notification to a mobile device

Send an email

Call a webhook

Run a Power Automate flow

Q41. Which fields are available when creating a Pie chart visualization?

Select 3 option(s):

Group

Value

Details

Legend

Q42. You create a Power Bl report for your company. The report has four pages containing visualization of financial data. Page 1 contains visualizations that show income and expenditure. Page 2 contains visualizations that analyze Accounts Payable. Page 3 contains visualizations on Accounts Receivable. Page 4 contains visualizations on Fixed Assets. You add a fifth page, home page.

How should you configure the home page to allow users to navigate to the report pages?
Solution:
• Add four images to the home page and set action type to Page navigation.
• Select the destination page for each image.
Does this solution meet the goal?

Select 1 option(s):

Yes

Q43. You create a report in Power Bl.

You need to configure the page for use with screen reader software for partially sighted users.
What should you configure on the report page so that the screen reader follows a logical sequence?

Select 1 option(s):

Tab order

Focus mode

Layer order

Bookmark groups

Q42. You create Power Bl reports and dashboards.

Report theme

Dashboard theme

Dashboard or report theme

Q45. Which properties of a tile can be edited in the Power Bl dashboard from the Tile details window? Choose the correct answers.

Select 3 option(s):

Subtitle

Color scheme

Title

Destination link

Q46. By default, which filter level behaves the same as a slicer in a report in Power BI Desktop?

Select 1 option(s):

Report level filter

Visual level filter

Page level filter

Query level filter

Q47. What is the specific name for visualizations added to a dashboard as displayed below?

Select 1 option(s):

Reports

Datasets

Tile

Bar charts

Q48. You create a Power Bl report.

You need to improve report navigation.
Which options should you use for the stated task?
“Preserve visual selection of a specific report page”

Select 1 option(s):

Buttons

Bookmarks

Q49. You create a dashboard in Power Bl with several visuals.

You need to explain how the dashboard will appear on a mobile device using the Power Bl app. For each of the following statements, select Yes if the statement is true. Otherwise, select No.
1. By default, in the Power Bl mobile, all tiles on a dashboard appear with the same size in a vertical list.
2. Enabling Dashboard tile flow causes the tiles to be displayed on a mobile device as they are on a web browser.
3. Creating a Phone view of a dashboard, allows you to resize and rearrange the visuals for the Power Bl mobile app.

Select 1 option(s):

1. No 2. Yes 3. Yes

1. Yes 2. Yes 3. No

1. Yes 2. No 3. Yes

1. No 2. No 3. Yes

1. Yes 2. Yes 3. Yes

1. No 2. No 3. No

Q50. You create several Power Bl report pages.

You need to make the report pages more interactive for users.
To answer, drag the appropriate Power Bl feature for the stated requirement.
“Show and hide visuals on a report page”

Select 1 option(s):

Bookmarks

Comments

Selection pane

Buttons

Q51. You create a Power Bl report for your company. The report has four pages containing visualization of financial data. Page 1 contains visualizations that show income and expenditure. Page 2 contains visualizations that analyze Accounts Payable. Page 3 contains visualizations on Accounts Receivable. Page 4 contains visualizations on Fixed Assets. You add a fifth page, home page.

How should you configure the home page to allow users to navigate to the report pages?
Solution:
• Add four buttons to the home page and set action type to Page navigation.
• Select the destination page for each button.
Does this solution meet the goal?

Select 1 option(s):

Yes

Q52. You create a Power Bl report.

You need to improve report navigation.
Which options should you use for the stated task?
“Add report navigation, so users can directly go to a specific report page”

Select 1 option(s):

Buttons

Bookmarks

Q53. You have a report page named Sales which contains visual A, showing total sales for each city for the selected year, as shown in the below exhibit.

Microsoft Power BI data visualization chart with year selection and sales data.

You need to configure an interaction for this visual. When clicking Drill through, it should redirect to a detail page that shows Sales for the selected city by Product Line and will preserve all the filters from the Sales page.
Which four actions should you perform? Each correct answer presents part of the solution.

Select 4 option(s):

On the Sales page, under the drill through option, set Keep all filters to On.

On the Sales page, under the drill through option, add City column as the drill through field.

Create a new page named Detail.

On the Detail page, under the drill through option, set Keep all filters to On.

Create a table visual named Visual B to show total sales by city and product line.

On the Detail page, under the drill through option, add City column as the drill through field.

Q54. You create a Power Bl report. The report has multiple pages with many visuals.

Users need to be able to view this report on their mobile devices.
You need to optimize the report for use on mobile devices.
Which two optimizations can you perform? Each correct answer presents a complete solution.

Select 2 option(s):

Set slicers to be responsive.

Set the page size.

Remove data labels.

Select and resize the visuals.

Apply a report theme.

Q55. You need to configure data alerts for a dashboard.

Which three visuals can be configured for data alerts? Each correct answer presents a complete solution.

Select 3 option(s):

Gauge visual

KPI visual

Matrix visual

Card visual

Line visual

Q56. You create a report page in Power BI.

You need to create a dashboard that will be simultaneously updated whenever the report page is updated.
What should you do?

Select 1 option(s):

Pin the report to a new dashboard as a live page.

Enable Persistent filters in report settings.

Create a new dashboard and pin each of the visuals from the report page as individual tiles.

Enable Dashboard tile flow in dashboard settings.

Q57. You create a Power Bl report to help users understand their data. You need to use the appropriate type of visualization for each of the requirements.

Which visualizations should you use for the below-stated requirement?
“Use scikit learn machine learning in visuals”

Select 1 option(s):

Python

Power Apps

Q58. What is the file format used to define a theme for a Power Bl report?

Select 1 option(s):

Power BI Markup Language (PBIML)

Cascading Style Sheets (CCS)

JavaScript Object Notation (JSON)

Extensible Markup Language (XML)

Q59. You create a Power Bl report to help users understand their data. You need to use the appropriate type of visualization for each of the requirements.

Which visualizations should you use for the below-stated requirement?
“Use JavaScript to create visuals”

Select 1 option(s):

Power Apps

Python

Q60. You create a report in Power Bl Desktop containing many visualizations.

You need to apply the fonts and colors to match your corporate standards. What should you do?

Select 1 option(s):

Customize the theme.

Set the Data colors on each visualization.

Set the font family on the page display settings.

Change the font on each visualization.

Q61. You have a dashboard tile that shows the manufacturing effciency using a card visual. The manufacturing effciency measure is formatted as a percentage. Your company requires a notification to be sent when effciency drops below 70 percent.

You need to configure email alerts to meet this requirement.
Which four actions should you perform? Each correct answer presents part of the solution.

Select 4 option(s):

Check the Send me email too checkbox and click Save and close.

Click the Save and close button.

Click the + Add alert rule button.

Choose Below in the Condition field and set the Threshold value to 0.7.

Choose Below in the Condition field and set the Threshold value to 70.

Choose More options on the Manufacturing efficiency card visual and click on Manage alerts.

Q62. You work on the new filter pane experience for a Power Bl report.

What can you achieve by using the new filter pane experience?
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
1. Hide specific filters from report consumers.
2. Lock specific filters so report consumers cannot edit them.
3. Disable the search for the Filters pane.

Select 1 option(s):

1. Yes 2. Yes 3. No

1. No 2. No 3. No

1. Yes 2. No 3. No

1. Yes 2. Yes 3. Yes

1. No 2. Yes 3. No

1. No 2. Yes 3. Yes

Q63. Months are sorted alphabetically in Stacked bar chart. What can you do to sort it by month number?

Select 1 option(s):

Right Click on field in report view and select sort by, then select MonthNumber

Click on ellipses on Right Top Corner of visual > Sort by - MonthNumber

Modeling > Select Month Column > Sort By - MonthNumber

Q64. Using the bookmarking features in the report designer in Power BI Desktop, there is a limitation of creating only one bookmark per page in a report.

Is this statement correct?

Select 1 option(s):

Yes