exam questions

Exam 70-778 All Questions

View all questions & answers for the 70-778 exam

Exam 70-778 topic 1 question 22 discussion

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

You use Power BI Desktop to create a visualization for a Microsoft SQL Server data source.
You need to ensure that you can use R visualization.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

  • A. Download and install Microsoft R Server.
  • B. Download and install RStudio Server on the computer that has Power BI Desktop installed.
  • C. Install SQL Server R Services on the server that runs SQL Server.
  • D. Enable R Scripting on the computer that has Power BI Desktop installed.
  • E. Download and install Microsoft R on the computer that has Power BI Desktop installed.
Show Suggested Answer Hide Answer
Suggested Answer: E 🗳️
References:
https://docs.microsoft.com/en-us/power-bi/desktop-r-visuals

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
shubhamgupta
Highly Voted 6 years, 1 month ago
D&E are correct. 1- download and install R Services 2- specifying local R installation in the R Scripting section of the Options dialog box.
upvoted 22 times
...
mohroshdy
Highly Voted 5 years, 8 months ago
Two actions to be performed: 1- answer E -> Download Microsoft R 2- answer D -> Enable R visuals in Power BI Desktop So the correct answers are E & D
upvoted 13 times
...
RohiniNarayan
Most Recent 2 years, 7 months ago
The part of the mentioned link says - "R visuals are created from R scripts, which might contain code with security or privacy risks. When attempting to view or interact with an R visual for the first time, a user is presented with a security warning message. Only enable R visuals if you trust the author and source, or after you review and understand the R script." Which means that we need to enable R visuals, if not R scripting.
upvoted 1 times
...
osaid
4 years, 8 months ago
A and E cannot be correct. R is not Microsoft. It is opensource. Answers are: B. Download and install RStudio Server on the computer that has Power BI Desktop installed. D. Enable R Scripting on the computer that has Power BI Desktop installed. After you've installed R, Power BI Desktop enables it automatically. However, when you insert the R Visual, it asks you to 'Enable Script Visuals'.
upvoted 2 times
osaid
4 years, 8 months ago
Sorry, D and E are correct.
upvoted 1 times
...
...
edgar20
4 years, 8 months ago
the correct answer is E, because in the documentation says that you only need to download and install R in the computer where you have Power BI Installed. After you've installed R, Power BI Desktop enables it automatically. This question was very confuse because says two actions, and I could undestand that like 2 options to check but not... this is the reference https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-r-visuals
upvoted 1 times
...
edgar20
4 years, 8 months ago
the correct answer is D, because in the documentation says that you only need to download and install R in the computer where you have Power BI Installed. After you've installed R, Power BI Desktop enables it automatically. This question was very confuse because says two actions, and I could undestand that like 2 options to check but not... this is the reference https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-r-visuals
upvoted 1 times
...
Lhouss
4 years, 8 months ago
D & E.
upvoted 1 times
...
ThisIsStupid
4 years, 9 months ago
You have to select 2 answers on this question per the instructions: Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point. Therefore the correct answers are D&E
upvoted 1 times
...
CDL
4 years, 9 months ago
E: download & install R engine(Package) to PBI desktop; D: Enable R icon, open R script editor, copy and paste and Run. (included in package or otherwise downloaded separately); Ref Link: https://www.youtube.com/watch?v=Y88s8Vra_1g
upvoted 1 times
...
CDL
4 years, 9 months ago
E: download R engine to PBI desktop; D: download R script; Ref Link: https://www.youtube.com/watch?v=Y88s8Vra_1g
upvoted 1 times
...
da_boston
4 years, 10 months ago
TWO actions as per question: "Which two actions should you perform? Each correct answer presents part of the solution."
upvoted 1 times
...
KR1998
4 years, 11 months ago
E & D.
upvoted 1 times
...
cromastro
4 years, 11 months ago
The answer is E. If you read the first 15 lines of https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-r-visuals ... It says simply download and install R on the computer where Power BI desktop exists. It further says that Power BI automatically enables R once this is done.
upvoted 1 times
...
gawa
5 years, 1 month ago
D&E are correct. When using R for the firt time on the machine, you need to enable R after installing it.
upvoted 1 times
...
ferdcoz
5 years, 1 month ago
E is correct. Says 2 actions: download and install
upvoted 1 times
...
DAX_learner
5 years, 3 months ago
"After you've installed R, Power BI Desktop enables it automatically"... i understood form the quote we no need to enable R personally
upvoted 1 times
...
JohnFan
5 years, 8 months ago
SQL Server R Services lets you execute R scripts in-database. You can use it to prepare and clean data, do feature engineering, and train, evaluate, and deploy machine learning models within a database. The feature runs your scripts where the data resides and eliminates transfer of the data across the network to another server. Base distributions of R are included in R Services. You can use open-source packages and frameworks in addition to the Microsoft packages RevoScaleR, MicrosoftML, [olapR]../r/ref-r-olapr.md), and sqlrutils for R. R Services uses an extensibility framework to run R scripts in SQL Server. Learn more about how this works: Extensibility framework R extension https://docs.microsoft.com/en-us/sql/advanced-analytics/r/sql-server-r-services?view=sql-server-2016 https://docs.microsoft.com/en-us/sql/advanced-analytics/tutorials/deepdive-visualize-sql-server-data-using-r?view=sql-server-ver15
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 ...