pl-300 Practice Question 1925
Exam: pl-300
Domain: Prepare the data
Topic: Get data from different data sources
Difficulty: medium
A business analyst needs to connect to an external SQL Server database to retrieve sales data for analysis in Power BI. The data is updated frequently and should be refreshed automatically without impacting the performance of the existing reports. Which mode should the analyst use for this scenario, and why?
Answer Options
A
Import mode
B
DirectQuery mode
C
Dual mode
D
Power Query mode
Correct Answer
B: DirectQuery mode
Explanation
DirectQuery mode is the best choice for this scenario because it allows the data to be queried directly from the source, ensuring that the latest data is always available. This mode also offloads the querying process to the source database, which helps maintain the performance of existing reports. Import mode would store the data locally, which could lead to performance issues due to the need to refresh the data, and Dual mode combines both modes but is not necessary for this specific requirement.