Exam 70-778 topic 1 question 100 discussion

Actual exam question from Microsoft's 70-778

Question #: 100
Topic #: 1

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?

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.

Show Suggested Answer

Suggested Answer: A 🗳️

by rhsdeal at Aug. 18, 2019, 4:16 p.m.

Comments

Submit Cancel

RyGar

Highly Voted 5 years, 9 months ago

Live connection is for analysis services model while direct query is for database https://radacad.com/directquery-live-connection-or-import-data-tough-decision

upvoted 8 times

...

CDL

Highly Voted 4 years, 7 months ago

Gateway for "power BI service" <--> "SQL server database" SSAS -> live connections SQL sever -> DirectQuery Links: 1. https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-directquery-about#directquery-connections 2. https://docs.microsoft.com/en-us/power-bi/connect-data/power-bi-data-sources

upvoted 5 times

...

rhsdeal

Most Recent 5 years, 9 months ago

Thinking that should be B based on the prior question.

upvoted 2 times

rhsdeal

5 years, 9 months ago

Prior question #98

upvoted 1 times

123

4 years, 11 months ago

Question #98 has a slightly different question: Microsoft SQL Server database (no mention of SSAS). But, yes....the answers are the same. I know this isn't a 'trick question', but....!!

upvoted 1 times

...