Microsoft 70-779 Online Practice Questions and Exam Preparation

Microsoft 70-779 Online Questions & Answers

• Question 111:

  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 File tab, click Option, and then modify the Data option.
  B. From the Power Pivot model, modify the Table Behavior setting.
  C. From the File tab, click Options, and then modify the General options.
  D. From the Data tab, click Queries and Connections, and then edit the properties of the query.
  D. From the Data tab, click Queries and Connections, and then edit the properties of the query.

• Question 112:

  DRAG DROP

  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 thescenario 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 worksheets. The data model is shown in the Data Model exhibit.

  (Click the Exhibit button.)

  Exhibit:

  

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

  End of repeated scenario.

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

  

  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.

  Select and Place:

  

  

• Question 113:

  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 Power Pivot model that contains the following tables.

  

  There is a relationship between Products and ProductCategory.

  You need to create a hierarchy in Products that contains ProductCategoryName and ProductName.

  Solution: You create a measure that uses the USERELATIONSHIP DAX function.

  Does this meet the goal?

  A. Yes
  B. No
  B. No

• Question 114:

  DRAG DROP

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

  Exhibit:

  

  In which area is Product and in which area is SalesAmount? To answer, drag the appropriate fields to the correct targets. 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.

  Select and Place:

  

  

• Question 115:

  You have a workbook query that loads data from a table named Products.

  Products contains a column named IntemalPrice that has a Data Type of Decimal.

  From Query Editor you create a custom column named ResellerPrice that uses a formula to multiply InternalPrice by 1.2, and then you remove the IntemalPrice column.

  What will occur when you load the data to a worksheet?

  A. All the columns except InternalPrice will load to the worksheet The values in ResellerPrice will be correct.
  B. An error message will appear and all the data will fail to load.
  C. An error message will appear and all the columns except InternalPnce and ResellerPrice will load to the worksheet.
  D. All the columns except InternalPrice will load to the worksheet. The values in ResellerPrice will be null.
  D. All the columns except InternalPrice will load to the worksheet. The values in ResellerPrice will be null.