Question 190 of 388
Single answerNote: 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 formatThe 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 need to create a relationship between the Monthly_returns table and Date[Date_ID].What should you do before you create the relationship?
AIn the Date table, create a new calculated column named MonthJD that uses the yyyydd format.
✓BIn the Monthly_returns table, create a new calculated column named DateJD that uses the ddmmyyyy format.
CTo the Order table, add a calculated column that uses the RELATED(Monthly_returns[Month_ID]) DAX formula.
DTo the Date table, add a calculated column that uses the RE LATE D(Monthly_ret urns [MonthJD]) DAX formula.
✓
Correct Answer: B
In the Monthly_returns table, create a new calculated column named DateJD that uses the ddmmyyyy format.
▥
Explanation
The correct answer is highlighted above. Review the wording carefully, then use the next question to continue building your understanding of Microsoft certification topics.