Microsoft PL-300 Microsoft Power BI Data Analyst Exam Exam Practice Test Questions

• Question 1

  You are configuring a Microsoft Power Bl data model to enable users to ask natural language questions by using Q&

  • 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?
  • Add a description of 'subscriber count' to the Customer Count measure.
  • Set Summarize By to None for the CustomerlD column.
  • Add a description of 'Subscriber' to the Customer table.
  • Add a synonym of 'subscriber' to the Customer table.

  Show Answer Answer: B Next

• Question 2

  You have a Power Bl report that contains the table shown in the following exhibit.The table contains conditional formatting that shows which stores are above, near, or below the monthly quota for returns. You need to ensure that the table is accessible to consumers of reports who have color vision deficiency. What should you do?

  • Add alt text that lists the values in the table.
  • Change the icons to use a different shape for each color.
  • Remove the icons and use red, yellow, and green background colors instead
  • Move the conditional formatting icons to a tooltip report

  Show Answer Answer: B Next

• Question 3

  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: You add a Power Apps custom visual to the report.Does this meet the goal?

  • Yes
  • No

  Show Answer Answer: A Next

• Question 4

  You are creating a Power Bl report by using Power Bi Desktop.You need to include a visual that shows trends and other useful information automatically. The visual must update based on selections in other visuals.Which type of visual should you use?

  • key influencers
  • decomposition tree
  • Q&A
  • smart narrative

  Show Answer Answer: D Next

• Question 5

  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?

  • scatter chart
  • ribbon chart
  • line chart
  • key influences

  Show Answer Answer: C Next