Online Access Free 070-778 Practice Test

You are creating a report in Power BI Desktop.
You are consuming the following tables.

You have a new table named Fiscal that has the same schema as the Date table, but contains the fiscal dates of your company.
You need to create a report that displays the total sales by fiscal month and calendar month.
What should you do?

• A.Add Fiscal to the model and create a one-to-one relationship by using Date[Year] and Fiscal[Year].
• B.Merge Fiscal into the Date table.
• C.Union Fiscal and Date as one table.
• D.Add Fiscal to the model and create a one-to-many relationship by using Date[Year] and Fiscal[Year].

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have a Microsoft Excel workbook that is saved to Microsoft SharePoint Online. The workbook contains several Power View sheets.
You need to recreate the Power View sheets as reports in the Power BI service.
Solution: From Excel, click Publish to Power BI, and then click Export.
Does this meet the goal?

• A.Yes
• B.No

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.a Microsoft SQL Server Analysis Services (SSAS) database
• B.a Microsoft SQL Server database
• C.Microsoft Azure SQL Database
• D.Microsoft Excel

You have the following tables.

You need to create a new table that displays the top 10 customers by the total of SalesAmount.
How should you complete the DAX formula? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Correct Answer:

Explanation

References: https://msdn.microsoft.com/en-us/library/gg492198.aspx

Your organization has a team of power users who recently created 20 Power BI dashboards.
The power users share the dashboards with other users in the organization.
When the users attempt to access the dashboards, they receive the error message shown in the exhibit. (Click the Exhibit.)

You need to ensure that all the users can access the dashboards.
What should you do first?

• A.From the Microsoft Office 365 Admin center, and the Power BI (free) subscription, and then assign a license to each user.
• B.From the Power BI Admin portal, modify the Privacy Settings.
• C.Instruct each user to install Microsoft Office 2016.
• D.From the properties of each dashboard, modify the Share dashboard settings.