MeasureUp Microsoft Power BI Data Analyst PL-300 Practice Exam

The PL-300 practice test trains you in Microsoft Power BI data analysis.

Why should I take the PL-300 exam? 

The PL-300 certification offers you the perfect opportunity to start a rewarding career in Microsoft Power BI as a Power BI data analyst, by allowing you to demonstrate your knowledge of Power Query and Data Analysis Expressions. On passing the PL-300 exam, you earn the Microsoft Certified: Power BI Data Analyst Associate certification. 

The PL-300 practice test includes two different modes: certification and practice mode. Certification mode allows you to assess your knowledge and discover your weak areas, with practice mode allowing you to focus on the areas that need development. 

The PL-300 practice test contains 175 questions and covers the following objectives: 

Prepare the data – 39 questions 

Get data from data sources 

• Identify and connect to a data source 
• Change data source settings, including credentials, privacy levels, and data source locations 
• Select a shared dataset, or create a local dataset 
• Choose between DirectQuery, Import, and Dual mode 
• Change the value in a parameter 

Transform and load the data 

• Select appropriate column data types 
• Create and transform columns 
• Transform a query 
• Design a star schema that contains facts and dimensions 
• Identify when to use reference or duplicate queries and the resulting impact 
• Merge and append queries 
• Identify and create appropriate keys for relationships 
• Configure data loading for queries 

Clean the data 

• Evaluate data, including data statistics and column properties 
• Resolve inconsistencies, unexpected or null values, and data quality issues 
• Resolve data import errors 

Model the data – 50 questions 

Design and implement a data model 

• Configure table and column properties 
• Implement role-playing dimensions 
• Define a relationship's cardinality and cross-filter direction 
• Create a common date table 
• Implement row-level security roles 

Create model calculations by using DAX 

• Create single aggregation measures 
• Use CALCULATE to manipulate filters 
• Implement time intelligence measures 
• Identify implicit measures and replace with explicit measures 
• Use basic statistical functions 
• Create semi-additive measures 
• Create a measure by using quick measures 
• Create calculated tables 

Optimize model performance 

• Improve performance by identifying and removing unnecessary rows and columns 
• Identify poorly performing measures, relationships, and visuals by using Performance Analyzer 
• Improve performance by choosing optimal data types 
• Improve performance by summarizing data 

Visualize and analyze the data – 53 questions 

Create reports 

• Identify and implement appropriate visualizations 
• Format and configure visualizations 
• Use a custom visual 
• Apply and customize a theme 
• Configure conditional formatting 
• Apply slicing and filtering 
• Configure the report page 
• Use the Analyze in Excel feature 
• Choose when to use a paginated report 

Enhance reports for usability and storytelling 

• Configure bookmarks 
• Create custom tooltips 
• Edit and configure interactions between visuals 
• Configure navigation for a report 
• Apply sorting 
• Configure sync slicers 
• Group and layer visuals by using the Selection pane 
• Drill down into data using interactive visuals 
• Configure export of report content, and perform an export 
• Design reports for mobile devices

Identify patterns and trends 

• Use the Analyze feature in Power BI 
• Use grouping, binning, and clustering 
• Use AI visuals 
• Use reference lines, error bars, and forecasting 
• Detect outliers and anomalies 
• Create and share scorecards and metrics 
• Incorporate the Q&A feature in a report 

Deploy and maintain assets – 33 questions 

Create and manage workspaces and assets 

• Create and configure a workspace 
• Assign workspace roles 
• Configure and update a workspace app 
• Publish, import, or update assets in a workspace 
• Create dashboards 
• Choose a distribution method 
• Apply sensitivity labels to workspace content 
• Configure subscriptions and data alerts 
• Promote or certify Power BI content 
• Manage global options for files 

Manage datasets 

• Identify when a gateway is required 
• Configure a dataset scheduled refresh 
• Configure row-level security group membership 
• Provide access to datasets 

 Notes: 

• The bullets that follow each of the skills measured are intended to illustrate how we are assessing that skill. Related topics may be covered in the exam. 
• Most questions cover features that are general availability (GA). The exam may contain questions on Preview features if those features are commonly used.