<< Prev Question Next Question >>

Question 3/28

You have a Power Bl 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 Bl 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.

LEAVE A REPLY

Your email address will not be published. Required fields are marked *

Question List (28q)
Question 1: You are planning a Power Bl solution for a customer. The cus...
Question 2: You are implementing a reporting solution that has the follo...
Question 3: You have a Power Bl dataset that uses DirectQuery against an...
Question 4: You have a Power Bl dataset that has the query dependencies ...
Question 5: You are using DAX Studio to analyze a slow-running report qu...
Question 6: You need to populate the CustomersWithProductScore table. Ho...
Question 7: What should you configure in the deployment pipeline?...
Question 8: You have the following code in an Azure Synapse notebook. (E...
Question 9: You are running a diagnostic against a query as shown in the...
Question 10: You have an Azure Synapse Analytics serverless SQL pool. You...
Question 11: You plan to generate a line chart to visualize and compare t...
Question 12: You are building a Power Bl dataset that contains a table na...
Question 13: You need to provide users with a reproducible method to conn...
Question 14: Note: This question is part of a series of questions that pr...
Question 15: You need to configure a source control solution for Azure Sy...
Question 16: You have the following Python code in an Apache Spark notebo...
Question 17: You need to create Power Bl reports that will display data b...
Question 18: You are creating a Power Bl Desktop report. You add a Python...
Question 19: You have a 2-GB Power Bl dataset. You need to ensure that yo...
Question 20: You have five Power Bl reports that contain R script data so...
Question 21: You have an Azure Data Lake Storage Gen 2 container that sto...
Question 22: You have a Power Bl dataset that contains two tables named T...
Question 23: You discover a poorly performing measure in a Power Bl data ...
Question 24: You are optimizing a Power Bl data model by using DAX Studio...
Question 25: Note: This question is part of a series of questions that pr...
Question 26: You need to recommend a solution for the customer workspaces...
Question 27: Note: This question is part of a series of questions that pr...
Question 28: You have a Power Bl dataset that has only the necessary fiel...