nerdexam
Microsoft

PL-300 · Question #470

PL-300 Question #470: Real Exam Question with Answer & Explanation

Sign in or unlock PL-300 to reveal the answer and full explanation for question #470. The question stem and answer options stay visible for context.

Submitted by obi.ng· Apr 18, 2026

Question

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?

Exhibit

PL-300 question #470 exhibit

Options

  • AMerge the Sales person and invoice tables based on the SalesPersonId column.
  • BChange the invoice table to a DirectQuery table and read the data live from the source, retaining
  • CReduce the size of the invoice table by summarizing sales by Product, Sales person, Calendar,
  • DChange the invoice table to a composite table that contains historical data as a DirectQuery table

Unlock PL-300 to see the answer

You've previewed enough free PL-300 questions. Unlock PL-300 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.

Full PL-300 Practice