Designing and Implementing Enterprise-Scale Analytics Using Microsoft Azure and Power BI — Question 53

You have a Power BI dataset that uses DirectQuery against an Azure SQL database.
Multiple reports use the dataset.
A database administrator reports that too many queries are being sent from Power BI to the database.
You need to reduce the number of queries sent to the database. The solution must meet the following requirements:
DirectQuery must continue to be used.
Visual interactions in all the reports must remain as they are configured currently.
Consumers of the reports must only be allowed to apply filters from the Filter pane.
Which two settings should you select? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

Answer options

• A. Add a single Apply button to the filter pane to apply changes at once
• B. Add Apply buttons to all basic filters to apply changes when you’re ready
• C. Disabling cross highlighting/filtering by default
• D. Ignore the Privacy Levels and potentially improve performance
• E. Add an Apply button to each slicer to apply changes when you’re ready

Correct answer: A, E

Explanation

The correct answers are A and E because adding a single Apply button in the filter pane allows users to apply all their filter changes at once, reducing the number of queries sent to the database. Likewise, applying changes through individual slicers with an Apply button also minimizes immediate queries. Options B, C, and D do not meet the requirements for maintaining visual interactions and specific filtering methods.