Question 146

You create a report by using Microsoft Power BI Desktop.
The report uses data from a Microsoft SQL Server Analysis Services (SSAS) cube located on your company's internal network.
You plan to publish the report to the Power BI Service.
What should you implement ta ensure that users who consume the report from the Power BI Service have the most up-to-date data from the cube?
  • Question 147

    You have the Power BI data model shown in the following exhibit.

    Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.
    NOTE: Each correct selection is worth one point.

    Question 148

    You have a report that contains four pages. Each page contains slicers for the same four fields. Users report that when they select values on a slicer on one page, the visuals are not updated on all the pages. You need to recommend a solution to ensure that users can select a value once to filter the results on all the pages .
    What are two possible recommendations to achieve this goal? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.
  • Question 149

    You have two Azure SQL databases that contain the same tables and columns.
    For each database, you create a query that retrieves data from a table named Customers.
    You need to combine the Customer tables into a single table. The solution must minimize the size of the data model and support scheduled refresh in powerbi.com.
    What should you do? To answer, select the appropriate options in the answer area.
    NOTE: Each correct selection is worth one point.

    Question 150

    Your company plans to completely separate development and production assets such as datasets, reports, and dashboards in Microsoft Power Bl.
    You need to recommend an application lifecycle strategy. The solution must minimize maintenance to update access and prevent end users from viewing the development assets.
    What should you recommend?