Microsoft 70-779 Online Practice Questions and Exam Preparation

Microsoft 70-779 Online Questions & Answers

• Question 41:

  HOTSPOT

  You have a date column named [Date] in the format of mm-dd-yyyy.

  You need to create a column named Quarter that displays the yearly quarter. A sample of the desired data is shown in the following table.

  

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

  You have a table that contains sales data.

  You need to create a Pivot Table that will display the sales by country as shown in the following exhibit.

  

  What should you use to display the icons?

  A. a measure
  B. conditional formatting
  C. data validation
  D. a KPI
  B. conditional formatting

• Question 43:

  You have the Excel worksheet shown in the exhibit. (Click the Exhibit button.) Exhibit: You need to transform the data by using Query Editor. What should you do first?

  

  A. From the Data tab, click From Table/Range.
  B. From the Data tab, click Flash Fill.
  C. From the Data tab, click Consolidate.
  D. From the Insert tab, click Store.
  A. From the Data tab, click From Table/Range.

• Question 44:

  You have a data model that has the following tables.

  

  You create a PivotTable. The data displayed in the PivotTable is shown in the following table.

  You need to ensure that the correct data is displayed. What should you do?

  A. Modify the workbook connections
  B. Configure the PivotTable Options
  C. Modify the relationships
  D. Refresh the data connection
  C. Modify the relationships

• Question 45:

  DRAG DROP

  You have a table named Sales. Sales contains the following columns.

  

  You need to add a column that shows the first three letters of the day of the week.

  How should you complete the DAX 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 46:

  You have the following tables in a data model.

  

  You create a PivotTable to display SaleAmount by Month. A sample of the results are shown in the following table.

  

  A. In the data model, modify the Sort By Column setting for Date[Month Year].
  B. From PivotTable Fields, add Date[Year] to the Rows area;
  C. In the data model, modify the Sort by Column setting for Sales[Date].
  D. From PivotTable Fields, modify the Field Settings for Date[Month Year]
  D. From PivotTable Fields, modify the Field Settings for Date[Month Year]

• Question 47:

  DRAG DROP

  You have a data model that contains a table named SalesOrders. SalesOrders has four columns named OrderId, SalesAmount, OrderDate, and Territory.

  You plan to create a PivotChart that will display the percentage of SalesAmount for each Territory.

  You need to create a measure to calculate the percentage of sales of each territory.

  How should you complete the DAX 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 48:

  DRAG DROP

  You have a workbook query that gets data from a table in a Microsoft Azure SQL database. The table has a column named Phone. The values in Phone are in a format of 999-999-9999. The first three digits of each phone number represent

  the area code, and the rest of the digits represent the local phone number.

  You need to split the Phone column into two columns. The first column must contain the area code, and the second column must contain the local phone number.

  How should you complete the query? 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 49:

  DRAG DROP

  You merge several CSV files by using Query Editor.

  You need to remove all the leading whitespaces and all the non-printable characters from a column.

  What should you do to achieve each task? To answer, drag the appropriate actions to the correct goals. Each action 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 50:

  You have a pie chart.

  You need the wedges of the pie chart to be separated as shown in the following exhibit.

  

  What should you do?

  A. Change the chart type to Pie of Pie.
  B. Right-click the pie chart, click Expand/Collapse, and then click Expand.
  C. Right-click the pie chart, click Expand/Collapse, and Then click Expand Entire Field
  D. Select a wedge of the pie chart and then drag the wedge.
  D. Select a wedge of the pie chart and then drag the wedge.