Question 31

You need to address the data concerns before creating the data model. What should you do in Power Query Editor?
  • Question 32

    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?
  • Question 33

    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 scenario, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
    You have a clustered bar chart that contains a measure named Salary as the value and a field named Employee as the axis. Salary is present in the data as numerical amount representing US dollars.
    You need to create a reference line to show which employees are above the median salary.
    Solution: You create an average line by using the Salary measure.
    Does this meet the goal?
  • Question 34

    You have a Microsoft Power Bl 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 custom 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 35

    You have a Microsoft Power BI data model that contains three tables named Orders, Date, and City. There is a one-to-many relationship between Date and Orders and between City and Orders.
    The model contains two row-level security (RLS) roles named Role1 and Role2. Role1 contains the following filter.
    City[State Province] = "Kentucky"
    Role2 contains the following filter.
    Date[Calendar Year] = 2020
    If a user is a member of both Role1 and Role2, what data will they see in a report that uses the model?