Free Microsoft 070-779 Exam Dumps Questions & Answers

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 Flash Fill.
• B.  From the Insert tab, click Store.
• C.  From the Data tab, click From Table/Range.
• D.  From the Data tab, click Consolidate.

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 Flash Fill.
• B.  From the Data tab, Click From Table/Range.
• C.  From the Insert tab, Click Store.
• D.  From the Data tab, Click Consolidate.

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.  Merge Queries
• B.  Combine Binaries
• C.  Append Queries
• D.  Transpose

You have a table that contains sales data.
You need to create a Pivot Table that will display the sales by country as shown in the following exhibit.

What should you use to display the icons?

• A.  a measure
• B.  conditional formatting
• C.  a KPI
• D.  data validation

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 the properties of the KPI, modify the KPI base field.
• B.  From the properties of the KPI, modify the absolute value.
• C.  From Power Pivot, create a new calculated column, and then modify the KPI.
• D.  From Power Pivot, modify the measure.