DRAG DROP -
You have a Power BI report that contains five bookmarks.
You need to add an object to the report from which users can navigate between three specific bookmarks.
How should you complete the task? To answer, drag the appropriate actions to the correct steps. Each action 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: Second step: Group the three bookmarks.
Third step: Change the Bookmark property for the button.
Explanation: A Bookmark navigator can be configured to display only a bookmark group. Create the group containing the three desired bookmarks, then set the navigator's Bookmark property to that group.
Question 173
You have a Power BI model that contains a table named Sales. The Sales table contains the following columns:
• Order Line ID
• Product ID
• Unit Price
• Order ID
• Quantity
Orders are uniquely identified by using the order ID and can have multiple order lines. Each order line within an order contains a different product ID.
You need to write a DAX measure that counts the number of orders.
Which formula should you use?
A. Count('Sales'[Order ID])
B. CountA('Sales' [Order ID])
C. CountRows('Sales')
D. DistinctCount('Sales' [Order ID])
Show Answer
Correct Answer: D
Explanation: Each row represents an order line, and an order can have multiple order lines with the same Order ID. Counting rows or counting Order ID values would count order lines, not unique orders. DISTINCTCOUNT on the Order ID returns the number of unique orders.
Question 174
DRAG DROP
-
You have a Power BI report that contains three pages. The pages are used to analyze sales across various countries.
You add a slicer named Country to each page of the report.
You need to configure the report to meet the following requirements:
• When a user selects a country on the first page, the report must filter the other pages.
• The second and third pages must display only the filtered results.
Which task should you perform for each requirement? To answer, drag the appropriate task to the correct requirement. Each task 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: When a user selects a country on the first page, the report must filter the other pages:
Configure the Country slicer to sync across all the pages
The second and third pages must display only the filtered results:
Hide the Country slicer on the second and third pages
Explanation: Use Sync slicers so a selection on page 1 propagates to pages 2 and 3. In the Sync slicers pane, keep the slicer synchronized but hide it on pages 2 and 3 so they only display the filtered data without exposing the slicer.
Question 175
DRAG DROP -
You use Power BI Desktop to create a Power BI data model and a blank report.
You need to add the Word Cloud visual shown in the following exhibit to the report.
The solution must minimize development effort.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
Show Answer
Correct Answer: 1. From Power BI Desktop, get the Word Cloud visual from Microsoft AppSource.
2. Populate the Category, Value, and Excludes fields.
3. Format the data colors and title.
Explanation: The Word Cloud is a custom visual that can be imported directly from AppSource within Power BI Desktop. After adding it, bind the required fields (Category, Value, Excludes), then apply formatting such as colors and the title to match the desired appearance.
Question 176
HOTSPOT
-
You have the Power BI data model shown in the following exhibit.
The Sales table has the following columns.
The data model must support the following analysis:
• Total sales by product by month in which the order was placed
• Quantities sold by product by day on which the order was placed
• Number of sales transactions by quarter in which the order was placed
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Show Answer
Correct Answer: Yes
No
Yes
Explanation: LastUpdated is not required for the stated analyses. ProductID is required to relate Sales to Product for analysis by product. ShipDate is not needed because all required time analysis uses OrderDate.
Question 177
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. Implement row-level security (RLS).
B. Remove unused columns from tables in the data model.
C. Replace the default visuals with AppSource visuals.
D. Enable visual interactions.
Show Answer
Correct Answer: B
Explanation: Removing unused columns reduces the imported model size and memory footprint, improving query execution and visual rendering performance. Replacing default visuals with AppSource visuals would generally not improve performance; AppSource visuals are often slower. RLS is for security, not performance optimization, and enabling visual interactions can increase, not reduce, work during interactions.
Question 178
You use Power BI Desktop to load data from a Microsoft SQL Server database.
While waiting for the data to load, you receive the following error.
You need to resolve the error.
What are two ways to achieve the goal? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
A. Reduce the number of rows and columns returned by each query.
B. Split log running queries into subsets of columns and use Power Query to merge the queries.
C. Use Power Query to combine log running queries into one query.
D. Disable query folding on long running queries.
Show Answer
Correct Answer: A, B
Explanation: The error is consistent with a query timeout or excessively long-running data retrieval. Reducing the number of rows and columns decreases the amount of data SQL Server must return, improving execution time. Splitting a large query into smaller queries and merging them later in Power Query can also reduce the workload of each individual query. Combining long-running queries into one typically increases execution time, and disabling query folding usually hurts performance because transformations are no longer pushed down to SQL Server.
Question 179
DRAG DROP
-
You have a Power BI report that contains a table visual with a measure named Revenue. The Revenue measure returns values within a range of 0 to 5.
You need to format the visual so that the Revenue column displays a specific background color based on the value range shown in the following table.
Which three actions should you perform in sequence in Power BI Desktop? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
Show Answer
Correct Answer: Open the Background color dialog for the Revenue column.
Set Format style to Rules.
Add and configure a new rule for each value range.
Explanation: To apply specific background colors for defined numeric ranges in a Power BI table visual, use Conditional formatting on the Background color, choose the Rules format style, then define each value range with its corresponding color.
Question 180
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.
C. Enable personalization for the report.
D. Enable personalization for each visual.
Show Answer
Correct Answer: C
Explanation: Enable report personalization. Personalize visuals allows users to change the visual type, swap measures/fields, and add or remove fields such as legends. Since all three visuals on the report page require this capability, enabling personalization for the report satisfies the requirement with the least development effort. Bookmarks would require many combinations, editing interactions is unrelated, and enabling per visual involves additional configuration compared with enabling it once at the report level.
Question 181
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.
Show Answer
Correct Answer: D
Explanation: Power BI report themes intended for reuse across multiple reports are defined as JSON theme files. A JSON theme can specify corporate branding such as colors, fonts, text sizes, and formatting defaults for visuals (including bar charts), and can be imported into any report in Power BI Desktop. PBIVIZ files are for custom visuals, built-in themes do not represent custom corporate branding, and customizing the current theme alone is not the reusable artifact unless exported as JSON.
$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.
