👉Get Full PDF
| Question 91 You have a Microsoft Power BI semantic model that contains three tables named FactSales, DimProduct, and DimDate. There is a relationship between FactSales and DimProduct and FactSales and DimDate. The model is used to create reports that show monthly sales by product. FactSales contains 50 million rows of daily sales data. DimProduct contains 1,000 rows, with each row representing a unique product. DimDate contains sales dates for the last three years. You need to minimize the size of the semantic model. The solution must support the reporting requirements. What should you do? A. Summarize the DimDate table to the month level. B. Summarize the FactSales table to the month level. C. Summarize the FactSales table to the product category level. D. Summarize the FactSales table to the quarter level. |
91. Click here to View Answer
Answer is (A) Summarize the DimDate table to the month level.
| Question 92 Which are calculated on demand? A. Calculated columns B. Calculated tables C. Measures |
92. Click here to View Answer
Answer is (C) Measures
| Question 93 Which are calculated based on the filters that are used by the report user? Calculated columns or measures? A, Measures B. Calculated columns |
93. Click here to View Answer
Answer is (A) Measures
| Question 94 Which DAX function evaluates an expression in a modified filter context? A. SUMX B. CALCULATE C. ALL |
94. Click here to View Answer
Answer is (B) CALCULATE
| Question 95 Why would you want to override the default context? A. To create measures that behave according to the user’s selection B. To create measures that behave according to your intentions, regardless of what the user selects |
95. Click here to View Answer
Answer is (B) To create measures that behave according to your intentions, regardless of what the user selects