Question 1

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

    Once the profit and loss dataset is created, which four actions should you perform in sequence to ensure that the business unit analysts see the appropriate profit and loss data? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

    Question 3

    You have two tables named Customers and Invoice in a Power BI model. The Customers table contains the following fields:
    * CustomerID
    * Customer City
    * Customer State
    * Customer Name
    * Customer Address 1
    * Customer Address 2
    * Customer Postal Code
    The Invoice table contains the following fields:
    * Order ID
    * Invoice ID
    * Invoice Date
    * Customer ID
    * Total Amount
    * Total Item Count
    The Customers table is related to the Invoice table through the Customer ID columns. A customer can have many invoices within one month.
    The Power BI model must provide the following information:
    * The number of customers invoiced in each state last month
    * The average invoice amount per customer in each postal code
    You need to define the relationship from the Customers table to the Invoice table. The solution must optimize query performance.
    What should you configure? To answer, select the appropriate options in the answer area.
    NOTE: Each correct selection is worth one point.

    Question 4

    You create a dashboard by using the Microsoft Power Bl Service. The dashboard contains a card visual that shows total sales from the current year. You grant users access to the dashboard by using the viewer role on the workspace. A user wants to receive daily notifications of the number shown on the card visual. You need to automate the notifications. What should you do?
  • Question 5

    You import a large dataset to Power Query Editor.
    You need to identify whether a column contains only unique values.
    Which two Data Preview options can you use? Each correct answer presents a complete solution.
    NOTE: Each correct selection is worth one point