👉Get Full PDF
| Question 86 You are optimizing a Power BI model and notice poor performance. Which of the following actions is best to improve performance? A. Convert all columns to text B. Use DirectQuery mode for better performance C. Remove unnecessary columns and tables D. Use calculated columns instead of measures |
86. Click here to View Answer
Answer: C. Remove unnecessary columns and tables
| Question 87 You need to create a relationship between two tables named Sales and Sales Detail in a Power BI data model. For every row in the Sales table, there is at least one row, and possibly multiple rows, in the Sales Detail table. How should you configure the relationship? A. one-to-one from Sales to Sales Detail B. one-to-many from Sales to Sales Detail C. many-to-many from Sales to Sales Detail D. many-to-one from Sales to Sales Detail |
87. Click here to View Answer
Answer is (B)
| Question 88 You preview a single table in the Power Query Editor in Power BI Desktop. The table contains the following columns: LocationName, LocationID, Temperature, and DateTime. You need to convert the table into a properly formed star schema. To which table should you add the LocationName field? Select only one answer. A. Date Dimension B. Location Dimension C. Location Fact D. Temperature Measurements Fact |
88. Click here to View Answer
Answer is (B) Location Dimension
| Question 89 You have a Microsoft Power BI semantic model that contains two tables named DimDate and FactSales. DimDate is the main date table in the model. FactSales is a fact table that contains data about sales orders. FactSales has the following three relationships to DimDate: • An active relationship between FactSales[OrderDate] and DimDate[Date] • An inactive relationship between FactSales[ShipDate] and DimDate[Date] • An inactive relationship between FactSales[ReturnDate] and DimDate[Date] Which type of dimension is DimDate? A. degenerate dimension B. junk dimension C. outrigger dimension D. role-playing dimension |
89. Click here to View Answer
Answer is (D) role-playing dimension
| Question 90 You have a Microsoft Power BI semantic model that contains a dimension table named DimCustomer and a fact table named FactOrder. DimCustomer contains one row per customer. FactOrder contains one row per order. You need to create a relationship between DimCustomer and FactOrder. Which type of relationship cardinality should you choose? A. many-to-many B. many-to-one C. one-to-many D. one-to-one |
90. Click here to View Answer
Answer is (C) one-to-many