Microsoft 070-778 Actual Free Exam Questions & Community Discussion

From Power BI Desktop, you create a query that imports the following table.

You need to configure the table to appear as shown in the following table.

What should you do?

You have a Power B1 model for sales data. You create a measure to calculate the year-to-date sales. You need to compare the year-to-date sales with the previous year for the same time period. Which DAX function should you use?

You have a table that contains a column named Phone. The following is a sample of the data in the Phone column.
You need to add a new column that contains the data in the format of nnn-nnn-nnnn.
How should you complete the Query Editor formula? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

You have an app workspace named Retail Store Analysis in the Power Bl service.
You need to manage the members that have access to the app workspace using the least amount of administrative effort.
What should you do?

You have the following two tables:
* Subscriber (SubscriberlD, Enroll mentDate, ServicePlan)
* Date (Date, Month, Week, Year)
There is a relationship between Subscriber [EnrollmentDate] and Date[Date].
You plan to create a KPI for the number of subscribers enrolled in the current year.
You need to create a goal that is five percent more than the number of subscribers enrolled during the previous calendar year.
How should you complete the DAX formula? 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.

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 user named User!. User1 is a member of a security group named Contoso PowerB1.
User1 has access to a workspace named Contoso Workspace.
You need to prevent User1 from exporting data from the visualizations in Contoso Workspace.
Solution: From the Power B1 Admin portal, you modify the Tenant settings.

You have a Power BI app named App1. The privacy for the App1 workspace is set to Private.
A user named User1 reports that App1 does not appear in the My organization AppSource. App1 appears in the My organization AppSource for your account.
You need to ensure that User sees App1 from the My organization AppSource.
What should you do?

You have a Power BI report in an app workspace.
You plan to embed a report from the app workspace into a line-of-business application by using Power BI Embedded.
Which information should you provide to the application developers?

Your company has a custom line-of-business application named SalesApp.
The developers of SalesApp want to push data into the Power BI service to create several visualizations.
You need to ensure that the developers can push the data from SalesApp to the Power BI service.
What should you do?

You have an app workspace named Retail Analysis in the Power BI service.
You need manage the members that have access to the app workspace.
What should you do?

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 Power BI model that contains two tables named Sales and Date. Sales contains four columns named TotalCost, DueDate, ShipDate, and OrderDate. Date contains one column named Date.
The tables have the following relationships:
The active relationship is on Sales[DueDate].
You need to create measures to count the number of orders by [ShipDate] and the orders by [OrderDate]. You must meet the goal without duplicating data or loading additional data.
Solution: You create measures that use the CALCULATE, COUNT, and FILTER DAX functions.
Does this meet the goal?

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: Configure the app workspace to be read-only for members and to run in a shared capacity.
Does this meet the goal?

You have a Microsoft SQL Server Analysis Services (SSAS) cube that contains historical data.
In Power BI Desktop, you have the following query for the cube.

The query retrieves 25,499 records.
When you check the data warehouse that is the source of the cube, you discover that there are 26,423 records.
You need to ensure that the query retrieves all 26,423 records.
What should you do?

You are creating a report in Power BI Desktop that has two visualizations on a page as shown in the following exhibit.

You need to ensure that when you click the bar of a country, only the values for that country are shown on the Revenue by Year and Manufacturer chart.