Question 1

What should you create to meet the reporting requirements of the sales department?
  • Question 2

    You have the data lineage 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 3

    You have a Power BI model that contains a table named Sales. Sales has the following three measures:
    * A measure named Total Sales Last Year that displays the sales from the previous calendar year. The current value is 32.89 million.
    * A measure named Total Sales This Year that displays the sales from the current calendar year. The current value is 11.69 million.
    * A measure named Total Sales Difference that uses a DAX formula of Sales[Last Year] - Sales[This Year].
    You need to create the following visualization.

    How should you configure the visualization? To answer, drag the appropriate measures to the correct fields.
    Each value may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
    NOTE: Each correct selection is worth one point.

    Question 4

    You create the following step by using Power Query Editor.
    = Table.ReplaceValue(SalesLT_Address,"1318","1319",Replacer.ReplaceText,{"AddressLine1"}) A row has a value of 21318 Lasalle Street in the AddressLine1 column. What will the value be when the step is applied?
  • Question 5

    You need to create a visualization that compares revenue and cost over time.
    Which type of visualization should you use?