Exam PL-900 topic 1 question 85 discussion

1. Modelling view 2. Import

Aggregation improves performance but question concerns size of data, then: 1.Modeling view - can reduce size of data 2. Import - creates buffer/cache

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.

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

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

Aggregations in Power BI can improve query performance over very large DirectQuery datasets. https://learn.microsoft.com/en-us/power-bi/transform-model/aggregations-advanced

still seen in exam Jan-23

'To enable interactive analysis on this dataset, you can add an aggregation table that groups by most of the attributes, but excludes the high-cardinality attributes like longitude and latitude. This dramatically reduces the number of rows, and is small enough to comfortably fit into an in-memory cache.'

Aggregations Import

In exam 2022/Nov/21.

Read the answers! "Improve performance reducing table size" —> this is a doing, not a question about where. When aggregating, we are reducing the table size! It‘s not asked where to change something, so it‘s NOT modelling view! Second one is an option to be set on Modelling View - Import improves performance. So this is correct!

In modelling view: "you could change the storage mode for multiple tables in your diagram view by holding down the Ctrl key, selecting tables, then changing the storage mode setting in the Properties pane." https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-modeling-view The storage mode lets you control whether Power BI Desktop caches table data in-memory for reports. https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-storage-mode This literally takes you to the discussion about setting the storage mode property to import or dual, which makes up the second question. Based on the before, the answer to the first question should be modelling view

In exam today , 21/7/2022

Verified

Answer is Correct Box 1: Aggregation . Why ? Aggregation is a way of speeding up the performance of a Power BI dataset. The approach works on the basis of creating aggregated tables from the main detailed fact table. The calculations and visuals then will be using the aggregated table which is smaller and faster in the response time. Answer Cant be Model view because Model view shows all of the tables, columns, and relationships in your model. This view can be especially helpful when your model has complex relationships between many tables. This has nothing to do with performance

1.0) Modelling view: 1.1) https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-modeling-view#setting-common-properties 1.2) https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-storage-mode 2.0) Import: 2.1) https://docs.microsoft.com/en-us/powerapps/maker/data-platform/data-platform-powerbi-connector#connect-to-dataverse-using-the-connector

1: Aggregations: https://docs.microsoft.com/en-us/power-bi/transform-model/aggregations-advanced#:~:text=Aggregations%20in%20Power%20BI%20can%20improve%20query%20performance,you%20cache%20data%20at%20the%20aggregated%20level%20in-memory.