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

Question

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.

Options

• Aan Orders query that has a filter on CustomerID
• Ba Customers query that has a filter on CustomerID
• Can Orders query that has a single column containing a list of customers
• Da Customers query that has a single column containing a list of customer IDs
• Ea parameter for CustomerID that uses a query to populate the suggested values
• Fa parameter for CustomerID that uses manually entered values to populate the suggested values