Power Bi Da-100 Study Guide Graded A+

What are the benefits to query folding? {Ans: The benefits to query folding include: -More efficiency in data refreshes and incremental refreshes. When you import data tables by using query folding, Power BI is better able to allocate resources and refresh the data faster because Power BI does not have to run through each transformation locally. -Automatic compatibility with DirectQuery and Dual storage modes. All DirectQuery and Dual storage mode data sources must have the back-end server processing abilities to create a direct connection, which means that query folding is an automatic capability that you can use. If all transformations can be reduced to a single Select statement, then query folding can occur.}What is the role of the business analyst? {Ans: While some similarities exist between a data analyst and business analyst, the key differentiator between the two roles is what they do with data. A business analyst is closer to the business and is a specialist in interpreting the data that comes from the visualization.}How does DirectQuery help with large datasets? {Ans: This mode is suited for when you have large datasets to pull data from. Instead of slowing down performance by having to load large