Question 41

You have a Microsoft Power BI report. The size of PBIX file is 550 MB. The report is accessed by using an App workspace in shared capacity of powerbi.com.
The report uses an imported dataset that contains one fact table. The fact table contains 12 million rows. The dataset is scheduled to refresh twice a day at 08:00 and 17:00.
The report is a single page that contains 15 AppSource visuals and 10 default visuals.
Users say that the report is slow to load the visuals when they access and interact with the report.
You need to recommend a solution to improve the performance of the report.
What should you recommend?
  • Question 42

    You have a Power Bl report hosted on powerbi.com that displays expenses by department for department managers.
    The report contains a line chart that shows expenses by month.
    You need to enable users to choose between viewing the report as a line chart or a column chart. The solution must minimize development and maintenance effort.
    What should you do?
  • Question 43

    You have a Microsoft SharePoint Online site that contains several document libraries. One of the document libraries contains manufacturing reports saved as Microsoft Excel files. All the manufacturing reports have the same data structure.
    You need to load only the manufacturing reports to a table for analysis.
    What should you do in Microsoft Power Bl Desktop?
  • Question 44

    You have two Power Bl reports named ReportA and ReportB that each uses a distinct color palette.
    You are creating a Power Bl dashboard that will include two visuals from each report You need to use a consistent dark theme for the dashboard. The solution must preserve the original colors of the reports.
    Which two actions should you perform? Each correct answer presents part of the solution.
    NOTE: Each correct selection is worth one point.
  • Question 45

    You have a table that contains a column named Phone. The following is a sample of the data in the Phone column.

    You need to add a new column that contains the data in the format of nnn-nnn-nnnn.
    How should you complete the Query Editor formula? To answer, select the appropriate options in the answer area.
    NOTE: Each correct selection is worth one point.