Exam PL-300 topic 1 question 52 discussion

Actual exam question from Microsoft's PL-300

Question #: 52
Topic #: 1

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 Suggested Answer

Suggested Answer: D 🗳️

by kay000001 at June 17, 2025, 1:40 a.m.

Comments

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!