File Info
| Exam | Analyzing and Visualizing Data with Microsoft Power BI |
| Number | 70-778 |
| File Name | Microsoft.70-778.CertDumps.2018-07-06.25q.tqb |
| Size | 1 MB |
| Posted | Jul 06, 2018 |
| Download | Microsoft.70-778.CertDumps.2018-07-06.25q.tqb |
How to open VCEX & EXAM Files?
Files with VCEX & EXAM extensions can be opened by ProfExam Simulator.
Coupon: MASTEREXAM
With discount: 20%
Demo Questions
Question 1
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.
- Download and install Microsoft R Server.
- Download and install RStudio Server on the computer that has Power BI Desktop installed.
- Install SQL Server R Services on the server that runs SQL Server.
- Enable R Scripting on the computer that has Power BI Desktop installed.
- Download and install Microsoft R on the computer that has Power BI Desktop installed.
Correct answer: E
Explanation:
References: https://docs.microsoft.com/en-us/power-bi/desktop-r-visuals References: https://docs.microsoft.com/en-us/power-bi/desktop-r-visuals
Question 2
You have a Power BI model that contains the following two tables:
- Sales(Sales_ID, sales_date, sales_amount, CustomerID)
- Customer(CustomerID, First_name, Last_name)
There is a relationship between Sales and Customer.
You need to create a measure to rank the customers based on their total sales amount.
Which DAX formula should you use?
- RANKX(ALL(Sales), SUMX(RELATEDTABLE(Customer), [Sales_amount]))
- TOPN(ALL(customer), SUMX(RELATEDTABLE(Sales), [Sales_amount]))
- RANKX(ALL(customer), SUMX(RELATEDTABLE(Sales), [Sales_amount]))
- RANK.EQ(Sales[sales_amount], Customer[CustomerID])
Correct answer: A
Explanation:
References: https://msdn.microsoft.com/query-bi/dax/rankx-function-dax References: https://msdn.microsoft.com/query-bi/dax/rankx-function-dax
Question 3
You have a Microsoft SharePoint Online site named Sales.
Your company has 1,000 sales users. All the sales users can access Sales.
You create a report in an app workspace in the Power BI service. You embed the report into a page on the Sales site by using the Power BI web part.
You need to ensure that all the sales users can view the report from the Sales site.
What should you do?
- Configure the Portal Site Connection for the Sales site.
- Enable anonymous access for the Sales site.
- Configure the app workspace for Premium capacity.
- Disable the Embed content in apps setting from the Tenant settings in Power BI.
Correct answer: C
Explanation:
References: https://docs.microsoft.com/en-us/power-bi/service-embed-report-spo References: https://docs.microsoft.com/en-us/power-bi/service-embed-report-spo
