Learn the best Power BI connectivity mode to use for real-time analytics on frequently updated streaming data sources. Minimize impact on data source performance and view latest data without refresh.
Table of Contents
Question
You have a Power BI semantic model that connects to a streaming data source. The data source is updated frequently.
You need to create a Power BI report that meets the following requirements:
- Supports real-time analytics
- Minimizes performance impact on the data source
- Displays the most recent data without performing a data refresh
Which connectivity mode should you use for the dataset?
A. DirectQuery mode
B. import mode
C. LiveConnect mode
D. push mode
Answer
D. push mode
Explanation
For the given scenario and requirements, push mode is the best connectivity mode to use in Power BI. Here’s why:
Push mode is designed for real-time analytics scenarios with streaming data sources that are updated very frequently. In push mode, data is continuously pushed into the Power BI dataset, typically every second. This allows reports to always display the latest data without needing to perform a data refresh.
Push mode also has minimal performance impact on the source system, since Power BI is simply receiving the data that is pushed to it, rather than querying the data source directly. This is in contrast to DirectQuery mode, which queries the data source in real-time and can impact its performance.
The other options are not ideal for this scenario:
- Import mode loads all the data into Power BI. It does not support real-time analytics with frequently updated data.
- DirectQuery mode queries the source data in real-time, but can significantly impact the performance of the data source system.
- LiveConnect mode (also called Live Connection) is used to connect to Power BI datasets or Analysis Services models. It does not apply to streaming data sources.
Therefore, push mode is the connectivity mode that best meets all the stated requirements for real-time analytics on a frequently updated streaming data source in Power BI. It will allow displaying the latest data without refresh while minimizing performance impact on the source system.
Microsoft PL-300 certification exam assessment practice question and answer (Q&A) dump including multiple choice questions (MCQ) and objective type questions, with detail explanation and reference available free, helpful to pass the Microsoft PL-300 exam and earn Microsoft PL-300 certification.