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

Question

Note: This question is part of a series of questions that use the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a different goal and answer choices, but the text of the scenario is the same in each question in this series. You have a Microsoft SQL Server database that contains the following tables. The following columns contain date information: - Date[Month] in the mmyyyy format - Date[Date_ID] in the ddmmyyyy format - Date[Date_name] in the mm/dd/yyyy format - Monthly_returns[Month_ID] in the mmyyyy format The Order table contains more than one million rows. The Store table has a relationship to the Monthly_returns table on the Store_ID column. This is the only relationship between the tables. You plan to use Power BI Desktop to create an analytics solution for the data. You plan to create a chart that displays total Order[Order_amount] by Store[Name]. You need to modify the model to ensure that you can create the chart. Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

Options

• ACreate a relationship between the Order table and the Store table.
• BTo the Order table, add a measure that uses the COUNTA('Order'[Order_ID]) DAX formula.
• CTo the Order table, add a column that uses the RELATED('Store'[Store_ID]) DAX formula.
• DTo the Order table, add a measure that uses the COUNT('Order'[Order_amount]) DAX formula.

Explanation

The scenario states the only existing relationship is between Store and Monthly_returns. To analyze Order data alongside Store data, you first need to create a relationship between Order and Store (A). Once that relationship exists, you can use RELATED('Store'[Store_ID]) as a calculated column in the Order table (C) to pull Store_ID values across the relationship-enabling further lookups and analysis. The COUNTA/COUNT measures (B/D) compute aggregates but do not solve the missing relational link between the tables.

No community discussion yet for this question.