Exam 70-778 All Questions

View all questions & answers for the 70-778 exam

Exam 70-778 topic 1 question 98 discussion

Actual exam question from Microsoft's 70-778

Question #: 98
Topic #: 1

You plan to create a dashboard in the Power BI service that retrieves data from a Microsoft SQL Server database. The dashboard will be shared between the users in your organization.
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 Import Data Connectivity mode.
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 Import Data Connectivity mode.
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: B 🗳️

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

Comments

Submit Cancel

CYRUSD

Highly Voted 5 years, 1 month ago

Users need to see " current data">> Direct Query Users need to share dashboard in between >> Can not be personal mode

upvoted 14 times

...

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 5 times

...

sjonghe

Most Recent 4 years, 8 months ago

We want live data, so Direct Query is needed. Direct Query does not work on on-premises data gateway in personal mode. So the answer is clearly B.

upvoted 2 times

...

Vi1125

4 years, 8 months ago

Has to be on-premsis data gateway and NOT personal https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-personal-mode As we want live data data - Direct Query.

upvoted 1 times

...

adi1236

4 years, 11 months ago

answer:B

upvoted 1 times

...

Waltmas

4 years, 11 months ago

Gateway(personal),what is the difference

upvoted 1 times

...

rainbowstuf

5 years ago

Answer : B hint -current data --live data - so direct query

upvoted 3 times

...

Brunobsv

5 years, 8 months ago

Live Connection and Direct Query are used according to the data source. Both have several limitations. https://docs.microsoft.com/en-us/power-bi/desktop-use-directquery https://docs.microsoft.com/en-us/power-bi/desktop-report-lifecycle-datasets

upvoted 1 times

...

rhsdeal

5 years, 10 months ago

Anyone explain the difference for this answer regarding the live connection and direct query.

upvoted 1 times

...