Online Access Free 070-779 Practice Test

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 Excel workbook that contains a table named Table1. A sample of the data in Table1 is shown in the following table.

You need to create a PivotTable in PowerPivot as shown in the exhibit.

Solution: You create a measure named Products the uses the CONCATENATEX DAX function. You add a PivotTable. You drag Products to the Rows field. You drag Price to the Values field.
Does this meet the goal?

• A.Yes
• B.No

Note: This question is part of a series of questions that use the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a different goal and answer choices, but the text of the scenario is the same in each question in this series.
Start of repeated scenario
You have six workbook queries that each extracts a table from a Microsoft Azure SQL database. The table are loaded to the data model, but the data is not loaded to any worksheets. The data model is shown in the Data Model exhibit. (Click the Exhibit Your company has 100 product subcategories and more than 10,000 products.

End of repeated scenario.
You have a PivotChart that uses Manufacturer as the axis and the sum of SalesAmount as the values.
You need to ensure that only the top 10 manufactures appear in the chart.
What should you do?

• A.Change the format of the SalesAmount field.
• B.Configure the Value Filters.
• C.Summarize the SaleAmount field by Max.
• D.Create a calculated column.

You are building a KPI.
You need to configure the KPI to display a red icon when the sales from a month is less than nine percent of the sales from the last 12 months.
What should you use to define the target value?

• A.a measure
• B.a calculated column
• C.an absolute value
• D.a calculated field

You have the Excel worksheet shown in the exhibit.

You need to transform the data by using Query Editor.
What should you do first?

• A.From the Data tab, Click From Table/Range.
• B.From the Insert tab, Click Store.
• C.From the Data tab, Click Consolidate.
• D.From the Data tab, Click Flash Fill.

You create an Excel workbook named SalesResults.xlsx. You create a workbook query that connects to a Microsoft SQL Server Database and loads data to the data model. You create a PivotTable and PivotChart.
You plane to share SalesResults.slsx to several users outside of your organization.
You need to ensure that the users can see the PivotTable and the PivotChart when they open the file. The data in the model must be removed.
What should you do?

• A.From Query Editor, open the Data Source Setting and delete the credentials.
• B.Save the workbook as an Excel Binary Workbook (xlsx)
• C.Run the Document inspector.
• D.Modify the source of the query.