Exam PL-300 topic 2 question 107 discussion

Presented answer is correct A. Summarize the detail data: Since Import mode loads the entire dataset into memory, reducing the amount of detail data (for example, aggregating granular data like daily sales into monthly or yearly totals) can significantly reduce the size of the model in memory. This approach helps minimize memory usage and improves query performance. D. Optimize the column data types: In Import mode, data is compressed and optimized by the VertiPaq storage engine. Using more efficient column data types reduces memory consumption and ensures better compression when the data is loaded into memory. For instance, using integer or decimal data types instead of string can help achieve better compression and optimize performance. link: https://learn.microsoft.com/en-us/power-bi/connect-data/service-dataset-modes-understand