exam questions

Exam 70-778 All Questions

View all questions & answers for the 70-778 exam

Exam 70-778 topic 2 question 4 discussion

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

You have an on-premises Power BI Report Server.
You plan to create a report in Power BI Desktop and publish the report to the report server.
Which data source should the report use?

  • A. Microsoft Azure SQL Database
  • B. a Microsoft SQL Server database
  • C. a Microsoft SQL Server Analysis Services (SSAS) database
  • D. Microsoft Excel
Show Suggested Answer Hide Answer
Suggested Answer: C 🗳️
References:
https://docs.microsoft.com/en-us/power-bi/report-server/quickstart-create-powerbi-report https://docs.microsoft.com/en-us/power-bi/report-server/connect-data-sources

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
Sim
Highly Voted 5 years, 6 months ago
I think multiple choices should be allowed on this question. As you can create a report from all the data sources mentioned and published to the on-premise report server.
upvoted 21 times
HiJaak
5 years, 2 months ago
You are right - all of them are allowed as long there are no limiting requirements as Live\DirectQuery.
upvoted 3 times
...
coupet
4 years, 7 months ago
Power BI report data sources in Power BI Report Server https://docs.microsoft.com/en-us/power-bi/report-server/data-sources
upvoted 1 times
...
...
iaaqq
Most Recent 3 years, 10 months ago
Based on the actual doc, A B C are corrects
upvoted 1 times
...
CDL
4 years, 1 month ago
C. https://docs.microsoft.com/en-us/power-bi/report-server/quickstart-create-powerbi-report#step-2-select-a-data-source
upvoted 2 times
...
Echicken69
4 years, 5 months ago
This question is so misleading. So what the reference is saying is that when you is that You can store and manage Power BI reports on premises in the Power BI Report Server web portal, just as you can store Power BI reports in the cloud in the Power BI service (https://powerbi.com). However, in the example it states that you are saving it to the SSRS. Is this the same as publishing it? Can someone please explain this to me?https://docs.microsoft.com/en-us/power-bi/report-server/quickstart-create-powerbi-report
upvoted 1 times
...
Echicken69
4 years, 5 months ago
Confused again... this lists all data-sources supported by SSRS...https://docs.microsoft.com/en-us/sql/reporting-services/report-data/data-sources-supported-by-reporting-services-ssrs?view=sql-server-ver15
upvoted 1 times
...
r8d1
4 years, 5 months ago
seems that SSAS is the best option if you consider the features marked as "Yes".
upvoted 1 times
...
lozqt
4 years, 9 months ago
To me A, B, & C are correct as it is listed in the following doc from Microsoft https://docs.microsoft.com/fr-fr/sql/reporting-services/report-data/data-sources-supported-by-reporting-services-ssrs?view=sql-server-ver15
upvoted 1 times
Israel2
4 years, 7 months ago
Reporting services (SSRS) is a different tool than Power BI report server
upvoted 1 times
...
...
twane
5 years, 3 months ago
https://docs.microsoft.com/nl-nl/power-bi/report-server/data-sources So, all of them are OK.
upvoted 1 times
JohnFan
5 years ago
https://powerbi.microsoft.com/en-us/report-server/
upvoted 1 times
...
...
3water
5 years, 3 months ago
I think all of them are ok
upvoted 2 times
JohnFan
5 years ago
You plan to use Power BI Embedded to deliver reports in a web application. You need to ensure that the reports display live data. Which data source you should use?
upvoted 1 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
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago