[Free] EnsurePass Microsoft 70-779 Real Exam Dumps Questions 21-30

Question No.21

DRAG DROP

You need to create a PivotChart as shown in the exhibit. (Click the Exhibit button.)

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:

Question No.22

You have a workbook query that gets a table from an Excel workbook. The table contains a column1.

In the query, you configure Column1 to use a Data Type of Whole Number.

You refresh the data and find several errors in Column1. You discover that new entries in the table contain nonnumeric characters.

You need to ensure that when the data is imported, any fields that contain nonnumeric values are set 1.

What should you do from Query Editor?

Select the table and click Keep Errors.

Select the column and click Replace Values…

Select the column and click Remove Errors.

Select the column and click Replace Errors…

Correct Answer: D

Question No.23

HOTSPOT

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 tables are loaded to the data model, but the data is not loaded to any worksheet. The data model is shown in the Data Model exhibit. (Click the Exhibit button.)

Your company has 100 product subcategories and more than 10,000 products.

End of repeated scenario.

You need to create a measure named [Sales Monthly RT] that calculates a running total of [Sales] for each date within a month as shown in the following exhibit.

Correct Answer:

Question No.24

You have a PivotChart template named Template1. You add a PivotChart to a worksheet.

You need to apply the template to the PivotChart. What should you do?

On the Design tab, click Change Chart Type.

On the Format tab, click Format Selection.

Right-click the chart and then click PivotChart Options.

Right-click the chart and then click Format Chart Area.

Correct Answer: A

Explanation:

Click the chart.

On the Charts tab, under Change Chart Type, click Other, and then under Templates, click the chart template that you created.

Question No.25

You have a model that contains data relating to corporate profits. The model contains a measure named Profit.

You need to create a PivotTable to display the Profit measure in three different formats by using the Show Value As feature. The PivotTabte must produce the results shown in the following table.

How should you configure the Show Value As feature for % Profit of Annual Total and % Profit of Grand Total? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Correct Answer:

Question No.26

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 the following data.

You need to retrieve a list of the unique ProductName entries.

Solution: Create a PivotTable that uses the ProductName field in the Rows area. Does this meet the goal?

Yes

No

Correct Answer: B

Question No.27

DRAG DROP

You have a model that contains the following table named Sales.

You have a measure named TotalSales that calculates the sum of LineTotal.

You plan to create a PivotChart to display TotalSales for each category and the percent of total sales for each category as shown in the following exhibit.

How should you complete the DAX formula for the Percent measure? 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:

Question No.28

You have a table named Sales that has three columns named OrderDate, OrderNumber, and SalesAmount.

You need to create the PivotTable as shown in the following table.

What should you use?

KPIs

sparklines

conditional formatting

banded rows

Correct Answer: A

Question No.29

DRAG DROP

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

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:

Question No.30

You have a table named Sales that has three columns named Region, Country, and SalesAmount.

You create a PivotTable as shown in the following exhibit.

You need to ensure that the PivotTable appears in three columns as shown in the following exhibit.

What should you do?

On the Design tab, click Report Layout and then click Show in Compact Form.

Move Country from the Rows area to the Columns area.

Move Country from the Rows area to the Values area.

On the Design tab, click Report Layout and then click Show in Tabular Form.