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.

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






 

Suggested Answer: AE



This question is in DP-500 Designing and Implementing Enterprise-Scale Analytics Solutions Using Microsoft Azure and Microsoft Power BI Exam
For getting Microsoft Certified: Azure Enterprise Data Analyst Associate Certificate




Disclaimers:
The website is not related to, affiliated with, endorsed or authorized by Microsoft. 
The website does not contain actual questions and answers from Microsoft's Certification Exams.
Trademarks, certification & product names are used for reference only and belong to Microsoft.