[Free] EnsurePass Microsoft 70-779 Real Exam Dumps Questions 11-20

Get Full Version of the Exam
http://www.EnsurePass.com/70-779.html

Question No.11

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.

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.

image

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 new conditional formatting rule that uses the Format only cells that contain rule type.

Does this meet the goal?

  1. Yes

  2. No

Correct Answer: A

Explanation:

https://www.exceltip.com/conditional-formatting/microsoft-excel-conditional-formatting.html

Question No.12

You have an Excel spreadsheet that contains a PivotChart. You install Microsoft Power BI Publisher for Excel.

You need to add a tile for the PivotChart to a Power BI dashboard. What should you do?

  1. From the Power BI tab in Excel, click Pin.

  2. From the File menu in Excel, click Publish.

  3. From powerbi.com, upload the excel workbook.

  4. From powerbi.com, click Get apps.

Correct Answer: A

Question No.13

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.

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.

image

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: From the What-If Analysis menu you modify the values of Goal Seek . Does this meet the goal?

  1. Yes

  2. No

Correct Answer: B

Question No.14

You have a measure named SalesGrowth that calculates the percent of sales growth. The

measure uses the following formula.

([Total Sales Current Year] – [Total Sales Last Year]) / [Total Sales Last Year]

Total Sales Current Year is a measure that calculates the sales from the current calendar year. Total Sales Last Year is a measure that calculates the sales from the previous calendar year.

You need to create a KPI that displays a red icon when the sales growth is less than last year. What should you use to define the target value?

  1. an absolute value of 0

  2. the Total Sales Current Year measure

  3. an absolute value of 100

  4. the Total Sales Last Year measure

Correct Answer: D

Question No.15

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 two Microsoft SQL Server database servers named Production1 and Test1. Production1 contains the same tables as Test1, but only a subset of the data.

You add Test1 as a data source, and you select 10 tables. You configure several transformations.

You need to connect the model to the tables in Production1. The solution must maintain the existing transformations.

Solution: From Query Editor, you configure the Data source settings. Does this meet the goal?

  1. Yes

  2. No

Correct Answer: A

Question No.16

You need to configure a PivotChart as shown in the following exhibit.

image

Witch chart element should you enable?

  1. Data Labels

  2. Axis Titles

  3. Data Table

  4. Error Bars

Correct Answer: B

Question No.17

You have a query that retrieves the following data.

image

You need to configure the query to ensure that the data appears as shown in the following table.

image

What should you do?

  1. From the Transform tab, use the sum function on the Vendor_ID column

  2. Group by Vendor_ID and add a SUM aggregation

  3. Unpivot the table on the Vendor_ID column

  4. Pivot the table on the Vendor_ID column

Correct Answer: B

Question No.18

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 a query named Query1 that retrieves the user information from two Excel files. One of the Excel files does not contain location information. A sample of the data retrieved by the query is shown in the following table.

image

You need to ensure that values in UserName are unique. The solution must ensure that the locations are retained. A sample of desired output is shown in the following table.

image

Solution: You use the Group By function to group the rows by UserName and you specify output columns for UserID and Location by using the Max operation.

Does this meet the goal?

  1. Yes

  2. No

Correct Answer: B

Question No.19

You have the data model shown in the Data Model exhibit. (Click the Exhibit button.)

image

You have the PivotChart shown in the Pivot Chart exhibit. (Click the Exhibit button.)

image

You need to change the current view of the PivotChart to display ProductCategory only. What should you do?

  1. Double-click a bar in the PivotChart.

  2. Click the – button.

  3. Right-click the PivotChart and click Reset to Match Style

  4. Right-click a bar in the PivotChart and click Expand Entire Field.

Correct Answer: D

Question No.20

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.

image

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?

  1. Yes

  2. No

Correct Answer: B

Get Full Version of the Exam
70-779 Dumps
70-779 VCE and PDF

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.