Microsoft Microsoft Certifications PL-300 Questions & Answers

• Question 251:

  HOTSPOT

  The table has the following columns.

  

  You need to add a column that will be used to sort the Year Month column chronologically.

  Hot Area:

  

  Correct Answer:

  

• Question 252:

  HOTSPOT

  You have a report in Power BI Desktop.

  You add a key influencers visual as shown in the exhibit. (Click the Exhibit tab.)

  

  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.

  Hot Area:

  

  Correct Answer:

  

• Question 253:

  HOTSPOT

  You have a column named UnitslnStock as shown in the following exhibit

  

  UnitsInStock has 75 non-null values, of which 51 are unique.

  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.

  Hot Area:

  

  Correct Answer:

  

  Box 1: 75 rows

  Is nullable allows NULL values in the column.

  Box 2: reduce

  Reference:

  https://blog.crossjoin.co.uk/2019/01/20/is-nullable-column-property-power-bi/

• Question 254:

  HOTSPOT

  You have a Power Bl report named Orders that supports the following analysis:

  1.

  Total sales over time

  2.

  The count of orders over time

  3.

  New and repeat customer counts

  The data model size is nearing the limit for a dataset in shared capacity. The model view for the dataset is shown in the following exhibit.

  

  The data view for the Orders table is shown in the following exhibit.

  

  The Orders table relates to the Customers table by using the CustomerID column.

  The Orders table relates to the Date table by using the OrderDate column.

  For each of the following statements, select Yes if the statement is true, Otherwise, select No.

  NOTE: Each correct selection is worth one point.

  Hot Area:

  

  Correct Answer:

  

• Question 255:

  HOTSPOT

  The data model must support the following analysis:

  

  Total sales by product by month in which the order was placed Quantities sold by product by day on which the order was placed Number Of sales transactions by quarter in Which the order was placed For each Of the following statements, select Yes if the statement is true. Otherwise, select NO.

  Hot Area:

  

  Correct Answer:

  

• Question 256:

  HOTSPOT

  You are creating a line chart in a Power Bl report 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.

  Hot Area:

  

  Correct Answer:

  

  Box 1: an average reference line

  With the Analytics pane in Power BI Desktop, you can add dynamic reference lines to visuals, and provide focus for important trends or insights.

  https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-analytics-pane

  Box 2: Axis

  The question is about drill-down and not drill-through.

  https://radacad.com/drill-down-and-up-in-power-bi-explained

  "For example, in the visual below I have SalesAmount as the Value of the column chart, and the Date field (OrderDate) as the X-Axis.

  Date hierarchy in a Power BI visual

  This will lead to seeing drill down/up buttons on the top of the visual (or at the bottom of it if the visual is touched at the very top of the report)"

• Question 257:

  HOTSPOT

  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.

  

  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.

  Hot Area:

  

  Correct Answer:

  

  Box 1: are 20 values that occur There are 20 unique values.

  Box 2: Elm, American Elm, American is below Peer, flowering species in the graphic.

• Question 258:

  HOTSPOT

  You plan to create the Power Bl model shown in the exhibit. (Click the Exhibit tab.)

  

  The data has the following refresh requirements:

  1.

  Customer must be refreshed daily.

  2.

  Date must be refreshed once every three years.

  3.

  Sales must be refreshed in near real time.

  4.

  SalesAggregate must be refreshed once per week.

  You need to select the storage modes for the tables. The solution must meet the following requirements:

  1.

  Minimize the load times of visuals.

  2.

  Ensure that the data is loaded to the model based on the refresh requirements.

  Which storage mode should you select for each table? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

  Hot Area:

  

  Correct Answer:

  

  Box 1: Dual

  Customer should use the dual storage mode.

  Dual: Tables with this setting can act as either cached or not cached, depending on the context of the query that's submitted to the Power BI dataset. In some cases, you fulfill queries from cached data. In other cases, you fulfill queries by

  executing an on-demand query to the data source.

  Note: You set the Storage mode property to one of these three values: Import, DirectQuery, and Dual.

  Box 2: Dual

  You can set the dimension tables (Customer, Geography, and Date) to Dual to reduce the number of limited relationships in the dataset, and improve performance.

  Box 3: DirectQuery

  Sales should use the DirectQuery storage mode.

  DirectQuery: Tables with this setting aren't cached. Queries that you submit to the Power BI datasetג€andquot;for example, DAX queriesג€andquot;and that return data from

  DirectQuery tables can be fulfilled only by executing on-demand queries to the data source. Queries that you submit to the data source use the query language for that data source, for example, SQL.

  Box 4: Import

  Import: Imported tables with this setting are cached. Queries submitted to the Power BI dataset that return data from Import tables can be fulfilled only from cached data.

  Reference:

  https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-storage-mode

• Question 259:

  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.

  Hot Area:

  

  Correct Answer:

  

  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

  Reference:

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

• Question 260:

  HOTSPOT

  You have a Power 31 data model that contains a table named Stores. The table has the following columns:

  1.

  Store Name

  2.

  Open Date

  3.

  Status

  4.

  State

  5.

  City

  You need to create a calculated column named Active Store Name that meets the following requirements:

  Hot Area:

  

  Correct Answer: