Free Microsoft Certified: Power BI Data Analyst Associate Practice Test

You are connecting Power BI Desktop to a SQL Server database that contains 10 million rows of sales data. Users need to create reports that display summarized data by region and year. The data is refreshed daily. What should you configure to optimize report performance?

You have a Power BI dataset with a Date table and a Sales table. The Sales table contains a column named OrderDate. You need to establish a relationship between the tables to enable time intelligence calculations. What should you do?

You create a Power BI report with several visuals. Users report that when they select a data point in one visual, related data in other visuals is not being highlighted. What is the most likely cause?

You need to publish a Power BI report to the Power BI service so that users in your organization can access it. The report contains sensitive financial data that should only be accessible to the Finance department. What should you do first?

You have a Power BI report that includes a slicer for Product Category. Users want to select multiple categories and have the ability to clear all selections quickly. What should you configure in the slicer settings?

You are using Power Query Editor to transform data from a CSV file. The file contains a column named FullName with values like 'Smith, John'. You need to split this into two columns: LastName and FirstName. Which transformation should you use?

You have a Power BI dataset with a large fact table containing 5 years of transaction data. The CEO only needs to see data from the current year in their reports, but other users need access to all historical data. What is the most efficient way to implement this requirement?

You create a measure in Power BI using the following DAX formula: Total Sales = SUM(Sales[Amount]). When you add this measure to a table visual with Product and Region columns, what context is used to evaluate the measure for each row?

You have a Power BI report published to the service. Users report that when they export data from a visual to Excel, they see more rows than are displayed in the visual. What is the most likely explanation?

You are preparing data in Power Query Editor. A table contains a column with product codes, but some rows have leading spaces. You need to remove these spaces. Which transformation should you apply?

You have a Power BI workspace with several reports and datasets. You need to ensure that when the dataset is refreshed, users are notified if the refresh fails, but you don't want them to receive notifications for successful refreshes. What should you configure?

You are creating a Power BI report that displays sales data. Users need to see year-over-year growth percentages. You have a Date table and a Sales table with a Sales[Amount] column. What DAX measure should you create?

You have a Power BI report with a map visual showing store locations. Some stores are not appearing on the map. What should you check first to troubleshoot this issue?

You are connecting to an on-premises SQL Server database from Power BI Service. The database is behind a firewall. What component must be installed and configured to enable this connection?

You have a table with the following columns: Date, Product, Sales, and Returns. You need to create a calculated column that shows the net sales (Sales minus Returns) only for transactions in the current row. What should you use?

You have a Power BI report with a large dataset that takes several seconds to load. Users need the report to load quickly when they open it. The data can be slightly out of date when first opened. What should you configure?

You have a Power BI model with a fact table containing 100 million rows. You need to optimize a report that filters by date ranges spanning multiple years. The report performance is slow. Users frequently analyze the most recent year but occasionally need historical data. What strategy should you implement?

You create a measure that uses the CALCULATE function to modify filter context. The measure returns incorrect values. You need to understand how the filter context is being modified. What tool should you use to troubleshoot the DAX measure?

You have multiple Power BI workspaces with datasets that connect to the same on-premises SQL Server database. Users report inconsistent data across reports. You need to implement a solution that ensures all reports use the same data while minimizing refresh times and maintenance. What should you do?

You need to implement a solution where regional managers can only see data for their respective regions in all reports within a workspace. The solution must be maintainable as managers are added or removed frequently. The Region table has a column named RegionName, and user information is stored in Azure Active Directory with a custom attribute called AssignedRegion. What should you implement?