In DirectQuery mode, which change reduces the number of queries when using filters and slicers?

Unlock all questions

This demo includes only 20 questions. Upgrade to access hundreds of questions, flashcards, exam simulations, and disable ads.

Full question bankExam simulationsFlashcards
From $25.99Unlock all

Prepare for the Fabric Analytics Engineer Associate Test with comprehensive materials. Explore flashcards, multiple choice questions, and detailed explanations. Get ready for your success!

Multiple Choice

In DirectQuery mode, which change reduces the number of queries when using filters and slicers?

Explanation:
In DirectQuery, every change to a filter or slicer can trigger a separate query to the data source. By adding apply buttons to basic filters, selections are collected and only a single query is sent when you click Apply, reflecting all current choices at once. This batching reduces the total number of queries compared to applying each filter change individually. The other options don’t batch filter changes and can either keep triggering queries per interaction or even increase query activity (for example, automatic page refresh adds more queries).

In DirectQuery, every change to a filter or slicer can trigger a separate query to the data source. By adding apply buttons to basic filters, selections are collected and only a single query is sent when you click Apply, reflecting all current choices at once. This batching reduces the total number of queries compared to applying each filter change individually. The other options don’t batch filter changes and can either keep triggering queries per interaction or even increase query activity (for example, automatic page refresh adds more queries).

More Multiple Choice Questions
Subscribe

Get the latest from Passetra

You can unsubscribe at any time. Read our privacy policy