← Back to exam page

70-779 – Analyzing and Visualizing Data with Microsoft Excel

Loading demo links...

Showing 4–6 of 8 questions

Question 4

You install Microsoft Power BI Publisher for Excel.

You need to use Excel to connect and analyze Power BI data.

To which two types of Power BI data can you connect? Each correct answer presents a complete solution.

NOTE: Each correct selection is worth one point.

Select all that apply, then click Submit answer.

  • ○

    datasets
  • ○

    apps
  • ○

    reports
  • ○

    dashboard
Question 5

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: You create a new connection to Production1, and then you import the tables.

Does this meet the goal?

Select an option, then click Submit answer.

  • ○

    Yes
  • ○

    No
Question 6

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?

Select an option, then click Submit answer.

  • ○

    Yes
  • ○

    No