Microsoft 70-779 Online Practice Questions and Exam Preparation

Microsoft 70-779 Online Questions & Answers

• Question 31:

  HOTSPOT

  You have the following tables.

  

  There is a relationship between the tables.

  You need to create a measure that displays how many users have a total TimeInMinutes that is greater than 60.

  How should you complete the DAX formula? To answer, select the appropriate options in the answer area.

  NOTE: Each correct selection is worth one point.

  Hot Area:

  

  

• Question 32:

  DRAG DROP

  You have a query as shown in the following exhibit.

  

  You need to ensure that the data only contains rows that have a valid date.

  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 33:

  You have two queries named client and invoice. A sample of Client is shown in the following table.

  

  A sample of Invoices is shown in the following table.

  

  You need to create a new table that has the following information.

  

  Which join kind should you use?

  A. Inner
  B. Left Outer
  C. Right Anti
  D. Left Anti
  B. Left Outer

• Question 34:

  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 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 have a PivotChart that uses Manufacturer as the axis and the sum of SalesAmount as the values.

  You need to ensure that only the top 10 manufacturers appear in the chart.

  What should you do?

  A. Change the format of the SalesAmount field.
  B. Create a calculated column.
  C. Configure the Value Filters.
  D. Summarize the SaleAmount field by Max.
  C. Configure the Value Filters.

• Question 35:

  DRAG DROP

  You have the following table named SalesOrder Detail in a model.

  

  You need to calculate the sum of SalesTotal for all the rows that have a quantity greater than 1.

  Select and Place:

  

  

• Question 36:

  DRAG DROP

  You have a table that contains the following data.

  

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

  

  How should you configure the PivotTable? 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 37:

  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 calculated column that uses the RELATED DAX function

  Does this meet the goal?

  A. Yes
  B. No
  A. Yes

• Question 38:

  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?

  A. KPIs
  B. sparklines
  C. conditional formatting
  D. banded rows
  A. KPIs

• Question 39:

  Drag and Drop.

  You need to create a PivotChart as shown in the 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 40:

  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?

  A. an absolute value of 0
  B. the Total Sales Current Year measure
  C. an absolute value of 100
  D. the Total Sales Last Year measure
  A. an absolute value of 0