HOTSPOT -
You have a Power BI semantic model that contains a table named Item. The Item table contains a column named Quantity.
You need to create a DAX query that meets the following requirements:
• The rank of items must be calculated according to the values in Quantity.
• Ranking must NOT be skipped if two or more items have the same value in Quantity.
• If an item is unfiltered, the total of Quantity must display a blank value.
How should you complete the DAX formula? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Show Answer
Correct Answer: HASONEVALUE
DENSE
Explanation: HASONEVALUE ensures the rank is returned only when a single item is in context, so totals or unfiltered contexts return BLANK. Using DENSE in RANKX assigns the same rank to equal Quantity values without skipping subsequent ranks.
Question 106
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 a data source that contains a column. The column contains case sensitive data.
You have a Power BI semantic model in DirectQuery mode.
You connect to the model and discover that it contains undefined values and errors.
You need to resolve the issue.
Solution: You change the semantic model mode.
Does this meet the goal?
A. Yes
B. No
Show Answer
Correct Answer: B
Explanation: Changing the semantic model mode (for example, from DirectQuery to Import) does not by itself resolve undefined values or errors caused by data quality or case-sensitive values in the source. Those issues must be fixed by cleaning or transforming the data or addressing the source logic. Therefore, simply changing the model mode does not meet the goal.
Question 107
You have a Microsoft 365 subscription that contains the resources shown in the following table.
You create a new dashboard that uses row-level security (RLS) filters. You define a new role named Consultants.
To which resource can you assign the Consultants role?
A. Group2
B. Team1
C. Sales reports
D. Group1
Show Answer
Correct Answer: A
Explanation: Row-level security (RLS) roles in Power BI can be assigned to users or supported group types such as Microsoft Entra security groups, distribution groups, and mail-enabled security groups. Microsoft 365 groups and Teams aren’t supported for RLS role assignment, and roles aren’t assigned to reports or workspaces. Group2 is the supported group type, so it can be assigned the Consultants role.
Question 108
You plan to use Power BI Desktop to create a bug tracking dashboard that will pull data from Analytics in Azure DevOps.
From Power BI Desktop, you need to configure a data connector to authenticate to Azure DevOps. The solution must meet the following requirements:
• Use Analytics views.
• Filter data from the cloud.
Which connector should you use?
A. OData queries
B. Azure DevOps (Boards only)
C. Azure DevOps Server (Boards only)
D. OData Feed
Show Answer
Correct Answer: D
Explanation: Azure DevOps Analytics views are exposed via OData endpoints. To both use Analytics views and apply server-side (cloud) filtering, Power BI Desktop must connect using the **OData Feed** connector, which supports querying and filtering data at the source. The Azure DevOps (Boards only) connector is limited and does not support Analytics views or effective cloud-side filtering.
Question 109
HOTSPOT
-
You have a Power BI semantic model that contains the data sources shown in the following table.
You need to configure the privacy level s of the data sources.
What should you configure for each data source? To answer, select the appropriate options in the answer area.
NOTE: Each correct answer is worth one point.
Explanation: Employee review data contains sensitive information and must not be combined with other sources, so it requires the highest privacy level (Private). Sales opportunities data is less sensitive but restricted to internal use, which corresponds to the Organizational privacy level.
Question 111
You have a Power BI report that contains a card. The card displays the value for year-to-date revenue.
You need to ensure that screen reader users can read the value when initially interacting with the card. The value must stay updated as the dataset is refreshed.
What should you do?
A. Convert the card into a text box.
B. Add the value to the chart title text.
C. Populate the alt text with a static value.
D. Populate the alt text by using conditional formatting with a DAX measure.
Show Answer
Correct Answer: D
Explanation: Screen readers rely on a visual’s alt text to announce its content. A static alt text would not update when the dataset refreshes, and other options do not guarantee accessibility on initial interaction. By using conditional formatting on the alt text with a DAX measure, the card’s year-to-date revenue value is dynamically inserted and kept up to date, ensuring screen reader users hear the current value.
Question 112
You are creating a Power BI single-page report.
Some users will navigate the report by using a keyboard, and some users will navigate the report by using a screen reader.
You need to ensure that the users can consume content on a report page in a logical order.
What should you configure on the report page?
A. the layer order
B. the X position
C. the bookmark order
D. the tab order
Show Answer
Correct Answer: D
Explanation: To ensure that keyboard users and screen reader users can consume report content in a logical sequence, you must configure the tab order on the report page. Tab order controls the sequence in which visuals and objects receive focus when users navigate using the Tab key, and it also influences how screen readers traverse the page. Layer order, X position, and bookmarks do not define keyboard or assistive-technology navigation flow.
Question 114
HOTSPOT
-
You use Power Query Editor to preview the data shown in the following exhibit.
You confirm that the data will always start on row 3, and row 3 will always contain the column names.
How should you shape the query? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Show Answer
Correct Answer: Remove top rows
Use first row as headers
Explanation: Rows 1–2 are non-data, so removing the top rows makes row 3 the first row. Then the values in that row can be promoted to column headers using the first-row-as-headers option.
Question 116
HOTSPOT -
You use Power Query Editor to pull data from a Microsoft SharePoint Online list.
You plan to use Advanced Editor to build a Power Query M formula language query.
You need to create a query that loads the data, expands a column named location, and hides a column named CountryOrRegion from the dataset.
How should you complete the query? To answer, select the appropriate options in the answer area.
NOTE: Each correct answer is worth one point.
Explanation: The SharePoint Location column is a record, so it is expanded with Table.ExpandRecordColumn. To hide a field from the final dataset, the column is removed using Table.RemoveColumns.
Question 118
DRAG DROP
-
You plan to use Power BI to create a quarterly profit report that meets the following requirements:
• Emphasizes the percentage of total profits contributed by each product category in dollars and as a percentage
• Compares profit margins across sales regions
Which type of visual should you use for each requirement? To answer, drag the appropriate visuals to the correct requirements. Each visual 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: Emphasizes the percentage of total profits contributed by each product category:
Pie chart
Compares profit margins across sales regions:
Stacked bar chart
Explanation: A pie chart highlights part-to-whole contributions as percentages of total profit, while a stacked bar chart enables clear comparison of profit margins across different sales regions.
$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.
