HOTSPOT
-
You have a Power BI semantic model that contains two tables named Sales and Forecast. Both tables contain a date column.
You need to create a calculated table that will cover the range of dates in both tables.
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: CALENDAR
MINX
MAXX
Explanation: Use CALENDAR(start_date, end_date) to create a contiguous date table. MINX returns the earliest date from Sales, and MAXX returns the latest date from Forecast, producing the required date range.
Question 52
HOTSPOT
-
You have a Power BI semantic model that contains three tables named Products, OrderHistory, and Date.
The Products table is a dimension table that contains the following columns:
• ProductID
• ProductName
The OrderHistory table is a fact table that contains the following columns:
• OrderID
• ProductID
• OrderDate
The Date table is a dimension table that contains the following columns:
• Year
• Date
• Week
• Month
You need to define a relationship from Products to OrderHistory and from OrderHistory to Date.
Which cardinality should you configure? To answer, select the appropriate options in the answer area.
NOTE: Each correct answer is worth one point.
Show Answer
Correct Answer: Between Products and OrderHistory: One-to-many
Between OrderHistory and Date: Many-to-one
Explanation: Products is a dimension with unique ProductID referenced by many fact rows. The Date table has unique dates, while OrderHistory contains many rows per date, so from the perspective of OrderHistory to Date the relationship is many-to-one.
Question 53
HOTSPOT
-
You have a Power BI semantic model.
You discover that the semantic model contains values that display as errors.
You need to use data profiling features in Power Query to preview the data and identify the issues.
What should you select to gain insight into the number of errors in the model, and what should you select to resolve the errors? To answer, select the appropriate options in the answer area.
NOTE: Each correct answer is worth one point.
Show Answer
Correct Answer: To gain insight: Column quality
To resolve the errors: Replace Errors
Explanation: Column quality displays the percentages/counts of valid, error, and empty values, helping identify error prevalence. Replace Errors is the Power Query transformation used to substitute error values with a specified value, resolving them.
Question 54
You have a Power BI semantic model named Model1 that contains two tables named DimDate and FactSales. There is an active relationship between DimDate and FactSales. DimDate is marked as the date table. FactSales contains the following data.
Model1 contains the following measure.
Previous Year Sales = CALCULATE([Sales Amount], PREVIOUSYEAR('Date'[Date]))
You have a report that uses Model1. The report has a single report page that has a page level filter set to May 9, 2024. The result of the Previous Year Sales measure is displayed in a card visual.
Which value will appear in the card visual?
A. 10
B. 15
C. 35
D. 60
Show Answer
Correct Answer: D
Explanation: PREVIOUSYEAR returns all dates in the previous year based on the first date in the current filter context, not just the corresponding single day. With the page filtered to May 9, 2024, PREVIOUSYEAR returns the date range Jan 1, 2023 through Dec 31, 2023. CALCULATE evaluates Sales Amount over that entire previous-year range, so the result is the sum of all 2023 sales shown in FactSales: 15 + 20 + 25 = 60.
Question 55
You have a Power BI report named Report1.
You plan to share Report1 with multiple users.
You need to add the users to a group.
Which two types of groups can you use? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
A. security group
B. distribution group
C. Microsoft Teams team
D. Microsoft 365 group
Show Answer
Correct Answer: A, B
Explanation: For direct sharing of a Power BI report with multiple users, Power BI supports sharing to Microsoft Entra security groups and email-enabled distribution groups. Microsoft 365 (Unified) groups are not supported for direct sharing in this scenario, although they are used in other Power BI contexts such as workspaces.
Sources:
https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-share-dashboards
Question 56
HOTSPOT
-
You have a Power BI semantic model named Model1 that will be used to support reports viewed in the Power BI service.
Model1 contains data from the following sources:
• An Azure SQL database that is accessible only via a private endpoint
• A Microsoft Excel file stored in Microsoft SharePoint Online
• A Microsoft SQL Server database in a private datacenter
You need to publish Model1 and schedule the model to refresh 12 times a day.
How many data sources require a data gateway, and which license mode will the workspace require to support the scheduled refresh? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Show Answer
Correct Answer: 2
Premium Per User (PPU)
Explanation: The SQL Server in the private datacenter requires an on-premises gateway, and the Azure SQL database accessible only through a private endpoint also requires gateway connectivity (such as a VNet/on-premises gateway). The SharePoint Online Excel file is a cloud source and does not. Twelve scheduled refreshes per day exceed Pro's limit (8/day), so a Premium-capable workspace is required; among the options, PPU supports up to 48 refreshes/day.
Question 58
HOTSPOT
-
You have a Power BI semantic model named Model1 that contains a table named Sales.
Sales contains 10 million records and the following data.
The related report displays the weekly sales per region.
You need to minimize the size of Model1.
How should you modify the CustomerID column and the PurchaseDateTime column? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Show Answer
Correct Answer: CustomerID: Remove the column.
PurchaseDateTime: Split the column into separate date and time columns.
Explanation: The report only needs weekly sales by region, so CustomerID is unnecessary and can be removed. Splitting a high-cardinality DateTime column into separate date and time columns improves compression by reducing cardinality, and the time portion can be omitted if not needed.
Question 59
You need to create a semantic model in Power BI Desktop. The solution must meet the following requirements:
• The model must contain a table named Orders that has one row per order. Each row will contain the total amount per order.
• The orders must be filtered to the selected CustomerID value.
• Users must select the CustomerID value from a list.
• The list of customers must come from an OData source.
Which three objects should you create in Power Query Editor? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
A. an Orders query that has a filter on CustomerID
B. a Customers query that has a filter on CustomerID
C. an Orders query that has a single column containing a list of customers
D. a Customers query that has a single column containing a list of customer IDs
E. a parameter for CustomerID that uses a query to populate the suggested values
F. a parameter for CustomerID that uses manually entered values to populate the suggested values
Show Answer
Correct Answer: A, D, E
Explanation: Create an Orders query filtered by a CustomerID parameter so the model contains only orders for the selected customer. Create a Customers query with a single CustomerID column sourced from the OData feed to provide the selectable values. Create a CustomerID parameter whose suggested values come from that query, giving users a dropdown populated from the OData source.
Question 60
You plan to create a Power BI semantic model named Model1 that will contain data from an Azure SQL database named DB1.
Model1 must show updated data within two minutes of the data being updated in DB1.
You need to select a connectivity mode for the connection to DB1.
What should you choose?
A. DirectQuery
B. live connection
C. import
Show Answer
Correct Answer: A
Explanation: DirectQuery is the appropriate connectivity mode for an Azure SQL Database when the semantic model must reflect source data changes within minutes because queries are executed against the source at report time. A live connection is for existing Analysis Services or Power BI semantic models, not Azure SQL Database. Import mode relies on dataset refreshes and cannot guarantee updates within two minutes.
Question 61
HOTSPOT
-
You are using Microsoft Power BI Desktop to profile data in Power Query Editor.
Table data is displayed 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: Change the data type.
Change the data type.
Explanation: The date column must have a Date data type before using date transformations such as extracting the day. The menuAmount column is incorrectly typed (displaying date values for what should be another type), so correcting its data type resolves the type-conversion error.
$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.
