ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam PL-300 All Questions

View all questions & answers for the PL-300 exam
Go to Exam

Exam PL-300 topic 1 question 49 discussion

Actual exam question from Microsoft's PL-300
Question #: 49
Topic #: 1
[All PL-300 Questions]

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 Suggested Answer Hide Answer
Suggested Answer: ADE 🗳️
by NadeemSalam at Feb. 11, 2025, 9:31 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
SushiPowerBI_175
5 days, 16 hours ago
Selected Answer: ADE
A. an Orders query that has a filter on CustomerID This ensures the Orders table only includes rows related to the selected CustomerID. D. a Customers query that has a single column containing a list of customer IDs This query will provide the source for the list of selectable CustomerIDs, and it's coming from an OData source as per the requirement. E. a parameter for CustomerID that uses a query to populate the suggested values This parameter enables users to select a CustomerID from a dynamic list, which aligns with the requirement to select the value from a list and to link it with the Customers query.
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago