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: Column quality
Replace Errors
Explanation: Column quality shows the count and percentage of valid, error, and empty values, providing insight into data issues. Replace Errors lets you correct or substitute error values to resolve them.
Question 43
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: With a page-level filter on a single date (May 9, 2024), PREVIOUSYEAR('Date'[Date]) does not behave like SAMEPERIODLASTYEAR. PREVIOUSYEAR returns all dates from the entire previous calendar year (Jan 1, 2023–Dec 31, 2023). Therefore, the measure sums all FactSales for 2023, which total 60.
Question 44
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: Power BI allows sharing reports with Azure AD security groups and email-enabled distribution groups so that access can be managed through group membership. Microsoft 365 groups and Teams teams are not supported for direct report sharing in this context.
Question 45
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: Data sources: 2
License mode: Premium Per User (PPU)
Explanation: The Azure SQL Database behind a private endpoint and the on‑premises SQL Server both require a data gateway. The Excel file in SharePoint Online does not. Refreshing 12 times per day exceeds the Pro limit (8/day), so a Premium-capable option is required; Premium Per User supports up to 48 refreshes per day.
Question 46
You use Power BI Desktop to open a PBIX file that contains a Microsoft Excel data source.
You attempt to refresh the data and receive the following error message.
Expression.Error: The column ‘Cost’ of the table wasn't found.
What is a possible cause of the error?
A. The Cost column was renamed in the data source.
B. The privacy level of the data source does not allow combining the data with other data sources.
C. The data in the Cost column cannot be converted into the target data type.
D. The source file was moved to a new location.
Show Answer
Correct Answer: A
Explanation: The error indicates that Power BI cannot find a column named 'Cost' during refresh. This commonly occurs when the column was renamed or removed in the Excel source after the PBIX was created, while the Power Query steps still reference the original column name. Other options would generate different error messages (privacy, data type, or file path).
Question 47
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 analyzes weekly sales per region, so CustomerID is not required and removing it directly reduces the model size. A DateTime/Timezone column has very high cardinality; splitting it into separate Date and Time columns reduces cardinality and improves compression. The time part can then be ignored if not needed for weekly aggregation.
Question 48
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: To meet the requirements, the solution needs a dynamic CustomerID selection sourced from OData and applied to filter orders.
An Orders query filtered by CustomerID is required so the Orders table contains only rows for the selected customer and has one row per order with totals (A).
A Customers query with a single column of CustomerIDs from the OData source is needed to provide the selectable list of customers (D).
A CustomerID parameter whose suggested values are populated from that Customers query allows users to select a CustomerID from a list rather than manually entering it, and enables the Orders query to be filtered dynamically (E).
Question 49
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 queries the Azure SQL database directly at query time, so reports reflect changes in the source almost immediately, meeting the requirement to show updates within two minutes. Live connection applies to Analysis Services or Power BI datasets, not Azure SQL Database, and Import mode relies on scheduled refresh, which cannot guarantee such a short latency.
Question 50
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: Date transformations such as extracting the day are enabled only after the column is correctly typed as Date. The error in the data.Entries.menuAmount column is caused by an incorrect data type, so changing it to the appropriate numeric type resolves the error.
Question 51
DRAG DROP
-
You have a Power BI semantic model.
You need to configure row-level security (RLS) to restrict data access for users that have the Viewer permissions.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
Show Answer
Correct Answer: From Microsoft Power BI Desktop, create a new RLS role by using a DAX filter.
Publish the semantic model.
From the Power BI service, assign the new RLS role to the users.
Explanation: RLS roles and DAX filters are defined in Power BI Desktop, then published with the semantic model to the service, where users or groups are assigned to those roles to enforce row-level security.
$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.
