70-778 Free Practice Test

You plan to create a report in Power BI Desktop. You have the following tables.
< ><>>>>>< >
Solution:
References:
https://support.office.com/en-us/article/when-to-use-calculated-columns-and-calculated-fields-ca18d63a-5b6d-4

Does this meet the goal?

1. A. Yes
2. B. No

Correct Answer: A

You are importing sales data from a Microsoft Excel file named Sales.xlsx into Power BI Desktop. You need to create a bar chart showing the total sales amount by region.
When you create the bar chart, the regions appear as expected, but the sales amount value displays the count of sales amount instead of the sum of sales amount each region.
You need to modify the query to ensure that the data appears correctly. What should you do?

1. A. Delete the query, import the data into Microsoft SQL Server, and then import the data from SQL Server.
2. B. In Query Editor, add a calculated column that totals the sales amount column.
3. C. Change the Data Type of sales amount column to Numeric.
4. D. Refresh the data model.

Correct Answer: B

You create a dashboard that displays the results of a customer satisfaction survey. You need to embed a tweet from your company's Twitter feed into the dashboard. What should you do?

1. A. To the dashboard, add a tile that uses a web content source.
2. B. To the dashboard, add a tile that uses a PubNub content source.
3. C. Edit the report and import a visualization from a fil
4. D. Pin the visualization to the dashboard.
5. E. Edit the report and import a visualization from the marketplac
6. F. Pin the visualization to the dashboard.

Correct Answer: A
References:
https://docs.microsoft.com/en-us/power-bi/service-dashboard-add-widget

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

1. A. by MonthNumber
2. B. ascending
3. C. descending
4. D. by DateKey

Correct Answer: A
References:
http://ppmworks.com/sorting-month-names-chronologically-in-microsoft-power-bi-reports/

You have three Power BI Desktop projects named Reportl.pbix, Report2.pbix, and Report3.pbix that have the following characteristics:
• Report1.pbix contains a custom visualization.
• Report2.pbix implements row-level security.
• Report3.pbix connects to a Microsoft SQL Server database by using DirectQuery.
Which reports support Publish to Web, and which reports can be published to Power BI Report Server? To answer, drag the appropriate reports to the correct targets. Each report may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.

Solution:
References:
https://docs.microsoft.com/en-us/power-bi/service-publish-to-web#custom-visuals

Does this meet the goal?

1. A. Yes
2. B. No

Correct Answer: A