DA-100 Exam Question 1

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.

DA-100 Exam Question 2

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?
  • DA-100 Exam Question 3

    You need to provide a solution to provide the sales managers with the required access.
    What should you include in the solution?
  • DA-100 Exam Question 4

    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.

    DA-100 Exam Question 5

    You have a query named Customer that imports CSV files from a data lake. The query contains 500 rows as shown in the exhibit. (Click the Exhibit tab.)

    Each file contains deltas of any new or modified rows from each load to the data lake. Multiple files can have the same customer ID.
    You need to keep only the last modified row for each customer ID.
    Which three 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.