Microsoft PL-300 Online Practice Questions and Exam Preparation

Microsoft PL-300 Online Questions & Answers

• Question 61:

  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 create a parameter named DataSourceExcel that holds the file name and location of a Microsoft Excel data source.

  You need to update the query to reference the parameter instead of multiple hard-coded copies of the location within each query definition.

  Solution: In the Power Query M code, you replace references to the Excel file with DataSourceExcel.

  Does this meet the goal?

  A. Yes
  B. No
  A. Yes

  ---

  Explanation

  Instead modify the source step of the queries to use DataSourceExcel as the file path.

  Note: Parameterising a Data Source could be used in many different use cases. From connecting to different data sources defined in Query Parameters to load different combinations of columns.

  https://www.biinsight.com/power-bi-desktop-query-parameters-part-1/

• Question 62:

  What should you create to meet the reporting requirements of the sales department?

  A. a measure column that uses the following formula: SUMX(FILTER('Sales', 'Sales'[sales_amount] > 0)),[sales_amount])
  B. a calculated column that uses the following formula: ABS(Sales[sales_amount])
  C. a calculated column that uses the following formula: IF(ISBLANK(Sales[sales_amount]),0, (Sales[sales_amount]))
  D. a measure that uses the following formula: SUM(Sales[sales_amount])
  A. a measure column that uses the following formula: SUMX(FILTER('Sales', 'Sales'[sales_amount] > 0)),[sales_amount])

• Question 63:

  HOTSPOT

  You use Power Query Editor to ingest data into Power Bl Desktop. The total dataset contains 250,000 rows. All the rows match the format of the data as shown in the following exhibit.

  

  You need to optimize the data model size of the table.

  Which type of data should you use for the Value column and the Datetime column? To answer, select the appropriate options in the answer area.

  NOTE: Each correct selection is worth one point.

  

  

• Question 64:

  You have a Power BI semantic model that contains item, price, and country data. The data is displayed in a report that uses filters.

  You need to calculate the average item price for a given country. The solution must support the existing filters.

  Which type of quick measure should you use?

  A. Total for category (filters applied)
  B. Average per category
  C. Rolling average
  D. Weighted average per category
  B. Average per category

• Question 65:

  You need to create a Power BI theme that will be used in multiple reports. The theme will include corporate branding for font size, color, and bar chart formatting.

  What should you do?

  A. From Power Bl Desktop, customize the current theme.
  B. From power Bl Desktop, use a built in report theme.
  C. Create a theme as a JSON file and import the theme into Power Bl Desktop.
  D. Create a theme as a PBIVlZ file and import the theme into Power Bl Desktop.
  C. Create a theme as a JSON file and import the theme into Power Bl Desktop.

  ---

  
  

• Question 66:

  DRAG DROP

  You have a Power BI semantic model that contains a table

  You need to create a Power BI report page that contains two visuals that meet the following requirements:

  1. Visual 1: Display* the distribution of hierarchical data

  2. Visual 2: Search arid then filler by values

  Which type should you choose for each visual? To answer, drag the appropriate visual types to the correct visuals. Each visual type 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 67:

  You are configuring a Microsoft Power Bl data model to enable users to ask natural language questions by using Q&A. You have a table named Customer that has the following measure.

  Customer Count = DISTINCTCOUNT(Customer[CustomerID])

  Users frequently refer to customers as subscribers.

  You need to ensure that the users can get a useful result for "subscriber count" by using Q&A. The solution must minimize the size of the model.

  What should you do?

  A. Add a description of "subscriber count" to the Customer Count measure.
  B. Set Summarize By to None for the CustomerlD column.
  C. Add a description of "Subscriber" to the Customer table.
  D. Add a synonym of "subscriber" to the Customer table.
  B. Set Summarize By to None for the CustomerlD column.

  ---

  Explanation

  You can add synonyms to tables and columns.

  Note: This step applies specifically to Q&A (and not to Power BI reports in general). Users often have a variety of terms they use to refer to the same thing, such as total sales, net sales, total net sales. You can add these synonyms to tables and columns in the Power BI model.

  This step applies specifically to Q&A (and not to Power BI reports in general). Users often have a variety of terms they use to refer to the same thing, such as total sales, net sales, total net sales. You can add these synonyms to tables and columns in the Power BI model.

  https://docs.microsoft.com/en-us/power-bi/natural-language/q-and-a-best-practices

• Question 68:

  HOTSPOT

  You use Power Query Editor to review a query that contains a column named Country.

  You need to view the following information in the Data preview view for the Country column:

  1. The percentage of values that contain errors.

  2. The count of empty values.

  What should you enable? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

  

  

• Question 69:

  You have multiple dashboards.

  You need to ensure that when users browse the available dashboards from powerbi.com. they can see which dashboards contain Personally Identifiable Information (Pll). The solution must minimize configuration effort and impact on the dashboard design.

  What should you use?

  A. Active Directory groups
  B. tiles
  C. data classifications
  D. comments
  A. Active Directory groups

• Question 70:

  You create a Power BI report named RPT1 that contains sales data. The data contains 10 million rows. RPT1 contains 15 different visuals.

  Users state that RPT1 is slow to load.

  You need to investigate the cause of the issue.

  What should you use?

  A. Power Query Editor
  B. Performance analyzer
  C. Query Diagnostics
  D. DAX query view
  B. Performance analyzer