In Power BI Desktop, you are creating a report that will contain three pages.
You need to create a custom tooltip page and prepare the page for use.
Which three actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
A. For the tooltip page, set Allow use as tooltip to On.
B. For the target page, set Allow use as tooltip to On.
C. Configure filters on the target visual.
D. For the tooltip page, configure filters.
E. Add and configure visuals on the tooltip page.
Show Answer
Correct Answer: A, D, E
Explanation: To prepare a custom tooltip page in Power BI Desktop, you must designate the tooltip page as usable for tooltips, add and configure the visuals that will appear in the tooltip, and configure the tooltip page's filters/tooltip fields so it responds to the hovered data context. Enabling 'Allow use as tooltip' applies to the tooltip page, not the report page that displays the visual. Configuring filters on the target visual is not a required preparation step for creating the tooltip page.
Question 163
DRAG DROP
-
You have the Power BI data model shown in the following exhibit.
The Country table contains the following data.
You create two row-level security (RLS) roles named Manager and CFO.
You plan to publish the dataset to the Power BI service.
You need to create DAX expressions for the RLS filters. The solution must meet the following requirements:
• Each manager must see only the data in the Sales and Human Resources tables for their own country.
• The CFO must be prevented from seeing the data in the Human Resources table.
• The CFO must see the sales data of all countries.
How should you complete the DAX expressions to meet the requirements? To answer, drag the appropriate expressions to the correct targets. Each expression 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.
Show Answer
Correct Answer: Human Resources: False()
Country: [Email] = USERPRINCIPALNAME()
Explanation: Use a Country table filter based on the signed-in user's email to restrict managers to their own country through relationship propagation. For the CFO role, apply False() on the Human Resources table to block all HR rows while leaving Sales unrestricted, allowing all sales data.
Question 164
HOTSPOT
-
You have the Azure SQL databases shown in the following table.
You plan to build a single PBIX file to meet the following requirements:
• Data must be consumed from the database that corresponds to each stage of the development lifecycle.
• Power BI deployment pipelines must NOT be used.
• The solution must minimize administrative effort.
What should you do? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Show Answer
Correct Answer: Create: One parameter
Parameter type: Text
Explanation: A single text parameter (values such as dev, uat, prod) can be concatenated into both the server URL and database name because they share the same environment suffix. This allows one PBIX to switch environments with minimal administration and without deployment pipelines.
Question 165
You have a Power BI report that contains four pages.
All the pages contain a slicer for a field named Country.
You need to ensure that when a user selects a country on page 1, the selection is retained on page 2 and page 3. The solution must prevent page 4 from being affected by selections on the other pages.
What should you do?
A. Remove the Country slicer from page 1, page 2, and page 3. Add the Country field to the page-level filters.
B. Remove the Country slicer from page 1, page 2, and page 3. Add the Country field to the report-level filters.
C. Move the Country slicer from page 2 and page 3 to page 1.
D. Sync the Country slicer on page 1, page 2, and page 3.
Show Answer
Correct Answer: D
Explanation: Use Sync slicers to synchronize the Country slicer across only pages 1, 2, and 3. This preserves the selected country when navigating between those pages while excluding page 4 from the synchronization, so it remains unaffected. Page-level filters apply only to one page, report-level filters affect all pages, and moving slicers does not synchronize filter state.
Question 166
You are creating a query to be used as a Country dimension in a star schema.
A snapshot of the source data is shown in the following table.
You need to create the dimension. The dimension must contain a list of unique countries.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
A. Delete the Country column.
B. Remove duplicates from the table.
C. Remove duplicates from the City column.
D. Delete the City column.
E. Remove duplicates from the Country column.
Show Answer
Correct Answer: D, E
Explanation: To build a Country dimension, keep only the Country attribute and ensure it contains unique country values. Deleting the City column removes an unnecessary attribute. Removing duplicates based on the Country column produces one row per country regardless of how many cities exist. Removing duplicates from the entire table would only work if City were removed first, making it order-dependent, whereas removing duplicates on the Country column is order-independent for the intended result.
Question 167
You have a Power BI data model that imports data from a Microsoft Excel spreadsheet.
You use Power Query to load a query that contains both renamed and custom columns.
Later, you attempt to reload the query and receive the following error message.
Expression.Error: The column 'Category' of the table wasn't found.
What are two possible causes of the error? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
A. The column was removed from the source file.
B. The column was renamed in the source file.
C. The file is no longer in the specified location.
D. The data type of the column was changed.
Show Answer
Correct Answer: A, B
Explanation: A 'column wasn't found' error in Power Query occurs when a query step references a column name that no longer exists. This happens if the column was removed from the source or its name was changed. If the file were missing, the error would indicate a file/path issue rather than a missing column. A data type change does not make the column disappear; it would typically produce a type conversion error instead.
Question 168
You have a Power BI data model that contains a table named Employees. The table has the following columns:
• Employee Name
• Email Address
• Start Date
• Job Title
You are implementing dynamic row-level security (RLS).
You need to create a table filter to meet the following requirements:
• Users must see only their own employee data.
• The DAX expression must work in both Power BI Desktop and the Power BI service.
Which expression should you use?
A. [Email Address] - USERNAME()
B. [Employee Name] - USERPRINCIPALNAME()
C. [Employee Name] = USERNAME()
D. [Email Address] = USERPRINCIPALNAME()
Show Answer
Correct Answer: D
Explanation: Dynamic RLS should compare a unique user identifier stored in the model to the current user's identity. The Email Address column is the appropriate unique key, and USERPRINCIPALNAME() returns the user's UPN (typically their email address) in both Power BI Desktop and the Power BI service, making it suitable for this scenario. Options using Employee Name are not reliable identifiers, and option A is invalid as written because it uses the subtraction operator instead of an equality comparison.
Question 169
You have a Power BI report named Report1 and a dashboard named Dashboard1. Report1 contains a line chart named Sales by month.
You pin the Sales by month visual to Dashboard1.
In Report1, you change the Sales by month visual to a bar chart.
You need to ensure that the bar chart displays on Dashboard1.
What should you do?
A. Refresh the dataset used by Report1 and Dashboard1.
B. Pin the Sales by month bar chart to Dashboard1.
C. Select Refresh visuals for Dashboard1.
D. Edit the details for the dashboard tile of Dashboard1.
Show Answer
Correct Answer: B
Explanation: Pinned report visuals on a Power BI dashboard retain their visualization type. Refreshing the dataset or dashboard updates the data but does not change a pinned tile from a line chart to a bar chart. To display the new visualization type, you must pin the updated bar chart to the dashboard.
Question 170
You have a Power BI report that contains a page. The page contains the following:
• A shape named Shape1
• A card named Sales Summary
• A clustered bar chart named Sales by Region
You need to ensure that Sales Summary renders on top of Shape1.
What should you modify?
A. Tab order in the Selection pane
B. Layer order in the Selection pane
C. Maintain layer order in the General visual settings
D. Vertical alignment in the Canvas settings
Show Answer
Correct Answer: B
Explanation: To control which visual appears on top of another on a Power BI report page, you adjust the layer (stacking) order in the Selection pane. Moving the Sales Summary card above Shape1 in the layer order ensures it renders on top.
Question 171
You plan to use Power BI to create sales invoices for customers. The solution must meet the following requirements:
• Sales invoices must be exported in a PDF format.
• The PDF exports must show all columns and rows clearly.
What should you create?
A. a paginated report that contains a tablix
B. a dashboard that contains a table
C. an interactive report that contains a table
D. an interactive report that contains a matrix
Show Answer
Correct Answer: A
Explanation: Paginated reports are designed for pixel-perfect, printable documents such as invoices. They support PDF export with all rows and columns rendered clearly across pages. A tablix data region is the standard report item used to display tabular or matrix data in paginated reports.
$19
Get all 369 questions with detailed answers and explanations
Instant download HTML + PDF delivered the moment payment clears.
Secure Stripe checkout we never see or store your card details.
7-day refund if files are defective see our refund policy.
