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 11 of 302

    Topic 1: Prepare the data

    Topic 1: Prepare the data

    You have an Azure SQL database that contains sales transactions. The database is updated frequently.

    You need to generate reports from the data to detect fraudulent transactions. The data must be visible within five minutes of an update.

    How should you configure the data connection?

    Choose your answer

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

  • Question 12 of 302

    Topic 1: Prepare the data

    Topic 1: Prepare the data

    A business intelligence (BI) developer creates a dataflow in Power BI that uses DirectQuery to access tables from an on-premises Microsoft SQL server. The

    Enhanced Dataflows Compute Engine is turned on for the dataflow.

    You need to use the dataflow in a report. The solution must meet the following requirements:

    ✑ Minimize online processing operations.

    ✑ Minimize calculation times and render times for visuals.

    ✑ Include data from the current year, up to and including the previous day.

    What should you do?

    Choose your answer

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

  • Question 13 of 302

    Topic 1: Prepare the data

    Topic 1: Prepare the data

    DRAG DROP

    You publish a dataset that contains data from an on-premises Microsoft SQL Server database.

    The dataset must be refreshed daily.

    You need to ensure that the Power BI service can connect to the database and refresh the dataset.

    Which four 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 14 of 302

    Topic 1: Prepare the data

    Topic 1: Prepare the data

    You attempt to connect Power BI Desktop to a Cassandra database.

    From the Get Data connector list, you discover that there is no specific connector for the Cassandra database.

    You need to select an alternate data connector that will connect to the database.

    Which type of connector should you choose?

    Choose your answer

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

  • Question 15 of 302

    Topic 1: Prepare the data

    Topic 1: Prepare the data

    DRAG DROP

    You receive annual sales data that must be included in Power BI reports.

    From Power Query Editor, you connect to the Microsoft Excel source shown in the following exhibit.

    You need to create a report that meets the following requirements:

    • Visualizes the Sales value over a period of years and months

    • Adds a slicer for the month

    • Adds a slicer for the year

    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.