Microsoft 70-779 Online Practice Questions and Exam Preparation

Microsoft 70-779 Online Questions & Answers

• Question 1:

  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?

  A. From the Power BI tab in Excel, click Pin.
  B. From the File menu in Excel, click Publish.
  C. From powerbi.com, upload the excel workbook.
  D. From powerbi.com, click Get apps.
  A. From the Power BI tab in Excel, click Pin.

• Question 2:

  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?

  A. Right-click the chart and then click Format Chart Area.
  B. Right-click the chart and then click PivotChart Options.
  C. On the Format tab, click Format Selection.
  D. On the Design tab, click Change Chart Type.
  D. On the Design tab, click Change Chart Type.

• Question 3:

  You open an Excel worksheet as shown in the following exhibit.

  

  You need to export the data into a dataset in the Microsoft Power BI service. What should you do first?

  A. Save the tile as an Excel template.
  B. Select the data, and then insert a table.
  C. Select the data, and Then insert a PivotTable.
  D. Install Power BI Publisher for Excel.
  D. Install Power BI Publisher for Excel.

• Question 4:

  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 You create a new connection to Production1, and then you import the tables.

  Does this meet the goal?

  A. Yes
  B. No
  B. No

• Question 5:

  DRAG DROP

  You create a new workbook and add a table to a data model. The data is shown in the following table.

  

  You need to create a visualization as shown in the following exhibit.

  

  Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

  Select and Place:

  

  

• Question 6:

  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.

  Select the ProductName column, and then click Group on the Data tab.

  Does this meet the goal?

  A. Yes
  B. No
  B. No

• Question 7:

  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.

  

  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 modify the conditional formatting rule, and then set a new value for the yellow icon.

  Does this meet the goal?

  A. Yes
  B. No
  B. No

• Question 8:

  Your company has a data analyst who uses Microsoft Power BI Desktop to create a data model and several reports.

  The data analyst publishes the reports to the Power BI service.

  You need to create a PivotTable in Excel that uses the data model created by the data analyst. The solution must prevent the data from being imported into Excel.

  What should you do first?

  A. From powerbt.com, select the report. From the File menu, click Save as.
  B. From Excel, create a new query that uses the Data Catalog.
  C. From powerbi.com, select the report From the File menu, click Download report.
  D. From powerbi.com, select the report and click Analyze in Excel.
  D. From powerbi.com, select the report and click Analyze in Excel.

• Question 9:

  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?

  A. Yes
  B. No
  A. Yes

• Question 10:

  You create a PivotTable and a Pivot Chart as shown in the following exhibit.

  

  You need to decrease the number of columns in the PivotChart to six. What should you do?

  A. Right-click the PivotChart, click Format Axis, and then change Interval between marks to 2.
  B. Right-click the PivotTable, click Group, and then change By from 10 to 20.
  C. Right-click the PivotChart, click Select Data, and then remove five of the bins from the Horizontal (Category) Axis Labels.
  D. Change the chart type to Histogram.
  B. Right-click the PivotTable, click Group, and then change By from 10 to 20.