← Back to exam page

70-778 – Analyzing and Visualizing Data with Microsoft Power BI

Loading demo links...

Showing 7–9 of 10 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 a Microsoft SQL Server database that contains the following tables.

The following columns contain date information:

Date[Month] in the mmyyyy format

Date[Date_ID] in the ddmmyyyy format

Date[Date_name] in the mm/dd/yyyy format Monthly_returns[Month_ID] in the mmyyyy format

The Order table contains more than one million rows.

The Store table has a relationship to the Monthly_returns table on the Store_ID column. This is the only relationship between the tables.

You plan to use Power BI Desktop to create an analytics solution for the data.

End of repeated scenario.

You plan to create a chart that displays total Order[Order_amount] by Store[Name].

You need to modify the model to ensure that you can create the chart.

Which two actions should you perform? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

Select all that apply, then click Submit answer.

  • ○

    Create a relationship between the Order table and the Store table.
  • ○

    To the Order table, add a measure that uses the COUNTA('Order'[Order_ID]) DAX formula.
  • ○

    To the Order table, add a column that uses the RELATED('Store'[Store_ID]) DAX formula.
  • ○

    To the Order table, add a measure that uses the COUNT('Order'[Order_amount]) DAX formula.
Question 8

You have a Power BI report that displays a bar chart and a donut chart on the same page. The bar chart shows the total sales by year and the donut chart shows the total sale by category.

You need to ensure that when you select a year on the bar chart, the donut chart remains unchanged.

What should you do?

Select an option, then click Submit answer.

  • ○

    Edit the interactions from the Format menu.
  • ○

    Set a visual level filter on the bar chart.
  • ○

    Set a visual level filter on the donut chart.
  • ○

    Add a slicer to the page that uses the year column.
Question 9

You create a report in the Power BI service.

You plan to provide external users with access to the report by publishing the report to a public blog.

You need to ensure that the report in the blog post will be updated as the data is refreshed.

What should you do in the Power BI service?

Select an option, then click Submit answer.

  • ○

    Publish the app workspace to the entire organization. In the blog post, use the URL of the app workspace.
  • ○

    Share the report. In the blog post, use the URL of the dashboard.
  • ○

    Publish the report to the web. In the blog post, use the embed code URL.
  • ○

    In the blog post, use the URL of the report.