Question 56

From Power 61 Desktop, you publish a new dataset and report lo a Power Bl workspace. The dataset has a row-level security (RLS) role named HR. You need to ensure that the HR team members have RLS applied when they view reports based on the dataset. What should you do?
  • Question 57

    You are creating a line chart in a Power Bl report as 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 58

    You are creating a Power BI report to analyze consumer purchasing patterns from a table named Transactions.
    The Transactions table contains a numeric field named Spend. You need to include a visual that identifies which fields have the greatest impact on Spend. Which type of visual should you use?
  • Question 59

    You have an API that returns more than 100 columns. The following is a sample of column names.
    * client_notified_timestamp
    * client_notified_source
    * client_notified_sourceid
    * client_notified_value
    * client_responded_timestamp
    * client_responded_source
    * client_responded_sourceid
    * client_responded_value
    You plan to include only a subset of the returned columns.
    You need to remove any columns that have a suffix of sourceid.
    How should you complete the Power Query M code? To answer, select the appropriate options in the answer area.
    NOTE: Each correct selection is worth one point.

    Question 60

    You are preparing a financial report in Power BI.
    You connect to the data stored in a Microsoft Excel spreadsheet by using Power Query Editor as shown in the following exhibit.

    You need to prepare the data to support the following:
    * Visualizations that include all measures in the data over time
    * Year-over-year calculations for all the measures
    Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.