Online Access Free 070-779 Practice Test

You import the data from two next files into a PowerPivot model to create two tables named Customers and Invoices. Each table contains a column named CustomerID.
When you attempt to create a relationship between the Customers table and the Invoices table by using the CustomerID column from each table, the relationship cannot be created due to duplicate CustomerID values.
You need to ensure that you can create the relationship.
What should you do?

• A.Add an index column to the Customers query
• B.Add an index column to the Invoices query
• C.Group the Customers query by CustomerID
• D.Sort the Invoices query by CustomerID, and then add a Fill Down step

You have the following table.

You plan to use [Month Name] as the axis in a PivotChart.
You need to ensure that whenever [Month Name] is used in a chart, the months are displayed chronologically be default.
What should you do?

• A.Change the Data Type of [Month Name] to Date.
• B.Add a calculated column named [ID] that use the [Month Name] & [Month Number] DAX formula
• C.Sort the [Month Name] column by [Month Name].
• D.Sort the [Month Name] column by [Month Name].

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.
Your company has sales offices in several cities.
You create a table that represents the amount of sales in each city by month as shown in the exhibit.

You need to ensure that all values lower than 250 display a red icon. The solution must ensure that all values greater than 500 display a green icon.
Solution: From the What-If Analysis menu you modify the values of
Does this meet the goal?

• A.Yes
• B.No

You need to create a PivotChart that has a filter as shown in the following exhibit.

What should you do first?

• A.From the model, create a measure.
• B.From the model, create a hierarchy.
• C.From Query Editor, create a parameter.
• D.From Query Editor, create a function.

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 two Microsoft SQL Server database servers named Production1 and Test1. Production1 contains the same tables as Test1, but only a subset of the data.
You add Test1 as a data source, and you select 10 tables. You configure several transformations.
You need to connect the model to the tables in Production1. The solution must maintain the existing transformations.
Solution: From Query Editor, you configure the Data source settings.
Does this meet the goal?

• A.Yes
• B.No