Analyzing and Visualizing Data with Microsoft Power BI — Question 56

You plan to create a dashboard in the Power BI service that will retrieve data from a tabular database in Microsoft SQL Server Analysis Services (SSAS). The dashboard will be shared between the users in your organization.
The Analysis Services database has a DirectQuery connection to the SQL Server database that contains the source data.
You need to ensure that the users will see the current data when they view the dashboard.
How should you configure the connection to the data source?

Answer options

• A. Deploy an on-premises data gateway. Connect to the data by using the Connect live option.
• B. Deploy an on-premises data gateway. Connect to the data by using the DirectQuery Data Connectivity mode.
• C. Deploy an on-premises data gateway (personal mode). Connect to the data by using the Connect live option.
• D. Deploy an on-premises data gateway (personal mode). Connect to the data by using the DirectQuery Data Connectivity mode.

Correct answer: A

Explanation

The correct answer is A because using the Connect live option with an on-premises data gateway allows real-time access to live data, ensuring users see the most current information. Options B and D involve DirectQuery but do not utilize the Connect live option which is necessary for live connections. Option C, while using the Connect live option, does not utilize the proper gateway mode for organizational sharing.