ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam 70-778 All Questions

View all questions & answers for the 70-778 exam
Go to Exam

Exam 70-778 topic 1 question 104 discussion

Actual exam question from Microsoft's 70-778
Question #: 104
Topic #: 1
[All 70-778 Questions]

You plan to use Power BI Desktop to create a report. The report will consume data from an on-premises tabular database 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?

  • A. Deploy an on-premises data gateway and configure the connection to SalesDB to use the Connect live option.
  • B. Deploy an on-premises data gateway and configure the connection to SalesDB to use the Import Data Connectivity mode.
  • C. Deploy an on-premises data gateway (personal mode) and configure the connection 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.
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️
by rhsdeal at Aug. 18, 2019, 4:21 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
CDL
Highly Voted 4 years, 7 months ago
Again. SSAS (with Analysis into the Model) just --> "Live Connect" , becoz we just grab the Analysis and use it (no need to do the Modeling thing again). SQL Server (#1, GateWay) --> DirectQuery, becoz we use "Query" to directly visit all those data located into SQL database (not importing them into PBI due to too heavy). Hope it would help.
upvoted 7 times
...
Ikay81
Most Recent 4 years, 10 months ago
If you want to obtain current data use "Live Connection" with Analysis Services (SSAS) and with SQL Server, use "Direct Query."
upvoted 3 times
...
rhsdeal
5 years, 10 months ago
Why is this not DirectQuery, does anybody have any Microsoft documentation on Connect Live Option.
upvoted 1 times
twane
5 years, 9 months ago
DirectQuery is for SQL server. For SSAS you need Live connect to get current data.
upvoted 12 times
...
HiJaak
5 years, 8 months ago
https://radacad.com/directquery-live-connection-or-import-data-tough-decision
upvoted 1 times
...
JohnFan
5 years, 6 months ago
A special case of DirectQuery for SQL Server Analysis Services (SSAS) and Power BI service is called live connection.
upvoted 4 times
...
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel