Online Access Free 070-779 Exam Questions

You create the PivotChart shown in the exhibit. (Click the Exhibit button.) Exhibit:

In which area is Product and in which area is SalesAmount? To answer, drag the appropriate fields to the correct areas. Each field 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.

Correct Answer:

Explanation

Box 1: Product: Axis
Box 2: SalesAmount: Values

Note: This question is part of a series of questions that use the same scenario, For your convenience 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 tables 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.

Your company has 100 product subcategories and more than 10,000 products.
End of repeated scenario.
You need to create a chart as shown in the following exhibit.

Which field should you use for each area? To answer, drag the appropriate fields to the correct areas. Each field 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.

Correct Answer:

Explanation
Axis: Month Year
Legend: ChanelName
Values: SalesAmount

You have an Excel workbook that has the following two workbook queries:
* A query named Consultants that retrieves a table named Consultants_Contact from a Microsoft SQL Server database
* A query named Employees that retrieves a table named Employee_Contact from a Microsoft Azure SQL database Both tables have the same columns.
You need to combine all the data from Consultants and Employees into one table.
Which command should you use?

• A.Combine Binaries
• B.Append Queries
• C.Merge Queries
• D.Transpose

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 a PivotChart.
You plan to share SalesResults.xlsx 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.Modify the source of the query.
• B.Run the Document Inspector.
• C.Save the workbook as an Excel Binary Workbook (.xlsb).
• D.From Query Editor, open the Data Source Settings and delete the credentials.

You have a workbook query that loads data from C:\Data\Users.xlsx.
You move Users.xlsx to a shared folder on the network.
You need to ensure that you can refresh the data from Users.xlsx.
What should you do?

• A.From the Data tab in Excel click Connections, and then modify the properties of the connection.
• B.From the Linked Table tab in Power Pivot, modify the Update Mode.
• C.From the Insert tab in Excel, click My Add-ins, and then manage the add-ins.
• D.From Query Editor, modify the Source step.