← Back to exam page

70-779 – Analyzing and Visualizing Data with Microsoft Excel

Loading demo links...

Showing 7–8 of 8 questions

Question 7

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 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 type of chart should you use?

Select an option, then click Submit answer.

  • ○

    line with markers
  • ○

    clustered column
  • ○

    combo
  • ○

    stacked column
Question 8

You have a table in a Power Pivot model that is loaded from a Microsoft SQL Server database.

The source table has four columns named ID, Price, Quantity, and Total. Total is derived by multiplying Price and Quantity. ID is a unique row identifier.

You need to minimize the amount of memory used to load the model. The solution must ensure that you can create visualizations based on Price, Quantity, and Total.

What should you do?

Select an option, then click Submit answer.

  • ○

    Replace the Total column by using a measure
  • ○

    Replace the Total column by using a calculated column
  • ○

    From Query Editor, remove duplicate rows from the table
  • ○

    Move the Total column to a lookup table