nerdexam
MicrosoftMicrosoft

PL-300 · Question #247

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

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

Submitted by daniela_cl· Apr 18, 2026

Question

You are building a Power Bl report that uses data from an Azure SQL database named erp1. You import the following tables. You need to perform the following analyses: - Orders sold over time that include a measure of the total order value - Orders by attributes of products sold The solution must minimize update times when interacting with visuals in the report. What should you do first?

Options

  • AFrom Power Query, merge the Orders query and the Order Line Items query.
  • BCalculate the count of orders per product by using a DAX function.
  • CCreate a calculated column that adds a list of product categories to the Orders table by using a
  • DFrom Power Query, merge the Order Line Items query and the Products query.

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 PracticeBrowse All PL-300 Questions