Analyzing and Visualizing Data with Microsoft Power BI — Question 2

You plan to use Power BI Desktop to create a report. The report will consume data from an on-premises tabular named SalesDB in Microsoft SQL Server Analysis
Services (SSAS). The report will be published to the Power BI service.
You need to ensure that the report published to the Power BI service will access the current data in SalesDB.
What should you do?

Answer options

• A. Deploy an on-premises data gateway and configure the connection to SalesDB to use the Import Data Connectivity mode.
• B. Deploy an on-premises data gateway and configure the connection to SalesDB to use the Connect live option.
• C. Deploy an on-premises data gateway (personal mode) and configure to SalesDB to use the DirectQuery Data Connectivity mode.
• D. Deploy an on-premises data gateway and configure the connection to SalesDB to use the DirectQuery Data Connectivity mode.

Correct answer: D

Explanation

The correct answer is D because using the DirectQuery Data Connectivity mode allows the Power BI service to query the data in SalesDB in real-time, ensuring that the report always reflects the most current data. Options A and C use Import Data and personal mode respectively, which do not provide live access to data. Option B, while using the Connect live option, does not specify the necessary DirectQuery mode required for real-time updates.