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

Exam DA-100 All Questions

View all questions & answers for the DA-100 exam
Go to Exam

Exam DA-100 topic 5 question 6 discussion

Actual exam question from Microsoft's DA-100
Question #: 6
Topic #: 5
[All DA-100 Questions]

You create a report by using Microsoft Power BI Desktop.
The report uses data from a Microsoft SQL Server Analysis Services (SSAS) cube located on your company's internal network.
You plan to publish the report to the Power BI Service.
What should you implement ta ensure that users who consume the report from the Power BI Service have the most up-to-date data from the cube?

  • A. a subscription
  • B. a scheduled refresh of the dataset
  • C. an OData feed
  • D. an On-premises data gateway
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️
When you've created dynamic reports in Power BI Desktop, you can share them by publishing to your Power BI site. When you publish a Power BI Desktop file with a live connection to a tabular model to your Power BI site, an on-premises data gateway must be installed and configured by an administrator.
by Mr_E at Jan. 6, 2021, 12:37 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
dayotee
Highly Voted 4 years, 3 months ago
SSAS is a live connection to Power BI. So no need to schedule refresh. D is correct.
upvoted 66 times
DDChen
4 years, 3 months ago
yes! exactly
upvoted 1 times
...
jerryl
4 years, 3 months ago
it seems even it says it is a live connection, it can still choose between import mode or direct query mode if import mode is chosen, i think it still needs regular extraction? please correct me if this is wrong https://www.youtube.com/watch?v=pX-Pyho1cnE
upvoted 2 times
...
jerryl
4 years, 3 months ago
https://powerbi.microsoft.com/en-us/gateway/ Keep your dashboards and reports up to date by connecting to your on-premises data sources without the need to move the data. so seem D is an appropriate option
upvoted 3 times
...
...
Taddi10
Highly Voted 4 years, 3 months ago
The answer is correct, we need a gateway to have last data because the cube is in internal location
upvoted 18 times
...
QWERTYman
Most Recent 2 years, 9 months ago
Selected Answer: D
Answer is D
upvoted 1 times
...
RamzanAnjum
2 years, 9 months ago
Microsoft SQL Server Analysis Services (SSAS) cube is located on company's internal network which requires a on-premises data gateway to refresh its data.
upvoted 1 times
...
TechDiva
3 years, 1 month ago
I got it on my exam 03/17/2022. 90-95% questions were from here. 61 questions in 100 min. All 3 case studies that appeared in exam, where from here.
upvoted 1 times
TechDiva
3 years, 1 month ago
Answered: d
upvoted 1 times
...
...
Dyma
3 years, 1 month ago
here is the answer, the correct option is D since it was done on the desktop and you want to publish the report to the Power BI Service https://docs.microsoft.com/es-es/power-bi/connect-data/desktop-analysis-services-tabular-data#frequently-asked-questions
upvoted 1 times
...
PatrickStr
3 years, 4 months ago
on exam 12/10/2021
upvoted 2 times
...
aguilartu1
3 years, 5 months ago
on exam - Nov 11, 2021. my answer: an On-premises data gateway
upvoted 2 times
...
kcwood94
3 years, 6 months ago
On exam 10/14/21
upvoted 1 times
...
nowwin
3 years, 7 months ago
question in exam on 18th September
upvoted 2 times
...
cmonte2
3 years, 10 months ago
D, no doubt.
upvoted 2 times
...
amadeus21
3 years, 12 months ago
D is correct - this video explains it https://www.youtube.com/watch?v=WJ5Y4FjkWZw
upvoted 3 times
...
SirChris
4 years ago
According to this link it's D. https://docs.microsoft.com/en-us/power-bi/consumer/end-user-subscribe Opening line says "It's never been easier to stay up-to-date on your most important dashboards and reports. Subscribe to report pages and dashboards". With the article being created in Feb 2021, I would say this is the most up to date document at the time of typing.
upvoted 1 times
...
manlynn
4 years ago
The point of this question is "to ensure the user consumes the most up-to-date reports". A gateway can only ensure the user access the data source but cannot ensure the reports are most up-to-date. But subscription can. Please refer to this material. I would go with A. https://docs.microsoft.com/en-us/power-bi/consumer/end-user-subscribe
upvoted 2 times
Maue
4 years ago
I undersand, but remember that the Microsoft questions always refers to the "most correct answer", not "the only correct" answer... and they do that reffering the question context too, when they said "internal network... SASS...", I know, that is anoying
upvoted 1 times
...
O_Anjum
3 years, 8 months ago
Easier way would be to schedule a refresh cube data job on SQL server daily. Now everyday the users will have fresh data on their report.
upvoted 1 times
...
...
lyniguez
4 years, 1 month ago
D is correct. We use cube data sources in SSAS at my company and this is how we have refresh set up.
upvoted 1 times
...
VM_GCP
4 years, 1 month ago
D Data refresh is not necessary for live connection https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-data
upvoted 2 times
...
Sujeet88
4 years, 2 months ago
Go with D as that is minimum set up needed. The connection can be Live mode as well. Hence D is correct !
upvoted 1 times
...
Load full discussion...
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
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago