Step2Study

Microsoft Certified: Power BI Data Analyst Associate practice questions

204 free questions with answers and explanations.

Practice test
  1. 151.A Power BI administrator needs to track user activities, such as who viewed a specific report, when they viewed it, and if they exported any data. Which Power BI feature provides this auditing capability?Deploy and maintain assets
  2. 152.A financial analyst is building a Power BI dashboard to monitor key financial metrics. The dashboard includes multiple visuals, such as a line chart for stock prices, a card for current market capitalization, and a table for recent transactions. The analyst wants to ensure that when a user selects a specific transaction in the table, all other visuals on the dashboard automatically update to reflect data related only to that transaction. Which interaction behavior should be configured for the table visual?Visualize and analyze the data
  3. 153.A company uses Power BI deployment pipelines to manage their reports. A developer has made changes to a report in the 'Development' stage. Before deploying to the 'Test' stage, the developer wants to ensure that the dataset's data source connection string is automatically updated from a development database to a test database. Which feature of deployment pipelines should be configured?Deploy and maintain assets
  4. 154.A manufacturing company uses Power BI to monitor production efficiency. The report includes a gauge visual showing the current efficiency score against a target, and a line chart tracking efficiency over time. The company wants to integrate an external R script that performs a more complex statistical anomaly detection on the efficiency data and displays the results directly within the Power BI report. How can the data analyst achieve this?Visualize and analyze the data
  5. 155.A marketing team wants to analyze customer demographics in a Power BI report. They have a dataset containing customer age, gender, and purchase history. To understand purchase patterns across different age groups, the team decides to categorize customers into age bins (e.g., 18-24, 25-34, etc.). Which Power BI feature should the data analyst use to create these age groups directly within the report?Visualize and analyze the data
  6. 156.A Power BI report contains sensitive customer personal identifiable information (PII). The data analyst needs to configure a data classification policy to indicate the sensitivity of the data and protect it from unauthorized sharing or download. Which Power BI feature integrates with Microsoft Information Protection to achieve this?Deploy and maintain assets
  7. 157.A marketing team is analyzing customer feedback data in Power BI. They have a dataset that includes customer comments as free-form text. The team wants to identify recurring themes and sentiment (positive, negative, neutral) from these comments to understand customer perceptions better. Which Power BI visual, combined with appropriate data preparation, would be most effective for this analysis?Visualize and analyze the data
  8. 158.A Power BI administrator needs to monitor user activities, such as report views, data exports, and changes to datasets, to ensure compliance with data governance policies. Which Power BI feature provides the necessary detailed logging capabilities for auditing purposes?Deploy and maintain assets
  9. 159.A Power BI administrator needs to track all activities related to report views, data exports, and dataset refreshes across all workspaces in their Power BI tenant for auditing purposes. Which feature should the administrator use?Deploy and maintain assets
  10. 160.A data analyst needs to validate that the Row-Level Security (RLS) roles defined in a Power BI Desktop model are working as expected before publishing the report. Which feature within Power BI Desktop allows the analyst to test these roles?Deploy and maintain assets
  11. 161.A data analyst has published a Power BI report. The report needs to be distributed to a wide audience of 500+ users, some of whom are external guests. The solution must provide a curated view of the reports, easily manage permissions for different user groups, and allow for a seamless consumption experience. Which Power BI feature is best suited for this distribution scenario?Deploy and maintain assets
  12. 162.A Power BI administrator needs to prevent users from sharing Power BI reports and dashboards with external guest users. This restriction should apply to all workspaces within the organization. Which Power BI admin portal setting should be configured?Deploy and maintain assets
  13. 163.A Power BI developer is working on a new report that connects to a dataset in another workspace. The developer needs to ensure that any changes made to the source dataset are automatically reflected in their report without manual intervention. What connection mode should the developer use when connecting to the dataset?Deploy and maintain assets
  14. 164.A data analyst has published a Power BI report to a workspace. The report contains a sensitive column, 'Salary', which should only be visible to users with an 'HR Manager' role. Other users should not even see the 'Salary' column in the field list or visuals. How can this be achieved?Deploy and maintain assets
  15. 165.A Power BI developer needs to publish a report to a new workspace. The report uses an imported dataset that connects to an on-premises SQL Server database. After publishing, the report displays an error indicating that the data source cannot be found. What is the MOST likely cause of this issue?Deploy and maintain assets
  16. 166.A sales director wants a Power BI dashboard that provides a high-level overview of sales performance. The dashboard needs to display key metrics like total sales, average order value, and profit margin using simple, prominent visuals. Additionally, the director wants to easily see the current month's performance at a glance without needing to interact with filters. Which combination of visual types and report design principles would achieve this effectively?Visualize and analyze the data
  17. 167.A financial analyst is creating a Power BI report to track quarterly expenses across different departments. The analyst wants to enable users to easily switch between viewing expenses by 'Category', 'Vendor', or 'Project' without modifying the report structure. The goal is to dynamically change the dimension used in a bar chart and a table visual based on user selection. Which Power BI feature should the analyst use to achieve this dynamic switching capability?Visualize and analyze the data
  18. 168.A data analyst is creating a Power BI dashboard to monitor website traffic. The dashboard includes a line chart showing daily page views and a card displaying the total unique visitors. To make the dashboard more dynamic and interactive, the analyst wants to allow users to switch between viewing 'Page Views' and 'Unique Visitors' on the line chart without having to change the underlying data model or create two separate charts. Which Power BI feature should be used?Visualize and analyze the data
  19. 169.A data analyst needs to ensure that all Power BI Premium per user (PPU) workspaces in their organization are configured to block external sharing of content. Which of the following Power BI administration settings should the analyst configure?Deploy and maintain assets
  20. 170.A data analyst has created a Power BI dataset and report that uses a web API as its data source. The web API requires an API key for authentication. The analyst needs to ensure that the API key is securely stored and used when the dataset refreshes in the Power BI service. Where should the API key be configured?Deploy and maintain assets
  21. 171.A Power BI developer needs to create a new report that combines data from an on-premises SQL Server database and a cloud-based Azure SQL Database. The report requires complex data transformations and the ability to define custom measures. What is the most suitable approach for connecting to and combining these data sources in Power BI Desktop?Deploy and maintain assets
  22. 172.A retail company uses Power BI to track sales performance across different product categories. The sales manager wants to see the total sales for each category and also clearly identify which categories are performing above or below a predefined sales target of $50,000. The report should visually emphasize these categories without using a separate gauge or card visual for each category. Which visualization technique is most appropriate for this requirement?Visualize and analyze the data
  23. 173.A data analyst needs to validate that row-level security (RLS) is working as expected for a Power BI report before publishing it to the service. The report is open in Power BI Desktop. Which feature should the analyst use to simulate different user roles and verify data visibility?Deploy and maintain assets
  24. 174.A data analyst is designing a Power BI report to display sales trends over time for a retail company. The report includes a line chart showing total sales by month and a table displaying detailed sales figures. The analyst wants to ensure that when a user selects a specific month in the line chart, the table automatically updates to show only the sales data for that selected month, without affecting other visuals on the page. Which feature should the analyst configure for the interaction between the line chart and the table?Visualize and analyze the data
  25. 175.A Power BI administrator wants to ensure that specific Power BI reports and dashboards, after being developed and tested, are reliably delivered to end-users with consistent settings and access permissions. Which asset management strategy should be employed?Deploy and maintain assets
  26. 176.A Power BI data analyst is developing a report that uses a dataset with a live connection to an Azure Analysis Services model. The analyst needs to apply row-level security (RLS) based on the user's Azure Active Directory (AAD) group membership. Where should the RLS roles be defined?Deploy and maintain assets
  27. 177.A financial analyst is building a Power BI report to monitor investment portfolio performance. The report includes a table of various stocks and their current 'Price', '52-Week High', and '52-Week Low'. The analyst wants to create a visual that quickly shows for each stock where its current 'Price' stands relative to its '52-Week High' and '52-Week Low', without showing the exact price values, but rather a relative position on a scale from low to high. Which visual type is best suited for this comparison?Visualize and analyze the data
  28. 178.A manufacturing company uses Power BI to monitor production efficiency. They have a dataset with 'Production Line', 'Product Type', 'Production Date', and 'Units Produced'. The operations manager wants to create a visual that shows, for each 'Production Line', the 'Units Produced' for the current month and the 'Units Produced' for the previous month, side-by-side, to quickly assess month-over-month performance. Which DAX function is essential for calculating the 'Units Produced Previous Month' for this comparison?Visualize and analyze the data
  29. 179.A company uses a Power BI deployment pipeline to manage its content. A developer has made changes to a report in the 'Development' stage and now needs to move these changes to the 'Test' stage. Before moving, the developer wants to ensure that the dataset parameters (e.g., database server name) are automatically updated to point to the 'Test' environment's database. What Power BI feature facilitates this automated parameter update during deployment?Deploy and maintain assets
  30. 180.A project manager is using Power BI to track the progress of multiple projects. Each project has a start date, end date, and current completion percentage. The manager needs a visual that clearly shows the timeline of each project, their duration, and their current progress towards completion. Which type of visual is best suited for this purpose?Visualize and analyze the data
  31. 181.An organization is implementing a new data governance policy that requires all Power BI datasets containing sensitive customer data to be encrypted at rest and in transit. Which Microsoft 365 feature, when integrated with Power BI, can help enforce this policy?Deploy and maintain assets
  32. 182.A data analyst is developing a Power BI report for a call center to monitor agent performance. The report includes a table showing individual agent metrics (e.g., calls handled, average call duration, customer satisfaction score). The call center manager wants to quickly identify agents whose performance is falling below a predefined threshold for any of these metrics, without having to manually scan through all the numbers. Which Power BI feature should the analyst implement to achieve this visual alert?Visualize and analyze the data
  33. 183.A data analyst has created a new Power BI dataset and report that sources data from a new Azure SQL Database. The analyst publishes the report to a Power BI workspace. To ensure that the report can connect to the Azure SQL Database in the Power BI Service, what type of Power BI asset needs to be configured?Deploy and maintain assets
  34. 184.A Power BI developer needs to implement a data source rule in a deployment pipeline to ensure that a dataset in the 'Test' stage connects to the 'Test_Database' SQL Server instance, while the 'Production' stage connects to the 'Prod_Database' SQL Server instance. The data source type and credentials remain the same. Which of the following properties should the developer configure in the deployment pipeline rule for the data source?Deploy and maintain assets
  35. 185.A data analyst is working with a large sales dataset in Power Query. The dataset includes a 'TransactionID' column which is currently stored as a Text data type. This column consists of unique identifiers that are always positive whole numbers. To improve performance and reduce memory usage in the Power BI model, the analyst wants to convert this column to the most efficient numeric data type. Which data type should the analyst choose?Prepare the data
  36. 186.A data modeler is preparing a Power BI report that combines sales data from an Azure SQL Database and customer feedback from a SharePoint Online list. The report needs to display near real-time sales data while also allowing for historical analysis of customer feedback, which is updated less frequently. Which storage mode configuration should the data modeler use for these two data sources to optimize performance and data freshness?Prepare the data
  37. 187.A data analyst is importing customer data from a legacy system into Power BI. The data includes a 'CustomerID' column where some entries contain leading or trailing whitespace characters due to inconsistent data entry. These extra spaces prevent accurate matching and filtering. Which Power Query transformation should the analyst use to remove these unnecessary characters?Prepare the data
  38. 188.A client is developing a Power BI model to analyze product sales. The 'Sales' table includes 'ProductID', 'OrderQuantity', and 'UnitPrice'. The client needs a measure to calculate the total sales amount for all products. Which DAX expression should be used?Model the data
  39. 189.A data analyst is connecting Power BI to an on-premises SQL Server database to retrieve sales data. The analyst needs to ensure that only aggregated data is loaded into Power BI, preventing the transfer of sensitive row-level transactional details over the network, while still leveraging the SQL Server's processing power. Which Power Query concept is most relevant for achieving this goal?Prepare the data
  40. 190.A data analyst is building a Power BI report that aggregates sales data from multiple regional Excel files. Each Excel file contains a 'SalesDate' column, but some files use the 'MM/DD/YYYY' format, while others use 'DD-MM-YYYY'. The analyst needs to ensure that the 'SalesDate' column is consistently interpreted as a date type across all files before combining them. Which Power Query feature should the analyst use to handle these varying date formats during type conversion?Prepare the data
  41. 191.A data analyst is importing a dataset into Power BI from a CSV file. The file contains a column named 'Price' where some values are missing, represented by empty strings. The analyst needs to replace these empty strings with `0` to ensure correct numeric calculations. Which Power Query transformation should the analyst use?Prepare the data
  42. 192.A data analyst is working with a sales dataset in Power Query. The dataset includes a 'TransactionDateTime' column that contains both date and time information. The analyst needs to create a new column that only shows the date part (e.g., 'YYYY-MM-DD') for reporting purposes, discarding the time component. Which Power Query transformation should be used?Prepare the data
  43. 193.A data modeler is optimizing a Power BI model for an e-commerce platform. The 'Sales' fact table contains 'OrderID', 'ProductID', 'CustomerID', 'OrderDate', and 'SalesAmount'. The 'Products' dimension table contains 'ProductID', 'ProductName', 'Category', and 'SubCategory'. The model has a one-to-many relationship from 'Products' to 'Sales' on 'ProductID'. The modeler observes that filtering by 'Category' in a slicer is slow. Which action should the data modeler take to improve filtering performance?Model the data
  44. 194.A data analyst is importing data from a web API that returns product information in JSON format. The JSON data includes nested records for 'SupplierInfo' (e.g., {'SupplierName': 'ABC', 'SupplierID': '123'}). The analyst needs to expand this 'SupplierInfo' record into new columns named 'SupplierName' and 'SupplierID' in the main table. Which Power Query transformation should be used?Prepare the data
  45. 195.A data modeler is preparing a dataset in Power Query where a column named 'ProductCost' contains numeric values. However, upon profiling, it's discovered that some cells contain text values like 'N/A' or 'Unknown' instead of numbers, which causes errors during type conversion to a decimal number. The modeler needs to convert this column to a numeric type, treating 'N/A' and 'Unknown' as nulls, without losing the rest of the valid numeric data. Which is the most robust Power Query approach to achieve this?Prepare the data
  46. 196.A data modeler is optimizing a Power BI model for a large enterprise. The 'Sales' fact table contains millions of rows and includes columns like 'SalesOrderID', 'SalesAmount', 'OrderDate', and 'CustomerID'. The model has a 'Customers' dimension table with 'CustomerID', 'CustomerName', 'Region', and 'Segment'. The modeler notices that reports filtering by 'CustomerName' are particularly slow. What is the most effective way to improve the performance of filters based on 'CustomerName'?Model the data
  47. 197.A data modeler is optimizing a Power BI model for a large manufacturing company. The model contains a 'Production' fact table with 'ProductionBatchID', 'ProductID', 'QuantityProduced', and 'ProductionDate'. The 'Products' dimension table contains 'ProductID', 'ProductName', 'Category', and 'WeightKg'. The relationship between 'Products' and 'Production' is one-to-many on 'ProductID'. The modeler notices that the 'WeightKg' column in the 'Products' table has many unique values (high cardinality), and reports filtering or aggregating by 'WeightKg' are slow. Which action should the data modeler take to improve performance related to 'WeightKg'?Model the data
  48. 198.A data analyst is developing a Power BI model for a retail company. The model includes a 'Sales' table with 'SaleAmount' and 'OrderDate', and a 'Date' table marked as a date table. The analyst needs to create a measure that calculates the 'Sales Growth Percentage' compared to the previous month. The calculation should be `(Current Month Sales - Previous Month Sales) / Previous Month Sales`. Which DAX expression correctly calculates the 'Sales Growth Percentage'?Model the data
  49. 199.A data modeler is optimizing a Power BI model for an e-commerce platform. The 'Sales' fact table has millions of rows and includes 'ProductID', 'CustomerID', and 'OrderDate'. The 'Product' dimension table contains 'ProductID', 'ProductName', 'Category', and 'SubCategory'. The 'Customer' dimension table contains 'CustomerID', 'CustomerName', 'Region', and 'Country'. The model currently uses a standard star schema with direct relationships. The modeler observes slow performance when filtering sales data by 'Category' and 'SubCategory' combined. To improve performance, the modeler decides to denormalize the 'Sales' fact table. Which columns should the modeler consider adding to the 'Sales' fact table during denormalization to directly address the observed performance issue?Model the data
  50. 200.A data modeler is building a Power BI model for a financial institution. The model contains a 'Transactions' table with a 'TransactionDate' column and a 'TransactionAmount' column. The model also has a 'CurrencyExchangeRates' table that stores daily exchange rates. The modeler needs to calculate the total transaction amount in USD for all transactions that occurred in the 'Current Month'. The 'Current Month' is determined by the latest 'TransactionDate' in the 'Transactions' table. Which DAX expression should the modeler use to achieve this?Model the data