You have a Power BI report named Report that contains the following tables.
For the last three days, refresh in Power BI has failed, and you receive the following error message: “You have reached the maximum allowable memory allocation for your tier. Consider upgrading to a tier with more available memory.”
You need to resolve the error and ensure that query response times are minimized for end users.
What should you do?
A. Merge the Sales person and invoice tables based on the SalesPersonId column.
B. Change the invoice table to a DirectQuery table and read the data live from the source, retaining only the dimension tables as import tables.
C. Reduce the size of the invoice table by summarizing sales by Product, Sales person, Calendar, and Customer.
D. Change the invoice table to a composite table that contains historical data as a DirectQuery table and hot data as an import table, and then partition the table.
Show Answer
Correct Answer: D
Explanation: The refresh failure is due to memory limits during import. A hybrid/composite fact table with partitions keeps frequently accessed 'hot' data imported for fast queries while leaving the rest in DirectQuery, reducing memory consumption during refresh and minimizing end-user query latency. Converting the entire fact table to DirectQuery would hurt performance, merging tables does not address memory, and summarizing the fact table reduces detail and is not the preferred solution when hybrid tables are available.
Question 21
You have a Power BI semantic model that contains two tables named DimCustomer and FactOrderDetails.
The primary key of DimCustomer is CustomerID.
FactOrderDetails contains a column named CustomerID that can be used to relate to DimCustomer. Multiple rows in FactOrderDetails possibly have the same CustomerID value.
You need to create a relationship from FactOrderDetails to DimCustomer. The solution must optimize query performance.
What should you create?
A. an active, single-direction, many-to-one relationship
B. an inactive, single-direction, one-to-many relationship
C. an active, single-direction, one-to-many relationship
D. an active, bi-directional, many-to-one relationship
Show Answer
Correct Answer: A
Explanation: DimCustomer is the lookup (dimension) table with a unique CustomerID, while FactOrderDetails is the fact table with many rows per CustomerID. For best performance and standard star-schema design, the relationship should be active with single-direction filtering from the dimension to the fact. In Power BI's relationship dialog, when creating the relationship from the fact table to the dimension table, the cardinality is expressed as many-to-one (*:1), making the correct option an active, single-direction, many-to-one relationship.
Sources:
https://learn.microsoft.com/en-us/fabric/data-warehouse/tutorial-power-bi-report
https://learn.microsoft.com/hr-hr/power-bi/create-reports/copilot-evaluate-data
Question 22
HOTSPOT
-
You have a semantic model that contains a table named Sales. The table contains the following columns:
• Order ID
• Product ID
• Sales Date
• Sales Amount
You need to create a DAX measure that will return the total sales amount for the same dates from the previous year.
How should you complete the measure? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Show Answer
Correct Answer: CALCULATE
SAMEPERIODLASTYEAR
Explanation: Use CALCULATE to evaluate the sales sum under a modified filter context, and SAMEPERIODLASTYEAR(Sales[Sales Date]) to shift the current date context to the same period in the previous year.
Question 23
You attempt to open a PBIX file in Microsoft Power BI Desktop and receive the following error message in Power Query Editor.
DataSource.Error: Could not find file D:\Data.txt.
How should you resolve the issue?
A. Update the Microsoft OLE DB Provider client libraries on your client computer.
B. Change the file path of Data.txt.
C. Change the file format to CSV.
D. Use an on-premises data gateway.
Show Answer
Correct Answer: B
Explanation: The error indicates Power Query is trying to access a local file at a path that does not exist or is no longer valid. Resolving it requires updating the data source settings or query to point to the correct location of the file. Updating OLE DB providers, changing the file format, or using an on-premises data gateway do not address a missing local file path.
Question 24
You have a semantic model named Model1.
You need to ensure that users can verify that the data in Model1 meets corporate standards.
What should you do?
A. Create an image of Model1.
B. Promote Model1.
C. Certify Model1.
D. Apply a sensitivity label to Model1.
Show Answer
Correct Answer: C
Explanation: Certification is the highest level of endorsement for Power BI semantic models and datasets. A certified semantic model indicates it has been reviewed and approved to meet organizational standards, allowing users to trust its quality and governance. Promotion is a lighter endorsement, sensitivity labels classify data protection requirements rather than quality, and creating an image is unrelated.
Question 25
HOTSPOT
-
You have a query that contains customer data in Power Query Editor 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: Customer Name
extract the last 12 characters
Explanation: The Customer Name column has fewer unique than distinct values, indicating repeated names. Extracting the last 12 characters from the phone values removes the country code and yields the consistent 10-digit phone number format (without leading spaces).
Question 26
You use Power BI Desktop to create a report named RPT1 that loads data from a Microsoft Excel file named File1. File1 is located in a network share.
File1 is moved to a different folder.
When you open RPT1 in Power BI Desktop, you discover that the report displays outdated data.
You need to ensure that the data in File1 refreshes properly.
What should you do?
A. Change the data source.
B. Clear the permissions of File1.
C. Export a PBIDS file.
D. Modify the permissions for File1.
Show Answer
Correct Answer: A
Explanation: The report stores the original file path for the Excel data source. If the Excel file is moved to a different folder, Power BI Desktop will continue to show the previously imported (cached) data until a refresh is attempted, but refresh will not succeed using the old path. Update the data source settings to point to the file's new location, then refresh. Clearing or modifying permissions does not fix an invalid path, and exporting a PBIDS file is unrelated to repairing an existing report's source connection.
Question 27
HOTSPOT
-
You plan to use Power Query Editor to get data from an API.
The API returns a JSON response.
You have a username and password for the API.
Which data source and authentication method should you use to connect to the API? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Show Answer
Correct Answer: Data source: Web
Authentication: Basic
Explanation: Use the Web connector to access an HTTP/HTTPS API. Since the API uses a username and password, Basic authentication is the appropriate choice; the JSON format is the response format, not the connector.
Question 28
You have a table named DIMCountries that contains a column named Country as shown in the following table.
You plan to use DIMCountries as a dimension in a report.
You need to ensure that the Country column in DIMCountries lists each country only once.
Which two actions should you perform on the Country column? Each correct answer presents part of the solution.
NOTE: Each correct answer is worth one point.
A. Change Data category to Country.
B. Remove duplicate values.
C. Apply a clean transform.
D. Replace the empty fields.
E. Apply a Capitalize Each Word transform.
Show Answer
Correct Answer: B, E
Explanation: To ensure each country appears only once, first standardize the text casing by applying the Capitalize Each Word transform so values such as 'canada' and 'Canada' become identical. Then remove duplicate values. Setting the data category does not affect uniqueness, cleaning transforms target non-printable characters rather than casing, and replacing empty fields does not remove duplicates.
Question 30
HOTSPOT
-
You use Power Query Editor to ingest data into Power BI Desktop.
The total dataset contains 250,000 rows. All the rows match the format of the data as shown in the following exhibit.
You need to optimize the data model size of the table.
Which type of data should you use for the Value column and the Datetime column? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Show Answer
Correct Answer: Value: Whole number
Datetime: Date
Explanation: Use the smallest appropriate data types to reduce model size. The Value column contains integer values despite showing .00, so Whole number is more efficient than Decimal. The Datetime values all have a time of 00:00:00.000, so Date is sufficient instead of Datetime.
$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.
