DRAG DROP
-
You have a Power BI semantic model that contains two tables named Dim Location and Fact Deliveries. The relationships between the tables are configured as shown in the following table.
The model contains one measure that has the following formula.
Deliveries = COUNTROWS(‘Fact Deliveries’)
You need to create a new measure that counts the number of deliveries based on the destination location.
How should you complete the DAX expression? To answer, drag the appropriate functions to the correct targets. Each function 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.
Explanation: Use CALCULATE to change filter context for the existing measure, and USERELATIONSHIP to activate the inactive relationship to Destination Location ID while evaluating the count.
Question 23
You have a Microsoft Fabric eventhouse named Eventhouse1 that contains high-velocity and high-volume data from IoT devices.
Eventhouse1 can be queried to deliver data to reports in near-real-time (NRT).
You plan to use Power BI Desktop to create a report that will contain both historical and live data.
You need to connect to Eventhouse1. The solution must minimize development effort.
What should you do?
A. Build a composite model.
B. Use DirectQuery connectivity mode.
C. Use Import connectivity mode.
Show Answer
Correct Answer: A
Explanation: The report must include both historical data and near-real-time (live) data from the same Eventhouse while minimizing development effort. A composite model is specifically designed for this scenario: it allows historical data to be handled in Import mode for better performance, while live or near-real-time data is accessed via DirectQuery without additional complex design. Using only DirectQuery would not optimize historical data performance, and Import mode alone cannot support live data. Therefore, building a composite model is the most appropriate and efficient solution.
Question 24
You have a PBIX file that contains sensitive information.
You need to secure the information to meet the following requirements:
• Only internal users must be able to open the file if the file is shared via email.
• Once the file is published, only internal users must be able to open the semantic model and the report downloaded from the Power BI service.
What should you do?
A. From Microsoft Power BI Desktop, apply a sensitivity label.
B. Certify the semantic model and the report.
C. Use a live connection for the file.
D. From the Power BI service, apply a sensitivity label.
Show Answer
Correct Answer: A
Explanation: Applying a sensitivity label in Power BI Desktop protects the PBIX file itself, ensuring that only internal users can open it when shared via email. The label’s encryption and access restrictions persist after publishing, so only internal users can also open the semantic model and any report downloaded from the Power BI service. Applying a label only in the service would not secure the PBIX file prior to publishing.
Question 25
You have a Fabric workspace named Workspace1 that contains two Power BI reports named Report1 and Report2.
You create a workspace app that contains both reports.
You need to ensure that the app meets the following requirements:
• Report1 must be visible to all the users in your organization.
• Report2 must be visible to only a security group named Group1.
What should you do next?
A. Assign Group1 the Viewer role for Workspace1.
B. Create an audience and assign Group1 to the audience.
C. Allow access to the hidden content of the app.
D. Share Report1 with the built-in All users security group.
Show Answer
Correct Answer: B
Explanation: Power BI/Fabric apps support multiple audiences to control content visibility within a single app. By creating separate audiences, you can expose Report1 to an audience that includes all users in the organization, while assigning Report2 only to an audience that includes Group1. Workspace roles, sharing, or hidden content settings do not provide per-report visibility control within the app.
Question 26
HOTSPOT
-
You have a Fabric workspace that contains the items shown in the following table.
You need to make content available to the management department and the accounting department at your company. The solution must meet the following requirements:
• The management department must have view access to the Headcount and Department Expenses reports.
• The management department must NOT be able to view any other current or future reports.
• The management department must NOT be able to build new reports by using the semantic models.
• The accounting department must only be able to view the Company Expenses report.
• The accounting department must be able to build new reports by using the Expenses semantic model.
The solution must follow the principle of least privilege and minimize administrative effort.
How should you make the content available to the users in each department? To answer, select the appropriate options in the answer area.
NOTE: Each collect selection is worth one point.
Show Answer
Correct Answer: Management:
Publish an app.
Accounting:
Publish an app.
Explanation: Publishing a Power BI app allows precise control over which reports and semantic models are exposed and what users can do with them. For management, the app can include only the Headcount and Department Expenses reports with view-only access, preventing access to other current or future content and blocking report creation. For accounting, the app can include only the Company Expenses report and the Expenses semantic model, with the option enabled to allow users to build content using that semantic model. This follows least privilege and minimizes ongoing administration.
Question 27
HOTSPOT
-
You have the Performance analyzer results 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: August 2024 Active User %
August 2024 Active User %
Explanation: From the Performance Analyzer, **August 2024 Active User %** has the highest total duration (474 ms), making it the slowest-loading visual. It also has the largest **Other** time (286 ms), which represents waiting for other visuals or background processing, so it waits the longest.
Question 28
You are creating a Power BI report that will contain multiple visuals.
You need to ensure that the report is accessible to users who use a screen reader.
Which two configurations should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
A. consistent fonts for each visual
B. alt text for each visual
C. the tab order for each page
D. consistent colors for each visual
E. Play Axis for each page
Show Answer
Correct Answer: B, C
Explanation: Screen reader accessibility in Power BI relies on descriptive alternative text so visuals can be interpreted audibly, and a defined tab order so users can navigate visuals in a logical sequence. Fonts, colors, and play axis do not directly support screen reader navigation or interpretation.
Question 29
You are creating a visual in a Power BI report. The associated semantic model contains sales from the last four years for three products.
You need to display the total sales by quarter categorized by product. The visual must display trends in both total sales and individual product sales.
Which type of visual should you use?
A. area chart
B. clustered column chart
C. stacked area chart
D. line chart
Show Answer
Correct Answer: C
Explanation: The requirement is to show quarterly sales over time while simultaneously showing the total sales trend and how each product contributes to that total. A stacked area chart is designed for this scenario: the overall height shows total sales over time, and the stacked segments show individual product sales and their trends within the total. A line chart or clustered column chart would show individual trends but would not as clearly convey contribution to the total.
Question 30
You have a Power BI report. The report contains a single report page that uses the default theme.
You need to configure the report page to match the formatting shown in the following exhibit.
What should you change on the report page?
A. the wallpaper color only
B. the canvas background color only
C. the wallpaper color and the canvas background color only
D. the canvas background image only
Show Answer
Correct Answer: C
Explanation: The exhibit shows two distinct background areas: the main report canvas and the surrounding margins. In Power BI, the canvas background color controls the area behind the visuals, while the wallpaper color controls the outer margins. To match both areas shown in the formatting, you must change both the wallpaper color and the canvas background color.
Question 31
You plan to generate a line chart to visualize and compare the last six months of sales data for two departments.
You need to increase the accessibility of the visual.
What should you do?
A. Configure a unique marker for each series.
B. Configure a distinct color for each series.
C. Replace long text with abbreviations and acronyms.
D. Move important information to a tooltip.
Show Answer
Correct Answer: A
Explanation: Using unique markers (such as circles, squares, or triangles) for each line allows users to distinguish data series without relying on color alone. This significantly improves accessibility for users with color vision deficiencies and aligns with accessibility best practices. Distinct colors help but are insufficient by themselves, while tooltips and abbreviations do not address visual differentiation.
$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.
