Online Access Free 070-778 Exam Questions

Note: This question is a 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 two columns named Date and Time.
The tables have the following relationships:
* Sales [DueDate] and Date [Date]
* Sales [ShipDate] and Date [Date]
* Sales [OrderDate] and Date [Date]
The active relationship is on Sales [DueDate].
You need to create measures to count the number of orders by [ShipDate] and orders by [OrderDate]. You must meet the goal without loading any additional data.
Solution: You create a calculated table. You create a measure that uses the new table.
Does this meet the goal?

• A.Yes
• B.No

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

• A.DATESYTD
• B.PARALLELPERIOD
• C.SAMEPERIODLAST YEAR
• D.PREVIOUSYEAR

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.

• A.Yes
• B.No

You have two tables named Customer and Orders. A sample of the Data in Customer is shown in the following table.

A sample of the data in Orders is shown in the following table.

You need to create the following new table.

You must use Customer as the first table.
Which join kind should you use?

• A.Right Outer
• B.Left Anti
• C.Right Anti
• D.Left Outer
• E.Inner

You open powerbi.com as shown in the following exhibit.
Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.
NOTE: Each correct selection is worth one point.

Correct Answer:

Explanation

References: https://docs.microsoft.com/en-us/power-bi/service-data-classification