Free Microsoft 70-779 Exam Dumps Questions & Answers

You have the PivotTable shown in the following exhibit.

You need to display only rows in the PivotTable in which the sum of LineTotal is greater than 100.
What should you do?

• A.  Add LineTotal to the Filters area of PivotTable Fields. Configure the Filters value.
• B.  From Row Label, configure a Value Filter.
• C.  From Row Label, configure a Label filter.
• D.  Add a slicer for LineTotal and select the values from the slicer.

You have multiple workbook queries that load data from tables in Microsoft Azure SQL Database to a Power Pivot data model.
You discover that new rows were added to the tables in Azure SQL Database.
You need to ensure that the workbook has the new data.
Why should you do?

• A.  Close and open the workbook.
• B.  From the Power Pivot tab, click Update All.
• C.  Select a cell in the worksheet and pressF5.
• D.  From the data tab, click Refresh All.

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: You create a measure, and then define a target value.
Does this meet the goal?

• A.  No
• B.  Yes

You have a KPI named Goal that calculates the sales from the previous year and multiplies the sales by 1.1.
You need to modify Goal to multiply the sales from the previous year by 1.15.
What should you do?

• A.  From Power Pivot, modify the measure.
• B.  From the properties of the KPI, modify the KPI base field.
• C.  From Power Pivot, create a new calculated column, and then modify the KPI.
• D.  From the properties of the KPI, modify the absolute value.

You have an Excel workbook query that loads data to a worksheet and the data model.
You need to ensure that the data is refreshed whenever you open the workbook.
What should you do?

• A.  From the Power Pivot model, modify the Table Behavior setting.
• B.  From the Data tab, click Queries & Connections, and then edit the properties of the query.
• C.  From the File tab, click Options, and then modify the General options.
• D.  From the File tab, click Option, and then modify the Data option.