DA-100 Exam Question 26

You view a query named Transactions as shown in the following exhibit.

The query gets CSV files from a folder.
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.

DA-100 Exam Question 27

You are modeling data in table named SalesDetail by using Microsoft Power Bl.
You need to provide end users with access to the summary statistics about the SalesDetail dat a. The users require insights on the completeness of the data and the value distributions.
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.

DA-100 Exam Question 28

You have the dataset shown in the following exhibit.

You need to ensure that the visual shows only the 10 cities that have the highest sales profit.
What should you do?
  • DA-100 Exam Question 29

    You publish a Microsoft Power BI dataset to powerbi.com. The dataset appends data from an on- premises Oracle database and an Azure SQL database by using one query.
    You have admin access to the workspace and permission to use an existing On-premises data gateway for which the Oracle data source is already configured.
    You need to ensure that the data is updated every morning. The solution must minimize configuration effort.
    Which two actions should you perform when you configure scheduled refresh? Each correct answer presents part of the solution.
    NOTE: Each correct selection is worth one point.
  • DA-100 Exam Question 30

    You have a dashboard that contains tiles pinned from a single report as shown in the Original Dashboard exhibit. (Click the Original Dashboard tab.)

    You need to modify the dashboard to appear as shown in the Modified Dashboard exhibit. (Click the Modified Dashboard tab.)

    What should you do?