DRAG DROP
-
You use Power Query Editor to import three tables named Customers, Address, and Country.
In the source system, not every customer has a related address, but every address has a related country.
You need to merge all the tables into a single query. The solution must optimize query refresh performance.
Which type of join should you use for each merge operation? To answer, drag the appropriate join types to the correct operations. Each join type 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: Join Customers with Address: Left outer
Join Address with Country: Inner
Explanation: Use a Left Outer join to retain all customers even when some have no address. Use an Inner join between Address and Country because every address has a matching country, making it the most efficient choice without losing data.
Question 113
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 Power BI report that imports a date table and a sales table from an Azure SQL database data source. The sales table has the following date foreign keys:
• Due Date
• Order Date
• Delivery Date
You need to support the analysis of sales over time based on all the date foreign keys.
Solution: You create measures that use the USERELATIONSHIP DAX function to filter sales on the inactive relationship between the sales table and the date table.
Does this meet the goal?
A. Yes
B. No
Show Answer
Correct Answer: A
Explanation: Yes. In Power BI, only one relationship between the Sales table and the Date table can be active at a time. Additional relationships (such as Due Date and Delivery Date) are typically created as inactive. Measures can use the USERELATIONSHIP DAX function within CALCULATE to temporarily activate an inactive relationship, enabling analysis by the desired date key.
Question 114
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: Use IF(HASONEVALUE('Item'[Item]), RANKX(..., DENSE)) so totals or unfiltered item contexts return BLANK, and DENSE ranking avoids gaps when quantities are tied.
Question 115
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 by itself does not resolve undefined values or errors caused by case-sensitive data. While switching away from DirectQuery may enable additional transformation capabilities, the stated solution is only to change the model mode, not to clean or transform the data. Therefore, the proposed solution does not, by itself, meet the goal.
Question 116
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/Fabric are assigned to users or supported Microsoft Entra groups, not to reports, dashboards, workspaces, or Teams. Among the options, Group2 is the supported group type for RLS role membership, whereas a Microsoft Teams team and a report are not valid role members, and Microsoft 365 groups are not supported for RLS role assignment.
Question 117
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: B
Explanation: For Azure DevOps Services (cloud), the dedicated Azure DevOps (Boards only) connector is the connector designed to consume Analytics Views. It authenticates to Azure DevOps, lists available Analytics Views, and supports server-side filtering through those views. The Server connector is for on-premises Azure DevOps Server, while OData Feed is the generic connector used for raw Analytics OData endpoints rather than the dedicated Analytics Views experience. 'OData queries' is not a Power BI connector.
Sources:
https://www.middleway.eu/how-to-use-azure-devops-data-within-powerbi
https://learn.microsoft.com/en-us/azure/devops/report/powerbi/access-analytics-excel?view=azure-devops
Question 118
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: Private prevents sensitive data from being folded into other data sources. Organizational allows sharing only within the organization and is appropriate for internal, less sensitive data.
Question 119
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 use a visual's alt text to announce information. To keep the announced year-to-date revenue current after dataset refreshes, populate the alt text dynamically using conditional formatting bound to a DAX measure. A static alt text would become outdated, and converting the card to a text box or placing the value in the title does not provide the intended dynamic accessibility behavior.
Question 120
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: Configure the report page's tab order. In Power BI, tab order defines the sequence in which visuals and interactive objects receive keyboard focus when users press the Tab key. Screen readers also follow this navigation order, allowing content to be consumed in a logical sequence. Layer order, X position, and bookmark order do not control accessible keyboard navigation.
Question 121
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: Since the data always begins on row 3, remove the first two rows so row 3 becomes the first row, then promote that first row to column headers.
$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.
