PL-900 Question 84

Community Discussion

Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.

• 4

  Improve performance by reducing table size. Feature: Aggregations Aggregations can improve performance by summarizing data, which reduces the amount of data that needs to be processed and stored. Cache data locally on a user's device. Feature: Dual The Dual storage mode in Power BI, for example, allows data to be cached both in the report and within the Power BI service, enabling quicker access and potentially allowing for some local caching. The other options provided in the list: Formulas are not directly related to reducing table size; they are used to calculate results based on data in the tables. Modeling view is used for viewing and managing relationships and metadata in the model, but does not directly reduce table size. Import refers to bringing data into a model, but does not inherently include caching it on the user's device. Hence, for the given requirements, the features would be matched as follows: Aggregations for improving performance by reducing table size. Dual for caching data locally on a user's device.

• 2

  1. Aggregations https://learn.microsoft.com/en-us/power-bi/transform-model/aggregations-advanced 2. Import Import: Imported tables with this setting are cached. https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-storage-mode

• 1

  Anuki 's answer is incorrect. Modeling view itself cannot optimize performance.