Exam DP-500 topic 1 question 77 discussion

IMO the answers are A&D. Since "Consumers of the reports must only be allowed to apply filters from the Filter pane", then B & E are wrong. Also, there is noted that "Visual interactions in all the reports must remain as they are configured currently." which would be violated by C. To support D answer, there is no information that the data contains sensitive information so this change can be considered reasonable: "Caution: Enabling Fast Combine by selecting Ignore the Privacy levels and potentially improve performance in the Workbook Settings dialog could expose sensitive or confidential data to an unauthorized person. Do not enable Fast Combine unless you are confident that the data source does not contain sensitive or confidential data." Source: https://support.microsoft.com/en-us/office/set-privacy-levels-power-query-cc3ede4d-359e-4b28-bc72-9bee7900b540

I took the exam a few days ago (14/8/2023) and I passed the exam with a score of 915. My answer was: - Add a single Apply button to the filter pane to apply changes at once - Add an Apply button to each slicer to apply changes when you’re ready

A and C D can be taken because there is a single source B, E - Consumers of the reports must only be allowed to apply filters from the Filter pane",

A. Add a single Apply button to the filter pane to apply changes at once. This will prevent Power BI from sending multiple queries to the database as users interact with the filter pane. Instead, Power BI will only send one query when the user clicks the Apply button. C. Disabling cross highlighting/filtering by default. Cross highlighting and filtering are features that allow users to filter visuals based on the selection in other visuals. When these features are enabled, Power BI sends multiple queries to the database as users interact with the visuals. Disabling these features will reduce the number of queries sent to the database.

I so Wonder how people Vote for E. Since requirements is "Consumers of the reports must only be allowed to apply filters from the Filter pane." there shouldn't be slicers in the solution at all. For me, AB is the only remaining reasonable solution.

A and E are the logical answers.

A. Add a single Apply button to the filter pane to apply changes at once: By adding a single Apply button to the filter pane, users can apply all the selected filters at once, rather than each filter triggering a separate query. This helps reduce the number of queries sent to the database. E. Add an Apply button to each slicer to apply changes when you're ready: By adding an Apply button to each slicer, users can choose when to apply the changes made through the slicer. This way, the queries are only sent to the database when the users explicitly click the Apply button, reducing the overall number of queries.

I will agree with ajaysharma2061 because option e: says "Add an Apply button to each slicer to apply changes when you’re ready" If this sentece were "Add an Apply button to ALL slicer to apply changes when you’re ready" i'll select this In this case opcion c is better than e

The correct answer is A and C. A. Add a single Apply button to the filter pane to apply changes at once: By adding a single Apply button to the filter pane, users can apply all the selected filters at once, reducing the number of queries sent to the database. C. Disabling cross highlighting/filtering by default: Disabling cross-highlighting and filtering by default will limit the queries generated by visual interactions. B and E are incorrect as they suggest adding Apply buttons to filters or slicers, which may cause more queries to be sent to the database as users interact with them. D is also incorrect as ignoring privacy levels can potentially create security issues and is not related to reducing the number of queries sent to the database.

Reduce number of queries sent by : Slicers (E) and Filters (A) In that way you can improve the performance https://www.datapears.com/post/power-bi-query-reduction-add-an-apply-all-filters-button-to-your-report

Options B and E, adding Apply buttons to basic filters and slicers respectively, may help reduce the number of queries sent to the database, but they don't meet the requirement of allowing consumers to only apply filters from the Filter pane. Option D, ignoring privacy levels, is not related to reducing the number of queries sent to the database. It's a security setting that determines how Power BI handles data sources with different levels of privacy.

I don't understand how the answer most people select could be D when the question says you should reduce the number of queries sent to the database. Changing the privacy levels doesn't affect the number of queries sent to the database does it?

The right answer is A and E. A: because we send just a query when all the filters are set. E: slicers are not included in the single Apply button to the filter pane, so we must put an extra button to run the slicers once they are set. We cannot select the option C because the requirement says that "the visual interactions in all the reports must remain as they are configured currently", so interaction between the visual must exist The option D does not reduce the number of queries sent to the source.

A for sure because as a result only one query will be sent to AAS model instead of multiple. D because When privacy levels are set on a data source, queries from Power BI to the data source have to be evaluated to ensure that only authorized data is returned. This process can add extra time to the query execution and impact performance. In some cases, having many privacy levels or complex privacy level evaluations can have a significant impact on performance. However, it is important to maintain privacy levels to ensure the protection of sensitive data. If performance is a concern, other methods such as optimizing the data model or using DirectQuery or Live Connection instead of Import can help improve performance while still maintaining privacy levels.

These are the one that make more sense...tricky though

answer is correct A,E

Consumers of the reports must only be allowed to apply filters from the Filter pane. So E cannot be correct. I'd pick A & C