Skip to content
ExamCup

Microsoft

Microsoft PL-300

Microsoft Power BI Data Analyst

Practice questions with answers and explanations.

302
Questions
today
Last updated
25
Free questions
Timed practice exam
Show
Question map
  1. 1
  2. 2
  3. 3
  4. 4
  5. 5
  6. 6
  7. 7
  8. 8
  9. 9
  10. 10
  11. 11
  12. 12
  13. 13
  14. 14
  15. 15
  16. 16
  17. 17
  18. 18
  19. 19
  20. 20
  21. 21
  22. 22
  23. 23
  24. 24
  25. 25

  • Question 16 of 302

    Topic 1: Prepare the data

    Topic 1: Prepare the data

    HOTSPOT

    You are using Power BI Desktop to connect to an Azure SQL database.

    The connection is configured 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 solution is worth one point.

  • Question 17 of 302

    Topic 1: Prepare the data

    Topic 1: Prepare the data

    HOTSPOT

    You have the Azure SQL databases shown in the following table.

    You plan to build a single PBIX file to meet the following requirements:

    • Data must be consumed from the database that corresponds to each stage of the development lifecycle.

    • Power BI deployment pipelines must NOT be used.

    • The solution must minimize administrative effort.

    What should you do? To answer, select the appropriate options in the answer area.

    NOTE: Each correct selection is worth one point.

  • Question 18 of 302

    Topic 1: Prepare the data

    Topic 1: Prepare the data

    You are creating a query to be used as a Country dimension in a star schema.

    A snapshot of the source data is shown in the following table.

    You need to create the dimension. The dimension must contain a list of unique countries.

    Which two actions should you perform? Each correct answer presents part of the solution.

    NOTE: Each correct selection is worth one point.

    Choose your answer

    Pick an answer to check it, or press Show answer to see the correct one.

  • Question 19 of 302

    Topic 1: Prepare the data

    Topic 1: Prepare the data

    DRAG DROP

    You use Power Query Editor to preview the data shown in the following exhibit.

    You need to clean and transform the query so that all the rows of data are maintained, and error values in the discount column are replaced with a discount of 0.05. The solution must minimize administrative effort.

    Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

  • Question 20 of 302

    Topic 1: Prepare the data

    Topic 1: Prepare the data

    HOTSPOT

    You attempt to use Power Query Editor to create a custom column and receive the error message 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.