PL-300 Practice Test

Answer choices

1. A. Use SUMX to iterate over a table
2. B. Create a new measure using AVERAGE
3. C. Use FILTER to remove unwanted rows from the dataset
4. D. Apply CALCULATE to override or add filters as needed

Wrong-answer review

• A. Use SUMX to iterate over a table: SUMX iterates rows, but by itself it is not the function used to override or add filter context.
• B. Create a new measure using AVERAGE: AVERAGE calculates a mean; it does not modify filter context.
• C. Use FILTER to remove unwanted rows from the dataset: FILTER returns a filtered table expression, but CALCULATE is needed to evaluate an expression under changed filters.

Answer choices

1. A. Apply conditional formatting to highlight all low-severity claims
2. B. Use a tooltip to display additional information about each claim
3. C. Add a new column that calculates the total number of claims per adjuster
4. D. Create a slicer to filter the data by claim severity level and date range

Answer choices

1. A. Implement a scheduled data refresh every 24 hours to ensure data is up-to-date
2. B. Create a Power BI dataset and immediately begin building visualizations based on the imported data
3. C. Develop a DAX measure to calculate the fulfillment rate and display it prominently on the report’s dashboard
4. D. Utilize Power Query’s data profiling tools to assess column quality, identify missing values, and understand data distributions

Answer choices

1. A. Create a single workspace with role-level security (RLS) applied to the datasets to control access based on user identity
2. B. Create separate workspaces for administrators, teachers, and district-level staff, each containing its own datasets and reports
3. C. Create a single workspace and share individual reports with each team, granting view-only permissions
4. D. Create a single workspace and use Power BI apps to bundle reports and dashboards, distributing them to different groups with predefined access

Answer choices

1. A. Create multiple fact tables for each type of transactional data
2. B. Use dimension tables to store detailed attributes and link them with fact tables through foreign keys
3. C. Store all data in a single large table without distinguishing between facts and dimensions
4. D. Avoid using any relationships between tables to simplify the model

Answer choices

1. A. Create a bookmark on the detailed page and link to it from the summary page
2. B. Define a drillthrough filter on the detailed page that matches the field used in the summary page's visual
3. C. Use a 'Go to Report' action to navigate to the detailed page
4. D. Create a slicer on the detailed page that mirrors the field used in the summary page's visual

Answer choices

1. A. Power BI Quick Measures
2. B. DAX Summarize Function
3. C. Power Query Group By
4. D. Power BI Visual Interactions

Answer choices

1. A. Implement direct query to minimize data refresh latency
2. B. Create separate Power BI datasets for each user group, filtered by region
3. C. Utilize Row-Level Security (RLS) to restrict data visibility based on user group membership
4. D. Publish the Power BI report to the Public workspace to allow for broader data sharing

Answer choices

1. A. Remove all columns related to booking channels
2. B. Filter out low-occupancy data points before modeling
3. C. Retain all historical data for comprehensive analysis
4. D. Delete any columns that are not directly used in visualizations or calculations

Answer choices

1. A. Configure the semantic model to automatically refresh data from the source system every hour
2. B. Create a custom visual to display the number of open tickets by priority level
3. C. Publish the semantic model to the Power BI service and share it with the IT team
4. D. Enable Copilot to generate a summary of the semantic model's relationships and key metrics