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.
You have an on-premises data gateway.
You need to reduce the amount of data sent through the gateway by semantic models that run in import storage mode.
Solution: You increase Automatic page refresh intervals.
Does this meet the goal?
A. Yes
B. No
Show Answer
Correct Answer: B
Explanation: Automatic page refresh is a report feature intended for DirectQuery and some live connection scenarios, not Import mode semantic models. For Import mode, gateway traffic is driven by dataset refresh operations, so increasing automatic page refresh intervals does not reduce data sent through the on-premises data gateway.
Question 83
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.
You have an on-premises data gateway.
You need to reduce the amount of data sent through the gateway by semantic models that run in import storage mode.
Solution: You configure incremental refresh.
Does this meet the goal?
A. Yes
B. No
Show Answer
Correct Answer: A
Explanation: Yes. Incremental refresh for Import-mode semantic models refreshes only new or changed partitions (based on the configured date/time policy) instead of re-importing the entire dataset. This reduces the volume of data retrieved from the on-premises data source and therefore the amount of data sent through the on-premises data gateway during refresh.
Question 84
HOTSPOT
-
You are designing the data model for a Power BI semantic model.
You have the following tables in the star schema.
Which table is the fact table of the star schema, and which column in the Patient table is the surrogate key of the star schema? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Show Answer
Correct Answer: Fact table: Test Result
Surrogate key: Patient key
Explanation: The Test Result table stores transactional events with foreign keys to dimensions and a measurable value, making it the fact table. In the Patient dimension, Patient key is the unique surrogate identifier, while Patient source ID is the business/natural key.
Question 85
HOTSPOT
-
You have a Power BI semantic model named ModelA that contains the following columns:
All of the columns use the Text data type.
Based on the model, you create a report named ReportA that contains the following columns:
• OrderID
• OrderDate
• CustomerID
• ShippingAddress
ReportA is the only report connected to ModelA.
You discover that ReportA has performance issues caused by the size of ModelA.
What should you do to optimize and reduce the size of ModelA? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Show Answer
Correct Answer: Optimize: Change Data Type of OrderID to Whole Number.
Reduce the size: Delete the OrderTitle and OrderDescription columns.
Explanation: Using a Whole Number for numeric IDs improves storage efficiency and query performance compared to Text. Since the report only uses OrderID, OrderDate, CustomerID, and ShippingAddress, removing unused OrderTitle and OrderDescription columns reduces the semantic model size.
Question 86
You use Power Query Editor to preview a column named Date as shown in the following exhibit.
You need to change the Date column to contain only the year. The solution must minimize administrative effort.
What should you do?
A. Split the column by delimiter.
B. Split the column by number of characters.
C. Extract the text after the delimiter.
D. Transform the column to contain only the year.
Show Answer
Correct Answer: D
Explanation: If the column is already of the Date data type in Power Query, the built-in Transform > Date > Year operation extracts the year directly. This is the simplest approach and minimizes administrative effort compared with splitting text or extracting by delimiters, which are intended for text manipulation and require unnecessary steps.
Question 87
You have a Power BI app that contains a report named Report1.
You add a new page to Report1.
You need to ensure that users can view the new page. The solution must minimize administrative effort.
What should you do?
A. Update the audience in the app.
B. Update the app.
C. Update the contact information in the app.
D. Unpublish and create a new app.
Show Answer
Correct Answer: B
Explanation: Adding a new page to a report in a published Power BI app does not automatically make it available to app users. You must update (republish) the app so the latest version of the report is included. Updating the audience or contact information does not publish content changes, and unpublishing/recreating the app is unnecessary and increases administrative effort.
Question 88
You have a Power BI report that contains the visual shown in the following exhibit.
You need to make the visual more accessible to users who have color vision deficiency.
What should you do?
A. Change the font color of values in the Sales column to white.
B. Change the red background color to orange.
C. Add additional measures to the table values.
D. Add icons to represent the sales status of each product.
Show Answer
Correct Answer: D
Explanation: Accessibility guidance recommends not relying on color alone to communicate meaning. Adding icons provides an additional visual cue that users with color vision deficiency can interpret regardless of the background color. Changing colors or font colors still relies on color perception, and adding measures does not directly improve accessibility for color vision deficiency.
Question 89
HOTSPOT -
You use Power Query Editor to preview the data in a column named Resource Location.
The column statistics and value distributions of Resource Location appear as 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.
Show Answer
Correct Answer: 0
US East
Explanation: In Power Query column statistics, 'Unique' is the count of values appearing exactly once; it is 0. The value distribution chart shows 'US East' with the largest bar, so it is the most frequent value.
Question 90
You publish a semantic model to the Power BI service. The semantic model contains data from the following data sources:
• Source1: A Microsoft Excel file stored in Microsoft OneDrive for Business
• Source2: An Azure SQL database on a virtual network
• Source3: A public website
Which data sources require an on-premises data gateway?
A. Source1 only
B. Source2 only
C. Source3 only
D. Source1 and Source2 only
E. Source2 and Source3 only
F. Source1, Source2, and Source3
Show Answer
Correct Answer: B
Explanation: Only the Azure SQL database hosted inside a virtual network requires a gateway because the Power BI service cannot directly reach data sources isolated within a private network. An Excel file stored in OneDrive for Business is a cloud-hosted source that Power BI can access directly, and a publicly accessible website is also reachable without a gateway.
Question 91
HOTSPOT
-
You have a Power BI workspace that contains a semantic model and a report named Sales report.
All users in the sales department are assigned the Viewer role for the workspace.
The Sales report is configured as shown in the Sales report exhibit. (Click the Sales report tab.)
From Power BI Desktop, you configure the Report settings as shown in the Report settings exhibit. (Click the Report settings tab.)
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
No
Explanation: Personalize visuals is enabled, so viewers can change supported visual types. Viewer role cannot reshare reports or personalized views outside the workspace. Personalize Visuals does not allow creating new quick measures or modifying the semantic model.
$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.
