Microsoft Certified Power Bi Data Analyst Associate Exam Questions & Answers

All 45 questions

1. Q1 A Power BI Data Analyst is building a report to visualize monthly sales trends from an Azure SQL Database containing a Sales…
2. Q2 Business OverviewNovaCare Health Analytics is a data-driven healthcare consulting firm that provides patient claims analysis, hospital performance tracking, and predictive insights for…
3. Q3 At NextWave Analytics, you are building a Power BI report on a large dataset stored in SQL Server.To optimize query performance, you…
4. Q4 This question is part of repeated scenario questions that contain a similar stem but with a different solution for each question. You…
5. Q5 You are working on a Power BI report that uses a data source file stored on a network drive. After publishing the…
6. Q6 You are preparing the sales dataset for analysis in Power Query. You observed that there are errors in the dataset, as shown…
7. Q7 A Power BI Data Analyst is working with a large dataset containing 10 million rows of transactional data in Power BI Desktop.…
8. Q8 CASE ANALYSIS:BrightMart Retail, a rapidly expanding chain of retail stores, needs an advanced Power BI solution to gain deep insights into their sales…
9. Q9 You are developing a Power BI report for BrightLens Manufacturing, where sales data is stored in a shared semantic model (Analysis Services…
10. Q10 Given below is an organization’s sales report for the last financial year.Which of the following actions would you take to point out…
11. Q11 You are working in Power BI and need to create bins for the CustomerAge column. You need to configure a bin for…
12. Q12 You have a dataset containing the number of new subscribers and cancellations per month for a subscription-based service.You want to create a…
13. Q13 A Power BI Data Analyst is designing a data model for a retail company that tracks sales data across multiple regions. The…
14. Q14 This question is part of repeated scenario questions that contain the same stem but with a different solution for each question. You…
15. Q15 GenAffair, Inc. Case StudyThis is a case study. Case studies are not timed separately. You can use as much test time as…
16. Q16 You are a Power BI developer managing the Adventure Works Pipeline, which includes Development, Test, and Production environments. You create new reports…
17. Q17 A Power BI Data Analyst is building a sales report that requires time-based analysis, such as year-to-date (YTD) and month-over-month comparisons. The…
18. Q18 You have a set of CSV files stored in a SharePoint Online folder. You need to load these files into Power BI…
19. Q19 Your colleague works with a data model to analyze the performance of the company’s offline stores.So, he creates a KPI visual to…
20. Q20 You are working on a Power BI report for the sales department. The report uses the following tables, as shown in the…
21. Q21 From the sales table, you create the below bubble chart in Power BI.Each bubble:a. is plotted along the axes that represent the…
22. Q22 This question is part of repeated scenario questions that contain a similar stem but with a different solution for each question. You…
23. Q23 GenAffair, Inc. Case StudyThis is a case study. Case studies are not timed separately. You can use as much test time as…
24. Q24 At EcoMetrics Corp., your inventory report includes the Inventory table with the following columns:DateProductIDStockQuantityYour manager asks you to create a measure that…
25. Q25 CASE ANALYSIS:You are a data analyst at HealthConnect Analytics, a company that provides data-driven insights to insurance providers. Your team has been tasked…
26. Q26 SwipeWire is an online merchandise company that sells T-shirts. Below is the table displaying the company’s Revenue and EBITDA across all its…
27. Q27 Your Power BI report displays sensitive information like customers’ Social Security Numbers to report users. You export the report from the service…
28. Q28 At Skyline Technologies, your Power BI report requires data from a cloud-based CRM system.✔ The dataset is moderately sized.✔ Data is updated…
29. Q29 Read the below information and answer the questions that are part of the case study.Below is the sample data of a popular…
30. Q30 Business OverviewNovaCare Health Analytics is a data-driven healthcare consulting firm that provides patient claims analysis, hospital performance tracking, and predictive insights for…
31. Q31 The Sales Analytics Team at Company A has created a line chart in Power BI to track the Sum of Order Total…
32. Q32 You are building a sales performance report in Power BI. The report contains the following visuals:A pie chart showing the percentage of…
33. Q33 You have a fictitious dataset of the products sourced by Apple Computers from its suppliers all over the world.The sales managers at…
34. Q34 You want to create a calculated column in the Sales table to calculate the profit margin for each order. You decide to…
35. Q35 At SkyMetrics Corp., your manager asks you to calculate the total quantity sold for a specific product category, "Electronics."The Sales table is…
36. Q36 Which built-in accessibility feature in Power BI ensures that all interactive elements of a report can be reached and activated solely using…
37. Q37 You monitor an active fraudulent activity report in the Power BI service that connects to a backend financial data mart. The Teradata…
38. Q38 In Power BI Desktop, you need to create a calculated table that contains a single column of three-digit even numbers. Which of…
39. Q39 While importing data into Power BI, you have to remove columns with column names that start with the prefix Test_ as shown…
40. Q40 In the screenshot, the refresh schedule includes three times: 1:00 AM, 9:00 AM, and 5:00 PM.What is the maximum number of refreshes…
41. Q41 The Sum of MarketingSpend by Month and SalesTeam is displayed in a clustered column chart. You notice a significant increase in MarketingSpend…
42. Q42 A Power BI Data Analyst needs to combine three CSV files containing sales data from different regions (each with columns: OrderID, SaleDate,…
43. Q43 You are managing permissions for a shared dataset. Amelia, a Workspace Admin, wants to grant a third-party contractor temporary access to build…
44. Q44 A Power BI Data Analyst needs to update a report’s data source from a development SQL Server database to a production SQL…
45. Q45 Which of the following statements about creating a portrait version of your reports/dashboards for mobile devices is TRUE?