Microsoft Power BI Data Analyst — Question 49

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.

Answer options

• 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

Correct answer: A, D, E

Explanation

The correct answers are A, D, and E. Option A ensures that the Orders table is filtered by the selected CustomerID, while D provides a list of customer IDs needed for user selection. Option E creates a parameter to dynamically populate suggested values for CustomerID based on a query. Options B, C, and F do not contribute effectively to the requirements outlined for filtering orders and providing a customer selection list.