Not sure whether TestSimulate fits your study style? Download the free demo and preview the 070-778 practice questions for Microsoft Analyzing and Visualizing Data with Power BI before you spend a cent.

Microsoft 070-778 Exam Overview:

Microsoft 070-778 Exam Syllabus Topics:

Common Questions About the Microsoft 070-778 Exam, Answered

Microsoft Analyzing and Visualizing Data with Power BI Sample Questions:

Question 1

You are creating reports in Power BI Desktop. The model has the following tables.

There is a relationship between the tables.
You plan to publish a report to the Power BI service that displays Order_amount by Order_date by Full_name.
You need to ensure that only the columns required for the report appear in Report View. The solution must minimize the size of the dataset that is published.
How should you configure the columns in Power BI Desktop? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Question 2

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.

Question 3

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 an app workspace that contains a report. The report contains sensitive data.
You need to ensure that you can embed the report into a custom application that will be accessed by external users. The external users will NOT have a Microsoft Azure Active Directory user account or Power BI licenses.
Solution: From Publish to web, generate an iFrame.
Does this meet the goal?

A. No
B. Yes

Question 4

You are creating a work schedule for a retail store.
You have the following data from a query named Schedule.

You need to visualize the data as shown in the following exhibit.

You add a matrix visualization, and then you add Employee to the rows and Scheduled to columns.
Which DAX formula should you use to create the measure that will display the checkboxes? To answer, drag the appropriate values to the correct targets. Each value 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.

Question 5

You have the visualization shown in the following exhibit.

You need to display the values as shown in the following exhibit.

What should you do?

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

Solutions: