Question 11

You need to recommend a strategy to consistently define the business unit, department, and product category data and make the data usable across reports.
What should you recommend?
  • Question 12

    You have a collection of reports for the HR department of your company.
    You need to create a visualization for the HR department that shows a historic employee counts and predicts trends during the next six months.
    Which type of visualization should you use?
  • Question 13

    Your company has training videos that are published to Microsoft Stream.
    You need to surface the videos directly in a Microsoft Power BI dashboard.
    Which type of tile should you add?
  • Question 14

    Note: This question is part of a series of questions that use the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a different goal and answer choices, but the text of the scenario is the same in each question in this series.
    You have a Microsoft SQL Server database that contains the following tables.

    The following columns contain date information:
    - Date[Month] in the mmyyyy format
    - Date[Date_ID] in the ddmmyyyy format
    - Date[Date_name] in the mm/dd/yyyy format
    - Monthly_returns[Month_ID] in the mmyyyy format
    The Order table contains more than one million rows.
    The Store table has a relationship to the Monthly_returns table on the Store_ID column. This is the only relationship between the tables.
    You plan to use Power BI Desktop to create an analytics solution for the data.
    You need to create a relationship between the Monthly_returns table and Date[Date_ID].
    What should you do before you create the relationship?
  • Question 15

    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?