70-778 Question #26: Real Exam Question with Answer & Explanation

Note: This question is a part of a series of questions that present 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 exactly the same in each question in this series. Start of repeated scenario You have a Microsoft SQL Server database that contains the following tables. The following columns contain data 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 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. End of repeated scenario. You are modifying the model to report on the number of order. You need to calculate the number of orders. What should you do?