Question 170 of 388
Single answerYou have an imported dataset that contains the following tables:DateProductCustomerSalesFactYou need to reduce the size of the dataset before you publish it. The solution must minimize the number of tables in the dataset.What should you do?
AMark the Date table as the date table for the model.
BChange the storage mode of all the tables to DirectQuery.
✓CReplace DAX calculated columns with Power Query equivalents.
DSummarize data at the month level in the SalesFact query.
✓
Correct Answer: C
Replace DAX calculated columns with Power Query equivalents.
▥
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.