Microsoft Power BI Data Analyst Free Practice Exam Questions

58 real Microsoft Power BI Data Analyst exam questions with answers and AI explanations. Microsoft certification prep — page 3 of 6.

  1. Question 38: You use Power BI Desktop to import two tables named Customer and Contacts. The Customer table contains the following columns: • Customer_Name • Customer ID • W…
  2. Question 39: You have a Power BI semantic model that contains a table named Table1. Table1 contains the following columns: • WebsiteName • URL You need to create a report n…
  3. Question 42: You have a Power BI semantic model named Model1 that runs in Import storage mode. You need to reduce the size of Model1. Which two actions should you perform?…
  4. Question 45: You have a Power BI report that contains a bar chart. The bar chart displays sales by country. You need to ensure that a summary of the data shown on the bar c…
  5. Question 46: You have a Power BI semantic model named Model1 that contains sales data. You need to ensure that Model1 is refreshed on the first day of each month to include…
  6. Question 48: You plan to create a Power BI semantic model named Model1 that will contain data from an Azure SQL database named DB1. Model1 must show updated data within two…
  7. Question 49: You need to create a semantic model in Power BI Desktop. The solution must meet the following requirements: • The model must contain a table named Orders that…
  8. Question 60: You plan to generate a line chart to visualize and compare the last six months of sales data for two departments. You need to increase the accessibility of the…
  9. Question 62: You are creating a visual in a Power BI report. The associated semantic model contains sales from the last four years for three products. You need to display t…
  10. Question 65: You have a Microsoft Fabric eventhouse named Eventhouse1 that contains high-velocity and high-volume data from IoT devices. Eventhouse1 can be queried to deliv…