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 used in any required analysis, so it can be removed. ProductID is required to relate Sales to Product for all analyses by product. ShipDate is not used because all time-based analysis is based on the order date.
Question 173
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: The report uses an imported dataset with a large fact table (12 million rows) and a very large PBIX size (550 MB) in shared capacity, which directly affects visual query performance. Removing unused columns reduces the in-memory model size, improves compression, lowers scan costs during DAX query execution, and speeds up visual rendering. AppSource visuals are generally slower than default visuals, RLS does not improve performance, and enabling visual interactions can add overhead rather than reduce it.
Question 174
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 occurs due to long-running queries or timeouts while loading data from SQL Server. Reducing the number of rows and columns returned (A) lowers the amount of data processed and transferred, shortening execution time. Splitting long-running queries into subsets of columns and then merging them in Power Query (B) breaks a large, slow query into smaller, faster ones that are less likely to time out. Combining queries (C) would worsen the problem, and disabling query folding (D) typically reduces optimization and can increase execution time.
Question 175
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: Background color conditional formatting must be configured on the Revenue column. Using the Rules format style allows mapping specific numeric ranges to fixed hex colors, which are then defined by adding a rule for each range.
Question 176
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: The requirement is to let users switch measures, change visual types, and add legends for all three visuals while minimizing development effort. Power BI’s Personalize visuals feature allows end users to modify measures, visualization types, and legends without creating bookmarks or duplicate visuals. Enabling personalization at the report level applies to all visuals at once, requiring a single configuration step and therefore the least development effort. Other options either don’t provide the required capabilities or require significantly more manual setup.
Question 177
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: To reuse consistent corporate branding (fonts, colors, visual formatting) across multiple Power BI reports, the theme must be portable. Power BI supports reusable themes through JSON files, which can define detailed formatting such as bar chart styles and fonts. Once created, the JSON theme can be imported into any report. Customizing the current theme alone applies only to a single report unless exported, and PBIVIZ files are for custom visuals, not report themes.
Question 178
You have a Power BI report that contains five pages.
Pages 1 to 4 are visible and page 5 is hidden.
You need to create a solution that will enable users to quickly navigate from the first page to all the other visible pages. The solution must minimize development and maintenance effort as pages are added to the report.
What should you do first?
A. Add a blank button to page 1.
B. Add a page navigation button to page 1.
C. Create a bookmark for each page.
D. Add a bookmark navigation button to page 1.
Show Answer
Correct Answer: B
Explanation: A Page Navigation button automatically generates links to all visible report pages and updates itself as pages are added or removed. By inserting it on page 1 and turning off "Show hidden pages," users can quickly navigate to pages 2–4 while excluding the hidden page. This approach minimizes development and ongoing maintenance compared to manually creating buttons or bookmarks for each page.
Question 179
HOTSPOT
-
You have the Power BI data model shown in the following exhibit.
You need to create a measure to count the number of product categories that had products sold during a selected period.
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.
Explanation: DISTINCTCOUNT counts unique product categories. Using 'Sales' as the filter argument in CALCULATE ensures only categories with at least one related sales record are counted, while the selected period is applied automatically via the Date–Sales relationship.
Question 180
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
From Power Query Editor, you profile the data shown in the following exhibit.
The IoT GUID and IoT ID columns are unique to each row in the query.
You need to analyze IoT events by the hour and day of the year. The solution must improve dataset performance.
Solution: You create a custom column that concatenates the IoT GUID column and the IoT ID column and then delete the IoT GUID and IoT ID columns.
Does this meet the goal?
A. Yes
B. No
Show Answer
Correct Answer: B
Explanation: Concatenating IoT GUID and IoT ID does not help analyze events by hour or day of year, nor does it improve performance for that goal. The requirement is to derive time-based attributes (hour, day of year) from the DateTime column. Additionally, in Power Query, concatenating text (GUID) and numeric (ID) columns without explicit type conversion results in errors. Therefore, the solution does not meet the stated goal.
Question 181
HOTSPOT
-
You have two Power BI workspaces named WorkspaceA and WorkspaceB. WorkspaceA contains two datasets named Sales and HR.
You need to provide a user named User1 with access to the WorkspaceB. The solution must meet the following requirements:
• Create reports that use the HR dataset.
• Publish the reports to WorkspaceB.
• Prevent the ability to modify the HR dataset.
• Prevent the ability to add users to Workspaces.
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: Grant User1 the Build permission for the HR dataset.
Assign User1 the Contributor role for WorkspaceB.
Explanation: Build permission allows creating reports using the HR dataset without modifying it. The Contributor role on WorkspaceB allows publishing reports while preventing user management and dataset modification.
$19
Get all 356 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.
