Exam 70-778 All Questions

View all questions & answers for the 70-778 exam

Exam 70-778 topic 2 question 6 discussion

Actual exam question from Microsoft's 70-778

Question #: 6
Topic #: 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?

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.

Show Suggested Answer

Suggested Answer: D 🗳️
References: https://docs.microsoft.com/en-us/power-bi/desktop-use-directquery

by Ced at Feb. 7, 2019, 4:16 p.m.

Comments

Submit Cancel

Ced

Highly Voted 6 years, 2 months ago

The correct answer is B. On a tabular Analysis Services the connection is a Live Connection and not a Direct Query. References : http://radacad.com/directquery-live-connection-or-import-data-tough-decision DirectQuery not support SSAS data source: https://docs.microsoft.com/en-us/power-bi/desktop-directquery-data-sources

upvoted 68 times

rhsdeal

5 years, 8 months ago

Thank you the answer is B.

upvoted 9 times

...

3water

Highly Voted 5 years, 8 months ago

B is the correct answer

upvoted 6 times

rhsdeal

5 years, 8 months ago

Thank you the answer is B

upvoted 6 times

...

Lhouss

Most Recent 4 years, 5 months ago

B is correct. For SSAS it's Live connection.

upvoted 1 times

...

Chrisychurch

4 years, 8 months ago

B SSAS / Tabular = Live Connection SQL = Direct Query This sections answers are almost all wrong. Even the reference is wrong.

upvoted 2 times

CDL

4 years, 5 months ago

ps: PBI desktop <-> om-premise SQL server <-- (data Source <--AS) SSAS -> PBI service "via" Live connect; SQL server -> PBI service "via" DirectQuery.

upvoted 1 times

CDL

4 years, 5 months ago

BTW, any on-premise "to" cloud need a "GATEWAY"

upvoted 1 times

...

RJM9000

4 years, 9 months ago

Have a look here: https://docs.microsoft.com/it-it/analysis-services/analysis-services-features-supported-by-the-editions-of-sql-server-2016?view=asallproducts-allversions Both Live connection and dIrectQuery are available option for Server Analysis.

upvoted 2 times

...

Ikay81

4 years, 9 months ago

"B" as the correct answer is a no brainer.

upvoted 1 times

...

lyniguez

4 years, 10 months ago

SSAS = Live Connection

upvoted 4 times

...

ArpanT

5 years ago

The correct answer is 'B'

upvoted 3 times

...

mohroshdy

5 years, 4 months ago

B is correct Live connection with SSAS

upvoted 5 times

...

Nishant

5 years, 4 months ago

Should be 'B': https://www.youtube.com/watch?v=GPf0YS-Xbyo

upvoted 2 times

...

JohnFan

5 years, 5 months ago

What is the "the Connect live option"? Do you mean Live Connection?

upvoted 1 times

Shil

5 years, 4 months ago

From what I understand, Analysis services uses Connect Live option and Database uses Direct query option. Easy to remember this way.

upvoted 2 times

...

rhsdeal

5 years, 8 months ago

I think the answer is D https://docs.microsoft.com/en-us/power-bi/desktop-use-directquery

upvoted 1 times

JohnFan

5 years, 5 months ago

Where does your post mention " Analysis Services" or "SSAS"?

upvoted 4 times

...

Exam 70-778 All Questions

View all questions & answers for the 70-778 exam

Exam 70-778 topic 2 question 6 discussion

Comments

Ced

rhsdeal

3water

rhsdeal

Lhouss

Chrisychurch

CDL

CDL

RJM9000

Ikay81

lyniguez

ArpanT

mohroshdy

Nishant

JohnFan

Shil

rhsdeal

JohnFan

SY0-701