You have a Power BI semantic model named Model1 that runs in Import storage mode.
You need to reduce the size of Model1. The solution must NOT increase report query response times.
What should you do?
A. Remove unnecessary columns.
B. Unpivot unnecessary columns.
C. Rename unnecessary columns.
D. Change Model1 to DirectQuery storage mode.
Show Answer
Correct Answer: A
Explanation: Removing unnecessary columns directly reduces the VertiPaq in-memory footprint in Import mode without affecting query response times, since unused data is eliminated. Unpivoting increases rows, renaming has no size impact, and switching to DirectQuery can degrade performance.
Question 65
HOTSPOT
-
You have a Power BI semantic model named Model1.
You need to create a measure that will display the sales result for all blue units. The solution must maintain the existing filter context.
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.
Show Answer
Correct Answer: CALCULATETABLE
KEEPFILTERS
Explanation: CALCULATETABLE evaluates the expression in a modified filter context, and KEEPFILTERS applies the 'Unit'[Color] = "blue" condition without removing existing filters, preserving the current filter context.
Question 66
You have a Power BI semantic model named Model1 that contains two fields named Sales and Quarter. Model1 contains a DAX measure that sums the Sales column.
You need to create a report that will contain the visual shown in the following exhibit.
The solution must NOT require additional DAX measures.
Which type of visual should you use?
A. ribbon chart
B. line chart
C. 100% stacked area chart
D. area chart
Show Answer
Correct Answer: C
Explanation: The exhibit shows each segment’s contribution as a percentage of the total over time, with the Y-axis scaled from 0% to 100%. A 100% stacked area chart natively calculates and displays percentages by time (Quarter) using the existing Sales measure, without requiring additional DAX measures. Other visuals either show absolute values or do not enforce a 100% scale.
Question 67
You have a Power BI semantic model that contains a table named Table1. Table1 contains the following columns:
• WebsiteName
• URL
You need to create a report named Report1 that will contain a table visual. The solution must meet the following requirements:
• Display the website name.
• Enable users to navigate to the website's URL by selecting the website name.
What should you use?
A. data categories
B. Conditional Formatting
C. inline hierarchy labels
D. URL icons
Show Answer
Correct Answer: B
Explanation: To make the WebsiteName text clickable while navigating to a different column that stores the URL, you must use Conditional Formatting with the Web URL option on the WebsiteName field and base it on the URL column. Data categories only make the URL column itself clickable, not the WebsiteName text.
Question 68
You use Power BI Desktop to import two tables named Customer and Contacts.
The Customer table contains the following columns:
• Customer_Name
• Customer ID
• Website
The Contacts table contains the following columns:
• Contact ID
• Contact Email
• Contact Name
• Customer Name
A web-based contact form is used to fill the Contacts table. The data is not sanitized.
You need to create a merge for the Customer and Contacts tables.
What should you do?
A. Disable fuzzy matching.
B. Enable fuzzy matching.
C. Set Join Kind to Left Outer.
Show Answer
Correct Answer: B
Explanation: The Contacts table is populated via a web-based form and the data is not sanitized, so the Customer Name values may contain typos, inconsistent casing, extra spaces, or slight variations. An exact match merge would fail to align many related records. Enabling fuzzy matching in Power Query allows approximate text matching, making it appropriate for merging Customer and Contacts based on inconsistent customer names.
Question 69
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 decrease the dashboard cache update frequency.
Does this meet the goal?
A. Yes
B. No
Show Answer
Correct Answer: B
Explanation: In Import storage mode, data passes through the on-premises data gateway only during dataset refresh operations (scheduled or manual). The dashboard cache update frequency only controls how often dashboard visuals are refreshed from the already imported dataset in the Power BI service. It does not change the volume or frequency of data transferred through the gateway. Therefore, decreasing the dashboard cache update frequency does not meet the goal.
Question 70
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 create aggregations to summarize results.
Does this meet the goal?
A. Yes
B. No
Show Answer
Correct Answer: B
Explanation: In Import storage mode, the on‑premises data gateway is used only during data refresh to pull the full dataset from the source. Creating aggregations in the semantic model summarizes data after it has already been imported and does not reduce the volume of data transferred through the gateway during refresh. Aggregations mainly improve query performance, not gateway data transfer, so the goal is not met.
Question 71
You have a Power BI semantic model that contains two queries.
You discover that a report based on the model has performance issues.
You plan to use Power Query to reduce the data loaded to the model.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct answer is worth one point.
A. Apply group by and summarize techniques.
B. Combine the queries by using Append.
C. Remove unnecessary columns and rows.
D. Combine the queries by using Merge.
E. Create a new query group.
Show Answer
Correct Answer: A, C
Explanation: To reduce the amount of data loaded into a Power BI semantic model using Power Query, you should focus on data reduction techniques. Applying Group By and summarization reduces row cardinality by aggregating data before it reaches the model. Removing unnecessary columns and rows reduces both column and row counts, lowering memory usage and improving report performance. Appending or merging queries reshapes data but does not inherently reduce its volume, and query groups are only for organization.
Question 72
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 applies to DirectQuery or live connections and controls how often visuals re-query the source. Import-mode semantic models use cached data and send data through the on-premises gateway only during dataset refresh, not page refresh. Increasing automatic page refresh intervals therefore does not reduce gateway data transfer for Import mode.
Question 73
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: Incremental refresh in Import mode refreshes only new or changed data partitions instead of reloading the entire dataset. This reduces the volume of data that must pass through the on-premises data gateway during refresh operations, meeting the goal.
$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.
