Step2Study

Microsoft Certified: Power BI Data Analyst Associate practice questions

204 free questions with answers and explanations.

Practice test
  1. 101.A manufacturing quality assurance team uses a Power BI report to monitor defects. The report includes a table listing defect types and their counts, as well as a bar chart showing defects by production line. The team wants to enable a feature where, if a user selects a specific defect type in the table, the bar chart automatically updates to show only the production lines affected by that particular defect type, and vice-versa. What Power BI feature allows for this bidirectional filtering and interaction?Visualize and analyze the data
  2. 102.A data analyst is deploying a new Power BI report that connects to an on-premises Oracle database. The report needs to be refreshed daily at 6 AM. After publishing the report to the Power BI service, the analyst attempts to configure the scheduled refresh but receives an error indicating that the data source credentials cannot be validated. The gateway is online and correctly installed. What is the most likely cause of this error?Deploy and maintain assets
  3. 103.A Power BI administrator needs to prevent a specific group of users from seeing a particular column (e.g., 'Salary') in multiple reports that all connect to the same shared dataset. Implementing RLS for every report is deemed inefficient. What is the most effective and scalable solution?Deploy and maintain assets
  4. 104.A data analyst is creating a Power BI report to visualize sales data. The report needs to display the total sales for the current year and compare it to the total sales of the previous year. Additionally, the analyst wants to show the percentage change between these two values. Which DAX function is most appropriate for calculating the sales of the previous year?Visualize and analyze the data
  5. 105.A data analyst is creating a Power BI report to visualize customer demographics, including age. The raw data contains individual customer ages, but the marketing team prefers to see age distribution in predefined groups (e.g., '18-24', '25-34', '35-44', etc.) rather than individual ages. The analyst wants to create these age groups directly within Power BI Desktop to use them in various visuals. Which feature should the analyst use to achieve this?Visualize and analyze the data
  6. 106.A data analyst is designing a Power BI report that includes multiple pages, each focusing on a different aspect of sales data (e.g., Sales by Product, Sales by Region, Sales Trends). The analyst wants to create a navigation experience where users can easily jump between these detailed pages from a high-level summary page, filtering the target page based on a selection made on the summary page. Which feature should the analyst implement for this enhanced navigation?Visualize and analyze the data
  7. 107.A human resources department is analyzing employee satisfaction survey data in Power BI. The dataset includes 'Employee ID', 'Department', 'Survey Question', and 'Rating' (1-5 scale). The HR manager wants to visualize the distribution of ratings for each 'Survey Question' across different 'Departments'. The visual needs to clearly show the proportion of each rating (1-5) within each department's response to a specific question, enabling easy comparison of rating distributions between departments. Which visual type is most suitable for this analysis?Visualize and analyze the data
  8. 108.A Power BI developer wants to promote a report from a 'Test' workspace to a 'Production' workspace using a deployment pipeline. The 'Test' workspace uses a different database server for its dataset compared to the 'Production' workspace. What must be configured in the deployment pipeline to ensure the report connects to the correct database in 'Production'?Deploy and maintain assets
  9. 109.A retail company wants to analyze customer behavior patterns using a Power BI report. They have transactional data including customer ID, product purchased, and transaction date. To identify which products are frequently purchased together, the data analyst needs to create a visual that shows associations between different products. Which type of visual or analytical technique is most appropriate for this task?Visualize and analyze the data
  10. 110.A Power BI developer is working on a critical report in a development workspace. After making several changes, they want to ensure that these changes do not negatively impact the existing production report. Which Power BI feature is designed to manage the lifecycle of content in a structured way, including development, test, and production stages?Deploy and maintain assets
  11. 111.A sales director wants a Power BI report to analyze sales performance by territory. The report needs to display both the 'Total Sales' and the 'Sales Growth Percentage' year-over-year for each territory. The director specifically requests a visual that can show both values for each territory side-by-side, allowing for quick comparison while clearly differentiating between the absolute sales value and the percentage change. Which visual type is most effective for this dual-metric comparison?Visualize and analyze the data
  12. 112.A marketing analyst is creating a Power BI report to analyze customer demographics and purchasing behavior. The dataset contains 'Customer ID', 'Age Group', 'Gender', 'Product Category', and 'Purchase Amount'. The analyst wants to create a visual that shows the distribution of 'Purchase Amount' across different 'Age Groups' and 'Gender' categories simultaneously, allowing for easy comparison of spending patterns. Which visual type is best suited for this multi-dimensional analysis?Visualize and analyze the data
  13. 113.A data analyst is creating a Power BI report for a global e-commerce company. The report needs to display sales performance across different countries. The company requires a visual that clearly shows the sales amount for each country, with larger sales represented by larger, distinct areas on a map. Which Power BI visual type is most suitable for this requirement?Visualize and analyze the data
  14. 114.An organization wants to implement a controlled process for developing and deploying Power BI reports. They need to ensure that reports pass through development, testing, and production environments with minimal manual effort and consistent settings. Which Power BI service feature is best suited for this requirement?Deploy and maintain assets
  15. 115.A data analyst is designing a Power BI report to visualize sales performance. The report includes a slicer for 'Region' and a bar chart displaying 'Total Sales by Product Category'. The analyst wants to ensure that when a user selects a region in the slicer, the bar chart filters to show only the sales for that selected region, while other visuals on the page remain unaffected by the slicer's selection. Which Power BI feature should the analyst configure?Visualize and analyze the data
  16. 116.A logistics company uses a Power BI report to track the status of its shipments. The report has a table visual that displays shipment ID, origin, destination, and current status (e.g., 'In Transit', 'Delivered', 'Delayed'). The logistics manager wants to quickly identify delayed shipments by making the 'Status' column turn red when the status is 'Delayed'. Which feature should be used to achieve this visual highlight?Visualize and analyze the data
  17. 117.A Power BI administrator wants to monitor the usage of all reports and dashboards within the organization, including who accessed them, when, and from what IP address. This information is needed for security audits and compliance. Which Power BI feature provides this detailed activity log?Deploy and maintain assets
  18. 118.A retail company is analyzing customer purchase patterns to identify products frequently bought together. The goal is to recommend complementary products to customers, thereby increasing sales. The analyst needs to visualize the relationships between products in a way that highlights co-occurrence. Which analytical approach and corresponding Power BI visual would be most appropriate for this task?Visualize and analyze the data
  19. 119.A Power BI developer needs to ensure that a newly deployed dataset, which uses an on-premises SQL Server database, can be automatically refreshed daily. The dataset has already been published to a workspace. What is the next logical step the developer must take in the Power BI service to enable the scheduled refresh?Deploy and maintain assets
  20. 120.A Power BI administrator needs to restrict certain users from exporting data from reports in a specific workspace. This is part of a data loss prevention strategy. Which setting in the Power BI service should the administrator configure to achieve this?Deploy and maintain assets
  21. 121.A data analyst has published a Power BI report to a workspace and enabled a scheduled refresh for its dataset. The dataset's data source is an Azure SQL Database. The analyst receives an alert indicating that the scheduled refresh has failed due to 'Invalid credentials'. What is the MOST likely cause of this issue?Deploy and maintain assets
  22. 122.A Power BI developer has published a report to a workspace. The report's dataset contains sensitive financial data. The developer wants to ensure that only a specific group of users can access this report and that they are prompted for their credentials each time they try to open it, even if they have previously logged into Power BI. What authentication method should be configured for the data source in the Power BI service?Deploy and maintain assets
  23. 123.A logistics manager needs a Power BI report to track the on-time delivery performance of various shipping carriers. The dataset includes 'Carrier Name', 'Shipment ID', 'Delivery Date', and 'Scheduled Delivery Date'. The manager wants a visual that displays the percentage of on-time deliveries for each carrier and allows for a quick comparison against an overall company target of 95% on-time delivery. The visual should be concise and easily interpretable at a glance. Which visual type is most appropriate?Visualize and analyze the data
  24. 124.A data analyst needs to configure a data refresh for a Power BI dataset that connects to an on-premises SQL Server database. The refresh must occur daily outside of business hours. The SQL Server database is located within the company's private network. What Power BI component is essential for enabling this scheduled refresh?Deploy and maintain assets
  25. 125.A data analyst is building a Power BI report for a global sales team. The report needs to display sales performance across different countries. The sales director specifically requested a visual that can quickly show sales values directly on a geographic map, with countries colored according to their sales performance (e.g., darker shade for higher sales). Which Power BI visual is best suited for this requirement?Visualize and analyze the data
  26. 126.A sales manager reviews a Power BI report daily to track regional sales performance. The manager needs to quickly identify regions where sales have dropped by more than 10% compared to the previous day. Which visual enhancement would best highlight these underperforming regions without requiring manual data scanning?Visualize and analyze the data
  27. 127.A data analyst has published a Power BI report to a workspace. The analyst now needs to ensure that a specific group of users can only access a curated set of reports and dashboards, and that this content is easily discoverable for them. The analyst also wants to control who can share this curated content further. What is the most appropriate Power BI feature to use for this scenario?Deploy and maintain assets
  28. 128.A product manager needs a Power BI report to track the adoption rate of new features in their software. The dataset includes 'Feature Name', 'User ID', 'Usage Date', and 'Feature Version'. The manager wants to visualize the cumulative count of unique users who have adopted each feature over time. The visual should clearly show the growth curve for each feature individually and allow for comparison between different features' adoption trajectories. Which visual type is most appropriate for this analysis?Visualize and analyze the data
  29. 129.A sales manager wants a Power BI report that allows them to quickly compare the sales performance of individual sales representatives against the team average and the overall company average. The report needs to highlight representatives who are significantly above or below these benchmarks. Which type of chart is best suited for visualizing a single measure against multiple benchmarks effectively?Visualize and analyze the data
  30. 130.A data analyst is building a Power BI report to track customer feedback sentiment over time. The dataset includes 'Date', 'Customer ID', and 'Sentiment Score' (ranging from -1 for negative to +1 for positive). The analyst wants to create a visual that shows the average sentiment score per month and highlights months where the average sentiment drops below 0, indicating predominantly negative feedback. Which visual type and configuration would best meet this requirement?Visualize and analyze the data
  31. 131.A data analyst is refactoring a complex Power BI report. The report contains a dataset with multiple tables and measures. To improve performance and maintainability, the analyst wants to isolate the dataset into a separate Power BI file and allow multiple reports to connect to it. What is the most effective way to achieve this in Power BI?Deploy and maintain assets
  32. 132.A data analyst is designing a Power BI report for a manufacturing company. The report needs to compare the current month's production volume with the production volume of the same month in the previous year. This comparison should be prominently displayed in a card visual. Which DAX function is most appropriate for calculating the previous year's production volume?Visualize and analyze the data
  33. 133.A project manager needs a Power BI report to track the progress of various projects. The report should clearly show the start date, end date, and duration of each project, with a visual representation that allows for easy identification of overlapping projects and overall project timelines. Which Power BI visual type is best suited for this purpose?Visualize and analyze the data
  34. 134.A Power BI developer needs to implement a solution where a dataset's data is only refreshed after a specific event occurs in an external system (e.g., a data warehouse ETL process completes). The refresh should not be based on a fixed schedule. What Power BI feature should the developer use for this scenario?Deploy and maintain assets
  35. 135.A Power BI administrator needs to ensure that a specific Power BI report and its underlying dataset are always associated with a dedicated capacity for performance and resource isolation. How can this be achieved?Deploy and maintain assets
  36. 136.A global logistics company uses Power BI to monitor shipment statuses. They have a dataset with 'Shipment ID', 'Origin Country', 'Destination Country', 'Status' (e.g., 'In Transit', 'Delayed', 'Delivered'), and 'Expected Delivery Date'. The operations manager needs a report that allows them to quickly identify all shipments that are 'Delayed' and then see the count of delayed shipments by each 'Destination Country' on a single, interactive visual. Which visual type is best suited for this task?Visualize and analyze the data
  37. 137.A logistics company uses Power BI to visualize delivery routes. The report includes a map visual showing delivery locations and a table detailing each delivery. The company needs to ensure that when a user selects a specific delivery location on the map, the table automatically scrolls and highlights the corresponding delivery entry. Which Power BI feature facilitates this precise linking between visuals?Visualize and analyze the data
  38. 138.A data analyst has developed a Power BI report that uses an imported dataset. The dataset's data source is a SQL Server database. To ensure that the report data is always up-to-date for end-users, which type of refresh should be configured for the dataset in the Power BI Service?Deploy and maintain assets
  39. 139.A Power BI developer is working on a report that uses a SQL Server database as its data source. To improve query performance and reduce the load on the source database, the developer wants to configure Power BI to cache the data locally. Which storage mode should the developer use for the dataset?Deploy and maintain assets
  40. 140.A Power BI developer needs to add a new calculated column to an existing dataset in Power BI Desktop. The column should categorize sales based on a complex 'IF/THEN/ELSE' logic. In which view within Power BI Desktop should the developer create this new calculated column?Deploy and maintain assets
  41. 141.A data analyst is designing a Power BI report for executive leadership. The report contains sensitive financial data, and different levels of leadership should only see data relevant to their respective departments or regions. The analyst needs to implement a security model that filters the data at the row level based on the user's login credentials. Which Power BI feature enables this requirement?Visualize and analyze the data
  42. 142.A Power BI administrator needs to ensure that all datasets published to the 'Finance' workspace are automatically assigned a 'Confidential' sensitivity label. This is crucial for compliance with the company's data governance policies. What Power BI feature should the administrator configure to achieve this?Deploy and maintain assets
  43. 143.A Power BI report relies on a dataset that connects to an on-premises SQL Server database. The report is published to the Power BI Service. To enable scheduled refresh for this dataset, what must be configured in the Power BI Service?Deploy and maintain assets
  44. 144.A company wants to embed Power BI reports into its internal web application for authenticated users. The reports should display data relevant to each logged-in user, and the embedding solution must scale efficiently. Which embedding solution should the company implement?Deploy and maintain assets
  45. 145.A data analyst needs to ensure that users in different departments can only view sales data relevant to their specific department within a Power BI report. The solution must dynamically filter data based on the user's login. Which feature should the analyst implement?Deploy and maintain assets
  46. 146.A financial services company uses Power BI to report on highly sensitive customer portfolio data. They need to ensure that when a Power BI dataset is refreshed, the connection to the on-premises SQL Server database is always secure and that the credentials are not embedded directly in the Power BI Desktop file. Which component is specifically designed to handle secure on-premises data connections and credential management for Power BI service refreshes?Deploy and maintain assets
  47. 147.A data analyst is designing a Power BI report to visualize the sales performance of different product categories over time. The report needs to clearly show both the overall trend of sales for each category and how each category contributes to the total sales for any given period. Which Power BI visual is BEST suited for this requirement?Visualize and analyze the data
  48. 148.A financial analyst is creating a Power BI report to track the company's monthly expenses. The report needs to display the current month's expenses alongside the expenses from the previous month and the same month in the prior year for comparison. Which DAX function should the analyst use to retrieve the previous month's expenses?Visualize and analyze the data
  49. 149.A Power BI developer needs to implement a solution to automatically export a Power BI report to a PDF file every Monday morning and send it to a specific email distribution list. Which Power BI feature should the developer use?Deploy and maintain assets
  50. 150.A data analyst has created a Power BI report and dataset in a development workspace. After thorough testing, the report is ready for deployment to the production environment. The production environment has different data source credentials and parameter values (e.g., database server names). How should the analyst ensure these settings are automatically updated during the deployment process to avoid manual configuration errors?Deploy and maintain assets