Microsoft PL-300 Online Practice Questions and Exam Preparation

Microsoft PL-300 Online Questions & Answers

• Question 71:

  HOTSPOT

  You are creating a quick measure as shown in the following exhibit.

  

  You need to create a monthly rolling average measure for Sales over time.

  How should you configure the quick measure calculation? To answer, select the appropriate options in the answer area.

  NOTE: Each correct selection is worth one point.

  

  

  ---

  Box 1: Total Sales

  We select the field Total Sales

  Box 2: Date

  Select a date field.

  Box 3: Month

  Monthly periods.

  https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-quick-measures

• Question 72:

  You need to ensure that the data is updated to meet the report requirements. The solution must minimize configuration effort.

  What should you do?

  A. From each report in powerbi.com, select Refresh visuals.
  B. From Power BI Desktop, download the PBIX file and refresh the data.
  C. Configure a scheduled refresh without using an on-premises data gateway.
  D. Configure a scheduled refresh by using an on-premises data gateway.
  C. Configure a scheduled refresh without using an on-premises data gateway.

• Question 73:

  Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.

  After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.

  You have a query for a table named Sales. Sales has a column named CustomerlD. The Data Type of CustomerlD is Whole Number.

  You refresh the data and find several errors. You discover that new entries in the Sales table contain nonnumeric values.

  You need to ensure that nonnumeric values in the CustomerlD column are set to 0.

  Solution: From Query Editor, select the CustomerlD column and click Remove Errors.

  Does this meet the goal?

  A. Yes
  B. No
  B. No

• Question 74:

  HOTSPOT

  You need to create a Power Bl report. The first page or the report must contain the following two views:

  1. Sales By Postal Code

  2. 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.

  

  

  ---

  Box 1: 2

  One for each visual.

  Note: When you edit a report in Power BI Desktop and the Power BI service, you can add report bookmarks to capture the current state of a report page.

  Bookmarks save the current filters and slicers, cross-highlighted visuals, sort order, and so on. When others view your report, they can get back to that exact state by selecting your saved bookmark.

  Box 2: Display

  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.

  You can select whether each bookmark will apply Data properties, such as filters and slicers; Display properties, such as spotlight and its visibility; and Current page changes, which present the page that was visible when the bookmark was added. These capabilities are useful when you use bookmarks to switch between report views or selections of visuals, in which case you'd likely want to turn off data properties, so that filters aren't reset when users switch views by selecting a bookmark.

  Note: When you create a bookmark, the following elements are saved with the bookmark:

  The current page -

  Filters

  Slicers, including slicer type (for example, dropdown or list) and slicer state Visual selection state (such as cross-highlight filters)

  Sort order

  Drill location

  Visibility of an object (by using the Selection pane)

  The focus or Spotlight mode of any visible object

  https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-bookmarks

• Question 75:

  You have a Power BI app named App1. The privacy for the App1 workspace is set to Private.

  A user named User1 reports that App1 does not appear in the My organization AppSource. App1 appears in the My organization AppSource for your account.

  You need to ensure that User sees App1 from the My organization AppSource.

  What should you do?

  A. From the app workspace, click Update app, configure the Content settings, and then click Update app.
  B. From the app workspace settings, add a member.
  C. From the app workspace, click Update app, configure the Access setting, and then click Update app.
  D. From the app workspace, share the dashboard.
  C. From the app workspace, click Update app, configure the Access setting, and then click Update app.

  ---

  Explanation

  References:

  https://docs.microsoft.com/en-us/power-bi/service-organizational-content-pack-introduction#what-is-appsource

• Question 76:

  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?

  A. In the Date table, create a new calculated column named MonthJD that uses the yyyydd format.
  B. In the Monthly_returns table, create a new calculated column named DateJD that uses the ddmmyyyy format.
  C. To the Order table, add a calculated column that uses the RELATED(Monthly_returns[Month_ID]) DAX formula.
  D. To the Date table, add a calculated column that uses the RE LATE D(Monthly_ret urns [MonthJD]) DAX formula.
  B. In the Monthly_returns table, create a new calculated column named DateJD that uses the ddmmyyyy format.

  ---

  Explanation

  References:

  https://docs.microsoft.com/en-us/power-bi/desktop-create-and-manage-relationships

• Question 77:

  DRAG DROP

  You have a Power BI semantic model that contains two tables named Dim Location and Fact Deliveries. The relationships between the tables are configured as shown in the following table.

  

  The model contains one measure that has the following formula.

  Deliveries = COUNTROWS('Fact Deliveries')

  You need to create a new measure that counts the number of deliveries based on the destination location.

  How should you complete the DAX expression? To answer, drag the appropriate functions to the correct targets. Each function may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.

  NOTE: Each correct selection is worth one point.

  Select and Place:

  

  

• Question 78:

  You have a dataset that is used infrequently and refreshes every hour. You receive a notification that the refresh was disabled due to inactivity.

  Which two actions will cause the scheduled refresh schedule to resume? Each correct answer presents a complete solution.

  NOTE: Each correct selection is worth one point.

  A. Enable query caching for the dataset.
  B. Import the dataset to Microsoft Excel.
  C. From the Power BI service, open a dashboard that uses the dataset.
  D. From the Power BI service, open a report that uses the dataset.
  E. From PowerShell, run the get-powerbireport cmdlet.
  C. From the Power BI service, open a dashboard that uses the dataset.
  D. From the Power BI service, open a report that uses the dataset.

  ---

  Explanation

  After two months of inactivity, scheduled refresh on your dataset is paused. A dataset is considered inactive when no user has visited any dashboard or report built on the dataset. At that time, the dataset owner is sent an email indicating the scheduled refresh is paused. The refresh schedule for the dataset is then displayed as disabled. To resume scheduled refresh, simply revisit any dashboard or report built on the dataset.

  Incorrect:

  Not E: get-powerbireport retrieves a list of Power BI reports that match the specified search criteria and scope.

  https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-scheduled-refresh

• Question 79:

  HOTSPOT

  You have a Power BI report with the Edit relationship page open as shown in the following exhibit.

  

  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.

  

  

• Question 80:

  You have a collection of reports for the HR department of your company. The datasets use row-level security (RLS). The company has multiple sales regions that each has an HR manager. You need to ensure that the HR managers can interact with the data from their region only. The HR managers must be prevented from changing the layout of the reports.

  How should you provision access to the reports for the HR managers?

  A. Create a new workspace, copy the datasets and reports, and add the HR managers as members of the workspace.
  B. Publish the reports to a different workspace other than the one hosting the datasets.
  C. Publish the reports in an app and grant the HR managers access permission.
  D. Add the HR managers as members of the existing workspace that hosts the reports and the datasets.
  C. Publish the reports in an app and grant the HR managers access permission.

  ---

  Explanation

  Note: Row-level security (RLS) with Power BI can be used to restrict data access for given users. Filters restrict data access at the row level, and you can define filters within roles. In the Power BI service, members of a workspace have access to datasets in the workspace.

  RLS doesn't restrict this data access.

  https://docs.microsoft.com/en-us/power-bi/admin/service-admin-rls