70-778 Free Practice Test

You need to create a dashboard in the Power BI service to display data from a PubNub source. What should you do?

1. A. Add a Microsoft SQL Server Analysis Services (SSAS) data source that uses Connect live and create a repor
2. B. Pin the report to a dashboard.
3. C. Create an app workspace and publish the workspace to a dashboard.
4. D. Add a Microsoft Azure SQL database data source that uses DirectQuery and create a repor
5. E. Pin the report to a dashboard.
6. F. Add a custom streaming data tile to a dashboard.

Correct Answer: D
References:
https://docs.microsoft.com/en-us/power-bi/service-real-time-streaming#set-up-your-real-time-streaming-dataset-

You embed a Power BI report in a Microsoft SharePoint Online page.
A user name User1 can access the SharePoint Online page, but the Power BI web part displays the following error message: “This content isn’t available”.
User1 is unable to view the report.
You verify that you can access the SharePoint Online page and that the Power BI report displays as expected. You need to ensure that User1 can view the report form SharePoint Online.
What should you do?

1. A. Publish the app workspace.
2. B. Edit the settings of the Power BI web part.
3. C. Modify the members of the app workplace.
4. D. Share the dashboards in the app workspace.

Correct Answer: C
References: https://docs.microsoft.com/en-us/power-bi/service-embed-report-spo

You have a Power BI model that has a date table. A sample of the data shown in the following table.
<>

1. A. FORMAT([Date], "MMM") & " " & FORMAT([Date], "DO") & ", " & FORMAT([Date], "YYYY")
2. B. FORMAT([Date], "MM") & " " & FORMAT([Date], "DO") & ", " & FORMAT([Date], "YYYY")
3. C. [Date].[Month] & " " & FORMAT([Date], "D") & ", " & [Date].[Year])
4. D. FORMAT([Date], "MMMM DO, YYYY")

Correct Answer: D

You have the visualization shown in the following exhibit.
< ><>>< ><>

1. A. Create a calculated column that adds the % symbol to the values.
2. B. From the Modeling tab, change the Data Type to Percentage.
3. C. Edit the query of the data source and change the Data Type to Percentage.
4. D. Create a measure that adds the % symbol to the values,

Correct Answer: D

You open powerbi.com as shown in the following exhibit.
< ><>>>< >
Solution:
References: https://docs.microsoft.com/en-us/power-bi/service-data-classification

Does this meet the goal?

1. A. Yes
2. B. No

Correct Answer: A