Question 51

You have the visual shown in the exhibit. (Click the Exhibit tab.)

You need to show the relationship between Total Cost and Total Sales over time.
What should you do?
  • Question 52

    You have a Microsoft Exert spreadsheet named Excel1 that contains survey results.
    You have a Power Bl dashboard named DashboardA that has Q&A enabled.
    You need to ensure that users who can access DashboardA can ask Questions based on the contents of Excel 1 and pm visuals based on their queries to Dashboard 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.

    Question 53

    You are profiling data by using Power Query Editor.
    You have a table that contains a column named column1. Column statistics and Value distribution for column1 are shown in the following exhibit.

    Question 54

    DRAG DROP
    You build a report about warehouse inventory data. The dataset has more than 10 million product records from 200 warehouses worldwide.
    You have a table named Products that contains the columns shown in the following table.

    Warehouse managers report that it is difficult to use the report because the report uses only the product name in tables and visuals. The product name is contained within the ProductDescription column and is always the fourth value.
    You need to modify the report to support the warehouse managers requirement to explore inventory levels at different levels of the product hierarchy. The solution must minimize the model size.
    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.

    Question 55

    You manage a Power BI model has a table named Sales and product.
    You need to ensure that a sales team can view only data that has a CountryRegionName value of United States and a ProductCategory value of Clothing.
    What should you do from Power BI Desktop?