PL-300 Exam Question 111

You are creating a Power BI model that contains a table named Store. Store contains the following fields.
You plan to create a map visual that will show store locations and provide the ability to drill down from Country to State/Province to City. What should you do to ensure that the locations are mapped property?
  • PL-300 Exam Question 112

    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 Order table and the Store table on the Store_ID column.
    What should you do before you create the relationship?
  • PL-300 Exam Question 113

    You need to create the dataset. Which dataset mode should you use?
  • PL-300 Exam Question 114

    You need to create a Power BI report. The first page of the report must contain the following two views:
    *Sales By Postal Code
    *Sales by Month
    Both views must display a slicer to select a value for a field named Chain.
    The Sales By Postal Code view must display a map visual as shown in the following exhibit.

    The Sales By Month view must display a column chart visual as shown in the following exhibit.

    Users must be able to switch between the views by using buttons on the report page. The selected Chain field must be maintained when switching between views.
    What is the minimum number of bookmarks required, and which property should you apply to each bookmark? To answer, select the appropriate options in the answer area.
    NOTE: Each correct selection is worth one point.

    PL-300 Exam Question 115

    Your organization has a team of power users who recently created 20 Power BI dashboards.
    The power users share the dashboards with other users in the organization.
    When the users attempt to access the dashboards, they receive the error message shown in the exhibit. (Click the Exhibit.)

    You need to ensure that all the users can access the dashboards.
    What should you do first?