Download PL300 Microsoft Power BI Data Analyst Associate and more Exams Materials science in PDF only on Docsity!
PL300 Microsoft Power BI Data
Analyst Associate Practice Exam 2026
edition with correct and accurate
answers
You plan to create a report in Power BI Desktop. You need to identify the type of visualization that displays data as a set of nested rectangles. Which visualization should you use? - Correct Answer: Treemap You need to create a custom R visual by using Power BI Desktop. What do you need to do first? - Correct Answer: Install R on your computer. You need to create a custom Python visual by using Power BI Desktop. What do you need to do first? - Correct Answer: Install Python on your computer. You are editing a report in Power BI Desktop. You need to adjust the behavior of the report by editing interactions. Which two types of interaction behavior can you change between visuals? Each correct answer presents a complete solution. - Correct Answer: Filter; Highlight You need to create a bookmark that toggles the visibility of a visual. This bookmark must only toggle the visibility state and perform no other action. Which three configurations should you make? Each correct answer presents part of the solution. - Correct Answer: Disable the Data option; Disable the Current Page option; Enable the Display option You need to create a visual that displays sales by employees, trending over months. The visual must clearly show how employees are performing against each other and have a ranking for each period. Which visual should you use? - Correct Answer: ribbon chart You plan to use Power BI Desktop to analyze sales data for products sold by your company. You need to create a DAX formula that will list 10 best-selling products sorted by their total sales. Which DAX function should you use? - Correct Answer: TOPN You plan to create a report in Power BI Desktop that will display the relationship between the number of orders and the number of orders shipped by product category. You need to identify the visual that will clearly identify outliers in the data set by displaying them away from the bulk of data. Which visual should you use? - Correct Answer: Scatter
You implement the Q&A feature in a report, so users can get answers to their questions on their own. You need to improve your Q&A search capabilities for end-users. Which two configurations can you add? Each correct answer presents a complete solution. - Correct Answer: Add a linguistic schema to the dataset; Add synonyms to model fields. You plan to build a Power BI report and apply conditional formatting to the columns used by a visual. Which two visuals support conditional formatting functionality for the report? Each correct answer presents a complete solution. - Correct Answer: Matrix; Table You have implemented role-based security that restricts access to a Power BI Desktop semantic model for users who are assigned the role named Salespeople. You need to validate that the implementation works. What should you do? - Correct Answer: In the Report view, activate the View as feature. You plan to use Power BI Desktop to analyze sales data of your company. You need to identify two types of data you will be able to use for creating bins that group the sales data. Which two data types should you identify? Each correct answer presents a complete solution. - Correct Answer: Date/time; Numeric You need to create a visual that will display information on a continuous axis. Which two data types can be used to display a continuous axis on a visual? Each correct answer presents a complete solution. - Correct Answer: Date; Decimal Number You need to make changes to your data sources. Which three changes are supported by the Data source settings in the Power Query Editor? Each correct answer presents a complete solution. - Correct Answer: Clearing permissions; Editing permissions; Modifying the file path You plan to add data to Power BI Desktop from a new data source. You are evaluating whether you should use the DirectQuery storage mode or the Import storage mode. What are two benefits of using DirectQuery instead of Import? Each correct answer presents a complete solution. - Correct Answer: Minimized local disk space usage; No need for data refresh When importing data from an Excel workbook into Power BI, you receive the error message: "We couldn't find any data formatted as a table." What should you do to resolve the error? - Correct Answer: In the Excel workbook, select the data you want to import, create a table, and save the change. From Power BI Desktop, you create a data source by importing an Excel file. You plan to identify data anomalies within the data source. Which interface should you use to display the column quality feature and column distribution graph? - Correct Answer: Power Query Editor
You have a fact table that contains sales data. The fact table includes a SalesDate column formatted as a Date data type. Auto date/time setting is disabled in both global and current file options. You load the fact table into Power BI Desktop. You need to ensure that you are able to analyze data on a yearly, quarterly, monthly, weekly, and daily basis. Your solution must minimize the model size and administrative effort. What should you do? - Correct Answer: Add a separate date dimension table. You have a Power BI data model that contains a table named Orders. Orders contains many columns. You have a report. A page in the report contains many visuals. Each visual references four fields from the Orders table. When you attempt to publish the report to the Power BI service, you receive an error message. You need to resolve the error and reduce the size of the data model. The solution must:
- Minimize the number of queries executed during scheduled refreshes.
- Prevent changes the columns in the original Orders table. What should you do? - Correct Answer: Reference Orders, remove all columns from the reference except the four used on the report page, and disable load for Orders. You need to create a Power BI dashboard. Which tool should you use? - Correct Answer: The Power BI service You are creating a Power BI dashboard. You need to apply a custom theme to the dashboard from another Power BI dashboard theme. Which type of file should you use?
- Correct Answer: JSON You upload reports to the Power BI service and pin several visuals to a dashboard. You plan to create alerts rules for several visuals. What are two locations you can view the alerts? Each correct answer presents a complete solution. - Correct Answer: An email; the Notification Center You plan to create a Power BI workspace. You need to ensure that you will be able to configure a Microsoft 365 group whose SharePoint Online document library is available to workspace users once the workspace is created. Which setting should you configure when creating the workspace? - Correct Answer: Workspace OneDrive You manage a Power BI workspace in shared capacity. The workspace contains a report that uses a semantic model named DS1. You need to implement an incremental refresh of DS1. What should you do first? - Correct Answer: In Power BI Desktop, define filter parameters. You manage a Power BI workspace in a shared capacity. The workspace contains a semantic model named DS1. You plan to schedule a refresh of DS1. What is the number of consecutive refresh failures of DS1 that will automatically disable the refresh schedule? Select only one answer. - Correct Answer: 4
You use Microsoft Power BI to analyze sales data stored in a database. Each user should only see their own sales records. You need to configure row-level security (RLS) in Microsoft Power BI to restrict each user's access to only their own sales data. What configuration should you implement? - Correct Answer: Use a dynamic DAX filter for each user's email address. Your organization uses Microsoft Power BI to analyze sales data. The sales team is concerned about unauthorized users exporting sensitive data. You need to ensure that only authorized users can export sensitive data from Power BI reports. What should you do? - Correct Answer: Apply sensitivity labels. You have a Power BI semantic model. You need to set the semantic model as discoverable. Which two configurations will allow the semantic model to be marked as discoverable? Each correct answer presents a complete solution. - Correct Answer: Certify the semantic model; Promote the semantic model. You have the following Power Query M formula that generates a range of dates. = List.Dates(#date(2020,05,31), 365, #duration(1,0,0,0)) What is the resulting date range? - Correct Answer: A list of days starting on May 31, 2020 and ending 365 days later Your organization is developing a Power BI report to analyze sales data with order and shipping dates but lacks a date table. You need to create a date table spanning the sales data range to support time intelligence calculations. Which three actions should you perform to create a functional date table for time intelligence calculations? Each correct answer presents part of the solution. - Correct Answer: Add year, month, and day columns to the date table; Mark the table as a date table; Use CALENDARAUTO to create a date table. You need to prevent hidden date tables from being auto generated by Power BI Desktop for every date or datetime data type column in a dataset. What two tasks should you perform? Each correct answer presents a complete solution - Correct Answer: Enable Mark as date table for the Calendar table; From the Current File options in Power BI Desktop, disable Auto Date/Time You have a Power BI model. You need to assign items to a display folder. Which three items can be assigned to a display folder? Each correct answer presents part of the solution. - Correct Answer: Calculated column; Column; Measure You create a data model in Power BI Desktop that contains DAX calculated columns and measures. You now need to create a report. In which two places can a DAX calculated column be used, but a DAX calculated measure cannot be used? Each correct answer presents a complete solution. - Correct Answer: As a filter in the "Filters on this page" well of the Filters pane; as an item in the Fields well of a slicer
of the Reading Time value; Use the Group By functionality to aggregate the rows by hour, DateKey, and LocationKey and then create an average Temp C value per row. You plan to run Power BI Desktop Performance Analyzer. You need to ensure that the data engine cache will NOT impact the test results without restarting Power BI Desktop. What should you do first? - Correct Answer: Connect DAX Studio to the data model. You have Power BI Desktop. You need to determine query timings for a report page visual. Which method should you use? - Correct Answer: Use the Performance analyzer You decide to start using variables when creating DAX formulas. What are two benefits of using variables in DAX measures over using original expressions? Each correct answer presents a complete solution. - Correct Answer: Improves the overall performance of the resulting DAX measure; improves the overall readability of the resulting DAX measure You plan to get data for a Power BI semantic model from flat files. You need to select a location for the files. The location must provide the ability to configure scheduled refresh for the semantic model by using Microsoft 365 credentials. Which two location types should you recommend? Each correct answer presents a complete solution. - Correct Answer: OneDrive for Business; SharePoint - Team Sites You have multiple Excel files stored in a folder synced with OneDrive for Business. You need to import data from the files. The solution must NOT use a data gateway. Which type of connector should you use? - Correct Answer: SharePoint folder From Power BI Desktop, you create a data source by importing an Excel file that contains 10,000 rows. You plan to identify data anomalies within the data source. You need to ensure that column distribution considers all rows in the Excel file. What should you do? - Correct Answer: In the Power Query Editor window, enable the Column Profile view. You have an Excel spreadsheet that contains two columns as follows:
- Category: Contain names of categories
- Subcategory: Contain names of subcategories for each category You import the Excel spreadsheet into Power BI Desktop. You need to transform the data to meet the following requirements:
- Have multiple columns, where one column represents one category
- Have a single row that includes the total count of subcategories for each category Which transformation should you use? Select only one answer. - Correct Answer: Pivot columns You have a Power BI report that connects to a public data feed. Users report that the report loads slowly.
You identify that the slow performance is caused by a query in the report. You need to reduce the load time. Where should you configure caching for the query? - Correct Answer: In a dataflow You plan to create a report in Power BI Desktop. You need to create a visualization that displays data in two or more dimensions and cross-highlights with other visuals on the same report page. Which type of visualization should you use? - Correct Answer: Matrix From Power BI Desktop, you open a Power BI report that contains three pages named Main, Error Rate, and On-time Rate. You add a button to the Main page for navigation. You need to implement a solution that meets the following requirements:
- The navigation destination must change based on the output of a DAX measure named [Error Rate].
- If [Error Rate] is greater than 5%, the button must display the text "Error Rate" and navigate to the Error Rate page.
- Otherwise, the button must display the text "On-time Rate" and navigate to the On- Time Rate page. What three actions should you perform? Each correct answer presents part of the solution. - Correct Answer: Create a DAX measure that outputs the correct page name based on the value of [Error Rate]; Set the button type to Page Navigation and then use conditional formatting to specify the destination; Use conditional formatting to set the button text. You need to create a report in Power BI Desktop that will display the sales data of your company such that customers of a similar age will be grouped into clusters. Which visual should you add to the report? - Correct Answer: Scatter You are modifying a report in Power BI Desktop. The report contains a single report page that has three card visuals and one clustered bar chart. You need to create a bookmark that displays only the clustered bar chart and hides the cards. The solution must minimize development effort. What should you do first? - Correct Answer: Hide the three cards in the Selection Pane. You are using Power BI Desktop to edit a stacked column chart that displays gross sales data with a date hierarchy that contains year, quarter, month, and day. You need to prevent users from viewing the hierarchy based on the year. What should you do? - Correct Answer: In the Visualization pane, remove the year field from the date hierarchy fields in the X-axis. An organization uses Microsoft Power BI to analyze sales data. The team observed unexpected spikes in revenue on specific dates. You need to identify and explain these spikes using a Microsoft Power BI report. What should you do? - Correct Answer: Use anomaly detection on a line chart.
solution. Select all answers that apply. - Correct Answer: Increasing the refresh page; Reducing the size of the data model You are evaluating whether you need to create a dashboard in Power BI. In which scenario do you need a dashboard instead of a report in Power BI? - Correct Answer: You need to display visuals that use different semantic models. You need to create a dashboard from a published report in Power BI. Which option in the report should you use? - Correct Answer: Pin visual You plan to create a Power BI workspace. You need to ensure that you will be able to configure a Microsoft 365 group whose SharePoint Online document library is available to workspace users once the workspace is created. Which setting should you configure when creating the workspace? - Correct Answer: Workspace OneDrive You have a collection of semantic models and reports. You need to share the semantic models and reports together. This solution must NOT send any email notifications to internal users after sharing. What should you create in the Power BI Service? - Correct Answer: An app You manage a Power BI workspace. You need to delegate the task to schedule data refreshes. The solution must use the principle of least privilege. Which role should you use? - Correct Answer: Contributor You have a Power BI Premium per user workspace. What is the maximum number of refreshes that can be scheduled each day?Select only one answer. - Correct Answer: 48 You have several on-premises Microsoft SQL Server databases. You need to provide Power BI Service users access to the data sources without exposing the database servers directly to the internet. The solution must minimize the configurations that must be performed by each user. What should you deploy? - Correct Answer: An on-premises data gateway Your organization uses a Microsoft Power BI workspace to manage and share reports and dashboards. You need to assign roles to control user permissions for editing, deleting, and viewing content. Which role should you assign? - Correct Answer: Contributor You plan to add data to Power BI Desktop from a new data source. You are evaluating whether you should use the DirectQuery storage mode or the Import storage mode. What are two benefits of using Import instead of DirectQuery? Each correct answer presents a complete solution. Select all answers that apply. - Correct Answer: Full support for the Q&A Power BI service; full support for the Quick Insights Power BI service.
You have created a Power BI semantic model and need to create multiple reports. What is a benefit of using a Power BI semantic model as a data source for multiple reports compared to each report having a separate semantic model? - Correct Answer: It reduces the number of semantic models, refreshes, and storage requirements in the Power BI service. You plan to create a report in Power BI Desktop. You need to create a visualization to display a running total. The solution must meet the following requirements:
- The initial and the final value columns must start on the horizontal axis.
- The intermediate values must be floating columns. Which type of visualization should you use? - Correct Answer: Waterfall You plan to create a report in Power BI Desktop that will display sales opportunities by five sales stages, including lead, prospect, qualified, committed, and transacted. You need to identify the type of visualization that will display a linear process with sequentially connected stages, with one stage transitioning to the next. Which visualization should you use? Select only one answer. - Correct Answer: Funnel You have a visual that is being cross-highlighted. By default, what data will be displayed in a report tooltip? - Correct Answer: The filtered (cross-highlighted) data You need to create a histogram that will display ranges of integers in groups. Which two resources do you need to create the histogram? Each correct answer presents part of the solution. - Correct Answer: A bin group type; A numerical column Your organization uses Microsoft Power BI to analyze sales data. There is a report on regional sales performance insights in a workspace with multiple reports. You need to ensure only Sales team members have access to the sales performance report data. What action should you take? - Correct Answer: Set up row-level security for Sales team members. Your company uses Power BI to analyze sales data. The data model includes a fact table called 'Sales' and a dimension table called 'Regions' with unique region names. You need to filter sales data by region. What should you do? - Correct Answer: Create a one-to-many relationship from the 'Regions' table to 'Sales' table. You have begun the process of creating a Power BI Semantic model by connecting to a data source based on multiple tables in a SQL Server database. You need to modify the relationship between the tables. Which interface should you use in the Power BI Desktop? - Correct Answer: Model view You are designing a data model in Power BI. You need to avoid introducing ambiguity into your data model design. Which type of cardinality should you avoid? - Correct Answer: Many-to-many
You plan to publish a semantic model from Power BI Desktop. You need to ensure that your data source server name can be changed after the semantic model has been published to the Power BI Service. Which two actions should you perform? Each correct answer presents part of the solution. - Correct Answer: Create a parameter; From the Data source settings, update the server source to use a parameter. You have an Excel spreadsheet that contains three columns labeled Year, 2021, and
- The entries in rows for the first column consists of names of the individual months in the year while the other two columns contain the sales amount for each month for the corresponding year. You import data from the Excel spreadsheet into Power BI Desktop. You need to transform the data so it will consist of three columns, with the first one containing month, the second containing year, and the third containing the sales amount for that month and year. Which transformation should you use first? - Correct Answer: Unpivot You have a Power BI data source that contains the following tables:
- ProductCategory: Lists the product category ID and category name
- ProductSubcategory: Lists the product subcategory ID, subcategory name, and the related category ID
- ProductList: Lists the product ID, name, and subcategory ID You need to optimize the data to create a dimension for use in a star schema data model. How should the tables be transformed before loading into the model? - Correct Answer: Merge the queries to create a single loaded table for Product. You have a Power BI report that uses data that is imported from a database. You add a slicer to a report. You need to sync the slicer to use it on other report pages. What is required to sync slicers between report pages? - Correct Answer: Each slicer must use the same column. You need to create a row level security (RLS) role for a semantic model. What should you do first? - Correct Answer: In Power BI Desktop, open Manage roles. You need to use DAX quick measures to generate results to use in a report. Which type of DAX quick measure calculations will NOT work against a DirectQuery table?Select only one answer. - Correct Answer: Time intelligence You plan to build a Power BI dashboard and set up alerts that will notify you when data presented in the visuals on the dashboard reach specific thresholds. Which three types of visuals support the alert functionality? Each correct answer presents a complete solution. - Correct Answer: Card; gauge; KPI You plan to certify a Power BI semantic model. You need to identify at which level the permissions to certify a semantic model are assigned. Which level should you identify? - Correct Answer: Tenant
You manage a Power BI workspace in shared capacity. The workspace contains a semantic model named DS1. You plan to schedule the refresh of DS1. What is the maximum number of data refreshes per day? Select only one answer. - Correct Answer: 8 You manage a Power BI workspace that includes a semantic model with your company's sales data. You create a report that displays the sales data grouped by department. You need to use row-level security to ensure that, once the report is published, employees in each department can only see the sales data for their department. What should you do first? - Correct Answer: In Power BI Desktop, create a role. You have a Power BI model with the following fact tables and storage modes.
- FactStoreSales (Import mode)
- FactOnlineSales (DirectQuery mode) You have a dimension table named DimCalendar that has a relationship to both fact tables. You need to assign a storage mode for DimCalendar. The solution must minimize the time to execute queries that combine data from the dimension table and the fact tables. Which storage mode should you use? - Correct Answer: Dual You have a query that has a column named Country and columns for each month of sales data. The names of the sales data columns use a format of Month Year, for example January 2022. The month columns contain the Sales Amount values for each month. You need to reshape the table to have all sales amount values in a single column. A new column should also be added and contain the relevant month year for each row of data. What should you do from the Power Query Editor? - Correct Answer: Select the Country column and then select Unpivot Other Columns. You have a folder that contains monthly transaction extract files. Each file has the same columns and is named by year and month. You need to combine the files into a single data table for reporting. What should you do? Select only one answer. - Correct Answer: Query the folder and select Combine & Transform Data. You plan to use Power BI Desktop to create a report with multiple visualizations. You need to create a visual that supports the following:
- filters other visuals on the same report page
- allows users to search for values by which to filter the other visuals. Which type of visualization should you use? - Correct Answer: Slicer You need to add a new visual to a Power BI Dashboard. This visual does NOT exist on a report in the workspace. What should you do first? Select only one answer. - Correct Answer: Select Ask a question about your data.
