Microsoft 70-779 Online Practice Questions and Exam Preparation

Microsoft 70-779 Online Questions & Answers

• Question 61:

  DRAG DROP

  You have a workbook query that retrieves data from a table named Users. Users contains a column named PhoneNumber. The following is a sample of the data in PhoneNumber.

  514 555 0160 1 (11) 500 555-0122 128 555-0148 819 555-0186 1-996-555-0192 +1 138-555-0156 556-555-0192

  You need to create a custom column that contains the data in PhoneNumber in the format of 999-999-9999. The following is a sample of the desired data.

  514-555-0160 500-555-0122 128-555-0148 819-555-0186 996-555-0192 138-555-0156 556-555-0192

  How should you complete the Query Editor formula? To answer, drag the appropriate values to the correct targets. Each value 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 62:

  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 edit the source of each table query.

  Does this meet the goal?

  A. Yes
  B. No
  A. Yes

• Question 63:

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

  

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

  

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

  A. Double-click a bar in the PivotChart.
  B. Click the - button.
  C. Right-click the PivotChart and click Reset to Match Style.
  D. Right-click a bar in the PivotChart and click Expand Entire Field.
  D. Right-click a bar in the PivotChart and click Expand Entire Field.

• Question 64:

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

• Question 65:

  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 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 measure named [Sales Monthly RT] that calculates a running total of [Sales] for each date within a month as shown in the following exhibit.

  

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

  DRAG DROP

  You have 12 sales reports stored in a folder as CSV files. Each report represents one month of sales data for a year. The reports have the same structure.

  You need to analyze the entire year of sales data.

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

  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 ISCROSSFILTERED DAX function

  Does this meet the goal?

  A. Yes
  B. No
  B. No

• Question 68:

  HOTSPOT

  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 PivotTable 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.

  Hot Area:

  

  

• Question 69:

  You have a data model in Excel.

  You export the data and the data model into a dataset in the Microsoft Power BI service.

  What can you use to modify the data model that is published to the Power BI service?

  A. Microsoft Power BI Desktop
  B. Excel and the Microsoft Power BI service
  C. Excel only
  D. the Microsoft Power BI service only
  A. Microsoft Power BI Desktop

• Question 70:

  You have a query that retrieves customers and their locations. You have sample of the data as shown in the following table.

  

  Additional customers and locations are added frequently.

  You need to transform the data as shown in the following table.

  

  What should you do?

  A. Select the Locations columns and the select split column by delimiter. Use a comma as the delimiter and split into rows.
  B. Select the Customer columns, and then click Unpivot Columns.
  C. Select the Customer columns, and then click Unpivot other Columns.
  D. Select the Location columns and then select split column by delimiter. Use a comma as the delimiter and split into columns.
  A. Select the Locations columns and the select split column by delimiter. Use a comma as the delimiter and split into rows.